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

  1. Re: Apply a Macro to a FunctionKey... (again, but with correct email address)
  2. Exporting Date to Text File
  3. searching for a combobox.value and filling in textboxes from results
  4. copying complete column incl. formating
  5. PROBLEM FINDING MINIMUM
  6. "Application.Function.Text" doesn't work
  7. text case
  8. Undo stack
  9. Create combo box dynamically - one more doubt
  10. suspending-interacting-resuming
  11. Re: Events problem
  12. Macro virus prompt
  13. Re: Macro virus prompt
  14. Re: Macro virus prompt
  15. PasteSpecial
  16. Excel VBA Access Database Error
  17. Copying formating and function from one Column to another
  18. Excel version reference problem
  19. problem with macro for pivot tables
  20. Serching in document
  21. I dont understand....
  22. Re: A VBA function to give serial date for date and time?
  23. Function to loop through a column and return a value based on an x
  24. Adding Message to Spreadsheet
  25. clearing VBA worksheet names
  26. Message box causing error in code
  27. Excel \ Access Time issues
  28. Re: Default File Path
  29. Splash
  30. Saving and returning to saved screen view? (Pan L/R U/D)
  31. Re: Referencing cells to VB
  32. Re: Default File Path
  33. Search and Replace
  34. Re: Creating a Directory from a user input
  35. Re: Addition to existing code
  36. Macro to copy and paste
  37. Re: Loop including IF statement
  38. Macro to add cumulative total
  39. How to split column?
  40. Keeping add-in private
  41. verify cell if is the same
  42. Non-Modal InputBox?
  43. excel - data merger in two cells
  44. excel - data merger in two cells
  45. Draw lines in a userform
  46. Re: Nursing shifts
  47. PivotCell class
  48. Running average without nonzero values or empty cells
  49. Error "Permission denied" when printing Web Browser control from button on userform,
  50. Macro virus prompt
  51. File Path Class
  52. METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file
  53. Combining Macro files
  54. auto name sheet w/ macro or function
  55. Re: "Radio" Button help
  56. Import of multiple .CSV files into Excel
  57. Help w/code
  58. Re: UDFs and file sharing
  59. Query - SQL to Excel
  60. Database usage within Excel
  61. Excel VBA- Time delaying macro
  62. Excel VBA - getPosition UDF
  63. Application.OnKey problem
  64. defining an event procedure (lostfocus) that works on a column range
  65. Re: disable close and shrink buttons
  66. Prevent formula from deletion?
  67. problem with Rows.Count and comparing cells
  68. How to avoid excel adding a 0 for cells with a formula
  69. Prevent copying sheet
  70. Pivot Table
  71. Re: VBA Question - How to print a frame within a template
  72. Reset Variables
  73. Solver not Using Constraints when called from VB
  74. Printing Pivot Tables
  75. Re: populating a cell with text w/ line breaks
  76. MACRO: How to change cells to negative value
  77. Re: Macro to email excel workbook with static recipient and auto subject
  78. Weekly report help
  79. 0 with ADODB Recordset
  80. Re: FileSearch inconsistencies between Office/Windows version combinat
  81. Programming in VB
  82. Excel.exe not terminated after spreadsheet saved
  83. Excel Pop Up Code Required
  84. Timer
  85. Excel 2003 Save as Bug
  86. Re: runtime error 9
  87. Sorry about the last ones...And statements with IF's
  88. Re: VBA Question - How to print a frame within a template
  89. VBA Protection
  90. Is there a way to call selected sheet's name from on deactivate event?
  91. Formatting Repeated Values
  92. Can you bypass excel generated pop ups.
  93. Help with Error Message Box code
  94. Install Addin in Excel
  95. 2 column sort
  96. Excel 2004 Can't Disable Auto_Open Macro. What Now?
  97. programmatically open VBE and go to a specified procedure in target module?
  98. Re: Digital signature/certificate
  99. Update Sheet from Formula.
  100. Runtime Error 1004 - Method Range of '_Global failed'
  101. Excel VBA Macro - parse data
  102. Detecting Text Numbers
  103. call a vb function from a cell
  104. How to format a Date to a Real Numerical Date?
  105. Variables to Comments
  106. Different between Excel 97 & Excel 2000
  107. Program question
  108. About the Update statement difference between Excel97 and SQL Server2000
  109. 97 to 2000 Refresh pivot table
  110. Single quote in a where clause
  111. Solver Reference in Hidden Personal.XLS Crashes Excel 2003
  112. Template opened while being populated
  113. copy data from 4 worksheets to master?
  114. Convert to a Parameter Query
  115. Variables
  116. Issue with Excel Macro. Unable to insert quotes before and after the text.
  117. List Box Control out of control
  118. Find the table height?
  119. Count
  120. Defined Range Problem
  121. Saving sheets with VBScript
  122. Error
  123. Event procedures (and the temple of doom)
  124. How to: check if folder exist, if not, create
  125. string manipulation
  126. Treeview/imagelist problem
  127. After oledb inset in Excel, 'Cannot Access file' error on Excel
  128. Help: Election 2004 Project -- Iterative Operations, midmean
  129. Excel2000: Reading Named Range value from VBA
  130. File input though some kind of windows interface
  131. select workbook
  132. Conditional Formatting question
  133. Macro Memory ( Paging File ) Problem
  134. Check for Enter key and change focus?
  135. Keep Listbox values when closing workbook
  136. Last Resort
  137. Finding a Row and cut and copy
  138. Fill series in visible cells only
  139. Define an array with variable size
  140. copying values form one workbook to other
  141. How do I select a range using VBA?
  142. Replicate a macro program
  143. build POS system using MS Excel
  144. Date Time Picker Control autosize
  145. How do I run a macro from a .xlt file
  146. Can you implement a custom format with VB code?
  147. Assign .value with the Mouse
  148. Re: Running a macro in another workbook
  149. How to access ranges in closed workbooks in custom functions
  150. 'portable' UDFs???
  151. Userform size limitation
  152. activate unknown workbook
  153. Inputbox as Date
  154. E-mailing pivot tables
  155. Conditional formulas
  156. Weird macro mistakes or goof ups - copy of original post
  157. VBE dark red highlight
  158. Averaging a dynamic range...Help ???
  159. Deleting Unneeded Records
  160. save macro to personal.xls.
  161. Hanging Instances Of EXCEL.EXE?
  162. Newbie: Excel Macros and Personal.xls
  163. traversing through a filtered range based on another filtered range
  164. How do I copy a Form from one VBAProject to another
  165. Pour ecrire dans une cellule
  166. Conditional Formatting using VBA Code
  167. Bypass Textbox Validation
  168. Doing it's own thing
  169. Re: Bad DLL
  170. ADO Connection stopped working
  171. Re: Variables
  172. Exceeding Max. (32,000) Data Points in a Series
  173. Using the COUNT funciton to count cells with values
  174. Re: Dynamic Range in Macro with R1C1
  175. Vlookup from a a different workbook with filters assistance please
  176. adding a month onto todays date
  177. Grater than or less than formula
  178. Querying Password protetected Access DB with ADO
  179. Error whil reading file
  180. Problems with reading files
  181. FILTER SHEETS BY NAME
  182. CHANGING FORMULAS WITH VBA !
  183. Excel VBA - read a WS and show results on another
  184. Application onEntry with IF then statement
  185. Run Time Error
  186. Forms
  187. Formula too long
  188. xldialog
  189. ComboBox text resizes on it's own
  190. Saving variables in XLA's
  191. Adding Code to the This_workbook module of a created workbook
  192. function to return positive number or zero
  193. Re: Automatic Bolding and Background Coloring
  194. Re: Automatic Bolding and Background Coloring
  195. Application.GetOpenFilename
  196. question
  197. Avoid error with simple subtraction function
  198. Icons
  199. Edit points, how to show that view at the end of a macro execution
  200. Alternative to InputBox
  201. Print Last Page
  202. What Is "Me." in Visual Basic Coding?
  203. After GetSaveAsFileName question
  204. Network detects if Windows Username is online
  205. How to keep excel from crashing?
  206. Loop Problem
  207. count and sum of dynamic range ????
  208. MACRO TO EDIT CELL FORMULA !!
  209. Workbook BeforeClose Bug
  210. To cut rows from a sheet with multiple blocks of data
  211. Help! Please!
  212. Re: Bad DLL
  213. VBA for changing a defined name reference
  214. Userform
  215. Help with VB and Excel
  216. worksheet change event > error events disabled
  217. Disable Format Painter?
  218. Applying the find fuction to a button
  219. ADO
  220. Can You Re-Create this problem?
  221. Filtered Visible Rows & VBA Non-Filtered Rows Displayed
  222. PageFields in 'Rows to repeat at top'
  223. Re: hi I want to add the results on comparison with 2 fields.
  224. Add menuitems to the VBE
  225. Write to Output Type Formating
  226. Conditional Row insertion problem
  227. User/pass prompting code
  228. Scramble password a little bit
  229. Unprotecting worksheets with a macro
  230. Help with VB and Excel
  231. Sort Macro
  232. dynamically changing chart y axis using spin buttons and worksheet_calculate event
  233. Beginning forms
  234. Changing filenames using theSaveAsCopy method
  235. download .csv file indirectly from website - long
  236. search worksheets in different workbooks
  237. External data references in a userform control
  238. Can Excel load data of volume 50 mb and analyse also by adding 25 mb more
  239. Restoring Screen Resolutions
  240. parsing HTML table into excel. How?
  241. List box to reference another workbook
  242. Storing Cell Values in Access
  243. Re: Running a macro in another workbook
  244. Unable to Lock a Range
  245. Range Selection
  246. DAO Excel to Access
  247. VBA to Email Attachment
  248. "enter" event of activex combobox?
  249. reading xml fields into excel
  250. looping and objects
  251. User selecting range from userform via dropdown menue
  252. Need a function to keep track of total data.
  253. Check to See ( Find ) if a Value is in a Table
  254. SMS with Excel.
  255. Program issue w/ VBA on next row
  256. ActiveX Textbox question
  257. ListBox population from Excel range
  258. inconsistent date conversion
  259. Excel VBA - Win Lose Streaks
  260. Simple way to convert UTM ED50 coordinates to decimal coordinates?
  261. VBA Stmt Format to Get Contents of Cell in Another Book
  262. creating a formula in textfield
  263. #N/A
  264. Listbox 2
  265. SaveAs works on one PC, not another. "Save" not really an option. What to do?
  266. Attaching Custom Menus
  267. Capture Custom View in a Variable
  268. Inserting Picture from Camera
  269. Word Control in Excel
  270. How do I solve this (Part II)
  271. Macro link issue when saving as new filename.
  272. Automatic Updating
  273. Auto_Open and Workbook_Open in Addins
  274. FORMATTING CELL CONTENT !
  275. Updating Access Database from Excel need help
  276. save into file while user is entering values in cell
  277. Error handling
  278. ADO & CopyFromRecordset performance
  279. An advanced email question.
  280. Followhyperlink - How do I disable IE launch?
  281. InputBox: Display Cell Content not Cell Ref ?
  282. From Excel to VBA and back?
  283. importing data from multiple excel spreadsheets
  284. Multiple ComboBox Lists
  285. Extra rows in csv file
  286. Analysis Services accelerator for Excel deployment
  287. Repost: ListBox Headings - customized! Class Module (warning: long post)"
  288. creating a routine to help memorize
  289. Dates
  290. Macro to create worksheets base on name
  291. Row Height for merged cells
  292. Sheets Name into array for form dropdown
  293. UNDO in EXCEL97 macro
  294. Protect/Unprotect function options
  295. How to define a Range with variant?
  296. Excel200: Strange behaviour for Name when referred from VBA
  297. Deleting rows based on multiple criteria
  298. what is wrong with creating pivottable ?
  299. Protecting VBA Project
  300. Find & replace with VBA
  301. Searching a column
  302. Integration between VB and Excel
  303. Change and update contents of a dropdown combo ....
  304. #NUM!
  305. Apllication.OnTime
  306. Searching within excel
  307. Links from Word no longer updating
  308. Sum depending on cell background color
  309. This Worksheet_Change sub doesn't work - why?
  310. Counting a range of cells based on 2 dates?
  311. Excel Crashes When Copying Multiple Sheets in VBA
  312. Zip workbook
  313. Save= False Question
  314. Printer Dialog Box
  315. Date/Time Picker Event Won't Fire
  316. Re: Disable Format Painter?
  317. Docking windows in the IDE
  318. Building COM Add-in in XL2003
  319. sql querries
  320. Override error code 214154 - max embedding
  321. disable mulitple select on pivot page field
  322. Doing it's own thing - Jim R - Check here
  323. Display set range
  324. Need help with creating a special copy and paste macro
  325. VBA ?
  326. excel to powerpoint via macro
  327. Excel 2003 / IE 6 bug closing workbook
  328. Automatically print in Excel
  329. Certificate Problem need solution
  330. Error Checking Option
  331. Opening File Browser
  332. Re: OPEN WORKBOOK WHEN EXCEL OPENS
  333. Re: Run-time Error '1004' Unable to get the findnext property...
  334. Returning From VBA Event Code Called From Excel 4.0 Macro
  335. Compile Error
  336. Deleting entire rows based on certain criteria
  337. Controlling java applet
  338. Searching for specific text
  339. Changing range name in loop
  340. sql querries
  341. Probelme with coding...
  342. Macro won't execute when "For Each 'range' in 'range'" is added
  343. How do I find out my row number
  344. Help with creating Excel Macro
  345. Print to .csv file
  346. Embedding of graphs/charts in forms possible?
  347. Applicaition Default File Path
  348. True/False Checkboxes
  349. Find
  350. Re: Activating Worksheets and Importing Data from them
  351. Function unable to return Collection object
  352. Dropdown box of macros
  353. Excel97 (w/ VBA) Template won't open in Excel2003
  354. How to access Excel-Sheets from outside Excel ?
  355. Re: Digital Signature issue in Excel files
  356. Index or Match?
  357. bizarre "invalid procedure call" error
  358. Automation COM Addin with Excel
  359. Re: How To: Page Fields
  360. Newbie Post - Clear All Button
  361. dates
  362. Clear a textbox
  363. selecting a row by header row in VBA
  364. Remove all Listbox items
  365. Copying Macro to Several Workbooks Fast
  366. Reading the contents of an inserted picture
  367. Can I automatically populate my dropdown with all available macros
  368. Browse for folder
  369. Can I automatically populate my dropdown with all available macros
  370. Color Code Duplicates
  371. How do I Insert a row that includes copied formulas
  372. Re: page setup via code
  373. formulas in code error
  374. Hard Return in large textbox
  375. keeping buttons from moving
  376. PSW for Macro & Codes
  377. Re: Excel Sheet Drop Down Menu Automation
  378. Verifying a cell is in a named range
  379. Getting file name from absolute-path
  380. Quick Question on Hyperlinks
  381. Magic Moving VBA buttons
  382. Excel-97 versus Excel2003
  383. Calling procedures in .xla projects
  384. Macro to Autofill Row
  385. Selecting a Range inside a range
  386. 2 VB questions
  387. worksheet events and referring to named ranges on other worksheets
  388. delete method arguments?
  389. Where do macros go?
  390. Deleting Worksheets Within A Macro
  391. Referencing Multiple Cells with Nested IF statements?
  392. C++ SetEnableEvents(true) Question
  393. Click event unhiding sheet
  394. How do I list all file names in a directory
  395. Formatting CSV file
  396. worksheet tab colouring
  397. Saving the contents of the clipboard
  398. Jim Rech's Browse for Folder
  399. Delete Duplicate Records
  400. filter result box
  401. EXcel VBA - OnAction menu item property
  402. problem with 'flagging' monthly anniversary dates
  403. Making Worksheet Menu Bar button sink or raise???
  404. Importing a text file using ftp
  405. Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor???
  406. Setting default values of user defined data type
  407. ? about the VBA code
  408. Can you registrate a drag and drop event?
  409. "AND" statments in Excell 2000
  410. OnAction menu item property coding
  411. Spaces in sheet names
  412. Exporting Excel 97 to Excel 2000/2002
  413. Calling macros from a VB app
  414. Help Me! Exporting Excel 97 to Excel 2000/2002
  415. Excel2000: How to copy data validation using VBA
  416. Auto_Open and Workbook_Open
  417. FileServer with GetOpenFilename
  418. Range and Cells
  419. Data transfer macro
  420. Unable to add user-defined data types to a collection
  421. Look for numbers in a cell
  422. A simple question -- Evaluate()
  423. Using solver in macros - Help
  424. Format of textbox on userform and correct result
  425. Header & Footer
  426. Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet
  427. Is worksheet protected?
  428. Auto refresh and DDE update is not work when running macro
  429. Error 1004 - Out of Memory
  430. Error 1004 - Out of Memory
  431. Events and values and Ranges
  432. Variable Value
  433. change all instances of Queensland to QLD
  434. How to make Excel feel switching application?
  435. Creating a worksheet with values based on a control cell
  436. Reference to a variable in windows(???).Activate
  437. Copy From Recordset
  438. Hosting XLS files within IE 6
  439. To: Dave Peterson
  440. Forms and sheetranges
  441. Active Workbook Properties - comments
  442. Can anybody help please? Urgent
  443. Altering Textbox Colour
  444. Relative path
  445. Avoid user to access first two rows in a sheet
  446. Connection to notes
  447. Delete duplicate cells
  448. Yes No dropdown box
  449. Compare Current Date
  450. Looping through to stop on pie charts
  451. DragAndDrop_event doesn't exist - any substitute?
  452. Non-contiguous selection
  453. labels, comboboxes, etc
  454. Creating Buttons and assigning code
  455. Re: rounding a formula in a cell, then replace the formula
  456. Global vars
  457. Re: rounding a formula in a cell, then replace the formula
  458. Formula to name tabs in excel worksheet
  459. Control Toolbox
  460. VBE Custom menuitem not calling OnAction macro
  461. =sum formula using arrays
  462. Sending multiple emails using SendMail
  463. Excel Macro - Save Function Problem
  464. Inserting a line....
  465. Bold certain text in textbox
  466. To: Bob Phillips
  467. Netsend or another type command
  468. Count Pages
  469. run time error 13
  470. Dynamic range
  471. Testing for content in Range
  472. Excel VBA from Excel 97 to Excel 2000 errors
  473. Searching with Macros
  474. Re: Creating a custom toolbar in VBA
  475. Numbers
  476. Stacked Column VBA
  477. Office/Excel 2003 - Stop toolbars automatically opening
  478. How do I set a default path when using Application.GetOpenFilename
  479. Totals
  480. converting architectural units
  481. Modifying text files with VBA?
  482. How do I add a Password?
  483. Re: where is my record button?
  484. Merging part of one field with another field
  485. Text Files
  486. Data Validation
  487. Null?
  488. Why this 1004 Error message?
  489. How to check for password in an excel file.
  490. Wild Ideas
  491. Internet printing problem using hyperlink from worksheet
  492. Column question
  493. Copy data from an external application into Excel
  494. How do I set a default path when using Application.GetOpenFilename
  495. Re: I want a msgbox when the contents of cell change
  496. Open pdf without converting
  497. Hiding the sheets my macro works with...
  498. Please help with vba code question
  499. Populating a cell with numbers without numbers being formula-based??
  500. Rename Files
  501. Re: minimum scale error code
  502. Database Query
  503. Workbook Open
  504. Swtiching the focus of Textboxes
  505. Calling a sub with a variable...
  506. calculations in large data set and in pivot table
  507. Running a Command Button from a different sheet
  508. Naming a range versus formula in Excel
  509. Loop expression to calculate return
  510. counting device
  511. Deleting new control button on auto_close??
  512. Error in code opening Outlook
  513. How to verify a cell is in a named range
  514. Find & Replace Macro from external spreadsheet/db?
  515. Range question in VB
  516. Re: Pivot Tables: counting columns and matching
  517. new to excel help me
  518. 16 digit Credit Card #
  519. loop
  520. Question on Custom Sum Function
  521. Retain, restore selection?
  522. Help Me!!. can not set the string with len more than 255 character to the value cell
  523. Color constants in VBA
  524. Pasting formulas without copying file ref.
  525. Shrink Formula
  526. Hyperlink
  527. Trying DROP TABLE in SQL from Excel
  528. Moving Cursor once set number of characters are entered.
  529. Option Button Macro (Forms Toolbar)
  530. VBA - Drop down; list range
  531. Coluring cells in a Range
  532. Increment array for debits and credits
  533. Difference Between UserForm in Excel VBA and the Form in VB
  534. Property Pages from my ActiveX are not visible
  535. ActiveX Property Pages are not visible
  536. Super Easy Question -- "
  537. Ask for help of Excel
  538. Starting with command
  539. Filesearch with disregard of Case
  540. Newbie Question: Returning the value from a cell on another sheet
  541. Macro to sort Worksheets
  542. VBA to copy
  543. Returning Dates - Lead Times
  544. Returning Dates - Lead Times
  545. excel vba.........
  546. check if worksheet is protected using code
  547. block scrolling
  548. Save .txt file as .xls format - HOW??
  549. using one macro to set a variable in another
  550. Calculations in a pivot table data set
  551. Calculations in a pivot table data set
  552. Lookup / Vlookup ??
  553. FAO : Bob Flannagan
  554. Using macro to add data in specific cell within a table
  555. setting chart axes
  556. right click menu reset?
  557. Importing cell info from closed workbooks into new spreadsheet
  558. Can not open excel workbooks from the file manager
  559. creat and transfer data sheet1 to sheet2
  560. Improvement to sub: Detect data extent and convert to values
  561. Combobox Value
  562. Percentage code
  563. creating Databases and tables
  564. VBA
  565. Copy image of UserForm to a clipboard
  566. VBA Auto Cell Formatting Uppercase
  567. Iterative Macro
  568. Array formula with =sum
  569. Cell contents in Excel??
  570. Difference b/w 2 worksheet
  571. Protecting an Excel Sheet name from being changed
  572. Renaming VB Form Causes Macro Corruption
  573. save as...
  574. Outlining works in XP not in 2000
  575. Project Name vs. Workbook Name
  576. Traversing two named rages of unequal length
  577. Calculations in a pivot table data set
  578. Re: Createobject (repost)
  579. What should I do when this has no data?
  580. Error
  581. comparing values in excel with vb6
  582. Renaming Files: Take 2
  583. Excel VBA - How do I programmatically change source code in another file?
  584. password protect
  585. Macro crashes excell from remote location
  586. ListBox.ColumnHeads Property
  587. Re: Deleting workbook
  588. when would you use "new workbook"
  589. Comparing Two Cells in Excel
  590. Open then Close
  591. Re: adding Activex control through code works BUT... Cannot access ob
  592. Calling to a specific cell
  593. Updating of one file and prograte to others files
  594. Whats wrong?
  595. Re: Nursing shifts shift scheduling software
  596. Initializing a Form with multiple forms embedded
  597. Key Identifier for Sheets?
  598. Getting data from several worsheet/books
  599. Tutorials?
  600. [UserForm]: *.gif
  601. Trigger Event
  602. Re: Inserting Formula
  603. Display a range fullscreen
  604. Re: Checking entire row for duplicates
  605. Open Unique excel.exe
  606. Re: setting chart axes
  607. Excel 2003 Additional Workbooks After Excel Crash
  608. Using SELECT...CASE with comparison operators?
  609. ColumnWidth
  610. Re: Checking entire row for duplicates
  611. Runtime Error 424
  612. VBA - Status Window?
  613. Deleting workbook
  614. Search/Find in any worksheet
  615. Can't get FindNext after deleting row?
  616. Macro within Macro
  617. Macro works in 2003, not in '97
  618. Re: Trigger Event - Frank Stone
  619. start a macro everytime excel opens
  620. Auto unique numbering
  621. Checking if a worksheet already exists...
  622. convert excel worksheet to binary array
  623. Create subfolders in a folder
  624. Escape On Error methods in Subs
  625. (Urgent) If col D= value, avg col G
  626. Copy method of chart class failed
  627. Using Columns().Row() To create a range
  628. Re: Why I got this 1004 runtime error
  629. FieldInfo
  630. All Caps
  631. How To....
  632. Tool tip for controls
  633. VBA Project Password
  634. Re: Running MS Queries
  635. Finding Folders
  636. Using Sheet names in formulas
  637. Excel Marcos
  638. Excel 2002 Macro to Execute SQL Statement
  639. Update Dates
  640. ExcelApplication
  641. Placing a Form with multi-tables into Excel
  642. detect empty cell
  643. Expand Range
  644. Re: Data Interpolation
  645. Re: filtered recodset to pivot table (or not)
  646. Tabs in Excel Spreadsheet
  647. Large file size problem...
  648. CAE macro for green screen updates with Excel data
  649. How to make a spreadsheet as popup?
  650. COM Addin in C#
  651. For Each - Range Cell
  652. Deleting a Menu Bar
  653. Paste to Multiple Selections
  654. RE: Cannot add custom image to Office.CommandBarButton in Excel using
  655. Application.Inputbox acting strangely
  656. Rename file
  657. how to extract the row number of a cell with certain value
  658. Why is my Workbook Open procedure not working
  659. message box pop up for a given value in a cell
  660. Help Delete Rows based on the macro in this message
  661. opening file with worksheetfunction
  662. Excel
  663. Hide Rows and Columns
  664. Opening Notepad from Code
  665. Locking range for view of Excel Sheet on button click
  666. Dates in TextBoxes
  667. Totals
  668. Keeping track of Global variables
  669. How to overide spell check blocking in protected sheet
  670. Visual Studio - Office 2003
  671. Force minimum text box entry
  672. Copy error with Autofilter
  673. Using macros to cut & paste rows to a new worksheet
  674. Formats many sheets
  675. Input data from one worksheet to another
  676. Create New Worksheets in VB
  677. Message with RoutingSlip
  678. Problem with Excel using a .Net rich text box
  679. Excel VBA not counting colored cells
  680. how to delete rows that show no value but contain formulas
  681. Transfer value to cell
  682. Protect file on a shared Network drive
  683. Public Const on a Drive
  684. What workbook is calling the function
  685. Conditional Formatting on Time
  686. Combo Box
  687. Copy/Paste From Excel To Word Macro
  688. Do you want to replace existing file?
  689. Rounding up decimals
  690. setting a command button to be a hyperlink
  691. Re: Range("F83").FormulaArray
  692. UserForm
  693. IsEmpty and bookmark help with excel 97 and word 97
  694. Alternate Worksheet printing
  695. How do you automatically update criteria in MS Query
  696. Selecting ranges to copying and Paste
  697. Animation
  698. Pivot Table
  699. Emails data from each row in a sheet
  700. Comparing a range with text
  701. Run-time error '1004'
  702. Reformatting a cell using VBA
  703. Repost with code - Runtime error '1004'
  704. Application Level Events Question
  705. Re: Visual Studio Tools for Excel problem
  706. conditional formatting
  707. Trying to save a worksheet
  708. suming across sheets
  709. What Key
  710. How to call out object's text w/o selecting
  711. Autocomplete in VBA turned off
  712. Re: Inserting a filename into a cell
  713. Re: Displaying Web Page
  714. Re: Displaying Web Page
  715. Chart Name
  716. Re: User Defined Type
  717. If open, go to, else open
  718. Memory per Sheet
  719. Autofilter
  720. Excel VBA Macro
  721. Re: Write Command Output
  722. Re: Write Command Output
  723. Protecting buttons with VB code rather than protecting sheets/books?
  724. Conditional move rows to another sheet
  725. VBAProject scope
  726. Format Vlookup column with Text
  727. Re: VBAProject Scope
  728. Re: VBAProject scope
  729. Re: VBAProject Scope
  730. lost Courier New font in the VBE but it's in my machine
  731. Re: Automatically applying a macro to many workbooks
  732. Simple macro help
  733. simple macro
  734. Adding text to first empy cell in column A
  735. numbering items in a column based on a condition
  736. Custom function does not work from an addin
  737. decimal places in currency
  738. Re: Trying to add a Pie Chart
  739. Avoid to reopen a working Workbook
  740. Excel VBA - Search record with multiple criteria
  741. Calling workbooks with apostrophes in name?
  742. Re: checkbox hell
  743. Re: checkbox hell
  744. Re: VBA error 1004
  745. Program no longer work on Excel 2003
  746. Finish one section of code before continuing
  747. matching numbers with images?
  748. Help: Election 2004 Project -- iterative operations
  749. Excel XP
  750. External Data Source Questions
224