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
  1. Multiple Discrete Columns Selection
  2. Variable sized combo box
  3. Thx CoRrRan, Bob Flanagan, Harald Staff
  4. Using listbox
  5. Delete if blank...
  6. Adding named range gives error "method range of object _Global failed "
  7. How can i Create
  8. Prompt before saving
  9. Need Code For Selection
  10. removing custom toolbars when closing workbook
  11. Dimension Level & Member Browser Control
  12. old makro (excel 95) should work with vba-modules
  13. Turn off menu options with vba
  14. I get two copies of pictures in the loop instead of one - why?
  15. xllastcell vs xlcelltypelastcell
  16. funny calculations
  17. How can i trap the rename event of an excel sheet?
  18. Graphs??
  19. help with debug
  20. Can any body help me out?
  21. Protect / Unprotect Sheets
  22. Locate cell in Named Range
  23. Questions from a beginner
  24. Unable to insert a form design
  25. array formula
  26. pulling data from an excel workbook
  27. Date
  28. On Change
  29. Using VBA to print to a PDF
  30. Activating a worksheet
  31. Option Buttons
  32. Macro to ajust columns!
  33. SaveAs Result?
  34. excel
  35. Re: Unable to use controls when sheet is protected
  36. connection to oracle with excel
  37. Re: RangeFromPoint Undocumented Returned Object
  38. checkboxes and option buttons
  39. CurrentRegion
  40. Run Macro on true statement
  41. RefEdit control
  42. Userform
  43. Re: User form or embed in a worksheet
  44. VBA list all worksheets
  45. Re: Unload the form on esc key
  46. Retrieving previously entered userform data from saved spreadsheet
  47. click with code
  48. Show userform without it taking focus?
  49. RE: Macro showing just certain rows
  50. Range of columns
  51. how do I get a cell to blink in excel?
  52. RE: App Defined or Object defined error
  53. Vba - restricting cell vallue
  54. Re: Prevent the Macros to be opened in 2nd xls. Sheet
  55. Re: Sheet Vs. Chart with C#
  56. Newbie question about accessing Excel sheet from the web
  57. Workbook_Open and Workbook_BeforeClose not working
  58. Get a List of Worksheets
  59. Missing Links???
  60. Finding worksheets by using variable names
  61. Cannot empty Clipboard problem
  62. Copy textbox contents to a range on a sheet
  63. How to put a 'return' in Msgbox?
  64. Zoom property
  65. Add-in
  66. Do Until Loop
  67. Re: Worksheet Comments
  68. Finding the last cell in a range
  69. Embedded VB Forms Font Problems
  70. VBA, Macros, functions, or formulas
  71. Re: Worksheet Comments
  72. Dynamically assign items to a list box
  73. Function return by reference
  74. Excel Query
  75. Learning Programming
  76. getting VBA to pause while external data loads from web
  77. problems with advanced filters
  78. Open File ?
  79. String Parse
  80. Re: Macro to re-write all cells in a column
  81. send email message
  82. How do I Remove Virus Scanner
  83. Re: Macro to re-write all cells in a column
  84. Re: Macro to re-write all cells in a column
  85. Add-in
  86. Im stuck in VB!
  87. Ignore Filtered items in actvecell.offset
  88. array formula
  89. Add Autofilter to A1:Z1 on workbook
  90. finding a value
  91. ODBC error
  92. Save As Web Page
  93. Picture the same size as a cell
  94. Easy one: On Open selected cells in a worksheet are disabled.
  95. Re: My files don't work after I got new computer
  96. Internet Connection
  97. search for line break in cell
  98. textbox value copying
  99. ...dispatching an input-synchronous call.
  100. Closing a workbook...
  101. Re: Unable to use controls when sheet is protected
  102. mail excel to outlook problem
  103. formula
  104. Custom Toolbar: ListBox on.action not working
  105. 97 vs. 2000
  106. Need help w/program to randomly sort row data
  107. Prompt before saving
  108. excel formula
  109. Dynamically assign items to a list box
  110. problem with custom menus
  111. Programmatically create combo boxes
  112. Autofilter with Loops
  113. How do I apply LTRIM to entire Sheet?
  114. Creating a Validation List Through Macro
  115. Multi-column two-dimensional quick sort
  116. How do I clear all Checkboxes on a worksheet on open
  117. How to get the original data in a cell after it is modified
  118. Protect Sheet but enable cell ranges giving Error 1004 Unable to set
  119. Sum Columns
  120. Overflow Problem
  121. Programming worksheet
  122. Check my Conditional Format Formula
  123. Macro Works, Function or Sub with Parameters doesnt. Suggestions Please.
  124. Reducing A Number By 1 (one)
  125. Re: On Change
  126. Advanced filter - counting the number of rows returned?
  127. How to get back the control
  128. Worksheet change suddenly not working
  129. macro for inventory ageing
  130. Select statements on the same sheet?
  131. Disable Customize in Excel 10,11
  132. VBA Glossary
  133. Re: Pivot Tables
  134. How to identify which cell in a row first becomes negative.
  135. Using a CASE statement in another spreadsheet?
  136. Message Box Duration
  137. Positioning a DOS Window
  138. Excel VBA Formatting cells by Date Range
  139. Extracting addresses from spreadsheet
  140. modification of hyperlink name
  141. DDE Channel
  142. UserForm positioning
  143. Application-Defined or Object Define error? Help please.
  144. Addressing a text box in a chart
  145. Deactivating Printing Message
  146. Class module creating OLEObject
  147. TRAPPING PRESSED BUTTON
  148. Microsoft Visual Basic for Applications Extensibilty 5.3
  149. Sorting range with areas
  150. Need help with formula
  151. Using VBA to calculate some data
  152. User Name From List
  153. Running A Access Macro From Excel
  154. GroupItems - different results starting with 2002(XP)
  155. Vba - Removing workbook
  156. Compare ranges
  157. TabIndex property
  158. calculating an average based on criteria
  159. Multiple Worksheet copying to a master worksheet
  160. Excel as Web Page in body of Email
  161. Change Filename
  162. can this not be done?
  163. Read comboboxes into array
  164. Message for Brett
  165. Share/Unshare work book
  166. Removing comment marker
  167. contact
  168. Code problem emailing range as html in Outlook body
  169. how do I detect an error
  170. create pivot table linked to another pivot? possible?
  171. Count no. of filled cells in a column
  172. Protect object vs. Protection from menu
  173. How to break dsifferent sections of the list in Excel into different files
  174. Forcing MS Query to run before macros
  175. Re: Delete Rows where all cells = 0
  176. application or object defined error - 5922
  177. Coding for printing (without preview)
  178. Paste Special Macro
  179. Re: Delete Rows where all cells = 0
  180. Reading files on a specific folders
  181. troubles with ActiveWorkbook.Save
  182. Filter question...
  183. Missing a line (Simple)
  184. Reading a specific Folder's file
  185. Sorting range multiple areas
  186. Closing Excel from a Macro
  187. Copying an entire row of formulas
  188. How to change color
  189. Re: App Defined or Object defined error
  190. Auto Filter
  191. AutoCalculate and UDF
  192. Place a SHELL Window
  193. Calling a VB.NET exe/dll from excel
  194. Maintain date once entered into a field
  195. Vba - Checking existence of file
  196. Create a reference
  197. InsertLines and AddFromString crash excel
  198. Runtime error 91
  199. Runtime error 91
  200. User Form Doesn't Show When Tab is Added
  201. VBA 97 does noet have Replace: anything similar ?
  202. RE: Disable Excel Control
  203. Select all cells in a range with a certain numerical value
  204. Combo box value disappers
  205. Combo box value disappers
  206. Replace a warning message...on protected cell
  207. Re: Disable Excel Control
  208. Re: Sizing a UserForm
  209. "deselect ?" a range or change state from edit to ?
  210. excel script question --> numbers to words
  211. Re: Efficient Code For Writing An Array To A Worksheet
  212. Re: Problem using "Find" WorksheetFunction in Excel VBA
  213. VLookup with VBA trouble :-(
  214. Save As B2
  215. removing link message
  216. Re: new problem...help
  217. Re: Can't populate combobox list with 1 item
  218. Re: Can't populate combobox list with 1 item
  219. Referencing
  220. Send mail with C#
  221. VLOOKUP or...??
  222. Re: OLEObject GetFocus
  223. Password protected
  224. formula
  225. Reference Book Suggestions
  226. Re: Efficient Code For Writing An Array To A Worksheet
  227. Export chart to .bmp
  228. Excel VBA + SumProduct + not working!
  229. RE: Efficient Code For Writing An Array To A Worksheet
  230. Help with VLOOKUP
  231. Multidimensional Array
  232. RE: Sizing a UserForm
  233. Re: Question on worksheet protection and breaking macros
  234. Dir () code -- Dave Peterson
  235. Show/hide cells code
  236. Trivial VBA and Google issues/doubts
  237. Q317109
  238. E-mail from VBA not working anymore
  239. Help creating a Macro or Formula
  240. Data Type question / Sort
  241. Command Button keeps moving!
  242. protect sheet in VB
  243. Re: Sorting range multiple areas
  244. PIVOT TABLES IN VBA
  245. Run MACRO from the valve of a cell?
  246. editing code in modules through VB
  247. Renaming Files
  248. Excel VBA - Chain of Input boxes
  249. Task Pane
  250. checkbox help
  251. RE: Function works except with January and February?
  252. .Net Managed Code - Excel
  253. Re: XLUP FInd Error
  254. re: InputBox code
  255. re: Vba - securying a folder
  256. returning values
  257. restict format replace in a cell
  258. Renaming folders
  259. Result
  260. Sheets Array
  261. Re: Date in danish
  262. macro to process rows in a selection
  263. [URGENT]How to mimic the toolbar zoom button from code
  264. Excel Notation for Documentation?
  265. How can I find out the Maximum Outline Rowlevel?
  266. Result
  267. standard function in userfunction?
  268. Help to hide rows, SpecialCells(xlCellTypeBlanks) doesn't work...
  269. Cell Comment
  270. Disable Customize in Excel 10,11
  271. Re: Books on Excel Programming
  272. E-mail Code
  273. hyperlink to pw-protected files
  274. Re: Flashing worksheets behind a userform
  275. Save local copy of webpages
  276. Change to excel settings launching an event
  277. Subclassing the EXCEL7 window
  278. application.worksheetfunction.vlookup
  279. Problem with creating numerous shapes on a single sheet
  280. using arrays in vba
  281. Charts smooth lines
  282. Adding a counter to a User Form in Excel
  283. Chart objects
  284. Fill with zero
  285. Foreign characters aren't processed in a macro
  286. 2 Questions
  287. Two little problems
  288. Resubmitting a question from yesterday...formula
  289. Excel/Access ADO
  290. Don't plot zeros in chart
  291. Use of Solver outside Excel, from VB6 - without using Excel.
  292. Need help finding unique values and transforming an n x 1 Array
  293. Re: Advanced DDE
  294. Ftp from VBA
  295. Re: Problem using "Find" WorksheetFunction in Excel VBA
  296. Re: VBE COM Add-in Shell
  297. ontime Method
  298. Re: CALCULATE A LINK to a value
  299. activex
  300. select cell
  301. Variable Types
  302. Change Pivottable layout through VBScript
  303. how do I get the name of worksheet I just add in macro
  304. Invoice template with pivot tables
  305. Excel dates seem to confuse me ...
  306. excel macro help
  307. IF ELSE with an AND?
  308. Returning number of blank cells
  309. RE: Find last filled cell in a column
  310. RE: Using Access DBs from Excel
  311. Automate Embedded Word Document
  312. period of sum of sine waves
  313. This should be an easy one for most programmers but im having some trouble...
  314. RE: Pivot Table
  315. VBA date in function
  316. Re: InputBox code
  317. Display Alerts
  318. Assigning range to array not working
  319. Re: Help sending mail...
  320. Syntax
  321. Browse for folder - Jim Rech's
  322. Data Validation
  323. vba - counting different items
  324. Writing Macros in Excel
  325. An MD5 Hash with a single quote = grief in SQL query
  326. VBA and SAS
  327. Trouble with Workbook_Open()
  328. Note to Bob Phillips
  329. URGENT: Comparing Ranges, Selecting Values, and blah blah blah
  330. new worksheets based on list
  331. SOme problem on VBA Userform
  332. Alias FROM: when sending mail in Excel
  333. URGENT: Alan Beban - SubArray not working - any thoughts?
  334. Vba - Generating Micr Outlook Alert from excel
  335. Can a function return two values?
  336. unique copy
  337. Re: Recording page set-up macro
  338. Autofiltering Makes Button Control Disappear
  339. Need help with writing variant back to sheet
  340. Remove UserForm
  341. Sorting multiple range using a macro
  342. Data Label Object Position not working
  343. Excel Spreadsheet using SQL.REQUEST - System Requirements
  344. Formatting Zeros
  345. Re: copy outlook contact information to excel sheet with macro
  346. calling excel macro
  347. Menu/toolbars/macros defined in Excel 2003 not working in other versions?
  348. Excel Characters
  349. Data type conversion
  350. Re: Help sending mail...
  351. Excel macro script to copy only formulas and not values from one sheet to another
  352. Convert to military time - part II
  353. Re: Recordset object loses validity in call between function & subrout
  354. RE: InputBox code
  355. macro that sends email with attachment and address
  356. Excel PivotTable C# problem
  357. VBA Errors Through Webpage
  358. Re: Vba - securying a folder
  359. Help with MS Graph
  360. public macros
  361. Open Folder - Ogilvy code
  362. speed up macros
  363. Macro to upload tasks to the Outlook Calendar
  364. Re: Find last filled cell in a column
  365. Re: Limitation on controls/objects?
  366. Another Outlook question
  367. add a reference manually
  368. Excel Security
  369. Macro that cut and pastes
  370. Populating data from an external database
  371. Re: ??Names ranges, charts, and SERIES function arguments
  372. Lookup Help
  373. Protect Macro
  374. Find range in one sheet, then paste in the other (one by one)
  375. Performance Issue with Database Connection
  376. Appears that HotKeys have been used, but where in Excel 97?
  377. Macro sending Excel template data to database
  378. Restrict the user from ADDING/DELETING column/rows
  379. Selecting autofiltered cells
  380. How do I create a user form in excel?
  381. Synchronise 2 dropdowns
  382. Speed - or lack of it
  383. Excel macro to extract information from MS project files
  384. Sort a range randomly
  385. how to capture data
  386. changing user name on windows system folder
  387. Returning the result of an SQL/Query to Excel
  388. autoshape
  389. How to use "Transpose"?
  390. Help Please
  391. ActiveWindow.ScrollColumn Sort
  392. Fullscreen
  393. autoshapes round 2
  394. GammaDist Worksheet Function
  395. Need help on blank cells
  396. Object Required Error
  397. VBScript to Change pivot table layout
  398. What next!!!
  399. Trigger an event when a cell's value is changed.
  400. worksheet protection
  401. Reading data from a database
  402. VBA - Writing in XL XP, executing in XL 97
  403. Excel Pivot table on the web
  404. Finding Files on a server
  405. command button color
  406. Imported Text File Worksheet Tab Name
  407. text box reference
  408. Code
  409. Attaching toolbars to spreadsheet, but macros do not follow?
  410. Paste
  411. Automating MS Query
  412. Macro to force delete tabs
  413. protect cells
  414. IF THEN ELSE STATEMENT
  415. Maximum Unique Records in Pivot Table
  416. Countif in VBA
  417. Re: textarea
  418. Re: textarea
  419. Save As... prompt
  420. Code and thanks for/to Tom and Frank
  421. Newworkbook
  422. A variable in VB
  423. How to rename a picture?
  424. consolidating records
  425. CopyFromRecordset does nothing
  426. Values run out of range
  427. Changing text color
  428. Erase Arrays
  429. Re: Populate cell values with sheet names
  430. Excel Macro Help
  431. Re: Populate cell values with sheet names
  432. inputbox and application.run macro1
  433. Need code
  434. How to imput " " (quotes) in to your cells
  435. Requesting Suggestions on Managing Large Data Set
  436. Run Time Error 1004
  437. Clearing all items in a collection
  438. Data types Questions
  439. links update
  440. ODBC/OLE DB to access Excel file and get weired table name Sheet$_
  441. MSFT Encounters Error
  442. *.xlb file missing?!
  443. Edit userform
  444. Opening Recovered Sheet - 2nd Post
  445. For Each Worksheet Problem
  446. Code for Tom and Frank
  447. macro problem
  448. 2 questions : ordering and placing
  449. Filtered counts
  450. A way to create a Command Bar without code???
  451. clarification
  452. clarification
  453. Re: Future Value of Increasing Payments
  454. excel.application.run macro1 --> added code to respond "yes" to a inputbox
  455. clarify
  456. *.xlb file missing!
  457. ok... but not a solution to my original post...
  458. inputbox Auto response
  459. Data Validation Lists - drop down.
  460. Help with error 1004 in database query
  461. Chart Tab Name & Worksheet Reference
  462. Rounding
  463. Mouse Over
  464. cursor position
  465. Not exactly a programming question
  466. newsgroups
  467. Extracting sub arrays from a 2-D VBA array
  468. ordering
  469. opening another workbook
  470. Re: QueryTable's
  471. Fox Pro Data Base
  472. Adding in data from another database
  473. looping through userform controls changing enabled and locked properties
  474. wildcards with sumif/countif in macro/vba
  475. Insert Text at Bottom of Last Page
  476. Can Excel use as a VB form creation?
  477. Dynamic Range Chart Macro Question
  478. Assign Sub to Custom Button
  479. Macro to sum up the amout?
  480. Send a range in Excel as the body of an Outlook Express message
  481. Worksheet as file
  482. ActiveX properties in VB and VBA
  483. Hide Worksheet
  484. VBA to create PDF using Adobe 6.0
  485. startup a userform
  486. looping through userform controls
  487. re:loop through controls
  488. insert two text values
  489. Lookup Mail Contact
  490. Class Terminate problem
  491. variable in a formula
  492. number format
  493. Collection Variable
  494. Help with Excel
  495. VBA code for automatic download
  496. Vba - Opening Outlook with Vba
  497. Workbook VBA not recognising half the new worksheet!!
  498. putting ' in a column of cells
  499. Passing IP address from Excel to a Web site Locator
  500. Create new sheets from data in either of two columns
  501. Why does this code not create a button when called???
  502. Transparent subform
  503. auto no save
  504. if its open...close it
  505. Occurances of value
  506. VBA programming textbook/reference
  507. Availability of fonts in VBA
  508. A couple of easy questions...
  509. Suppressing Pivot Table totals
  510. combining two cells
  511. Workbook_Open Question
  512. ADO recordset returns -1
  513. hiding / displaying the excel application window
  514. active directory?
  515. Three short questions regarding importing of data. See code
  516. Data Validation
  517. Display sum of selection with SelectionChange procedure
  518. Copy textbox contents
  519. Date change macro between worksheets
  520. using vba to copy from excel to embedded word doc
  521. working by column name
  522. Print userform
  523. Creating Add-in with library of functions
  524. What are XLL Add-ins?
  525. Pivot Table SQL Query saving
  526. General debugging question
  527. Daily Automatic Transfer of data from one ws to another ws
  528. save as loop
  529. button to activate userform
  530. Newbie question
  531. Clear vaidation
  532. Delete Rows
  533. Forcing "Macro Enable"
  534. How to leave a combo box?
  535. Populating listbox
  536. Forcing "Macro Enable"
  537. Mail merge issue - ghost Excel process remains after closing application
  538. Insert Rows after text appears in column
  539. Userform with Formula
  540. Charting with VBA
  541. Display Excel file in Internet - an interesting question
  542. copy data to another sheet
  543. How to stop having to re-assign macros every time you open a workbook???
  544. Mail merge issue - ghost Excel process remains after closing application
  545. Tony Barla
  546. How to reset Worksheet Menu Bar in VBA???
  547. Excel VBA - delete hidden column in mergence status
  548. Detecting Applications Run using Excel
  549. Effecient way to check, add, delete duplicates
  550. conditions in Excel
  551. Excel 2000 V Excel 2003 and Pivot Tables
  552. Navigation Tree
  553. Need some events...
  554. (no subject)
  555. Converting From DAO to ADO
  556. Adding to Chart Popup menu
  557. error
  558. Code snippet storage
  559. Active x Calendar control error (-2147417848 (80010108))
  560. Cell Reference in formula increment
  561. Clearing Combo Boxes.
  562. Save As.....
  563. how do I get data into my *.xlt from my *.xls
  564. Printing
  565. Printing
  566. Problem with removing qoutes from string
  567. Memory Leak When Copying Charts
  568. Code - Repost
  569. Open Files by Clicking on a Cell
  570. Workbook_BeforeSave()
  571. Problem in using Advanced Filter
  572. PDF converter to xls
  573. Problem is using any method of Range Object
  574. Run-time error '91'
  575. Userform does not always show on startup over LAN
  576. Accessing Server Date
  577. chart problem
  578. error 50290
  579. Error Handling when database not available
  580. Excel VBA - go to cell problem
  581. Subtracting dates to come up with number of days
  582. Replicate - 'Ctrl+Shift+DownArrow' in Macro
  583. Numberformat vs string question
  584. set ToContact Outlook security workaround - help
  585. Command Button
  586. Converting <b> to bold in excel
  587. Delete Password protected macros
  588. Returning Range Total in VBA
  589. Change pivot Table color on Condition
  590. Re: Volatility With Comboboxes?
  591. Checking for Open Files
  592. Another Reference Problem
  593. Currency formatting
  594. Delete empty array columns
  595. Can Excell 2000 do queries
  596. setting the focus using VB
  597. Re: Macros in HTML
  598. Multiple persional.xls files making macros NOT work!
  599. Running macros in the background
  600. Add an exception rule
  601. User Indicating the Arguments while code is running
  602. Multiple personal.xls files found!
  603. removing words/phrase from sentences
  604. Rename worksheet
  605. CommandButton
  606. Enabling Line/Column number in code
  607. Active Directory? (reposted in case it was missed after a quiet weekend)
  608. moving mouse pointer
  609. moving mouse pointer
  610. Improving data retrieval system
  611. error message in Vlookup
  612. RE: Toolbars
  613. Re: Toolbars
  614. Filter blanks and populate with a series
  615. Editing Code - Help!!!
  616. Editing Code - Help!!!
  617. Searching for mutiple items in txt files
  618. Re: List boxes - help
  619. PasteSpecial Values
  620. Unloading UserForm not working
  621. exporting categories - excel
  622. Access and retrieve data from network workbook
  623. Formulas and making info invisible
  624. Excel on the web using .NET
  625. How to run an excel Macro in VB?
  626. Re: Input Box Question with Code
  627. Re: Numerical Input via an inputbox method
  628. Re: Numerical Input via an inputbox method
  629. Re: Input Box Question with Code
  630. RE: Input Box Question with Code
  631. Need help with this reference problem
  632. Input Box Question with Code
  633. Need to print different sheets conditionaly
  634. Week to date
  635. Network Workbook (access data, etc.)
  636. Reordering with Multicolumn Listbox
  637. Cells = Worksheet name
  638. creating a new dataset
  639. Removing Personal Information (Author etc)
  640. Copy file while in use
  641. Excel - VBA Macro Not Found
  642. Tab Name same as Cell
  643. selecting worksheets
  644. code to insert add'l code ???
  645. Relative Range in a Formula
  646. Converting Excel Worksheets into PDF
  647. Display initial value in combobox
  648. Copy Worksheets from one book to another?
  649. RE: Formatnumber
  650. next empty row
  651. Variable sheet name in formula
  652. Animated charts showing change with time
  653. How to include a double quotation character in a string?
  654. Searching an Array
  655. Changing a text entry format
  656. select row in userform listbox with right-click?
  657. Re: Accessing information from second workbook
  658. AutoLoad Custom Tool Bar
  659. VLookup question in a macro
  660. Row Height
  661. Combo Box initial set up
  662. Re: Okay, Let's ask this another way
  663. Excel Math Bug
  664. Re: Cancel return on keyboard
  665. Moving between Worksheets
  666. countif usage ?
  667. Cell Comparsion (a bug?)
  668. How to parse the comma seperated strings into the excel sheet
  669. a faster method in changing cell value?
  670. Switching Names Around
  671. SQL Query Headache
  672. Paste special to the active cell
  673. Recognising cell values
  674. Activate button when row selected.
  675. Sort options by Excel VBA
  676. Autofill
  677. Countif with row criterion
  678. screenupdating workbook open
  679. validating macro
  680. Read text data
  681. How can I use web query with a password protected page?
  682. Cannot suppress an ErrorMessage
  683. read text file
  684. read text file
  685. MDB add-ins for Excel 97
  686. RE: Access and retrieve data from network workbook
  687. Excel VBA question - Running a autofil
  688. Help with some code please
  689. VBA execution stops at ActiveSheet.Copy -- but only sometimes!
  690. Naming A Table Array in Vlookup
  691. Naming A Table Array in Vlookup
  692. Naming A Table Array in Vlookup
  693. Tab Name same as Cell - PART 2
  694. Additional feature to code given on August 6th
  695. deleting row using macro need help
  696. Insert a heading
  697. TextBox Controls--tabbing
  698. Search for criteria and count
  699. Difficult returning result !!!!
  700. Colouring cells
  701. Password protect excel code
  702. Searching text lists
  703. running a webquery after every 5 secs
  704. Using cell references in Excel Macros
  705. Find Linked Cells
  706. Find Method
  707. Can I attach a toolbar to an add-in?
  708. programming the VBE for a new event procedure
  709. Test if Clipboard is empty
  710. Userform cannot return any values
  711. How to use QueryTable with insertion sql
  712. Repeated validation lists in several worksheets
  713. Print Array in Cell
  714. Update cell selection of embedded worksheet in Word
  715. Adding columns for purpose of payment
  716. Make Option Compare Text the Default??
  717. Windows Explorer Right-Click Extension
  718. Need Help With A Loop To Copy
  719. Help with Pop up screens and Error Pop ups
  720. User defined function
  721. Read all -- Adding columns for paying
  722. ParsingCellData
  723. Re: VBA To Replace Duplicate Values with Zero (Complex)
  724. Adding - Thanks - in reversing the formula it worked
  725. How to eliminate any new pivot Items
  726. can i add a row for (x,y) values and perform its maths?
  727. irrational problem
  728. Counts
  729. Hiding Excel Menus
  730. Hiding Excel Menus
  731. Hiding Excel Menus
  732. Inputs into equations withwout having to repeat the equation every time.
  733. Adding add columns and not getting duplication
  734. Problem populating a multicolumn listbox
  735. Dynamic Validation Lists
  736. Excel VBA- If Then statement
  737. Hourly calculation
  738. Conversion to Text file
  739. VB programming interactive macroes
  740. vlookup from VBA on a closed workbook
  741. Opening with a password with VB
  742. Copying Worksheets from one book to another
  743. access/excel ado via vba
  744. Apologies: access/excel ado via vba - forgot a line
  745. ComboBox Values
  746. User Form Template???
  747. Save takes seconds vs. SaveAs/Save As takes minutes
  748. range data type
  749. Creating a chart (Getting the correct input and output)
  750. Save file with fields within quotes and comma separated
223