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. Put Excel Data into Powerpoint Template (tables and graphs)
  2. Programmatically determining if worksheet is protected
  3. Event macro to extract data based on value of 2 cells - help
  4. save nonactive worksheet as a seperate workbook?
  5. Expanding a range
  6. dont see custom document properties...
  7. call a macro with arguments in a Command Button
  8. VBA edit menu actions
  9. Looking for String Function
  10. Find a break in sequential number
  11. search in a list, then replace using 1st column always
  12. Worksheet Protection
  13. Replace text with variable using VBA replace code?
  14. can a C# plugin return array to Excel? or set Range values?
  15. Round calculations
  16. Where is the problem???
  17. combining values ?
  18. Digital signatures
  19. Scheduling - adding minutes to time
  20. bring focus to workbook with variable name
  21. Macros skip steps and/or stops in the middle of code
  22. beginner ColumnsQuestion b + 1 = c how?
  23. Display autoshape with circumstances
  24. Check the "Windows Regional Languages" setting?
  25. How can I detect "nothing"?
  26. Copy and PasteSpecial help
  27. Commandbar properties
  28. Auto fill Row Numbers in Col A
  29. problem resizing range in vba
  30. sumproduct syntax
  31. How Do I Populate A ComboBox RowSource With VBA
  32. addin toolbar
  33. Scroll Event
  34. xsl to xml problem during load
  35. Selection.Resize error
  36. Testing for "Password to modify"
  37. if value = 0 then
  38. SolverOK setCell and byChange args are not passed to the solver
  39. Problem with setting a R / W property, FileSearch, LookIn
  40. delete a macro
  41. Restart
  42. Find Value of column
  43. Userform Development
  44. Problem with code
  45. display a chart on the useform thru excel vba
  46. Loops, ranges and VLookup
  47. Header & Footer from vb6
  48. unpredictable combobox behavior
  49. Help! Can't refer to a subroutine on a worksheet
  50. System error &H8000FFFF (-2147418113)
  51. VLOOKUP always required the searching field SORTED?
  52. Select some sheets automatically
  53. Using Container in Auto open macro
  54. Hide Zero Values
  55. Series collection pb on Ecxel 2003 chart
  56. Pb With Excel 2003 Charts
  57. Allow user
  58. how to detect change of calculation-option
  59. Round Function (Significant Figures) for Large Numbers
  60. Highlighting Range of Cells based on another cell with 5 condition
  61. hide blank rows
  62. Server Throws Exception on Workbook.Close
  63. Make page break every several lines automatically by VBA
  64. Savings settings for an add-in in the add-in's own worksheets
  65. Inserting comments on protected worksheet
  66. Applescript question
  67. Re: How to make worksheet saved in VB6 visible?
  68. Cancel button on messagebox/inputbox
  69. Data Grid control
  70. Hyperlink to Hyperlink
  71. Reference Cells on another worksheet
  72. All charts in workbook to powerpoint
  73. macro to delete specific row with queries embedded
  74. check boxes
  75. Need Help on this complicated issue - VBA and the API to Dynamically Set Screen and Window Sizes
  76. Same Value in ALL Sheets in a workbook, based on sheet1 Cell Value + Code Strange Behaviour
  77. Is the string a date?
  78. User Form: Multiline text box to multiple rows
  79. Multiple Logical Tests in IF function
  80. Search with multiple results
  81. turn an filter off or back to All
  82. Geometric shape programe
  83. Macro to Filter>ShowAll on Protected workbook
  84. How to create a workbook from a signed addin that is itself signed
  85. Inserting a character into a cell that has text.
  86. Union Statement Question
  87. Excel API programming
  88. Hyperlink calls macro passing argument
  89. How do I save more then one Excel worksheet to .csv file format?
  90. checkbox linked to a cell
  91. printing hidden sheets
  92. Need help with deleteing sheets using VBA
  93. Problem with validation deletion/modification
  94. Count connected users
  95. Use MsgBox to get filename and save .xls file to pre-defined path
  96. sum
  97. Paste results not as expected
  98. need help with macro to convert number to date
  99. Re: showing userform with excel minimized
  100. Looking for Excel function verification tool
  101. separate "A1200:AB13000" into A, 1200, AB, 1300
  102. Defined Names
  103. the first event that occurs after a file is done saving?
  104. List subtotals
  105. DSUM?
  106. Buttons to run macro do not work ...
  107. Reading from Numerous Text Files into Excel Column
  108. Macro help, very slow
  109. .NetFrameWork\Policy\AppPatch, v1.1.4322, v2.0.50727 and Excel,
  110. automatically sending workbook daily to email recipient
  111. Filename Recognition
  112. LENDING A FORMULA FOR INVOICES
  113. Comparing two dates in one column
  114. Process will not end from task manager after vba code is over
  115. RE: Program won't work on all computers
  116. How to cancel the selection?
  117. Conditional Formating For Expired Dates
  118. User Form: Multiline textbox to multiple rows
  119. How do I select multiple selections using the range(cell(),Cell())
  120. Checking if the sheet already exists
  121. Excel Beta / Command Buttons
  122. Trap error in: ThisWorkbook.VBProject.References.Item(i).FullPath
  123. Copy and Paste Rows according to Drop Down Box
  124. xldown in a non-contiguous column
  125. Drop Down Lookup Return Value From Another Cell
  126. Addition/subtraction possible with occasional empty cells?
  127. Resetting the background color of a cell?
  128. open filename containing specific characters in known folder
  129. Creating an addin
  130. How to replace Excel solver with some free solver codes in Excel V
  131. MsgBox for filename and static path
  132. Need to place 3 formuals in VBA
  133. Searching mutiple sheets for a value in one column
  134. Save one worksheet from a workbook to a new .csv file
  135. Finding last row in range with blank cells?
  136. Text box in User Form resizing upon data entry
  137. Stop a Macro if no Data found
  138. Trying to write a macro
  139. Turn formula into vba
  140. Applying Formula Based on Cell Contents
  141. Sorting Rows on a password protected worksheet
  142. Word Automation
  143. Loading SQL Data into Excel 2003 with VBA
  144. Clearing Values in a Range under certain conditions
  145. How do I take a number from a cell and mult each digit by
  146. Excel starts without any bars...
  147. Sorting 3 columns in a 2 dimension array
  148. Truncate string
  149. Truncate string
  150. Weird Behaviour of Code
  151. numbering add-in
  152. Close excel application
  153. Loop in Excel
  154. Updating Excel Code
  155. Excel updating
  156. VBA error -> increased file size
  157. Assistance please for date range filling...
  158. Excel to find a name in a column and if found place a tick in sheet 2.....
  159. File comparing, fill file2 with value from file1
  160. remove item fr listbox (correction)
  161. Formula Help Please
  162. Open new workbook(s) when userform and excel are minimized
  163. returning multiple cell addresses
  164. How do I set Printer Paper Source using Visual Basic?
  165. Error in setting formula (Match) with dynamic variables
  166. Saving xls in specific directory
  167. Select print area
  168. Multiple look-up / summing
  169. When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error
  170. Get data from magnetic card reader to each cell
  171. Find next ID in non sort column
  172. Selecting a Folder or Subfolder
  173. Re: Import data into Excel sheet from CSV File
  174. Determine if a File Exists
  175. SaveAs Dialog Box
  176. change filter with criteria back to All
  177. Template Help Task Pane Appears When Workbook Is Open
  178. Clear Clipboard after Copy
  179. Referencing Cells in Multi-Area Range?
  180. track changes on an excel sheet
  181. FYI: One macro really helped for capturing data from multiple workbook stored in a specific folder to one excel file only
  182. How to get handle of Combobox in worksheet
  183. Storing data in MS Access from Excel VBA
  184. Navigate between 2 workbooks
  185. Assign variable ListBox names
  186. deleting rows across worksheets?
  187. Simple if formula in a macro
  188. Selecting next to highest number in an array?
  189. remove item from list box
  190. How to convert Excel File to XML Data
  191. A challenge
  192. Winzip and remove files
  193. Custom control event problem
  194. Store range of values in an array
  195. Displaying Chart on Userform (with Scroll Bars)
  196. Get the max number from a collection
  197. Can sumproduct do this......
  198. Amazing... something hidden in cells...
  199. BeforeDoubleClick processing question(s)
  200. Sort question
  201. list sub totals
  202. How to jump to specific cell
  203. setting multiple values in array at once?
  204. How can I put a list into a range of cells
  205. GETPIVOTDATA
  206. Cell wrapping event, does it exist? How can I calculate cell filli
  207. sorting a one dimensional array
  208. Force use of a date picker control
  209. Help with auto filter
  210. Array UDF
  211. Does anyone know how to force a cell re-calculation
  212. Found a glitch in the OFFSET function.
  213. Replacing Chr(10) in a string
  214. Passing range to a Sub
  215. Macro To Print Files By A Listing of Filenames And Paths
  216. Some help with Find/Find next
  217. Worksheet Button Properties
  218. how to define range for autofill without knowing the last row .
  219. Option Buttons
  220. network location
  221. Merge columns into single list and replace with count of occurrences
  222. How to find the first occurence of any number in a string
  223. Text in DAtes
  224. Copy data to multiple specific worksheets?
  225. Variable in cell reference
  226. Only for experts - please help
  227. Text in dates
  228. macro or function
  229. Paste totals from 1 sheet to another
  230. calculation problem...
  231. Loop Routine in Excel
  232. Edit query in Excel
  233. Gantt Charting
  234. Print dialog return help needed
  235. Find & Move Sheets
  236. Disabling CTRL R or CTRL D in workbook
  237. Edit query in excel
  238. Adding formating
  239. Saving a variable value
  240. Calling a function in another module
  241. Count Space, comma and fullstop in a string
  242. Macro to insert formula failing...need help
  243. "ActiveX component can't create object"
  244. Macro to copy files
  245. Determing range name that is tied to the active cell
  246. Remove duplicated Items in combo box
  247. Scroll Combo box with mouse wheel
  248. Module Protection
  249. Need to create "on change" logic.
  250. Reset variables
  251. data validation invalid in dynamic validation list
  252. lost VBA editor toolbars...
  253. Charts
  254. Convert input to numeric
  255. change combobox values one by one based on selection in multiselect listbox
  256. Apply format to whole column depending on row 1 contents
  257. How to find the last column or last row in a pivottable range
  258. Display col width in a cell
  259. Info in Formulas
  260. My anti-virus has deleted my vba macros!
  261. CommandButton State
  262. replace defined text with page break in vba + excel
  263. Date Value in wrong format on userform
  264. Special Filter Macro - one rngFilter, several Worksheets filtered
  265. Newbie: Reading color information
  266. File SaveAS
  267. Referencing Named Cells in Find
  268. Edit a cell macro in Microsoft Visal Basic
  269. error in code, Clear Clipboard Memory
  270. something just not right in code, please help!
  271. count
  272. showing a listbox with last entry as the default
  273. make a box with... or other solution
  274. forgotten array
  275. Any experts on the "if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG!
  276. Duplicated code window and userform window problem
  277. Anyone know what's happening with this bit of basic?
  278. hide sheet tab and protect
  279. Sorting macro needed on a protected sheet
  280. Delete all named ranges in a workbook
  281. Date "E2" to add 7 days How?
  282. Trouble with this code
  283. add items to listbox
  284. Choosing multiple items in a dropdown menu
  285. Many Workbooks into one spreadsheet
  286. How to copy a file into folders that are created based on a list?
  287. Extracting data from outlook
  288. Macro to open, calculate, the save many files.
  289. IF file Exists, then ....., Else.......
  290. Copy and Paste data
  291. AutoFilter button
  292. Macro runs on cell value
  293. Enable ESC to canel UserForm
  294. R1C1 and A1 style conflict in formula problem
  295. multiple lookup formula question
  296. Change event on single cell fires many times
  297. Quotes in CSV Files
  298. "On Open" Run Macro
  299. How do you know what version of Excel you are using??
  300. AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS
  301. Disable Close All
  302. Auto cut & paste
  303. Deleting rows based on a cell value
  304. Saving Excel File in Current Directory NOT My Documents
  305. Saving Excel File in Current Directory NOT My Documents
  306. Excel 2003: VBA: How to Speed Up Row Deletions
  307. Setting default value for combo box
  308. Formula for Cell
  309. Import code help
  310. Getting a collection of named ranges using wildcard characters?
  311. Number stored as text
  312. Converting months as # to Text Month
  313. forcing cell format to be negative currency?
  314. print query continued.. nearly there - possible ??
  315. Run Time errot 1004, with formula
  316. What are MICROS in EXCEL and how can I benefit from them?
  317. Re cell reference
  318. Automating key strokes to a dialog box
  319. Pivot chart display options
  320. 1004 Cell Protected Error for data validation lists when locked and protected
  321. How to use vba for inserting data into a sheet that is acting as a template or form
  322. How to calculate
  323. Automate importing
  324. Passing arguments to a module in a Cell
  325. Color alternate Entire row dependant on value in "A"
  326. Getting Excel to send message via Outlook 2000
  327. How can I automate creating a sheet for a unique value that is bla
  328. Auto Shutdown
  329. JUMP to the next cell with TAB key !
  330. Delete Worksheet Condition
  331. Removing subtotals - annoying 'feature'
  332. WorkBook _SaveAs method help
  333. Can you Add Check Boxes??
  334. Pausing or waiting in VBA
  335. Add method of Workbooks class failed
  336. Find syntax
  337. Issue creating a furmula in VBA, Please Help
  338. COLORED cells, how do I make them PRINT without the Color?
  339. Macro to run on cell change
  340. Optimizing Excel Reading
  341. Removing Commas from xlcsv
  342. Comparing columns and deleting rows based on criteria
  343. Help with Creating a Macros!
  344. Delete column if a cell is not named
  345. Cell to display text from cell on focus??
  346. Rule for jumping to a public function
  347. automate importing
  348. Output Array Values
  349. Vaiable in range().formula
  350. Sorting a listbox
  351. annual to quarterly
  352. Mouse Scroll in Combo box on excel worksheet
  353. Protect Chart Sheet
  354. Successive VLOKKUP ?
  355. Windows().Activate vs Workbooks().Activate
  356. Excel as a reporting tool
  357. Code is not running
  358. Is there an alternative to Application.Run
  359. Array Vlookups
  360. printing a html file progra
  361. Passing Controls on a form between modules
  362. Remove duplicates from list but leaving one row with highest date
  363. If Len > 5 OR cell is alphanumeric Then Clear contents
  364. Using ActiveWorkBook.Container
  365. SheetSelectionChange
  366. Using solver variables to access database values
  367. Formula
  368. Information Right Managment
  369. Formula for calculating storage days
  370. Chart to PPT without opening PowerPoint
  371. Select last months file
  372. Join statements using ADO across separate Worksheets
  373. How to make fetching and displaying of data from dtabase to workbook faster??
  374. Query
  375. Select specific Project in VBA
  376. Tracking changes with respect to the correlation in entities
  377. Excel VBA Vlookup
  378. Method 'Range' of object '_Global' failed
  379. subscript out of range error with 500+ files.
  380. Chart to PPT from linked sheets
  381. unique values to array
  382. Global Variables in Excel VBA
  383. MultiPage: How to enable controls in Frame on Page
  384. Price List For Sales Representative
  385. ERROR 462
  386. msg error with part of code???
  387. Reinstall EXCEL
  388. format from empty cell below
  389. Help Please
  390. Change Lowercase or Proper to ALL CAPS
  391. OptionButton problem
  392. using variable with .Activate
  393. How can I find type of control on a form
  394. How can I find type of control on a form
  395. Convert String to a Contstant
  396. Set Range Question
  397. Passing info to macro from icons
  398. Chart to PPT
  399. Transferring (Copy/Paste) Info to another excel workbook
  400. Command Button question
  401. Adding rows to a 2 dimensional array ...
  402. Caching?
  403. in formula, want 2 use 1 for A, 2 for B, 3 for C...Help plz
  404. collage out of my photos
  405. how to undo changes made by micro
  406. Embed PDF in Excel UserForm
  407. Text box problem
  408. Input login ID & password in IE
  409. How to hide row/column labels from VBA?
  410. Help with code
  411. Auto-email based on cell value change?
  412. set textbox cursor in mouse right-click
  413. how to arrange dimensions of source data array?
  414. Excel to Power Point?
  415. Programming a dynamic range then apply it to a chart
  416. Combine Data From 2 Columns into 1
  417. using ado db connection in different workbook
  418. Autofilter: jump from visible row to visible row by command button
  419. find ""qqq""
  420. copying data to muliple worksheets
  421. Custom Function to Retrieve Spread Sheet Data
  422. Custom Function to Retrieve Spread Sheet Data
  423. Adding Data Automatically
  424. Match of cell values
  425. calling C# DLL from VBA
  426. Conditional Formating
  427. List box Code
  428. VBA Conditional formating
  429. Copy cell value from W/book2 into W/book1
  430. Measure Text and insert underscore.
  431. Formula for cells
  432. automatically add sheets and link them to external workbook named
  433. Userform Newbie
  434. Filling Blancks in Columns with the containing of cell.
  435. Formula HELP !!
  436. Formatting Text for Drop Down-HELP!
  437. Problem with Cells Selection through macro.
  438. resident functions
  439. Adding Times
  440. Application.Match and Ranges
  441. How VBA Excel handling the Lookup with multiple "index"?
  442. Retrieving time value from cell as decimal. Why?
  443. Autofilter innerhalb der eingeblendeten Zeilen mit Pfeil rauf / runter springen
  444. Help with Conditional Formating
  445. Solver function question...
  446. Getting cell value from other sheets
  447. Appending to a file with run-time error '54' Bad file mode
  448. How to merge worksheets on a key - merge horizontally, that is
  449. useful templates for analyzing bloomberg data
  450. how do i create a button on excel which would send an email / Lotu
  451. How do you include a quotation as part of a string ??
  452. HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE
  453. How do I change the shortcut key for a macro
  454. reading a cells defined name
  455. creating a filtered range/named range
  456. Avoiding goto
  457. XML ERROR in PivotTable on generated XML spreadsheet
  458. cell value not recognised
  459. Landscape printing: userform
  460. How do I alter this AutoSave code?
  461. Remove a reference for an item
  462. running script when workbook opens problems
  463. What am I doing wrong?
  464. Range Name question
  465. CSV Header Information
  466. messagebox help
  467. Help Adding a Column with a formula
  468. Using Filter as a criteria within COUNTIF
  469. Excel Change Focus to Outlook Contacts
  470. HELP on Formula
  471. Executing Code When Cell Is Double Clicked.
  472. Locate a change in Col
  473. I've deleted a file by mistake how would i recover that file?
  474. Issues with VBA
  475. Gradient Fill in a cell
  476. Please help me sort then extract the data to new workbooks
  477. Block a cell depending on the sum of other cells
  478. Compile error in hidden module: USAs
  479. How do I create a loop to merge contents of rows 1-4 across column
  480. Figuring ages and calculating totals on a spread sheet
  481. How to access a downloaded file before VBA ends
  482. Audible alert for cell condition...
  483. Form Question
  484. How do I create a loop to merge rows...
  485. Convert columns to Rows
  486. Need IDEAs For hidding data
  487. Hyperlink from VBA ?
  488. Working with check boxes embedded in worksheets
  489. Excel 2007 Recalculation Bug
  490. Date Time Calculations - Need Some Direction
  491. converting a vba procedure/module to xml or xhtml? (vbhtmlmaker)
  492. help: I need to have an excel worksheet name = a cell in an existi
  493. Excel Error
  494. Userforms and Dates
  495. Run Time Error
  496. take sheet to procedure
  497. Making Queries
  498. Multiplying range: followup for tom
  499. setting the protect option
  500. How to populate a summary page ????????????????????????????????????????
  501. Distance between Forms
  502. resizing listbox columns in excel userform
  503. multiplying range
  504. Selection Question
  505. Copy pictureShape to another Workbook
  506. Is this a bug?
  507. E-mail date from a sheet TEXT only
  508. Import text onto form
  509. DoCmd.SendObject (E-mail)
  510. Macro for finding number of times a word repeats in a cell
  511. Run time Error 380. Could not set the ControlSource property
  512. Command Button & Macro
  513. Loop through range of cells, string search, take action
  514. Problem with Protection
  515. excel to access problems
  516. Set E-Mail Importance with code
  517. Help on a Complicated Formula
  518. VB Script for Autofilter
  519. For Next loupe in a worksheetformula
  520. locking excel sheet from vb code
  521. Compare 2 lists and show reconciliing items
  522. Run time Error 380
  523. Can't find project or library
  524. Search engin
  525. Find MatchCase problem
  526. How to index a variable in VBA
  527. Re: Formula Help...Easy One.
  528. Re: Formula Help...Easy One.
  529. Software language version discrepancies
  530. how can I control the mouse pointer by the Excel VBA?
  531. msgbox to display a cell value, HOW, If possible?
  532. delete a file in code
  533. How to Update Price List
  534. format last 20 rows
  535. Code to convert date (xx/xx/xx) to xx xx xx
  536. How to insert color in row or cell?
  537. Setting dropdown menu to default value
  538. Word wrap merged cells in Excel 2003
  539. How to Populate a summary page from the input page???????????????????????
  540. How to calculate the MTBF for time and date.
  541. What's the vba equivalent of search(text1,string,1)?
  542. SQL parameter query - more than cell value
  543. Excel not refreshing data for User Defined Functions
  544. Opening a workbook withAuto-open Macros without transferring control
  545. No events in form displayed from callback routine
  546. How can I get the author of a file using CreateObject("Scripting.FileSystemObject")?
  547. printing macro?
  548. Loop thru cells and find match
  549. Macro in Excel causes problems when spreadsheet is opened in IE
  550. Possible -- a custom format on text, similar to a VLOOKUP() function?
  551. Problems with excel and screen projector
  552. sheet name used ?
  553. Tricky compare formula
  554. Automatically Close Workbook
  555. Printer
  556. How to Question
  557. Excel sheet size as OLEObject in Powerpoint
  558. AutoFilter - How to determine number of records found
  559. Compile error on VBA Function
  560. Add password to querytable command
  561. formatting question
  562. Ranges
  563. Extract text
  564. getpivotdata problem
  565. Excel Colors
  566. Combining related unique (distinct) values from two columns into an array
  567. Reverse Engineer Pivot Table
  568. Picture on Spreadsheet will not print
  569. saving text files and parsing data to spreadsheet
  570. Need help Utilizing Dynamic ranges for creating charts
  571. What is wrong with this code to name a worksheet range
  572. Disable Autosave
  573. How to continue macro if there is an error value
  574. filter combo box based on another
  575. Compare 2 excel files for the cheapest price.
  576. Hyperlink Defaults
  577. VB to AutoSum
  578. Click in ComboBox question.
  579. Application Updating?
  580. Dependent dynamic combobox
  581. Can I use conditional formatting for this neat thing?
  582. please help with syntax in code
  583. NOT changing Date Modified
  584. Multiple Hyperlinks in 1 Cell
  585. Populate multiple worksheets
  586. Calling Excel macro from Access errors
  587. Macro to format text
  588. Update workbook which is an attachment.
  589. Fastest way to access information inside a WorkBook
  590. Trying to get a splash screen to listen to me?
  591. more than two optionbuttons in a group
  592. Select a column using it's number
  593. Excel macro to sort columns, one row at a time
  594. How to backup excel files?
  595. DATA VALIDATION WITH AUTODATE2
  596. Various Version References = Compile Error
  597. Mulitple SUMPRODUCTS?
  598. Excel macro to create directories?
  599. Combo box properties in VBA
  600. Global definitions
  601. Calculate time to do a job
  602. Combining data from multiple rows
  603. Form Combo Box RowSource Question
  604. delete rows that contain ********* ?
  605. About workbook_Open madro
  606. Consolidate sheets automatically
  607. How do I make a cell allow only 24 alpha/num. char.to be entered
  608. Font Size
  609. Cursor Placement
  610. Is there a simple way to check lots of cells for entries?
  611. Runtime error '462'. The remote server doesn't exist
  612. Check whether appointment time is free in Outlook Calendar
  613. Macro inserts a column but dont update formulas in another sheet!
  614. Repost: Userfrom Back Color
  615. assigning random numbers without repetition
  616. Comparing values
  617. Arrays - Lower Bound and Singleline Assignment
  618. function to call an ODBC query...
  619. Excel 2000: Dynamically Generating Data Driven Sheet Columns
  620. Autofit
  621. VBA (excel) quits on workbooks.open
  622. For every new number in Column A - change row colour
  623. Navigate between open workbooks
  624. How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net?
  625. print procedural question
  626. Linear Programming(solver ?)
  627. What Causes Automation Error When Excel file on Network?
  628. Copy Range to a New WorkBook + Name Sheet a cell Value + Name WorkBook another Celll Value
  629. not excel data source
  630. Insert blank row macro question.
  631. Combo Box Properties
  632. Help with ranges
  633. Excel & Outlook
  634. Merging Col A with Col D
  635. Keeping the formatting Excel to Word
  636. Help with event
  637. Save as !
  638. Delete rows that do not match criteria
  639. Help on Displaying Pictures
  640. Format Entire Sheet Column Widths How?
  641. protection using UserInterfaceOnly
  642. Looking for a better way - Serial to local machine number
  643. make a box with:
  644. VB Delete rows that do not match criteria
  645. How to get Excel to use a custom RGB color in a chart series?
  646. How do I do a cell reference to upload a picture file
  647. Post info to webpage
  648. Cells in a range
  649. How to use/evaluate another Cell Formula in R1C1 style
  650. Need Help Delete Columns Macro PLEASE!
  651. indirect formula help please
  652. MACRO in EXCEL
  653. select and delete certain rows
  654. Disable Move or Copy functionality
  655. Autoscaling a chart
  656. Essbase Add-In Functions
  657. Find & Replace Macro
  658. Date Modified
  659. One print job as oposed to several ?
  660. How do I reverse information in a cell example last name, first n
  661. Subtotals on for selected data fields in Pivot Table
  662. populate 2 column listbox from one named range
  663. Sort Cells?
  664. Need explanation of code please
  665. Get a specific cell value/text inserted in a macro
  666. For Each...won't loop through worksheets
  667. Historical Data - Progress Mesurement - Track changes - Log
  668. Cell Formula
  669. Syntax help for if
  670. TRUE and TRUE or TRUE then......
  671. Closing a workbook
  672. Can excel sum a vlookup value and return the difference?
  673. Printing text from a textbox in a userform using vba code
  674. Getting Shortcut Information ?
  675. Page Setup, Scaling
  676. gathering information from web pages and trasporting to excel
  677. Copy an Excel sheet using VBA
  678. Hiding rows that are included in a named range
  679. Finding Links
  680. How do i reuse a Excel macro on another worksheets, global macro?
  681. How do I setup a spreadsheet to scroll past what is on the screen
  682. eliminate blanks from listbox rowsource
  683. Saving Macro
  684. Combining lines from individual sheets into one summary sheet
  685. Consolidating Lists on Information
  686. Columns by numbers
  687. How to Read File Properties Programmatically
  688. VBA validation & error reporting
  689. Open Word Document and Accept Track Changes - Partial Solution
  690. InputBox with multiple answers
  691. array copy
  692. indicating sheet
  693. running program from userform
  694. updating hyperlink
  695. Verify Input
  696. DATA VALIDATION WITH AUTODATE
  697. Todays date plus 3 months & less 3 months
  698. Help with my VBA Vloopup
  699. change properties on
  700. How to show cell results of formula to mix of currency/number formats?
  701. Drop down missing in cells with validations!
  702. Checking if something is past due
  703. Input box with multiple choices
  704. How to work with NodeList
  705. Change ODBC
  706. active sheet
  707. Formula Errors
  708. how do I write an IF/other statement to capture certain time data?
  709. Macro to merge worksheets
  710. Visible automated Excel: automation crashes if user selects cells, protection?
  711. Running Macro "Logged Off" & Copy/Paste from WORD .rtf into EXCEL .xls
  712. Macro to delete only certain rows
  713. Copy Comments to a cell
  714. Date
  715. Select corresponding row on another worksheet
  716. Automatically installing and running the Analysis ToolPak add-in
  717. Conditional formatting based on formatting
  718. How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
  719. Modifying built in document properties using an excel macro
  720. Complicated Macro - Someone please help.....this will definetly be a challenge!!
  721. Check the value of Password
  722. opening hyperlink with other program not explorer
  723. mail a single excel sheet
  724. Excel remains running due to held references
  725. How to loop (or list) all the criteria in autofilter
  726. Pasteing a list without duplicates
  727. Excel 2002 autoRecover settings
  728. Restricting Pivot Tables
  729. Reading a Cell Value in C++ (with Autowrap)
  730. Need help with setting variables
  731. Running a macro when there is a given cell entry
  732. Call by value(and not be reference)!
  733. Issues with wrapping Excel text macro
  734. check status bar condition
  735. Range Offset
  736. Input filename at start of macro
  737. More than 3 cell highlite colors ?
  738. PASSING PARAMETER FORM DOS script to Excel
  739. .BackColor of CheckBox only extends as far as the text in the caption
  740. how to setup GETFORMULA() in EXCEL 2003?
  741. MATCH does not work on a UDF-generated array
  742. Cell Highlight
  743. Creating Macro Buttons (Any Good Websites)
  744. Deleting worksheet specific range names
  745. Creating a Complex What if in Excel: Beyond Nested Conditionals
  746. Cell Highlighting
  747. extracting numbers from alphanumeric strings
  748. Unable to run VB Editor within Excel
  749. RegExp to Parase File paths
  750. VBA continue