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 237

  1. Run time error '1004': Generaol ODBC error
  2. SUMPRODUCT WITH AN "OR" MAYBE????
  3. Change File DATE created & modified
  4. Shell can open an application, can it close an app too?
  5. CheckBox Change Event
  6. EXCEL VBA
  7. How to program a spreadsheet to do this?
  8. automatically running a macro
  9. Automatic Refresh for Pivot Table
  10. Check for dated sheet
  11. Micro
  12. string compare with wildcards
  13. RE: Record macro to export xml
  14. Excel 97 - VB question
  15. sorting in pivot table
  16. How to trap delete row event and hide column event?
  17. Is it worthwhile to upgrade Office 2000 to Office 2003?
  18. Re:User form Yeah!!!!
  19. Can I send results of a formula to multiple cells?
  20. List box
  21. Architectural guidance, please
  22. vba is converting text to values!
  23. referring to a named range on another worksheet
  24. Protecting Hidden Areas
  25. Automatically Installing Add-Ins?
  26. Querytables parameters
  27. SUMPRODUCT OR SUMIF
  28. Invisible cells in VBA
  29. lost ability to see worksheets
  30. Making Address function & references as links to external files ??
  31. How to Write a sub to execute the following
  32. VBA to copy sheets (as values) that begin with the same sheet name
  33. request macro to save file to multiple, separate locations
  34. rounding to .5 in VBA
  35. Hyperlinks / server / cd
  36. Delete Row Based on Listbox Selection
  37. printing labels
  38. Re: Reading registry with Excel
  39. Reading registry with Excel
  40. Formatting Textbox
  41. Cells(col,row) keep moving to lower case and I can not ref. a cells in a differnet sheet
  42. Restrict Macro Availibility
  43. Excel file very large in size?
  44. excel solver
  45. Re: calling a stored access query from excel vba
  46. Help with macro
  47. variable not set error?
  48. Over 29 args in a UDF with double parens
  49. How do I repeat key strokes in Excel?
  50. How do I sort nulls within date field in Excel
  51. Macro to force cell entry before running
  52. Sheets.Add using other worksheet as "template"
  53. switch rows & columns?
  54. subtotaling becomes slow
  55. Macro Copy Active Cell to Range Name, loop
  56. Reading data from a filtered list
  57. Userform - Entering Time
  58. Variable in a Search and Replace macro
  59. Re: Two Userforms
  60. MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET
  61. .wait for 1/2 a second
  62. RE: INSERTING A PICTURE ON WORKSHEET
  63. Re: VBE References Missing from Exported File
  64. Re: I was Asked an Interesting Question
  65. How do I format a document?
  66. Re: Control on Sheet - Drop Down 1
  67. Re: Multisheet IF Function
  68. Re: Show what options are in custom function?
  69. Array
  70. Re: Bold some of the cell contents
  71. Re: Bold some of the cell contents
  72. Re: OnTimer Event
  73. Re: Bold some of the cell contents
  74. automating macro
  75. How do I set up an error bar in Excel and a vertical line together
  76. I need a macro to grab specific data and transfer it to a now worksheet
  77. VBA questions
  78. I was Asked an Interesting Question
  79. Adding Sound to Program Revisited
  80. Opening Forms error with Workbook_open
  81. Adding Sound to Program Revisited
  82. Excel2000: Declaring function parameter as an array
  83. LoadBehavior problem
  84. How to sum using vba
  85. how to tracking function run time
  86. question about Excel file writing and reading
  87. Open an Excel file in a new Excel session
  88. Print Area
  89. Send Email (Active Sheet)
  90. Copy data into cells until changes trigger new copy
  91. Using Autofill knowing row and column number
  92. Ok try agian. User form LastRow
  93. Listbox - Text Field
  94. Coloring cells
  95. excel on multiple computers
  96. Difference Escape and Ctrl + Break to interrupt code
  97. stringing macros together
  98. adding rows to spreadsheet after macro is written
  99. Pop up a Form when Clicking a Cell
  100. Placement question
  101. Type Mismatch error
  102. shape object on a userform?
  103. How to display an input onto excel?
  104. I need a macro to delete unwanted data
  105. Hide range of worksheets in a workbook
  106. VLOOKUP Is NOT CORRECT
  107. Creation date is not right
  108. Need help referencing an embedded file in Excel
  109. Save As csv file between Excel versions
  110. Program Understanding
  111. help in checkbox code
  112. Finding MAX number (excluding a particular number)
  113. checkboxes and code
  114. CheckBox Selection
  115. UK date format and combo box
  116. Can't seem to get Combo Box on User Form
  117. vlookup
  118. ListBox
  119. Userform Help!!!!Please
  120. Roesource problem
  121. Return value of heading if an adjacent cell in a row is not blank
  122. Function (array argument, range argument, string argument) vba
  123. Naming Worksheets with a Macro
  124. Make string bold?
  125. Excel Add-Ins... Distribution and Overwriting old Versions
  126. UserForm_Initialize error
  127. character representation of specific column
  128. Small application needed
  129. Copy number that changes daily with macro
  130. Print if there is a picture
  131. Dates and Combo box
  132. Close file and run macro from newly opened file
  133. Are there any solutions for truckers?
  134. How can I rename a Workbook?
  135. Does Workbook.Open ever run from a Function Call?
  136. Runtime error 91 when assigning range
  137. Add to a string to make it continuous
  138. User Form Interface .... really a simple question!
  139. Worksheet change VBA
  140. INSERT PICTURE IN MACRO
  141. AdvancedFilter to Array
  142. Selection or Recordset to Array
  143. Switch to another application
  144. Is the active cell part of a named range
  145. conditional task in Excel 2003 macro
  146. Combo Box
  147. Passing parameter to a query
  148. Worksheet_Change DDE
  149. Worksheet_Change DDE
  150. User Defined Function - efficiencies.
  151. Count How Many Times A Cell's Value Has Been Changed
  152. Auto Search Archive files
  153. Macro to perform Advanced Filtering
  154. Query
  155. Install 2002 & 2003 on same computer
  156. Code error
  157. sort in pivot table
  158. Workbook.Open doesn't leave an open Workbook
  159. List workset fucntions
  160. Search in row
  161. Lists question
  162. finding corresponding row
  163. How do I create a function into function list?
  164. How do I display calendar days in a row
  165. Excel chart source data
  166. Bug in Excel 2003
  167. Copying and transfering select rows of data
  168. Detecting When #N/A Returned By VLOOKUP
  169. Difficulties with SaveAs method
  170. Milti Column Combobox
  171. Macro to insert rows in Excel
  172. Running multiple queries in Microsoft Query in Excel
  173. Display background color of a cell in a Validated cell
  174. Sorting contents of an array
  175. DEEP IN MUD
  176. Controlling an application from excel vba
  177. ATPVBAEN.xls Not Found
  178. Print From Macro Only
  179. Excel Front End for SQL Server
  180. Help using MS Office Document Imaging
  181. Clipart in Marco
  182. Calculate value based on a cell and inputbox
  183. linking list box
  184. Screentip and Hyperlinks
  185. ClipArt to macro
  186. Default in a textbox and change a module name
  187. automaticaly increase the row spacing in xcel
  188. How do I create validation lists which change based on another lis
  189. Combo column identifier
  190. Transpose Combobox ListFillRange
  191. Help with variable
  192. Re: Concatenate problem
  193. VBA and cab files
  194. Keyboard shortcut for formula bar?
  195. Concatenate problem
  196. MsgBox date & time
  197. Export Specifications Question
  198. copyfromrecordset not working
  199. How to change a macro while running others?
  200. Print to MODI but not display viewer?
  201. alert
  202. lock / unlock dynamically
  203. Adding Sound to Program
  204. How to copy formula from one cell to a range?
  205. Names.Add - Range Syntax Issue
  206. How to make the column in the excel file as read-only?
  207. Help with silly error
  208. Re: Modify this a bit
  209. Enabling more than one option button
  210. compile error
  211. Repost: Activate Worksheet
  212. Licensed User - Changes on its own!
  213. Help on EXCEL-VBA-HAsp Key Encryption
  214. Help with some code please
  215. Macro running time
  216. Msgbox when Excel is closing down.
  217. SOLVER macro
  218. simple question about macros
  219. prevent open invalid Excel file
  220. If Then Else Statement
  221. assigning macro to cell
  222. repost: searcing multi excel files...
  223. Problem with Excel DDE
  224. Limit of objects on a form
  225. Problem on Excel Exit
  226. Excel2000: Need help on UDF (working with arrays)
  227. Saving
  228. overwrite
  229. pre written basic macros for excel
  230. This may seem rudundant...
  231. from menu Data-Validation, with List
  232. Why Sheet1 is displayed in modules as sheet1
  233. PasswordChar
  234. Porting of Excel data to SQL Server 2000 remotely
  235. "SaveAs" Generates error on shared drive
  236. help with speeding this up...
  237. NOT static variable problem
  238. Row from address of range
  239. "=sum(variable:variable2)"
  240. I like to open a folder,auto print,save then close
  241. Worksheetfunction-countA----please help
  242. VB Form vs VBA UserForm problems...
  243. VB Form vs VBA UserForm problems...
  244. VB Form vs VBA UserForm problems...
  245. Searching 5 or 6 excel files for specific data...
  246. sorting a column
  247. Screen flicker when changing Image.Picture source on UserForm
  248. Close workbook/excel
  249. More on disappearing shapes
  250. ThisWorkbook.FollowHyperlink to Location in Workbook
  251. Macro Help - copying specific data
  252. How to save entire Cell in a variable and put it back later?
  253. InvalidCastException with .NET
  254. Terminating Forms
  255. A double check, please
  256. Edit to CDO email (Ron deBruin)
  257. AUTO_OPEN and Automatic Data Refresh
  258. Using variables to make a date and using find method to find that.
  259. Decent Excel VBA books and some sites
  260. I get a macro warning when there are no macros attached
  261. Incorrect resolution of path to XLA file when user has roaming prf
  262. Autosave
  263. macro on "mouse down" in graph?
  264. Userform - Formating Text in a Label
  265. Removing apostrophe from imported data
  266. Range of a whole column in Cells syntax
  267. Tab Stops
  268. Enter a formula in a cell based on value in another cell
  269. Activate Worksheet
  270. Days in a Month
  271. Conditional macro to hide rows
  272. Rounding Up a Timestamp
  273. click event problem in excel 2003 only
  274. Range as variable
  275. Copy & Delete
  276. The 'other' status bar - that displays the sum of the selection
  277. RE: Copy & Delete
  278. visual basic with Excel- how to move cursor right
  279. Excel 2003 crashing - turn off autorecover?
  280. NOT allow users to save XLS file when viewing over web
  281. RE: Conditional macro to hide rows
  282. Sorry... no Google results!
  283. Create a word file from XL
  284. Memory Space Due to the "Undo" Button
  285. Objects moving when printing
  286. java icon
  287. Formatting all cells or sheet
  288. Refering to Names
  289. select method of range class failing ?
  290. Passing string arguments that have quotation marks in them
  291. Macro to loop thru sheets & return to a1 cell
  292. Concatenate text confusion
  293. After Print event
  294. Checking specific cell, and identifing how many rows in the sheet
  295. Converting Excel to Tiff
  296. Problems when printing to the virtual printer
  297. Compare Macro
  298. Download files without alerts by Excel VBA
  299. IF AutoFilter is on, turn it off
  300. Call a procedure in the workbook from a worksheet
  301. HELP! limit of objects on a form.
  302. criteria for a given date equal or -greater then-
  303. Call workbook function
  304. Problem with the file format xlCSV and a field separator
  305. Loading a Text Box
  306. Change date format
  307. Seasonal factors
  308. Environ Library Not Working on Excel 2000
  309. VB, Pivot Table, Refresh
  310. count number of workbooks open
  311. applying function depending on condition in other cell
  312. How to identify missing libraries in Excel (Office-XP) using VBA
  313. Tab Colour of selceted sheets not changing
  314. Freezed Panes and CTRL+HOME
  315. Outline.ShowLevels
  316. Problems with sending eMail by SMTP
  317. Problem with number lock
  318. Range names -VBA
  319. Apply Excel Program to a Number of Rows
  320. Pasting values from a closed Excel instance
  321. Other option of InputBox for range selection
  322. Data Validation problem
  323. Macro to to get values for specific date and copy to cells
  324. VBA- Is the cell hidden?
  325. Adding times but excluding a time range
  326. sorting in pivot table
  327. Error routine needed
  328. A lot of easy questions.
  329. summing multiple percentages for a large doallr amount
  330. A constant array?
  331. Select specific columns for a given cell selection
  332. Effective Method to Detemine the Beginning and End of An Array?
  333. UDF Name Reverts to Lower Case
  334. Visual Component Manager for VBA
  335. play sound when opening workbook
  336. Macro Help - 2 sets of sheet array
  337. Saving two file names? One with no extension?
  338. Looping question
  339. Find worksheet
  340. calculate time/distance
  341. how do find out the column of the active cell in a macro?
  342. "Open" or "OpenText"?
  343. Excel function to search and access database problem
  344. Invalid Qualifier
  345. Is it Possible to create a Message Box (MSGBOX) with Excel Formula?
  346. Printing
  347. ATTN: Tom Ogilvy or anyone else: send DOS command?
  348. Newbie to VBA, Can someone help me?
  349. find and replace
  350. I've deleted all macros but still asked when opening file
  351. How do I use check boxes to determine which worksheets to print?
  352. How to automate extraction of url, that change daily, from hyperli
  353. comparing two columns, help!
  354. Recalculation of User Function when Hiding arguments
  355. Programatically find Duplicate entries
  356. Data Manipulation
  357. Cell Contents controlled via a scroll bar
  358. UserName
  359. Series values from an array variable
  360. Excel 2003 File, New Task Pane
  361. Recorded macro won't run
  362. Conditional Formatting
  363. Recreate AutoScroll
  364. User Form
  365. Prevent recalculation when opening earlier versions
  366. Excel drop down menu
  367. Convert, export, or save Word as an image file (jpg, gif, png, etc
  368. Add-in crashing Excel
  369. Printing
  370. Can you freeze a result in a cell? (VBA needed, methinks)
  371. How to highlight active row and column?
  372. Displaying the Save As Window using VBA
  373. Outline.ShowLevels
  374. Date Modified from an External Internet Source
  375. delete row if no data, non-contiguous range problem
  376. Copy data from Cell to Cell
  377. Problem with a recorded macro to create two pivot tables from same data
  378. Macro Writing
  379. Non-adjacent area selection
  380. AutoFilter
  381. What's in a (macro) NAME?
  382. convert text to data with decimals
  383. Improve code
  384. Combining multiple Excel files into one html?
  385. Further help on delete criteria found
  386. Another Chart Question
  387. How to get a macro to work in different workbooks ?
  388. finding the number of rows and the first row with a specific value
  389. Floating a Chart Question.
  390. Range Names-VBA
  391. Time format and various users
  392. I really need some help Please !!
  393. Length limitation of cell formulas
  394. Simple scroll and select?
  395. Printing selected rows
  396. Assitsance with writing macro to import text report into Excel
  397. one button for many (macro)
  398. zip a email
  399. Look for value in a column and delete
  400. Spreadsheet
  401. win32+Excel
  402. why a workcheet_change function is not working???
  403. Want to create a search gui on wkst1 to seach data on other wksts
  404. Call VBA function from cell
  405. Feedback To The Group
  406. Marco: Pivot Table
  407. Sumproduct in VBA
  408. How do I retrieve multiple selections from a forms listbox?
  409. Excel 2003 - VB Code - Run time error....pls help :(
  410. Year to date
  411. WorksheetFunction.CountA - Excel 2000, Please help
  412. Flaky combo boxes. Work around?
  413. Closing user form in Initialize macro?
  414. Hyperlink in text
  415. Looping through controls on a MultiPage control
  416. How can I put a cell location (ie. row and column #, not value in.
  417. Bug in Excel 2003 while debugging RefEdit control in form
  418. auto_open macro not performing as expected
  419. Referencing .Net DLLs
  420. Cannot copy addin locally error?
  421. How can I get a macro to execute in excel based on the value of a.
  422. Caption disappears from CommandButton.
  423. Array as chart series data source
  424. Populate multiple cells off one equation
  425. linking table
  426. Parameter query
  427. Data>val question
  428. RTD w/Array Formula fails when moving to new PC
  429. Making An Add-in
  430. Inefficient?
  431. Alert when conditions are met
  432. Code problem with text box
  433. Fix Code: Select Case and "Contains" selection
  434. Is there any books for startibg up with macros?
  435. add method of validation failing
  436. Reference varialble value rather than variable name
  437. Window Handle
  438. VBA and 2002/2003/2000
  439. How do I construct a text box which will pop-up based on a condit.
  440. trying to merge historical and current data using a common id fiel
  441. Input date function.
  442. Does anyone have an excel macro that converts states to 2 digit f.
  443. API Call from VBA crashing Excel
  444. Mulitple Excel Macro Users
  445. How to get a SUBTOTAL field from PivotTable?
  446. Addition to Worksheet Change event (RP?)
  447. OldValue property
  448. make formulas from relative to absolute
  449. Need VBA code for Save As dialog
  450. Add-in crashes Excel
  451. Problems copying Autofiltered rows & SpecialCells
  452. Organizing functions
  453. Stopping macros running?
  454. Displaying enteries of a certain type
  455. VBA function : How to search a string in another string?
  456. IF..Then..ELSE.. ELSEIF
  457. print event
  458. Custom Menu Programming
  459. Assign ShortCut-key To Toggle VBA-toolbar?
  460. automation difficulty
  461. Performing actions on multiple worksheets
  462. test (ignore this one please)
  463. How can I determine who has workbook open?
  464. finding values quick
  465. API commands to turn volume control on
  466. Create folder if it does not exists
  467. Select current region and print
  468. How to select multiple ranges in Excel with vbs
  469. using Windows API Open Dialog/Browse in VBA - center form in scree
  470. How to determine an opened sheet( Read Only)
  471. controls.add
  472. Prevent a file being deleted
  473. entries into random cells
  474. How to set conditional format with vba?
  475. Change formats based on A:A cell value on each row - (not with conditional format!) ?
  476. Macro to copy duplicate rows (not delete)
  477. how to add calander control in excel cell ?
  478. [Help] How to merge two charts?
  479. Excel2000: UDF's parameter as cell range OR array
  480. MS-Excel: keep lines (rows) together
  481. Create a Worksheet by getting datas from the txt file with Macro
  482. Select file.
  483. Find do not work with decimal point
  484. Active X Checkboxes
  485. Excel NETWORKDAYS - incorrect results
  486. Sum based on font color
  487. why Microsoft Excel can't support if() multiple choices more then.
  488. run-time error'-2147352571(8002005)
  489. Remove active module in a copy
  490. Function Help
  491. chart help
  492. I have no idea why this is giving me a error: Windows(dataFile).Activate
  493. Microsoft Add-Ins
  494. Running a Macro from a Hyperlink
  495. userform_keypress event
  496. Need to be able segregate units run in excel sheet using time.
  497. Incorporating Matrix Functions From Excel
  498. Data Validation or Pull Down Menu
  499. Copying from one worksheet to another
  500. Embedded Objects in EXCEL spread sheet
  501. ThisWorkbook vs. ActiveWorkbook?
  502. Mailing List Parsing
  503. matching 2 columns
  504. Can you save options selected in Text Import Wizard?
  505. PDF Writer
  506. Moving workbook with VBA between computers
  507. Rename worksheets
  508. XL97 Private Sub Workbook_Open() Not Working
  509. Combobox data accidentally copied on different sheet
  510. combo box of control toolbox
  511. circular reference in VB
  512. Macro to print a hidden sheet
  513. Adding Embedded OLE Objects on a Spread Sheet
  514. list + macros continued
  515. Date last changed by Row
  516. XML mapping in Excel
  517. print long text
  518. CheckBox Problems
  519. Running a macro based on a cells value
  520. summing comma separated values in a range
  521. How check for No/Cancel Button when SaveAs and file already exists?
  522. determining fractional seconds from serial time
  523. Obtain current RGB settings for color indexes 17 thru 27
  524. Rearranging Data
  525. label does not show???
  526. Big Honkin' Query
  527. copying a range of cells from one worksheet to another
  528. conditional numeric formatting
  529. Simple Array Looping
  530. Option Button problem
  531. Detect external link from unopened workbook?
  532. Textbox edit
  533. Combo problem again
  534. Chart versus Work Sheet Code Failure
  535. Powerpoint macro inserting pictures
  536. loop does not work except in debugging step through mode
  537. A difficult question
  538. Making Excell formula constant
  539. When a cell is change
  540. Custom toolbar buttons
  541. Automatic Archiving
  542. Ranges in Custom Functions
  543. Date
  544. Simple Question
  545. SetFocus problem
  546. combo box problem
  547. Help with UDF Function
  548. Help - I'm sure it must be simple
  549. Macro working well in Excel 97 but not in excel 2003
  550. Easy question?
  551. remove subtotals from pivot tables
  552. Macro that draws a chart
  553. Protecting chart objects
  554. Macro's
  555. create a folder
  556. Highlighting today's row.
  557. Renaming multiple files from *.csv to *.txt
  558. Problems programming to the registry using RegEnumKey
  559. How to get value of a excel-fields without open the workbook.
  560. keydown event
  561. Help on AutoFilter
  562. Text Boxes and Default Values
  563. Multiple Option Buttons and Selected Button
  564. Disable the "X" close button in an excel application
  565. Printing problem
  566. Timed Application
  567. WorksheetFunction.Count
  568. minimising workbook while having the active form open
  569. Complex adjacent row value finder - need help
  570. Complex reports
  571. Accelerator keys in user form not working
  572. Delete specific row in range
  573. File management
  574. Splash Screen Flashing Label Problem
  575. Hide Password Technique ???
  576. Add Cells In A Column Until They Equal 4200
  577. How to select cell and have time or date appear?
  578. Copywrite spreadsheet
  579. Creating a macro
  580. If Cell Not Number Than Specific Word?
  581. Copying a sheet from an addin into an open workbook
  582. how do i use excel to check my lottery numbers
  583. VB for importing data into excel in proper columns
  584. read a Unix binary file
  585. using IF and AND conditions in a macro
  586. Filtering Data
  587. Dynamically create a formula in Sheet B referencing SheetA
  588. roundup, ceiling or whatever
  589. How to increase number of "conditional format"
  590. ISERROR function
  591. Named range
  592. Copy FormulaArray
  593. Printing Word Document from Hyperlink -- Can't get the full path!!! Please Help
  594. Naming vba Buttons
  595. color of active cell
  596. Excel VBA - How to enter a reference to another sheet?
  597. I am trying to export MS Outlook tasks into excel
  598. VBA UDF Writing data to spreadsheet
  599. Error 94
  600. User form in copy of original file
  601. Blinking Label on Splash Screen
  602. Formatting chart TickLabels fails to include time with date
  603. Excel Array Conversion from 2-Dimensional to One
  604. Relative address equations
  605. Deleting cells in a row
  606. IF statement in a macro
  607. FORMULA IN EXCEL
  608. Change event macro
  609. wRITING A mACRO TO MAKE A WORKSHEET PRINT.
  610. Excel VBA for Global Address List
  611. Working with headers in pagesetup
  612. combo box help
  613. Once-only Macro
  614. Excel cells that flash info
  615. Sendkeys
  616. how to display specific data in a Pivot Table
  617. Playing sounds on opening a worksheet or shortcut
  618. Automate Access from Excel
  619. Question about worksheets in an AddIn
  620. Question about worksheets in an AddIn
  621. Remember last selection?
  622. Find method
  623. eof
  624. Date formatting issue in user form
  625. Preparing Workbook for user input
  626. ComboBox Issues
  627. Another ComboBox Issue
  628. Another ComboBox Issue
  629. If sheet not created show a message
  630. Pivot Table - display only sum and count if greater then 5
  631. putting graph as Line
  632. Currency format for combo box in a user form
  633. TAB STRIP CODE
  634. Adding Qty based on Item
  635. Formatting and sorting cells with VBA
  636. Problem with find method
  637. An Array Lookup Formula
  638. Formula needed for date range
  639. Form Controls; setting properties based on cell values
  640. Log users opening the VBE?
  641. Which ActiveX DO Lib?
  642. RUNNING WINZIP32 FROM EXCEL
  643. Is there anyway to hide #DIV/0! in an excel worksheet cell.
  644. ComboBox Problems
  645. precision question
  646. Help! I Deleted my File Menu bar Control
  647. Option button
  648. click on cell it goes to formula location??
  649. Default Value?
  650. Request for Excel Formula
  651. Sort Data for duplicates
  652. Relative cell ranges
  653. Switch focus to inactive userform
  654. macro
  655. calling web service from excel 2000
  656. autofill with best match
  657. Reference Calculations
  658. Column conversion
  659. Sort data then delete duplicates
  660. Macro if greater than letter then delete
  661. Need formula to calculate average monthly percentage of change...
  662. Strange Range.item behavior?
  663. Data on the clipboard is not the same size and shape as the selected area..
  664. Microsoft Excel 2003: Clicking on a LINK that takes you to a different cell in the Workbook
  665. Overflow Error
  666. How can I run a query(dqy file) from an Excel macro
  667. blank rows
  668. AutoFill columns
  669. Confusion about how the Window object fits into the Excel object model
  670. No Returns on Fuction Call
  671. Conditional Formatting
  672. UserForm Calculation
  673. Variables
  674. Button vs Command Button
  675. Saving A File
  676. loops ...
  677. Latest date
  678. VBA Project Explorer list
  679. Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range)
  680. VBA command for edit cell mode
  681. Printing to header/footer programatically
  682. determine pagebreak using VBA
  683. Track changes
  684. macro'S
  685. clipboard
  686. Prevent deactivation of sheet
  687. How to store hidden binary data?
  688. lookup for a combo box in VBA
  689. Need 2 create userform that uses data from rows...HELP.
  690. Preventing cell from being empty
  691. Reference.
  692. Fun Excel applications wanted
  693. How do i create a popup window (a macro ?)
  694. Add Sheet - Copy Worksheet
  695. On Events
  696. Form places number in database from combo box
  697. sql query for excel column values
  698. Copying formats?
  699. Duplicating cell properties
  700. Compilers for Excel to create exe programs
  701. Repeat Data
  702. Toggling a Command Button
  703. Comparison or two sheets
  704. Copy Method
  705. Getting filenames via VBA
  706. dynamic input from a text file pavement elevations
  707. Extract Data Validation Input Messages and Titles
  708. pasting screendump picture in VBA form
  709. Linking cells by cell text.......................TIA
  710. Storing cell location
  711. Reversing names and sorting
  712. ListFillRange linked to named range in a closed remote file
  713. Re: How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
  714. Insert and Delet Rows between pivot tables on a worksheet
  715. Return Activecell row number from another sheet
  716. RE: Cell tests for upper case, and certain #'s
  717. Excel VBA Newbie
  718. Calculate value based on a cell and inputbox
  719. Macro for a comparison
  720. SUM PRODUCT ACROSS WORKSHEETS
  721. HOW DO I program one worksheet to get info from another?
  722. Displaying values on graph
  723. setting a copied worksheet
  724. searchwords in same row?
  725. Re: toggle button & event code
  726. Lookup part of a cells contents
  727. Re: Cell tests for upper case, and certain #'s
  728. present data as hierarchy/tree structure in user form
  729. selecting range of cells - variable # of rows
  730. Re: Need a property that will give me true if a value is close
  731. plz help: creating named range in VBA, loop goes haywire
  732. Move sheets To New Wbk - recover workbook
  733. Re: formula question/elapsed time
  734. having trouble writing string to cell-xl2k
  735. Fixed Decimal point
  736. Re: Pasting pictures from Excel to Word (2000)
  737. Re: how do set up a database to prepopulate details to a form in exce.
  738. Re: Automation Error(-2147467259) in Properties Collection
  739. Re: Automation Error(-2147467259) in Properties Collection
  740. Re: Conceptual Question about ReDim
  741. Re: Conceptual Question about ReDim
  742. Re: Custom Function - Adding Help Information
  743. Re: toggle button or worksheet_activate causing form to open twice
  744. Re: Environ function.
  745. Re: User picks a text file, macro defining the array
  746. Macro better solution than cell formula with date?
  747. how to catch errors from outlook
  748. Re: Application.Calculate & VLOOKUP
  749. Loading a spreadsheet from memory
  750. Re: average