PDA

View Full Version : Excel Programming


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  [19] 20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 |  90 |  91 |  92 |  93 |  94 |  95 |  96 |  97 |  98 |  99 |  100 |  101 |  102 |  103 |  104 |  105 |  106 |  107 |  108 |  109 |  110 |  111 |  112 |  113 |  114 |  115 |  116 |  117 |  118 |  119 |  120 |  121 |  122 |  123 |  124 |  125 |  126 |  127 |  128 |  129 |  130 |  131 |  132 |  133 |  134 |  135 |  136 |  137 |  138 |  139 |  140 |  141 |  142 |  143 |  144 |  145 |  146 |  147 |  148 |  149 |  150 |  151 |  152 |  153 |  154 |  155 |  156 |  157 |  158 |  159 |  160 |  161 |  162 |  163 |  164 |  165 |  166 |  167 |  168 |  169 |  170 |  171 |  172 |  173 |  174 |  175 | 

  1. Worksheets do not open Arranged
  2. Ribbon Macro does not work when stored in Personal file
  3. Hide, unhide macro
  4. user form image
  5. Tom Ogilvy code
  6. Re: AfterUpdate Code to Subtract Column (L) from (G)
  7. AfterUpdate Code to Subtract Column (L) from (G)
  8. track best seller in a shop
  9. Who Can Develop a new vbPrint?
  10. RE: Excel 2003 positioning a cell to first non frozen cell
  11. Excel 2003 positioning a cell to first non frozen cell
  12. Retaining number format
  13. RE: Turn Off Auto-Format in Macro
  14. Turn Off Auto-Format in Macro
  15. moving columns
  16. Uprotect sheet in shared document
  17. updating formulas at inserted rows with locked columns
  18. Insert new row in specific range from an entry row
  19. Re: Optionbutton Group test
  20. Writing Cell info to a new Excel file
  21. Optionbutton Group test
  22. Assign Macro to Custome Button Error!
  23. VB.Net app creates report, then downloading to Excel it takes fore
  24. Re: help! function not obtaining cell values
  25. Excel 2007 macro assigned to button
  26. Syntax for using table and column names
  27. loop hide cells
  28. help! function not obtaining cell values
  29. Excel 2003 macro for turning on AtoZ autofiltering on a protected
  30. save xlsx files
  31. Loop a code thru several worksheets
  32. user form issues
  33. Help fine tuning delete macro
  34. Multiciplicity
  35. Excel 2007 and Mapping Schemas
  36. Importing Large Text File Problem
  37. Macro to copy formula and paste into another
  38. Manipulating data
  39. Open sheet based on Username
  40. Save workbook button on Userform
  41. Comment Box To Multipul Cells
  42. Defining destination Range
  43. Find Question
  44. Find in listing and copy value
  45. Write text to a table in Word
  46. Code questions
  47. Word Document Object on excel Sheet
  48. Syntax error?
  49. Using range name in formulas
  50. RE: File path for Linked Picture
  51. macros to create symbols
  52. Listbox value depending on other listbox value
  53. Extra Workbook Security via 3rd Party Software
  54. Get rid of apostrophe when pasting text string values
  55. Automatically compiling many workbooks into one
  56. Copy formula down
  57. Get the most recent file from a directory
  58. Re: Obtain Row No of xlEnd
  59. Re: Textbox data to cell
  60. Textbox data to cell
  61. Obtain Row No of xlEnd
  62. Function to subtotal by employee and also by month for each employ
  63. Search for word and copy
  64. DTPicker Resizing
  65. Re: lost all modules when opened xlsm in Excel 2003
  66. Sub Group
  67. Find a Value then delete cells before and after
  68. Re: Force Calculation
  69. Userforms and Dates
  70. copy values and Countif
  71. Force Calculation
  72. Re: Initiating the VBA program
  73. RE: Initiating the VBA program
  74. RE: Initiating the VBA program
  75. Re: Initiating the VBA program
  76. Initiating the VBA program
  77. how to send an email when saving
  78. Re: Combo box selection will not calculate
  79. create a loop so i don't have to keep retyping?
  80. Re: trying to create sheets and tab names from first colum of data
  81. Combo box selection will not calculate
  82. Forms, marcos, buttons?
  83. trying to create sheets and tab names from first colum of data
  84. Re: beforesave
  85. How do you enlarge a cell
  86. beforesave
  87. Can Excel 2007 help with website accessibility?
  88. Can a macro pause for a data entry before finishing?
  89. Delete all buttons on sheet
  90. Unique filenames
  91. Protection and Auto filter
  92. Getting file name from the file path error
  93. userinterfaceonly=True fails with this code!
  94. Range Selection
  95. Dynamic DSUM?
  96. Adding a button to a VB form
  97. RE: combobox, and chr(10)
  98. Conditional Line/Arrow
  99. VBA code syntax to protect/unprotect VBProject asumming if Password is known.
  100. combobox, and chr(10)
  101. RE: Manipulating date
  102. RE: Worksheets in Loop
  103. RE: Can A Macro Help Me?
  104. Sum multiple columns; find max
  105. Remove spaces between items in a dropdown list
  106. Worksheets in Loop
  107. Re: To find Average
  108. Manipulating date
  109. Can A Macro Help Me?
  110. Re: To find Average
  111. RE: To find Average
  112. To find Average
  113. EXCEL Issue retriving data from SQL
  114. Combinations
  115. Drop-Down List Search Capability
  116. Reversing the order of a For-Each loop action?
  117. Worksheet Change event
  118. Reference to next non-blank cell
  119. Invoices details
  120. Make my vba wait?
  121. Which library does the Format function comes from?
  122. Re: ReDim arrays in Variant
  123. Re: ReDim arrays in Variant
  124. Re: ReDim arrays in Variant
  125. Searching VBA code to disable excel compatibilty checker
  126. Test for formula in cell
  127. Can this be done with HIDE - UNHIDE ?
  128. Re: HIGHLIGHT CELLS WHICH HAVE NO DEPENDENTS TO 2ND WORKSHEET
  129. HIGHLIGHT CELLS WHICH HAVE NO DEPENDENTS TO 2ND WORKSHEET
  130. Strange Replace Failure
  131. Copy data from on workbook to another...with a catch
  132. Re: MsgBox sounds
  133. Re: HPageBreaks and InsertRow Problem
  134. This procedure used to work before IE8
  135. RE: Macro In Excel
  136. Excel automation: how to employ Find function?
  137. RE: What's the best way to select duplex printing from Excel VBA?
  138. What's the best way to select duplex printing from Excel VBA?
  139. Where can I find code for the Excel 2007 functions?
  140. Extend range from A4 to last column
  141. Excel export formatting problem for fixed width files
  142. Print to PDF using Adobe Acrobat 6.0
  143. is it possible to create VBA or even VB just by entering data into a worksheet?
  144. How to figure out which right-click context menu is appearing whenclicking shape/picture
  145. .dropdown
  146. How to copy worksheet template into multiple worksheets
  147. Adding hyper links from summary page to tab?
  148. Mass-change Excel file associations to version 2003?
  149. Insert Name reference to Active Cell in VBA
  150. Insert ComboBox into ExcelWorksheet through C#
  151. Re: Install/register CDO 1.21 on Office2007?
  152. RE: Install/register CDO 1.21 on Office2007?
  153. Re: Is it possible to make a custom function behave like a built i
  154. Re: Get contents of editbox on RibbonX
  155. Install/register CDO 1.21 on Office2007?
  156. Apply filter and cell reference
  157. Open Sharepoint site & Determine the number of files and their nam
  158. change code name
  159. Problem with date values
  160. Private Macro
  161. Character Analysis
  162. Tweak some code
  163. Send e-mail based on condition
  164. comparing work books
  165. Pop up Value in VB
  166. 32-bit or 64-bit?
  167. TextBox value on an email body with same format
  168. Re: lost all modules when opened xlsm in Excel 2003
  169. Re: copy text from a cell to enter in macro
  170. copy text from a cell to enter in macro
  171. Re: set range
  172. Re: Formulas in linking worksheets
  173. Re: strange vba break
  174. Re: variable number of For Next loops
  175. function to colour cells
  176. Re: due to failed Com Exception failed due to the following error: 800
  177. COPYING DATA FROM MULTIPLE TABS INTO ONE
  178. Re: variable number of For Next loops
  179. Re: save twice command
  180. Re: Protect Macro
  181. variable number of For Next loops
  182. Re: Unhidden rows depending upon the secection of input
  183. Delete workbook
  184. Re: How do I get a UDF to return #N/A, as if from =NA()
  185. RE: Link in e-mail
  186. Re: ReDim arrays in Variant
  187. Link in e-mail
  188. Re: Hide and unhide rows
  189. Re: How do I get a UDF to return #N/A, as if from =NA()
  190. Re: Excel macro - search/find function
  191. Re: Breaking one column into three
  192. No more fonts can be applied - with a twist
  193. Formating and Header coloring in VB script for summary sheet
  194. How can I get the smallest image using copypicture?
  195. Is there an mso.dll in Office 2003 that is for Office 20077
  196. Re: Code won't kick off
  197. Code won't kick off
  198. Odd formatting issue
  199. How to create object to follow selected cells in vba
  200. Re: Data validation list from another worksheet
  201. Creating an instance of Microsoft Project without it being installed.
  202. Re: Formula array
  203. remove/delete/hide/exclude all (Blanks) in a pivot table macro
  204. Formula array
  205. Data validation list from another worksheet
  206. VSTO PowerPoint/Excel Interaction
  207. Regex Pattern
  208. Trouble with 255 characters max in a cell
  209. copying all charts as enhanced metafiles
  210. ComboBox Drop Down List
  211. how to insert the picture of employee against his concurrent cell
  212. Deletion Code - Fix please
  213. Randomize from set of values
  214. VBA equivalent to =OFFSET(....
  215. Calculating and multiplying ratios
  216. 03 to 07 function update
  217. Delete sheets
  218. Reinstate formulas in specific cells
  219. ComboBox generic reference
  220. Split cell value and add to array
  221. COUNTIF calculations & Two-way Lookup
  222. Three-way Lookup (revised)
  223. Multiple Column Criteria which deletes all but Highest Value
  224. Macro to determine values
  225. adding record to database
  226. Error does not appear to get directed to the OnError code.
  227. Data to big for cell
  228. Open Text Files/Format/Save as .xls for multiple files.
  229. Macro to set new data validation each time
  230. Looking for easy way to add data to the first empty row from a for
  231. vba formula error
  232. How do I populate listbox1 using the commandbutton8 (Caption Find)
  233. Data Extract from Multiple Worksheets Macro
  234. if a cell value changes, update date in another cell.
  235. Merging Data From Excel
  236. selecting month column
  237. Re: Formatting stop when reach blank cell
  238. Formatting stop when reach blank cell
  239. How to solve this?
  240. RE: Format Icon
  241. Format Icon
  242. RE: If Macro
  243. If Macro
  244. Preserving cell validation on worksheets post data merging
  245. Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument
  246. Copy to Next Blank Row
  247. GetVstoObject not working
  248. Is it possible to share a file on the network?
  249. CellPointer (rectangle around selected cell) invisible
  250. Possible to do a search/replace in the IDE Code window with VBA?
  251. Re: Another varible range address question
  252. Autostart macro-protect file
  253. INSERT A SYMBOL IN A CELL THAT TAKES ME BACK TO TOP OF PAGE
  254. Another varible range address question
  255. Run macro automatically upon opening or closing document
  256. relative reference pivot table macro
  257. Budget spreadsheet
  258. I am looking for a phrase
  259. Re: macro
  260. macro
  261. PowerPoint to Excel
  262. Create tabs against main list, now I need errors
  263. Mailing
  264. Re: connect to access using password
  265. connect to access using password
  266. Protext extel-file
  267. auto assign project
  268. auto assign project
  269. Withusing of input box data store in given cell
  270. balance sheet problem
  271. Analysis ToolPak Function in VBA is sloooow
  272. Setting a Filtered Range
  273. range addressing var issue
  274. How can I return the format & value of cell with VLOOKUP ?
  275. Multiple Sendkeys not working... need help to condense code
  276. balance sheet problem
  277. VBA to monitor/alert when/if a ActiveCodePane.Window = "General" has focus
  278. Printing
  279. Publishing Named Ranges to Web Pages
  280. RE: Help with subscript error
  281. Help with subscript error
  282. How to not execute Worksheet_Change while making changes to it via
  283. move and modify exiting character in cell
  284. Data Grid
  285. conditional copy and paste
  286. File Open Dialog
  287. Add column after last column used
  288. Sort and count or just count?
  289. VBA code line to ascertain if VBAProject(Test) in the IDE is open
  290. Setting the Transition Function for two columns
  291. Opening an Excel workbook with VBA from Access
  292. Vlookup?
  293. return UDT element to spreadsheet cell
  294. Problem with a Userform
  295. Setting A variable name From Loop
  296. Simple Macro freezes the whole Excel and PC!
  297. Hide/unhide personal ribbon tab.
  298. Opening files on the web
  299. split data to different Excel files
  300. Compare value in cell A to value in Cell b and add 1
  301. Automatically sending Outlook mail
  302. Run xlsm Macro in the middle of night
  303. RE: Open files from a file register
  304. Open files from a file register
  305. Excel with MS Project
  306. Macro to Activate a Macro
  307. Exit 2 Sub
  308. Programming problem
  309. Check to see if reference library is enabled
  310. Re: Cancel InputBox
  311. Cancel InputBox
  312. Taking a picture of a userform?
  313. Tom Ogilvy's Filter Check Function Adaptation Needed...
  314. If cell equals a text value return a value from corresponding cell
  315. Dependent Cell - Change Value Problem
  316. Dependent Cell - Change Value Problem
  317. Re: coding a find button and a listbox to work together
  318. Validating a input box entry
  319. Re: InputBox and UserForm
  320. coding a find button and a listbox to work together
  321. Color rows based on a cell value
  322. Help with code - countdown timer
  323. Help with code - countdown timer
  324. InputBox and UserForm
  325. RE: Writing excel info into MS Word
  326. Writing excel info into MS Word
  327. Extract First Letter from each word in a Text String
  328. Removing a VBA Project from the Project Folder
  329. Removing a VBA Project from the Project Folder
  330. Transpose simple question
  331. Transpose simple question
  332. Shift Result from Start Time Formula
  333. Stopping Excel from stripping off leading zeros?
  334. How do I: vba to create column sorting buttons/hyperlink
  335. DAY Function issue ...but am baffled....
  336. DAY Function issue ...but am baffled....
  337. count multi lines
  338. count multi lines
  339. Blank cell w/data validation & automatic fill in?
  340. Manipulate Text Boxes on Chart
  341. Code Fails on SAVE
  342. ListBox Property where 'focus' triggers selection
  343. ListBox Property where 'focus' triggers selection
  344. Tracking Driver Hours
  345. If year = X and Value = A,B,C then show N...
  346. VBE problem ?
  347. RE: center aligning commandbutton text
  348. center aligning commandbutton text
  349. Autofilter in 1 workbook and paste in 2nd workbook
  350. Autofilter in 1 workbook and paste in 2nd workbook
  351. Application error
  352. Application error
  353. Same table in to sheets
  354. Copy Headings based on Cell Value
  355. Continue formula until reaching a blank cell.
  356. RE: Cell reference to determine filename
  357. Cell reference to determine filename
  358. 0 instead of nothing?
  359. Helpme with Forumal Array option
  360. Calendar Userform?
  361. commandbutton text/assigning sounds
  362. RE: Help with macro to delete rows
  363. Help with macro to delete rows
  364. Get sheets name without file open
  365. $ sign in Formula with cell referce
  366. $ sign in Formula with cell referce
  367. Copy data to new sheets
  368. UserForm Combobox Change Event
  369. max number in cell rest in other cell
  370. worksheet that will only work on one users pc
  371. worksheet that will only work on one users pc
  372. Comments for Software Protection Solutions
  373. Comments for Software Protection Solutions
  374. Distinguish between Windows Xp and Windows Vista
  375. Distinguish between Windows Xp and Windows Vista
  376. Center displayed columns in middle of window
  377. Inverse FFT
  378. Copy chart and paste it as a PICTURE back into Excel
  379. Copy chart and paste it as a PICTURE back into Excel
  380. Check the two different cells in the same row
  381. Check the two different cells in the same row
  382. counif by column2 & column 4 ?
  383. moving charts - show data?
  384. RE: Insert Worksheet change procedure
  385. Insert Worksheet change procedure
  386. Selected series in chart
  387. VBA slows with time
  388. Autofilter
  389. Creating Dependent lists
  390. Locking worksheet
  391. Import Worksheets and "Overright"
  392. Copy/Paste from Different Worksheet
  393. Excel 2007 XML error: "The screentip attribute is not declaed"
  394. remove module via code
  395. Excel addin
  396. Excel addin
  397. Creating Path and FileName
  398. Creating Path and FileName
  399. VB editor find/replace: Use pattern matching
  400. VB editor find/replace: Use pattern matching
  401. Update #REF! to Active Workbook
  402. A solution to Excel2007 slowness when running Excel 2003 macros
  403. Program Speed - Arrays Searching vs. Row Searching
  404. Adding to a "list sheet names" macro ...
  405. RGB for column and row headers colors in Excel 2007
  406. Copy basic format from one cell to another
  407. Error 400
  408. combox box
  409. combox box
  410. RE: Save As in a Macro
  411. Protect Workbook
  412. Userform hanging after show
  413. RE: Save As in a Macro
  414. Save As in a Macro
  415. Excel 2007 Add-in not displayed in Add-in Manager
  416. Message box with Yes or No option
  417. RE: IF function and date range
  418. Loop through worksheets
  419. Loop through worksheets
  420. IF function and date range
  421. Append to a cell
  422. CLEARING THE CLIPBOARD !!!
  423. CLEARING THE CLIPBOARD !!!
  424. Ribbon in Excel 2007
  425. Ribbon in Excel 2007
  426. ListObjects.Add Question
  427. With Specific App
  428. Scanning in reverse order
  429. Date Format
  430. Reading the duration property of an mp3 file in VBA
  431. RE: Filter show all in VBA
  432. Filter show all in VBA
  433. Failed to open document by double click
  434. Add all fields to pivot using VBA
  435. Using VBA to swap between a clustered or separated column chart
  436. Using VBA to swap between a clustered or separated column chart
  437. Insert Form control on worksheet
  438. Insert Form control on worksheet
  439. Hidding ribbon created in Designer
  440. Hidding ribbon created in Designer
  441. Update table in access from excel
  442. How to Write Error Trap
  443. How to Write Error Trap
  444. Double click to clear option button
  445. Environ () Function
  446. Excel & MS Query caused compile errors
  447. Change numbering of data
  448. Change numbering of data
  449. Selected... or not ??
  450. Selected... or not ??
  451. Allow programmation in a userform
  452. "order by" and removing newer records
  453. 1 Hour in Excel 2003 vs 8-10 Hours in 2007
  454. VBA fails with Run-time Error 429 "ActiveX component can't create object"
  455. VBA fails with Run-time Error 429 "ActiveX component can't create object"
  456. Need to add values...maybe
  457. Want to check if cell is blank before running macro
  458. Requiring Cell Input
  459. "ByRef argument type mismtach" on string variable *sometimes*
  460. "ByRef argument type mismtach" on string variable *sometimes*
  461. Path & File Name
  462. Path & File Name
  463. Code locking up until I press the reset button
  464. Code locking up until I press the reset button
  465. How do I set this up
  466. Project / Libary error
  467. Project / Libary error
  468. 2 validation macros
  469. 2 validation macros
  470. Range object evaluates to Range.value, or Range object
  471. Range object evaluates to Range.value, or Range object
  472. Vlookup or Match VBA
  473. excel form on internet
  474. excel form on internet
  475. How does XL "lose" a macro that's right there?
  476. How does XL "lose" a macro that's right there?
  477. Anaother time format question
  478. RE: Selecting a Table Column
  479. Excel 2007 VBA
  480. Excel 2007 VBA
  481. Selecting a Table Column
  482. Re: Auto Check Mark
  483. Auto Check Mark
  484. Activating a command button with a single key stroke
  485. Hyperactive ToolBox in VBE
  486. Custom Right Click--VBA?
  487. Custom Right Click--VBA?
  488. Insert Tab Character
  489. Pivot Tables - delete rows from Master List
  490. VBA Search Workbook Question (Excel 2007)
  491. VBA Search Workbook Question (Excel 2007)
  492. Active X Control - Combo Box
  493. Run Time 1004
  494. Need help with formula...
  495. Decimal problem
  496. Decimal problem
  497. search form in excel
  498. search form in excel
  499. Some expert help needed
  500. Decline Save
  501. To remove the promt question message in a Save As method
  502. Exchange Server 2010 Beta 1
  503. Open Workbook Macro - with a twist
  504. Open Workbook Macro - with a twist
  505. Array/Literal notation
  506. Array Formula/UDF
  507. Multipage label caption
  508. Can I declare an event in Excel 97?
  509. All possible combinations of data inputted under three headings
  510. Multiple windows of single file display on windows taskbar
  511. VBA Range.Formula
  512. VBA Range.Formula
  513. About Excel VBA
  514. Collapsed category title question
  515. Re: single file, show multiple tabs
  516. single file, show multiple tabs
  517. cancel message while sub running
  518. Excel Macro Settings
  519. RE: Problem with a macro
  520. Problem with a macro
  521. Different ways of generating same range object gives differentresults
  522. Issues with excel 2000 xsl template
  523. Using VBA to copy a Chartsheet to Powerpoint
  524. Sheet navigation, if there isn't hotkey for "go to first sheet"?
  525. Runtime Error 13 - Type Mis-match
  526. averaging non-contiguous data using arrays
  527. Convert UTF-16 Excel file to UTF-8 and back
  528. Custom Toolbar Loading issue
  529. Dynamic web query - Can this be done?
  530. XL 2007: can't change Inactive Excel Add ins to Active (DLL Com Addin as Visible)
  531. Find text in a word document
  532. delete rows based on 2 conditions of that row
  533. Referencing sheet on a web browser
  534. code trying to run while typing
  535. dtermine row/column boundaries of selected area
  536. Clear formula memory?
  537. Auto copy cell data from source sheet to another wrkbook sheet
  538. Problems with CSV file input
  539. Passing an event up the chain.
  540. Re: Toolbar Gone - STUPID STUPID STUPID!!
  541. Re: Toolbar Gone - STUPID STUPID STUPID!!
  542. Entering information
  543. Toolbar Gone - STUPID STUPID STUPID!!
  544. Help with Concatenating
  545. Treeview with context menus
  546. Multiple criteria...
  547. Update Excel file
  548. help with debug errror and saving only one worksheet
  549. Can we use variables in XL macros?
  550. Datamatrix ActiveX control
  551. Scatter chart does not refresh: HELP
  552. I learned how to rename workbook without saving it
  553. For Loop
  554. Comparing against table to return value
  555. GetOpenFilename with default filename?
  556. CreateEventProc
  557. Change when function is called
  558. control the Visible Property on sections of a UserForm with a macro
  559. Returning to active sheet
  560. Text Box Scroll Bars do not appear until you click in the text box
  561. How to delete commas and spaces when not needed ... S&R way, or macro way?
  562. Dumb question # 32,345..Moving Around On A Spreadsheet
  563. Dumb question # 32,345..Moving Around On A Spreadsheet
  564. Summary table from two worksheets
  565. Hiding RTD calls
  566. vba function module returns #NAME?
  567. Sorting a spreadsheet that is grouped/outlined
  568. Macro Button to Sort Columns - Troubleshooting ideas?
  569. Read and write an array
  570. vba function returns #name?
  571. Merge Sheets
  572. Summing two columns
  573. Deleting Duplicate Rows containing a value matching with a value f
  574. Macro Code Issue
  575. linechart through vb script
  576. Copy from worksheet if cell is blank
  577. sumifs question
  578. Error Handling with Worksheetfunction.Match
  579. Re: Create a Month's Sheets automatically
  580. Import .odc files into an Excel workbook.
  581. Create a Month's Sheets automatically
  582. CDO Email with Gmail
  583. Copy Worksheet Between Books and Retain Formatting
  584. Size of arrow in combo box
  585. .Paste
  586. .Paste
  587. .Paste
  588. Operate on each cell in range.
  589. Data sort is placing blanks at top
  590. Problem with advanced filter macro
  591. Looking to select noncontiguous rows with For loop
  592. Help - Easy one - ControlSource Property Invalid
  593. Counter
  594. Alternate to ActiveWorkbook.Close
  595. Dynamically Freeze Panes
  596. Open another WorkBook
  597. Force Excel to close
  598. Listbox selected
  599. Can I do this autoselect with GetOpenFileName or the Dir function?
  600. Unlocking Aspect Ratio For images
  601. Three-way Lookup Help Please
  602. Type of charts from Access
  603. Solution required
  604. Converting a grid of data to linear
  605. Troubleshoot access - excel linked table
  606. WEBSITE ACCESS AND VBA !!!
  607. Google query
  608. Help with Tooltip on clipart
  609. COUNTIF function help please
  610. Macro issues - trying to get an array to a column
  611. Help with VB macro
  612. Vlookup Help Please
  613. RefreshTable vs PivotCache.Refresh
  614. Problem With A Pesky Question during a Macro
  615. vbOKCancel Problem
  616. Macro recently quit working
  617. clear contents re value
  618. check for links
  619. check for links
  620. Renaming the Excel windows taskbar
  621. 100% quandry
  622. Finding the biggest number out of 8 variables
  623. Data Validation - List
  624. listbox with multiple selections
  625. deleting sheet
  626. Delete sheets
  627. path to macros being changed
  628. Extract base domain from an URL?
  629. sumif in vba
  630. Copy a command button
  631. Rename Tab
  632. Download data from web page
  633. Input Box Location
  634. Email Using CDO - mixed results
  635. Window Manipulation
  636. Driving me Crazy
  637. .dropdown problem
  638. Print to PDF code for both Cute PDF and Adobe
  639. Need to meet criteria
  640. Efficiency, Workbook objects in User Defined Record
  641. "Limited Use Question?"
  642. Add problem
  643. Preventing Duplicate Records
  644. RE: Compare cell value with string
  645. RE: Compare cell value with string
  646. Re: Compare cell value with string
  647. RE: Compare cell value with string
  648. Compare cell value with string
  649. Form Startup Position
  650. Autofilter using a value from a list.
  651. Spell Checking on a protected sheet
  652. Call a sub in a modeless userform from a code module?
  653. VB script line graph
  654. ControlButton Size
  655. multiple column Listbox - look like table
  656. Adding and Protecting a Totals Column to a Table
  657. Dim Array as Byte
  658. How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code?
  659. Copy range on multiple sheets into one sheet
  660. Copy range on multiple sheets into one sheet
  661. Looping through file names of a csv and then through other csv
  662. Insert formulas
  663. RE: Stack Space Problem with On Worksheet Change Event
  664. RE: Stack Space Problem with On Worksheet Change Event
  665. OpenOffice macros
  666. .CurrentPage = "(ALL)"
  667. Stack Space Problem with On Worksheet Change Event
  668. Stack Space Problem with On Worksheet Change Event
  669. Image Stretch While Printing
  670. Custom Properties for Worksheets and Workbook
  671. Code debug
  672. Hide Columns
  673. Horizontal scroll bar
  674. Workbook_close
  675. Auto_open User Name Log
  676. Is there a command to 'Hide' the Activeworkbook?
  677. Format Zip Codes Correctly for a Mailmerge
  678. FRom Pivot table select multiple items under report filter
  679. module won't quit as expected
  680. Force users to enter a range of cell in dd/mm/yy hh:mm format
  681. Re: What application do you use to write VBA on?
  682. Re: parse Excel
  683. Re: What application do you use to write VBA on?
  684. Copy contenst of a cell into a string
  685. What application do you use to write VBA on?
  686. Open file from same path
  687. all permutations
  688. RE: A way of capturing the new path a file is stored in
  689. Fully Populate Tree View Control
  690. How do I calculate the age of a person from their ID no.?
  691. Find method without "With / Set" in a For...each: error after 1st run
  692. Address of Excel.Range & Range
  693. using excel from c++
  694. Replaced text count
  695. API code for 'Renaming a Directory'
  696. Picture on Worksheet Cell
  697. Cannot find project or library
  698. FIND method , versus FOR EACH ...
  699. File check on FTP server
  700. Import through dialogbox
  701. Auto_Open Code on Worksheet
  702. Application.Quit Not Working in Office 2007
  703. Main Sheet
  704. Check for duplicate numbers from ones entered and anoter set
  705. Multiple of a Variable in an If function?
  706. code to hide/unhide rows
  707. How do I add iserr or iserror to this
  708. Wavfile playing trubcated
  709. Change a web query
  710. Run-time Error: '438'
  711. Print Userform - fit to page
  712. 20007 issue?
  713. Create list of files with hyperlink from a folder with EXCEL 2007
  714. Lookup and match color of corresponding cell
  715. Slow Updatelink off Networked Open files
  716. Capture
  717. Activate a Workbook
  718. CDO to Retrieve E-mail
  719. new workbook add and save by a modified name based on original fil
  720. New to excel macros need help with selecting ranges
  721. Is somekind of Slider Selection possible?
  722. macro to redirect to another worsheet within the same workbook
  723. Manipulating Strings in a Macro
  724. Open Sharepoint Hosted Excel File, in Excel, Using VBA
  725. Show a value for Listbox1.Selected(i)
  726. Error in excel com: Microsoft.Office.Interop.Excel Exception from HRESULT: 0x800A03EC
  727. How do I force user to enter their ID# before filling other data?
  728. Problems With Page Breaks
  729. Copy/Paste dynamic ranges
  730. Copy/Paste dynamic ranges
  731. Paste
  732. Automation: Invoking Excel Financial Functions Without InstantiatingExcel?
  733. Delete All Blank Rows--A plea for help
  734. Change cell with command button
  735. Re: Auto code in VBE when pressing F7
  736. Re: Placing a few spaces between syntax
  737. Passwords
  738. Placing a few spaces between syntax
  739. Read in Data
  740. Help with inserting automatic comments
  741. Removing automatic(Default) page break
  742. Auto code in VBE when pressing F7
  743. Re: macro to send you to a specified worksheet
  744. Macro
  745. macro to send you to a specified worksheet
  746. Grouping Based on Indent
  747. Macro to run Command Buttons
  748. Rearrange Data
  749. macro for deleting specific columns & rows. Help. Please. No Clue.
  750. CellPointer (rectangle around selected cell) not visible
  751. Code Help
  752. using one macro to edit another
  753. Add data to 2007 table based on column names?
  754. Autofill Help Please
  755. Copy sheet and rename tab
  756. Looping Help Please
  757. Visual Studio 2010 (Creating Excel DLL) "warning" no build
  758. macro to transfer from excel to word
  759. RE: Visual Basic - Invisible Command
  760. RE: Delete VB code from a worksheet
  761. Visual Basic - Invisible Command
  762. RE: is array redimmed?
  763. 5 months prior to date macro help please
  764. Delete VB code from a worksheet
  765. is array redimmed?
  766. 2 Autofilters
  767. FreeFormBuilder Bug?
  768. Hard code the workbook name in macro
  769. Macros Being Re-Directed
  770. Check URL exists in Webquery
  771. Query 2 excel files with ADO
  772. Selection after copy sheet failed
  773. How do i password protect my VB Code from users
  774. Saving data from a user form
  775. Worksheet Function
  776. Invoice
  777. Button - Assigned Macro
  778. Retrieving Current Row,Columns & copying Format from Row,Columns a
  779. "Web" Command Bar always appears on start up
  780. Moving the cursor around with a macro....
  781. Comboboxes with multiple values
  782. Hide value of cell if value same as other cell
  783. Adjust Zip code to 9 Char fmt.
  784. Need to run a Macro to ....
  785. Need to run a macro to ...
  786. Send an email from Excel using Outlook
  787. 2 columns w/ text data that i want to do a wildcard comparison
  788. How to run this macro
  789. Maintaining selections in UserForm
  790. Run-time error '424': Object Required
  791. Conditional Selection.Find
  792. Cell reference in User Defined Function.
  793. Running a Batch file from VBA
  794. variable in application line
  795. Userform - Label
  796. Copy if adjacent Cell has data
  797. Fast AND Accurate
  798. Compile error in 2003
  799. setting a variable to the offset of another object declared variab
  800. Loop to delete shapes
  801. Re: Sorting Macro Loop
  802. RE: Sorting Macro Loop
  803. RE: Sorting Macro Loop
  804. Website problem
  805. Return Column Number
  806. Sorting Macro Loop
  807. RE: exit form and close sheet
  808. Copy a mamed range in one worksheet to the first blank cell in a c
  809. comparing data without unique identifier
  810. exit form and close sheet
  811. Highlight Duplicate Rows (In Series)
  812. name ranges in array
  813. what VBA command is used to go to the next blank row in Excel?
  814. PLease Help!
  815. When this happens, do that, then do the next thing
  816. query criteria based on a changing list of values
  817. Spliting Data into Months
  818. Combine and Convert to Multiple Rows
  819. If Formula & Vlookup
  820. AutoShape color
  821. Re: Coding, Formula, or Conditional Formating?
  822. Check for duplicate values
  823. Copy code
  824. making a worksheet & certain ranges within a variable
  825. Selecting worksheet and ranges within sheet to run macro on
  826. Coding, Formula, or Conditional Formating?
  827. sheet update date
  828. Keeping XML data in workbook?
  829. Hide and Unhide
  830. Hide and Unhide
  831. Change Print Margins in VBA for Printing an E-mail
  832. Change Print Margins in VBA for Printing an E-mail
  833. Extracting specific data from a string
  834. What is the meaning of this sub
  835. Problem with UDF
  836. Application-defined or object-defined error
  837. Excel OLE Automation: How to access constants ?
  838. Workbook which having unreadable contents is not getting opened
  839. environ username vs. application username
  840. Help with hyperlinks
  841. Scroll Bars on Worksheet
  842. Create own properties?
  843. using the same range name on different worksheets in a workbook
  844. Cursor and Sheet Protection may09
  845. Named Ranges vs. Constant Addresses, sheet protection, Guidance.
  846. Modifying Sub SortMatch
  847. "Do You Want to Save Changes" message window
  848. Paste Special values for entire workbook
  849. Missing Printer Method in VB6
  850. Add in does not Function in Excel 2007
  851. referring to a row that contains a single cell
  852. Problem using DLL written in C++
  853. Speed up Array Transfer to Dictionary
  854. Searching a cell for certain contents
  855. Variables in a Userform
  856. How do I know that Application.AutoRecover.Enabled = False works?
  857. How do I print to a printer line by line from VB6?
  858. list or combo box?
  859. macro to automatically remove blank rows
  860. Tough one - image and embedded html document
  861. How do I print to a printer in VB 6?
  862. Input box for multiple entries
  863. ComboBox and multi sheets
  864. Run Excel with VBA code from Website
  865. Re: Delete Row if value in row changes
  866. Delete Row if value in row changes
  867. Copy all worksheets to another workbook, excl. duplicate sheets already in other workbook
  868. personal.xls in Excel 2007
  869. Shell Command
  870. I want to define the use of Unicode globally in a VBA macro in Ex.
  871. removing duplicates in a row
  872. Form Names
  873. Input box help needed
  874. disabling macro message
  875. Locking cells, Excel 2003 SP3
  876. Execute a macro automatically when checkbox is clicked
  877. Automatic transfer of row info to another worksheet
  878. Macro instead of lookup
  879. Pivot Excel 2007 - Change data source Table head's cells' values ...
  880. Pivot table - eliminate rows out of the table
  881. How to check the decimal number of each cells vaue in the column
  882. Modify all pivot tables in one sheet
  883. reference with variables
  884. Check that only ASCII chars are used
  885. How to check the last digit of each cells vaue in the column
  886. Is this right?
  887. Enter smallest amount in row
  888. Re: Generating new workbooks based on data
  889. Re: Generating new workbooks based on data
  890. Generating new workbooks based on data
  891. 3D averaging / histogram
  892. Enter the smallest amount in row
  893. Ignore Case without using Regular Expressions
  894. Conditional "If Not ... Then" Statement not working properly Help!
  895. Help with this macro please
  896. Public Variable Question
  897. New range overwrites other range in create sheet macro
  898. New range overwrites other range in create sheet macro
  899. Assigning macro buttons to macro code in another file
  900. Error 4605 when trying to copy/paste a table from excel to word.
  901. Problem with formula
  902. Defining multiple ranges as one range
  903. Filtering data hides row
  904. Code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.
  905. Transfering data
  906. Unable to Compile a Macro
  907. XMLSS document to Excel document in .xls format
  908. Unable to Compile a Macro
  909. Shell comand
  910. Problem reading text file
  911. sheet code window
  912. test
  913. Updated sheet content is not copy pasting from sheet1 to sheet2
  914. Delete VB issue
  915. Selected listbox item
  916. Save As Macro
  917. When
  918. Get "Large" from List
  919. Error: "Compile error in hidden module: Main"
  920. VBA project not viewable
  921. clipboard excel
  922. Using function to change a cell color
  923. Text Formating
  924. RE: ActiveWorkbook.close problem
  925. ActiveWorkbook.close problem
  926. how to open a workbook when application excel is running ?
  927. Finding TWO things
  928. UBound array problem
  929. If Selection is one cell
  930. data summary & macros
  931. Using check boxes
  932. Check if Range EXISTS
  933. Sub or function not defined
  934. Lose Cursor After Protecting Sheet
  935. Get data from closed file... Cont..
  936. Re: Check cell range for a fragment
  937. Check cell range for a fragment
  938. Can a macro do this job?
  939. Open a Workbook using VB
  940. Sort
  941. sOURCE CODE REPOSITORY
  942. alternative to using the 'chart method' to exporting range as .jpg file
  943. WinZip 12 page
  944. arrays
  945. VB career advice appreciated for self-taught newbie
  946. RE: Skip Errors
  947. Skip Errors
  948. Activate Workbook (Windows) with keywords
  949. Use Bcc
  950. using variable in subject when send mail
  951. Opening a new workbook via a macro
  952. How to access VBA variable from active worksheet
  953. Give a sheet a name from data in a cell-saving to a specific folde
  954. Copying a worksheet with macro buttons on it
  955. Copying multiple worksheets to another workbook
  956. How do you get the selection in the VBE Active window
  957. Can an input box do this
  958. ListBox question
  959. insert 3 rows between data
  960. macros
  961. a formula to go in a macro
  962. Looping Question
  963. Refreshing pivot tables according to scroll menu result
  964. How can I selectivly delte rows with a macro ?
  965. Why is this Worksheet Change Event triggered?
  966. scramble names on work roster
  967. Command Button misfire
  968. Looking for a way to Set Range to Entire Column
  969. XL2003 find and replace broken?
  970. Change delimiter position based off of Last Name
  971. Memory Management in VBA
  972. Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
  973. ScrollBar - set MIN/MAX cell value
  974. Column grouping and hiding being over-ridden when sheet opened
  975. Subtotal Function response is slow
  976. send an outlook task to colleagues
  977. Insert Contents
  978. Need Calculations Done Event
  979. Copy sheet to next un-named Workbook
  980. Runtime Error 13 - Mismatch
  981. Sample VBA code to open an Visual-Studio-2008-created VBA DLL
  982. Excel 2007, Custom Right Click Menu Doesn't Work in Table
  983. Outlook and bcc
  984. Create User-defined Template
  985. VLOOKUP in VBA
  986. To Enable Macro in Excel.
  987. CNA
  988. Run-time error: '9'
  989. Referring to same cells in all worksheets
  990. outlook task recipient
  991. Events
  992. Vlookup based on Combobox in a Userform
  993. How to implement the progress bar to indicate the Macro start to finish
  994. How to Upload a Workbook on my website
  995. How to Upload a Workbook on my website
  996. Excel XML Time format & arithmetic
  997. Excel XML Time format & arithmetic
  998. Excel XML Auto Column Width
  999. How to hide rows in a range that have a certain value, withoutfiltering
  1000. Open files Error in Excel 2007