PDA

View Full Version : Microsoft 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 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. Disabling Paste Options
  2. Highlight row if condition is met
  3. how to parse through pivot filtered items
  4. Throttling DDE's Thread Count or CPU Utilization
  5. Modify existing code to dynamic code
  6. Excel remaining open on workbook exit
  7. Converting Paste to PasteSpecial Values
  8. Cannot kill a WINWORD.EXE instanciation
  9. Adding vs Concatenate
  10. Inserting Row
  11. List & Text Box Problem
  12. Last updated cell
  13. Sheet.Select is not working - why?
  14. Workbook_BeforeClose trouble
  15. How to open a *.Vba file
  16. caption property in command bar (excel 2003)
  17. alternating format
  18. action upon selection
  19. sorting language
  20. Send file to Bluetooth using Excel VBA
  21. Preserve Excel undo stack
  22. Open Folder Help required
  23. Open a folder
  24. the go to formula
  25. Accounting Software Import
  26. DSUM vs sumproduct
  27. Custom Toolbar Icons Ugly in Excel 2007
  28. Help with code to sort worksheet, please?
  29. Cell displays ################# instead of the text
  30. Position DataLables on a pivot pie chart realative to their Points
  31. Add formula to cells in a column through VB
  32. Display and Hide a text or Auto Shape box
  33. Programmatically delete Module1 from a workbook
  34. Macro independent of newbook name
  35. Problem entering percentage on form
  36. cell value storage
  37. Help with CreateObject
  38. Template Files
  39. Some Files Can Contain Viruses........
  40. View Code
  41. Protect Cells
  42. Pivot Table Columns
  43. String Comparison Not Returning Expected Result
  44. Using Paste Feature with out Activating Sheet
  45. How to calculate based on Validation LOV items?
  46. VBA Autorefresh format change
  47. Any library issues when giving XL2003 wkbk to XL2000/2002 users?
  48. Change pointer to hand over button
  49. Updating OLD code
  50. have calculations from sheet one calculate in table on sheet two
  51. Pivot Table Update - Data from GP Dynamics
  52. ABMS like sim stores model
  53. Select a range in an unselected cell
  54. Compare Range Totals After VBA Manipulation
  55. Delete Space
  56. Open file on password-protected FTP site
  57. Stacked Bar Charting help needed
  58. Stacked Bar Chart
  59. Daily Updating
  60. How to display columns in the right order from a SQL DB query
  61. to make pictures move in excel
  62. Using a "SHELL" Command
  63. controlling excel recalculation in VBA?
  64. Automatically update a sheet from another
  65. "Too Many Cell Formats" when merging files
  66. Rename rather than overwrite existing file
  67. Making Excel 03 count product usage by month
  68. Adding comment to cells not working with merged cells
  69. Border around each printed page
  70. Referencing across projects
  71. Restrict user's ability to paste into cells
  72. Macro to Save (As) a file
  73. Recommended header when hiding multiple columns?
  74. VLOOKUP
  75. IE automation, Frames content reading problem, excel 2003 and 2007
  76. Shared Workbook - Slow opening of shared workbook.
  77. ActiveX warning after control is deleted
  78. Modification of existing code
  79. VLOOKUP
  80. Need help with COUNTIF in VBA
  81. Protection using Username
  82. Inserting pictures into cells (Excel 2007)
  83. Get page orientation of active sheet in Excel 2007
  84. searching in the list of dates
  85. Getting list of theme colors
  86. selecting cell under a button
  87. Select chart object in Excel 2007
  88. Change Sheet Format to Tahoma
  89. Application.DoubleClick question
  90. how to create the formula for that attached explanation
  91. macro to disable auto refresh
  92. Refreshing user defined functions
  93. Unable to close 2nd user form
  94. need help
  95. need help
  96. Excel 2007 Menus
  97. Start/Repeat/Stop Macro at specific time/interval
  98. excel 2007, problem with msgbox and custom help file
  99. Excel/VBA source book?
  100. Data types Cells
  101. How to stop calculation on open?
  102. Help
  103. Universal time
  104. DoubleClick on embedded object(shape)
  105. Cummulative total in Userform
  106. Desable "Cancel" event
  107. Efficient way to drtermine if a string contains digits?
  108. Compare Column Headings
  109. Keeping code dynamic when adding columns to a list of records
  110. Just upgraded to Vista Macros unstable
  111. Loop Not Working
  112. Convert SQl to VBA so that it executes in VBA
  113. Code to open links
  114. What Is Wrong Here?
  115. how do i protect a worksheet without disabling drop downs lists?
  116. How to write late-binding code in XL VBA for Word objects?
  117. VLOOKUP
  118. VLOOUP
  119. Terminating autofilter removes commandbuttons (xl2000, not in xl2003)
  120. Conditional printing
  121. chart source data code
  122. Conditional Formatting based on data in adjacent cell & restrict save without required data
  123. Creating multiple formated text in a textbox.
  124. Manipulating Notepad from Excel
  125. Are objects slow in VBA?
  126. Close doesn't always close
  127. add check boxes in a list in excel
  128. When does DoEvents return?
  129. Highlight selected cell
  130. synchronizing folders
  131. Get Last Row
  132. Frustrated rookie trying to create a custom form
  133. Call an addin Macro from Workbook_Open event
  134. Delete Duplicate row and Copy to another sheet
  135. VBA program to limit date
  136. trying to count the pagebreaks in the immediate window
  137. Inserting contents of a Word document into a Userform in Excel
  138. Selection.ClearContents for data only
  139. Can I have two worksheet_change events in same worksheet?
  140. vba
  141. object required
  142. Functions that return arrays
  143. Macro to password protect
  144. Excel Sheets Opens Itself Again After ADO Query ! Please Help It's Urgent !
  145. Select case or If then
  146. error 424 object required
  147. Looking for help with a sorting macro.
  148. Can you recommend an Excel book? ...
  149. copy cells
  150. copy cells
  151. Evaluating 3 Variables
  152. update file list code for excel 2007
  153. Email on value change (Formula)
  154. issue with RefersTo in non-EN languages
  155. Mkdir with 2 variables not working ....
  156. import text to Text box
  157. Print multiple files from File Open screen
  158. macro opening a file
  159. Identify open Workbooks
  160. Using a macro to do a calculation
  161. Automating Calculation of Lagged Cross Correlations between Variables
  162. Could not find installable ISAM
  163. Application.GoTo.Reference query
  164. Excel and VBA - If and Find Expressions
  165. Generating a column based on import file name
  166. Stating an area in vba
  167. Sumproduct in VBA
  168. How to get the screen resolution in VBA
  169. NOT ABLE INSERT CHART
  170. Selecting non adjacent cell ranges
  171. Using Indirect Function to Intersect 2 Named Ranges
  172. excel 2007 Seriescollection.Add bug
  173. Data import, carriage return
  174. Data import, carriage return
  175. Excel 2007 ListObject question
  176. VBA code for pressing "down arrow" in recording macro
  177. Ranking and real time manipulation
  178. Formatting a cell as a hyperlink
  179. How do you store data in Excel as a database?
  180. Need Help
  181. Condition form
  182. Accumulating values from one page to another.
  183. Adding Columns in Excel 2007 (2003 Compatibility Mode)
  184. Question about rounding.
  185. Do Until Loop Help
  186. Problem opening a word file from Excel
  187. Do Until Loop Hlpe
  188. Hyperlink from cell value
  189. AutoFit
  190. Deleteing a worksheet
  191. How Can I reference a the * cell in a list?
  192. Turn off error dialogue
  193. Find Last cell copy UP
  194. Importing many text files into one excel worksheet - how to?
  195. Extending Selection of Column to the next Column to the Right
  196. data table function
  197. Rows outside of current range being saved as CSV
  198. vba autofilter two columns
  199. Website Excel Spreadsheet for Non-Excel Users
  200. Variables into autofilters
  201. Reducing Color Intensity in Excel?
  202. Row number changes in conditional format formula during VB executi
  203. Using "IF" with a "NAME" search?
  204. What is Add in
  205. Collection::Item runtime error
  206. lookup multiple values
  207. Selecting tabs in a multipage form
  208. How to delete the duplicate name on columnA
  209. Requesting Help (yes again) Translating a Macro into VB.Net Code
  210. Get cell name into MsgBox?
  211. ODBC excel Macro help needed
  212. Payroll calculations
  213. Sync
  214. Read Variable from Another Module
  215. Custom Cell format
  216. TESTING FOR EMPTY ARRAY
  217. Extract Values from a String
  218. excel workbook time log
  219. Select range of rows/Columns?
  220. Tools/Add-ins displays unable to read file
  221. Compacting or a Summation of several different lists into one
  222. Excel object "Access denied" error
  223. .HTMLBody
  224. "is now available for editing" problem with Excel-automated mail merge
  225. Using Find on nonactive sheet
  226. Lopp Formula
  227. Executing a command when clicking on a tab
  228. Loop from a to z
  229. Need elp comparing two columns in VBA
  230. command button for open sheets
  231. Start macro "on load all information"
  232. display hidden controls once check box activated
  233. Web Page Hyperlink not executing from Access 2003 query export
  234. Find values from one worksheet in other worksheets
  235. Programmatically turn on Track Changes
  236. Pivot Table Refresh Speed Issue
  237. effective rate, debt issue costs, loan interest with varable payme
  238. Programming Function
  239. userform for multiple sheets
  240. eliminate N/A error when using Vlookup
  241. External data and password
  242. Internet connection check via vba?
  243. Is there a way to release the memory taken by a Recordset Object ?
  244. Update hyperlink value with cell value
  245. Move multiple worksheets to a new workbook
  246. Using a macro to open an existing workbook
  247. Using ADO to Query Excel
  248. Using ADO to Query Excel
  249. set a range thats not allways the same size.
  250. Array formula in a makro want work
  251. Macro doesn't run under Vista
  252. How to determine order of row fields in pivot table
  253. Finding a user's My Documents path
  254. Overriding the overwrite confirmation prompt
  255. Unauthorized Movers!
  256. monthview calendar question/ want the calendar to display weekdays only..
  257. A Pictures Puzzle
  258. a defined name not working in Excel 2007
  259. Help with Macro
  260. Set up a time line tracking schedule
  261. Isolate Numerical Data in Cell
  262. Move data from a worksheet
  263. How do I select the 2nd sheet from the Right in this code Q
  264. activity duration
  265. LOOKUP filename construction
  266. Counting data
  267. Multi-threaded calculation and VBA
  268. counting data
  269. Get Cell Contents Including Formatting
  270. Some Help Please to Translate an Excel Macro into VB.Net Code
  271. Open Workbooks, Used Area on Sheet
  272. Copy worksheet
  273. Macro Help in Excel 2002
  274. Text parsing - Extracting data from inconsistent data entry format.
  275. Transfer userform contents to Sheet
  276. Search for Partial File Name
  277. Delete a row based on more than one condtion
  278. how to copy workbook names and worksheet names to columns in acces
  279. Sorting Issues
  280. User form return values
  281. Can I Designate Cells "Not Available" Without Raising an Error?
  282. Programming
  283. Impossible to close excel without saving message in internet explorer
  284. Running another program out of excel
  285. sorting text in a string
  286. how to select multiple charts on a worksheet in excel 2007
  287. custom format syntax ques
  288. Joel, Would you contact me on your reply please? Thanks
  289. PasteSpecial method of Range class failed
  290. Load Add-Ins
  291. Trying to close Excel file nut get error msg
  292. Closing Excel
  293. Find text in column
  294. Deleting duplicate rows
  295. dynamic clock in excel
  296. Incremanting text
  297. Opening Excel Workbook More Than Once
  298. Formula to get number
  299. Copy down Multiple cell
  300. Excel 2003: Stop Screen flickering
  301. Excel 2003: Freeze Panes with list boxes
  302. PACKAGING & DEPLOYMENT WIZARD/FEATURE
  303. Position DataLables on a pivot pie chart realative to their Points
  304. Help in Excel 2002
  305. Change Log with prior and new values
  306. Macro syntax problem - Dean
  307. Status Bar
  308. Merging cells
  309. how to copy content AND formating with vba
  310. Adding cells with programmed data
  311. Custom Menu For Each Sheet In A Workbook
  312. Filling down?
  313. How to Delete VBS code via VBA
  314. Insert > Field control in Word; Link to Excel Sheet
  315. Pass listbox values to autofilter
  316. DOS access from Excel
  317. Activate speech when sheet is changed
  318. Format Date in Save AS function
  319. Making a footer 2 lines
  320. Automation works with Excel 2003 but NOT Excel 2007
  321. strange...
  322. strange...
  323. chart works in excel 2007, not 2003
  324. Cond Format if cell contains Values INSTEAD of a formula
  325. Save As with Cell Verification
  326. TypeName of a UDT
  327. Format Cells for binary or hexadecimal numbers
  328. Creating separate workbooks based on filter
  329. Status Bar
  330. update links
  331. Help with mastersheet
  332. Any way to programmatically make pivot tables behave more like data tables?
  333. Pivot table calculations
  334. Open File Using A Wildcard
  335. Add VB Reference
  336. Calling for a particuler item of Excel 2007 help
  337. Font ColorIndex, Ws Change Event
  338. Parsing names from one column into 3.
  339. Re: filter by more than 2 criteria
  340. copy cell format
  341. Sub that will not end
  342. VBA code to Save a .CSV to an FTP site
  343. Looking for help with a sorting macro.
  344. more excel automation trouble with ms access
  345. How to get username during workbooks.open macro
  346. ms access 2k automation problem with selection
  347. Autofilter Criteria not filtering when using NOW()
  348. Running time of procedure increases
  349. Enable / Disable Command Button depending on a cell's value
  350. Suggested file name
  351. Setting worksheet properties
  352. track whose make changes
  353. reduce if statements
  354. Does a worksheet exist
  355. HELP...anybody got any ideas why this is running so slowly......
  356. TinyGraphs - Open Source Excel Add-in for Sparklines Generation
  357. Duplicating Formulas
  358. Avoid Startup Prompt on Excel 2002
  359. The same event handler for two CommandBar buttons
  360. Preventing Copy-command
  361. query after refresh question
  362. VBA code outputs currency value rounded to 2 decimal points
  363. Using user function (vba) with sqrt(array)-only first answer
  364. Getting vba code (macros)
  365. Barb - don't worry, I got it working...you are a lifesaver!!!!!!.t
  366. Sum cells, excluding hidden columns
  367. 2 Questions
  368. Creating a Running Count
  369. "Bouncing Bar" progress indicator control?
  370. Creating number formula to count number occurences in a data set
  371. Make non-modal form an inactive window
  372. Validation Font Size varies
  373. Clarification
  374. EMail Outlook failing
  375. Unprotect a workbook while opening from Access
  376. Very Slow code
  377. Deleting alternative rows
  378. Creating Reports in Excel 2002
  379. Conditional format over a Range
  380. 1004 error on function for printer
  381. speech function and variables
  382. Code to cut and paste text from continuous cells to make a document such as a memo or narrative
  383. Array or Something in VBA
  384. Trying to shade cells
  385. Help with problem validation problem. 256 limit posted earlier.
  386. 2003 user forms in 2007 macro
  387. Excel Error
  388. Working with data in Excel
  389. Pivot table creating isue regarding columns with the same name
  390. auto sorting data validation list
  391. Security - Post user infos on the internet
  392. Copying a Range When Rows Are Long Variables
  393. Best way to do this-fill down formulas, cond formats, etc only in certain columns?
  394. Trouble! Unlocking VBA project.
  395. Delete worksheet row based on condition
  396. Stack area chart - keep the same color for each item
  397. Exporting Data to Excel from Access for Analysis
  398. Repost - Autofill today's date Everyday
  399. Scrolling Message BOx
  400. 256 character limitation
  401. Vlookup code needed
  402. Deleting Rows Based Upon ListBox Selection
  403. Date Macro if B is populated then date in A
  404. E-Mail Importance Flag Q
  405. Collating of data from 2 or more sheets into one sheet
  406. Macro to Insert New Worksheet
  407. LOOKUP VALUE
  408. Conditional naming of copied worksheets
  409. Duplicate Pastes into a table for a draw
  410. How To Require Input
  411. Using Find in VBA
  412. UserForm VLOOKUP result in textbox
  413. Find and replace "?" character
  414. A Sub/Function to cause another Sub/Function to Exit
  415. "sumproduct" ??
  416. Find date, create new workbook, copy lines with same dates in column H
  417. displaying warning message
  418. Converting a 2007 document to a 2003 version
  419. Run-time error question
  420. Disable moving sheets
  421. Add attachment to CDO email
  422. Change passwords on fly
  423. Custom toolbars in Excel 2003
  424. Bottom Cell with VALUE
  425. Run-time error '5':
  426. Excel / Access User Conference - Oct 24-26, St Loiuis
  427. Import Data from web-sites
  428. Pressing TAB doesn't exit TextBox
  429. Dynamic Stacked column charting with VBA
  430. VBA 2003 and XP compatible?
  431. A "+=" Operator like in C?
  432. Formatting Active Cells
  433. Slow Function
  434. Subtotal function
  435. Populate dataform with combobox1.value
  436. Update links without warning
  437. Dropdown event in validation cell
  438. Convert any documents(Word, Excel) into BMP, GIF, JPEG, PNG and TIFF image
  439. Poor humaneyes
  440. valadation malfunction
  441. Poor humaneyes
  442. Poor humaneyes
  443. No Blank Cell
  444. Control Toolbox Design Mode
  445. Reference 2 separate workbooks!
  446. Enhancements to Sub FillColBlanks by Dave Peterson
  447. Evaluate vba matric
  448. To change Columns(4).Rows.Count
  449. Error sending sheet in mail body
  450. Unhide sheets
  451. sumproduct & dates & similar data
  452. How do I calculate at timed intervals?
  453. need an OR in the countif statement
  454. Excel Macro to choose a line
  455. PRINT command button
  456. Calling procedures of a different project
  457. searching cells with a macro
  458. Using Excel VBA to Make Edits to A PowerPoint Pres
  459. How do I only recalculate 1 cell
  460. sorting named range data
  461. Extracting 3 Arrays from 1 Array
  462. OR statement in a Countif
  463. Error in Retrieving Formatted Cell Value
  464. Auto Load Add-In
  465. How to get specific cell data from one sheet!
  466. How do I activate the next cell in a selected range?
  467. Scan pdf417 barcode = is scanned, actually tab data to next cell.
  468. Simple use of ActiveX Command Button -
  469. Get last column
  470. Why Am I Getting This Error Message Please?
  471. Delete all objects on sheet except...
  472. Autofill today's date Everyday
  473. Copy from file1 sheet1/file2 sheet1 last blank row
  474. Macro hide rows with blank data in cells
  475. macro doesn't hide columns for an unexplicable reason
  476. pulling data from one worksheet onto another
  477. Functions not working in Vista... (custom defined viewable as modules with Alt-F11)
  478. Excel calculate the z factor automatically
  479. Bound Control On A Form Problem - Office 2003
  480. How to seperate measurements 1.375 in (35 mm)
  481. SQL connection string giving type mismatch
  482. sumproduct
  483. Range of cells seem to be initialized randomly
  484. Can a sub be deleted via macro?
  485. VLOOKUP
  486. Embedded pictures
  487. Pivot Tables using VBA
  488. C++ DLL from VBA
  489. Loading a Userform
  490. User Name
  491. get validation on a cell clicking a button
  492. ActiveWorkbook.Sheets.Select
  493. Tuition on 'copyorigin'
  494. Command button on worksheet
  495. Name of cell range not accepted in Conditional Validation
  496. File opens second copy of itself for no apparent reason
  497. taborder on Excel form
  498. turn off error handling
  499. New array with old array elements
  500. Lookup second/third values
  501. Down One Row
  502. hide rows if cell in a column has no value
  503. Excel.Application error
  504. If X = Y then (when it doesn't have to be an exact match)
  505. How to Loop and Read the Cell until the end of worksheet
  506. Object: smart way to assign a value as for an array?
  507. Arranging data from different Column
  508. How to evaluate the size of each worksheet in a workbook?
  509. MsgBox using cell references
  510. measuring load time
  511. showlevels is very slow
  512. Copying sheet with hidden columns
  513. Missing Library Problem
  514. External data validation
  515. copy certain cells
  516. Computer "name"
  517. subtotal question
  518. Replace Contents of Destination Cells
  519. Closing WINWORD.EXE from Excel VBA when my main proc ends
  520. Looping a Macro
  521. Search in multi dimensional array - URGENT help
  522. Unfixing source data range for a pivot table using vba
  523. Advanced filter criteria for <>
  524. Adding a micron symbol to text string
  525. I found a bug
  526. Limitation to Collection Object
  527. values are decimal
  528. xy scatter chart using multiple dynamic range as source
  529. Data Validation List - Multiple Columns
  530. Instruction Delay
  531. Web Query
  532. dash ports
  533. Calculating speed
  534. Updating ExcelName Registry Key
  535. Excel Macros Disabled
  536. Prevent opening solution on other (older) versions (Excel 2000) et
  537. hide column script, range address?
  538. Excel VBA Compile Error when dimensioning jagged array
  539. question about creating variable from 2 strings
  540. Getting error with load/unload of UserForms??
  541. Excel Recent Files Issue
  542. Find-Copy and Paste
  543. Repeating Named Range
  544. Macros, Excel 2000
  545. ZOrder Behavior Changed in Excel 2007?
  546. ZOrder Behavior Changed in Excel 2007?
  547. Worksheet_SelectionChange question
  548. Help .. Lookup and match UDF/macro
  549. Copying Cells on Enter
  550. Excel 2003
  551. Does Excel have Threshold function?
  552. api - tracking LostFocus or Exit event of a combobox
  553. api - tracking LostFocus or Exit event of a combobox
  554. Catching RNG before getting changed?!
  555. Excel 2007 Bug - "Locked" Property is Broken for Shape Objects
  556. Excel 2007 Bug - "Locked" Property is Broken for Shape Objects
  557. INDEX function issues
  558. lines
  559. Automate Access from Excel to run hidden
  560. equipment service tracking
  561. tabbing to textboxes in multipage tab control
  562. Hyperlink
  563. What Is Wrong With This?
  564. Work book with working days only
  565. External File Validation?
  566. Calendar poping up on form when not wanted
  567. Simple question?
  568. Interop.Excel Split and Copy
  569. runtime error #9 subscript out of bounds #4
  570. hotkey for command button on Excel form
  571. VLOOKUP and then some
  572. Speed up code Removing duplicate rows
  573. Can you change scanned input of an = to tab in excel?
  574. Matching multiple userform height and widths after resizing
  575. Calling a module only when a sheet is actually "activated"
  576. looping through questions
  577. E-Mail Sheets Q
  578. Error in external named range
  579. autosize cells
  580. ExPaste-xl2ppt, a powerful Excel add-in
  581. Import from Outlook/Contacts
  582. Copy worksheet to another file
  583. Is there a way to count how many elements there are in an array?
  584. Macro for copying cells above empty cells
  585. why it does not work????
  586. macro for copying cells above empty ones
  587. counting elements of two arrays
  588. List Box Head-Scratcher
  589. matching similar values
  590. Re: Help requested for conditional formatting
  591. Lower case "a" in "application"
  592. Network problem
  593. Delete Variable spaces at beginning of a range
  594. how to pause a 'save-as' and continue after input
  595. VBA find today's date in Column A
  596. Fill work day
  597. Amend Code Help Please
  598. Import Data button
  599. Range name Database only works on one sheet
  600. COUNTA
  601. Changing linked cell runs ComboBox code
  602. Insert picture with macro
  603. Excel slowing down....
  604. Excel VAB+ADO connect ACCESS with SQL
  605. Count Variable
  606. Worksheet_change error
  607. Unbelievable error 457
  608. Get last column
  609. XL 2007: Conditional Formatting not saved properly
  610. Data Validation redux
  611. Calendar control
  612. Validation
  613. When changing document information how do you show the date and t.
  614. VBA Code
  615. Unwanted Procedure & Do While
  616. For each Workbook limit?
  617. How do I place a chart on an Excel VBA Userform & drive w/spinners
  618. Email Ron or Dave Please.
  619. Where to declare module-level variables?
  620. Formula returns "#VALUE"
  621. Re: find the sheet of an active chart (VBA)
  622. Re: find the sheet of an active chart (VBA)
  623. Conflict in assigning values to a cell from another cell
  624. Dynamic scroll bar max limit
  625. Using a variable to determine row selection
  626. PivotTable: Excel cannot complete this task with available resourc
  627. runtime error 9 subscript out of range #3
  628. Need help with rounding in VBA code
  629. Using the data in the last cell
  630. Speech Activation for Messages
  631. Speech Activation for Messages
  632. 2 auick questions please
  633. Stubborn date format and range copy
  634. Macro to LookUp Data and Copy/Insert only Non-Duplicated Rows
  635. Copy a R1C1 formula to a user defined range results #NAME? error
  636. Using Certain Forms From The Pivottable Wizard in Excel VBA
  637. Automate Tab Color
  638. Sheets("Sheet9") Error
  639. Break on Calendar Year
  640. Execute a macro in another file with an argument
  641. Get data from database via web
  642. How do I calculate the z factor automatically
  643. Where are my custom toolbars in 2007?
  644. runtime error 9 out of range subscript #2
  645. how to assign contents of a cell to a macro variable
  646. How do I calculate the z factor automatically 
  647. If sheet exists, delete
  648. Slow code
  649. runtime error 9 out of range subscript
  650. Copy to destination of "A50" + value in I12 (sequence#) A51,A52
  651. Automate MS-Access from MS-Excel
  652. Sort Worksheet Range from another worksheet range, Excel 2000 & 2003
  653. Disabling Specific Menu Bar Choices
  654. Rolling back 'folders delete' using VBA
  655. Replace old sheet with new without losing formula ref
  656. Excel 2003 ODBC driver without support for XML files?
  657. Formula in macro with variable sheet names
  658. Copy and paste contents of one sheet into another
  659. Selection.Cells vs Range reference - strange behaviour (using 2007
  660. Nested With's
  661. Moving Shapes within VBA
  662. Upgrade options from XL2003/VBA/VB6 to XL2007/VB.NET ...
  663. pivot managment through VBA
  664. List of Fonts
  665. Run-time error after calling a procedure
  666. List box in tool bar
  667. partnumber search and select the cell
  668. define destination sheet
  669. OPC Data Collector
  670. Help to Break links please!!
  671. can't find macros in a macro-enabled workbook
  672. Hourly Refresh
  673. Hide rows using VBA
  674. Yield (ROI = Return Of Investment) issue
  675. manually run macro's
  676. Retrieving Textbox values from another workbook
  677. Using formula in code...Part 3!
  678. Can you specify an Array as a Target??
  679. Compare cell contents in adjacent columns
  680. Call Sub From InputBox
  681. Search and select a cell when pressing enter
  682. Dropdown Options
  683. Graphs to eps image
  684. Can't Find Project or Library
  685. Merge two sheets into third sheet
  686. Numeric
  687. Help with calling Data Form
  688. Data inputted accuracy check
  689. Using formula in code....Part 2!
  690. Copy a Sheet to New Sheet Q
  691. Edit Pivot Query in Code
  692. How to set active cell range to an variable
  693. Comma separator for numbers
  694. merging all macros into one
  695. Fill combo box from range
  696. conditional formatting
  697. Macro for paste special of a number
  698. Copy data matching date and retain information in a monhtly report
  699. Trying to Drag a Formula but it only Copies the First Cell
  700. Missing or Invalid References with binary compatible DLL Options
  701. Macro running EXTREMELY slow
  702. Macro taking longer each time
  703. pointers in VB
  704. Email code Question to Ron de Bruin Please
  705. location of combobox and chart
  706. Using StrComp
  707. evaluate question
  708. Copying a Variable Number of Rows
  709. dynamic range counta error
  710. Format Cell based on two other cells in same row.
  711. speed question
  712. Desctop Shortcut question
  713. saving a workbook, naming it and saving it to a specific path
  714. autofit in multiple workbooks
  715. Changing the Font Size and attributes in a message box
  716. Comm-separated output to a csv file
  717. How to Increment Time using EXCEL ??
  718. Matric vba array
  719. Complex Question - XML Validation in Spreadsheet Web Component
  720. Load into Array rather than Hard Coded
  721. protection of cells
  722. macro not opening file
  723. How can I make Excel give me a warning message?
  724. Trim
  725. Offset(0, 1) and then Offset(1, 0)?
  726. Selecting a file in Windows Explorer
  727. Line under first menu item
  728. Userform Textbox, limit lines.
  729. How to skip the save file notification on exit?
  730. how to get width and height of picture with VBA function?
  731. how to refer to a workbook which name changes over time?
  732. Update Links Stopping Workbook_Open Routine
  733. if formula
  734. Background color
  735. Public Programming
  736. Color List?
  737. GetSaveAsFilename - Runtime error
  738. help on circular reference and MINIMUM value to be found
  739. Using VB.Net, How Do I Put a Picture (jpg) Into a Cell ?
  740. Excel's GROWTH function?
  741. Excel running after close
  742. open file contain
  743. Opening Windows Explorer
  744. public
  745. On open select worksheet by day of month
  746. Update Links
  747. Update Links
  748. Time Format in a ComboBox
  749. "can't find projects or libraries"
  750. How to pool Print Jobs