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. Copy If
  2. Adjusting the range of a script
  3. Simple Macro
  4. Sub Menus disabled
  5. ComboBox_Change Event to Populate another Combox
  6. Permanently Disable Auto Formatting of Cell Content
  7. Getting an error using
  8. Pulling String
  9. Custom Toolbar showing in any and all workbooks opened
  10. How to assign a Category to a custom function?
  11. Looping through a Range and copying to Another Sheet
  12. question on using average function in macro
  13. copy data as string and paste into web form
  14. Step-through works, Run does not?
  15. Formatting Cells
  16. Macro to change file name in Vlookup formula
  17. Revision Number for an Add-In
  18. Unprotecting Workbook
  19. How to add text to this formula?
  20. Excel - Slight edit of the macro below should do the trick! Add filename to cell A1 upon merge.
  21. Fetch Access data from Excel
  22. Automatically close a message box
  23. Linking/embedding worksheets
  24. What cell caused the worksheet change event
  25. how to convert text obtained from formula to numbers
  26. Excel VBA - checking a date field for null
  27. Change ODBC
  28. Passing a Control as an Argument
  29. checking value of named range
  30. shared workbook
  31. Add Fill Color to Row
  32. Help with filter code.
  33. Copy Data from Multiple Closed Workbooks to Open Workbook
  34. Object for visualizing processes and plants
  35. Excel to Open Lotus Notes
  36. Fast blinking cell
  37. Return matching names per criteria in table
  38. How to Create a macro from drop down list (Validation List) in excel
  39. Enum Names
  40. Search for text easy macro
  41. Seeking help with MACRO or VBA??? Open all files of type in directory and parse
  42. Count occurences and rows they are on
  43. Add sheet to workbook
  44. Open but not activate
  45. unable to open excel 2007 and interact with it using vc++ code
  46. how to open excel 2007 and interact with it using vc++ code
  47. Excel -> Access Table
  48. String to name
  49. help with loop in autofilter
  50. Print Variables ?
  51. I need some help creating a graph with multiple ranges
  52. Create New Sheet from template sheet
  53. How do I set Printer Paper Source using Visual Basic?
  54. Module still there even after remove and save
  55. Specifying work-path
  56. get data and field name using querytables
  57. Text to rows...at wits end
  58. Changing cell value in a range terminates code execution
  59. toolbar or icon in a add-ins
  60. Could not set the ControlSource property. Invalid property value error
  61. Check if any value in a range is equal to 0
  62. VBA / Changing the colour of cell given an input
  63. Loop w/ Public Function as arguement
  64. Array, Range, Lookup - I'm not sure!
  65. Cell Selected to run Macro
  66. msgbox - How to Create a New Line or 2
  67. Time limit restriction.
  68. hide rows
  69. Macro Issue
  70. left or right
  71. Disabling the Red X in Excel
  72. How stable is Excel using timed loops
  73. XML copy from table to table
  74. Automatically executing a macro when A pick list item is selected
  75. Excel Tabs to indvidual PDF Files
  76. Cell Value (Date) + number of days in VB
  77. Please ammend or adivise re this easy print rountine
  78. fonts for if...then statements
  79. Searching for blank cell and populating based on previous data
  80. How to id if range is correct?
  81. Why is this an error?
  82. Security within menus????
  83. Macro to run in Specified Sheet and Column
  84. Simple if statement?
  85. Saving as Sheet as a Tab Delimited Text file
  86. Substitute copy for cut
  87. How to paste non-adiacent cells values inside an email?
  88. sum is represented by a picture?
  89. Bizarre mutation of data upon assignment to cell !!??!!
  90. help
  91. End of Sheet
  92. Adding custom menus to Excel ????
  93. 2 problems to solve
  94. Better way to fill a ComboBox ?
  95. Inserting VBA Code Programmatically
  96. Floating commandbar problem -- toolbars destroyed only if sheet first upon opening ... ?
  97. Formula that takes a cell value over another?
  98. Validate Cell Content AfterUpdate
  99. programatically reference controls on spreadsheet
  100. How to create hyperlinks in an Excel Form
  101. Making a matching worksheet allowing drag and drop of protected cells...
  102. Cutting and pasting large variable text into a text box shape usin
  103. Closing a workbook after it has opened another
  104. same row different column
  105. Excel Question Prevention
  106. Web update onchnage macro
  107. Easy question on formatting
  108. Count number of Rows with Value
  109. Delete rows that are visible after applying filter
  110. Compile error in hidden module: This workbook
  111. VBA: List of blank and non-blank cells
  112. spreadsheets should be available to handle groundwater problems
  113. VBA Programming.
  114. Summary sheet for multiple worksheets
  115. Excell cell formatting
  116. conditional displaying of data
  117. step up loan amortization - by annual increase %
  118. Draw words from a list without duplicates
  119. Protecting a Microsoft Query
  120. seggregating email addresses
  121. IWshRuntimeLibrary.WshShell.SpecialFolders requires a variant argument
  122. Listview - SetFocus and Me.Repaint
  123. searching for a specific part of a formula
  124. pareto diagram
  125. Conditional Formatting (two sheets three cells)
  126. Script is bogging down and will not end
  127. Getting to SQL Server without ODBC from VBA
  128. Paste to the right
  129. Creating an Index Sheet that obtains a cell Value using VBA
  130. replacing , with nothing ?
  131. If..statement
  132. Removing extra row from range
  133. entering date, formula for continuing date to contract terms
  134. Script is bogging down and will not end
  135. How to create Singleton Pattern in VBA?
  136. Update links
  137. Excel Chart after paste to MS Word 2000 (URGENT)
  138. Column shading color based on specific cell content
  139. Can I force an entry?
  140. Help with CMS Script(ver 13) using VBA
  141. VBA command has stopped functioning
  142. Use of UPPER()
  143. Offset Question
  144. Link cell
  145. embed cell references in macros
  146. Delete all charts on single Worksheet
  147. error - KB article 320369
  148. Help with an formula
  149. Sheet selection help
  150. Updating Access table with a range from Excel,
  151. Pivot table in Xml Spreadsheet
  152. Copy/Export/Transfer charts from Excel to power point with VBA cod
  153. Remove Modules not working
  154. Customizing userforms on button clicks
  155. Error in PasteSpecial ?
  156. Can .xls make itself ReadOnly?
  157. WorksheetFunction.Trend doesn't work?
  158. Macro - settings to protect sheets
  159. Range without Blank values
  160. trouble with macro
  161. calculation
  162. Move Specific Text to new worksheet
  163. recovery loss data
  164. Force TextBox to hold time ("hh:mm")
  165. Range going up the column instead of down
  166. determine if wrap text is set within a range
  167. Email a text file from within a userform
  168. Macro list in Tools - Macro
  169. copy one array formula to an array range
  170. Array
  171. How to know if 2 sheets are identicals
  172. Call Worksheet_Change macro in another worksheet
  173. Closing internet explorer in an excel macro
  174. Where can I download Help on Excel objects.?
  175. Syntax for changing font color in a Shapes object
  176. Writing the result of arithmetic calculation in a cell
  177. Menus in an xla
  178. Telnet from Excel 2000
  179. Opening MS Word template using VBA in excel
  180. Problem with progressive filling of cells?
  181. Struggling with this...
  182. determine if there are hidden rows in a column
  183. Update from web
  184. SCREEN UPDATE!
  185. Results no longer currency when adding text to formula / formulas based on resulting cell don't work.
  186. vba to set calendar object auto load to TRUE
  187. verify a shape exists in the sheet
  188. determine if first word of cell is capitalized
  189. Help, Tom Oglivy
  190. Email hyperlink
  191. Bracket Sheet
  192. calendar question
  193. XLL and function tips
  194. Range offset
  195. textbox codes
  196. Using Like
  197. Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files
  198. exporting multiple ranges to a gif gile
  199. Taskpane turns disappears.
  200. E-mail to a list in worksheet
  201. textbox show correct time in userform
  202. Macro Security Warning
  203. Macro to replace file name many times
  204. Find number of employee's working a Shift
  205. Need help for Date & Time adjacent formula
  206. search, compare, execute based on specified criteria
  207. ListView - Data from the first column can be modify?
  208. Character count
  209. ListView and checkbox (Refresh problem)
  210. Run-time error, why?
  211. Changing function key definition to insert time
  212. Coding a SumProduct formula
  213. How do I display the link location of a hyperlink?
  214. Daylight Savings Time Fuction
  215. Macro's only partly activated?
  216. Formula for cells
  217. Program to insert rows
  218. Limitations of auto-open (xlstart) macro
  219. query question
  220. Macro to run macros
  221. setting up time sheets in excel with total hours
  222. time sheets using hours and totals
  223. Invalid index in foreach(HPageBreak hpb in sheet.HPageBreaks)
  224. preserving variable from userform
  225. Web query parameter
  226. Re: Help on VBA Arrays
  227. find cells based on its content's format
  228. A challenge: referencing cell contents in a nested function formu
  229. printing questions
  230. Calendar control
  231. Filtered list code (changing criteria)
  232. remove formula macro
  233. determine if autofilter is on
  234. Covariance in Excel in biased
  235. ReDim an array of variant - Help
  236. automation
  237. Find
  238. Excel Web Query
  239. Dates In VBA
  240. Offset Copy help
  241. extracting contents to another cell based on specified criteria
  242. ALL;TOTAL reference help
  243. How to assign a collection item?
  244. detect ctrl-c was pressed (in copy mode) from vba?
  245. Excel instance won't unload from memory
  246. Fiscal Calendar Date Function
  247. Determine if Excel is running in a browser window
  248. Date format change
  249. Lookup from External Reference File
  250. Loop until
  251. get range coordinates
  252. replacing built in keyboard shortcuts with my macros?
  253. VBA Script to use any open file when copying and pasting
  254. Display check mark value
  255. Remove data from a cell
  256. VBA: format, Format or FORMAT
  257. Range Formula question
  258. Using the file search object
  259. VBA copy paste sort refresh
  260. set control toolbox- optionbuttons
  261. copying variable range not working
  262. Run-Time Error '380'
  263. specify a specific column to input text based on another cell's content
  264. testing for characters
  265. creating matching lists between sheets for comparison
  266. When importing query from code - password required but not directl
  267. Don't let user close. Use macro button to close?
  268. Microsoft Query
  269. vLOOK UP INTO vba
  270. test do not read
  271. HELP!!
  272. Deleting Rows Problem
  273. help with find value select range and paste to diff sheet, multipl
  274. .xls to array in c++
  275. converting data from table to individual sheets
  276. Line Position Drawing Object
  277. SQL
  278. Macro help
  279. Macro help
  280. comboboxes
  281. menu
  282. Replace characters with symbols
  283. File explorer
  284. Delete entire row based on cell color
  285. VBA: sheet in background
  286. time
  287. help with code please
  288. User Form: Combo Box - filter out repeats.
  289. How to mark an item selected in the Excel VBA Form?
  290. Sum orders in a month from a table
  291. Conditional Formatting Help
  292. Control not showing normal user
  293. Check value in Array
  294. Excel2000: Opening *.csv through VBA and International Settings
  295. simulate mouse movement
  296. Copy Charts from Excel worksheet to PowerPoint
  297. Week vs. Week VBA Function
  298. Stop vbTimer
  299. How can I disable linking?
  300. Incorrect Date Returned
  301. How can we change linked numbers to words in Excel?
  302. Loop through values in a combobox
  303. Most efficent code to copy a row on one sheet to a row on another
  304. How to Reference a .Net Assembly from within VBA?
  305. How to get the current cell position in VBA (eq. Row(), col() in F
  306. Create, delete and re-use a range name
  307. Macro warning but no macros
  308. macro to find extract and paste contents from one cell to another
  309. Using ActiveWorkBook.RoutingSlip
  310. Copying Range Based On Certain Criteria? Possible looping through the Range
  311. reset cell.Hyperlinks.Count to 0
  312. delete two columns at a time
  313. VBA date difference
  314. Search for the YTD Actual column, copy and unlink
  315. How do I capture CANCEL on an Inputbox?
  316. How do I capture CANCEL on an Inputbox?
  317. Saving Workbook
  318. Saving a worksheet with a condition
  319. Searching in Excel
  320. Application Defined Error setting a formula via VBA
  321. Excel dropping decimal places
  322. Access Functions & Subprocedures in an Add-In
  323. Merging Tables
  324. throw string
  325. Outlook Express - Importing emails into Excel via VBA
  326. Protect Macros From inadvertent Use
  327. Problem w/code to copy worksheet to new workbook
  328. Using Macro to hide rows that have a "0" quantity value
  329. Copy Paste Special Transpose Skip Cells and start over
  330. Caption on UserForm only setting in Subclass
  331. Naming A Worksheet
  332. Range names in macros - DA
  333. Copy works using A1:L1 Format but Not Cells(..) Format
  334. Passing Arrays to SUBs
  335. How can I Center a Dialog Box each time a user opens it?
  336. Naming Ranges
  337. Excel equivalent of Lotus {?}
  338. Open a file on startup
  339. close UserForm
  340. Cell Formatting
  341. Progress bar freeze while running code
  342. Invoke Outlook Contacts From Within Excel
  343. Send email notice when date reached in an excel spreadsheet
  344. Copying strings and using counters
  345. Answering Message boxes
  346. Auto Archive old file to a folder
  347. refedit won't work
  348. Looping over a worksheet
  349. paste cells with reference
  350. Updating subtotals
  351. copy formulas from horizontal cells into vertical cells.
  352. building a macro that saves a file and converts to pdf
  353. Exit without saving in a macro
  354. Batch Processing macro for excel
  355. Cell Formulas
  356. 'Type mismatch' error!
  357. How to goto the next available cell in a column.
  358. ADODB.Connections Error
  359. copy paste loop---new to vba
  360. User Form Help
  361. Text Box
  362. need to create shortcut button in Excel spreadsheet
  363. What's this new sheet?
  364. Microsoft Excel for Windows has encountered a problem....
  365. Running SAME Excel macro with VBScript
  366. Macro to Open Word from Excel
  367. savecopyas saves as file type
  368. counting pivot table subfields
  369. drop down list macro help
  370. User Forms
  371. Set focus on Subject line in Outlook
  372. Activate a Worksheet
  373. Excel
  374. ListBox edit
  375. Check Format
  376. what alternatives do I have to msgbox??
  377. Opening pdf's while embedded into an excel document as a package
  378. How do I write a Macro that
  379. Showing the Address Book window
  380. Formula req
  381. Replace character in string, not document
  382. delete rows when value is within an interval in col 3
  383. Position of the mouse pointer
  384. Date into filename noe I need time also
  385. Can Visual Basic update a Shared workook rather than autoupdate?
  386. Group and Delete
  387. Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet
  388. Calendar control not showing properly???
  389. Copy to bottom of sheet quickly
  390. Visual Basic for Excel
  391. copy down without changing cell numbers to bottom of worksheet
  392. RE: BackgroundWorker in Excel 2007 Managed Add-In
  393. programatically drawing flowchart in excel
  394. Re: Runtime 91 error due to cells.find statement !??!
  395. Changing cell colours based on a cell value
  396. VBA code to search for a text from a userform
  397. Searching text
  398. How can I create a button, that is linked to a macro (start)?
  399. associate cell format
  400. Dice
  401. Find MatchCase problem
  402. Extracting row data from a range
  403. Format Painter Keyboard Shortcut
  404. Automate replication of Charts
  405. Run-time error '1004': Select method of Range class failed
  406. Hiding Columns based on value from another worksheet
  407. Excel File Slowing Down after Macros Added
  408. ListView information
  409. VBA Updates Cell but not the cells that reference it with formulas
  410. Re: Range Object error
  411. Creating a report to send extracted data to
  412. Determine the last non-blank cell in a range
  413. Hiding a sheet
  414. VBA Code - Pasting Pictures from Excel into Word
  415. Excel Macro for creating bar chart
  416. Activate Macro Button Located In Another File
  417. SaveAs closing file without firing event WorkBook_beforeclose
  418. Push Button in Outlook to Change Focus to Outlook Contact List
  419. Re: Range Object error
  420. Getting a clean part number
  421. Error With ADO (Starting to pull my hair out)
  422. Web Query Macro - Mixed content prompt prevents script from loadin
  423. More efficient memory deallocation
  424. Quotation marks and variables within code
  425. Re: Data Lookup Help
  426. Workbook takes a long time to open (calculating), why?
  427. code gone wrong when trying to make an automated form
  428. VBA Code help
  429. parameter and macro driven pivot table filter?
  430. Searching for Saved Files
  431. Suppressing Update Links Warning
  432. Testing if a workbook on the network is open
  433. Excel.ActiveWindow Is Excel.ActiveWindow Returns False
  434. refedit control not seen?
  435. DirectX use in Excel
  436. Variable Printing Procedure
  437. How to create copy & paste loop--rows to new sheets
  438. toolbar macro buttons
  439. Export many sheets to one text file
  440. How to know if a variable has been reset inside other function
  441. Filling a listbox
  442. Find Maximum value in a range via macro
  443. Command Buttons
  444. Date formula in file name
  445. Finding Certain Data in a Worksheet
  446. Filename Problem
  447. System.AccessViolationException on VS2005 and Microsoft.Office.Int
  448. Cannot sort Tables in C#
  449. CallByName in Excel for Fill object
  450. capitalizing first letter of a word in columns
  451. Open the OpenFiles window
  452. Conditional formatting or worksheet change event?
  453. Need some VB script, please
  454. if Stucture help
  455. Trim for Hard Returns
  456. Workbook_BeforeSave - driving me crazy!
  457. Re: distributing each characters on a cell
  458. Get the name of worksheet behind active worksheet
  459. Copy rows based on a word being found in a cell
  460. Mailing to a distribution group in Excel
  461. Find Hidden rows and delete
  462. Multiple font sizes in a single cell
  463. Changing the value of chart labels
  464. Listbox header inside VBA (Array("Head1", "Head2", ...)
  465. vba. help. reference formula
  466. storing input
  467. Strange glitch
  468. Put Password Protection in Code
  469. Re: distributing each characters on a cell
  470. How do I change a merged Cells background color
  471. Problems with userform, refercencing code to worksheet
  472. User Form
  473. Change a cell value when another cell changes
  474. Similar to SPLIT
  475. Handling Excel Evens in addins
  476. Overimte Problems
  477. Re: Programmatically getting a Max value from a PivotTable
  478. Using ADO to read from ActiveWorkbook
  479. list comparing - vague data
  480. Re: Loading userform problem
  481. Search for data and bring it up in another worksheet
  482. SUMPRODUCT Problem
  483. How to make Join in VisualBasic
  484. Re: With statements
  485. Re: Range Object error
  486. Re: If Cell Contents =today() then....
  487. Re: creating a new worksheet from a template using VBA
  488. Re: Data Lookup Help
  489. RE: Closing word from excel
  490. Bring Queries from Access into Excel
  491. Updating Linked Cells using Auto_Activate Macro
  492. User Forms Multipage Background/Foreground Colors
  493. Run Time Error 1004
  494. Importing VB code and having it password protected
  495. How do i Link SQL data with a Excel Cell.
  496. Number of hours between 2 dates
  497. Controlling Listbox Scroll Bars
  498. SUMPRODUCT in VBA
  499. auto fill-in formula
  500. Find date in column then delete row???
  501. Does AxisTitle Interface totally keep compatibility in Office 2007 beta2?
  502. Simple oversight on my part in this code I'm sure
  503. VB Script to insert row and calculate a range
  504. Compile Error (ADO) Ron De Bruin
  505. Automatically copy macro to multiple workbooks?
  506. Create worksheets and populate
  507. Real Meaning of Apostrophe?
  508. customized toolbar buttons macros to a group of users
  509. Range (variable)
  510. Check if number in Excel
  511. To refedit, or not to refedit, that is the question.
  512. Limit on array when using seriescollection.XValues and .Values met
  513. Read Only Issue
  514. SendMail disable question?
  515. Creating right-click menus
  516. Printing a sheet
  517. Checking HasPassword property without opening
  518. dynamically select sheet
  519. simplify formula
  520. Replace Error with Empty Cell
  521. 1004-Applcation-defined or object-defined error
  522. Filename Problems
  523. chek mark in menu item
  524. iam new to programming in excel i require help
  525. Run-Time-Error : -2147417847 (80010108)
  526. Finding a list of tables in Access from VBA in Excel
  527. Transfer data from worksheet to array
  528. Filling menu items
  529. NEW: Macro KB shortcut doesn't work (otherwise Ok)
  530. How do you dynamically load an array?
  531. How to pass file references to a sub in VBA
  532. search or vlookup help
  533. Comment Location
  534. Autosizing a Cell
  535. Change color of moved cell text
  536. Automatically hide rows
  537. Nested Ranges?
  538. Workbook Open?
  539. Settings
  540. Help with populating new combobox with list of ranges
  541. Problem opening Excel 2007 file from OleDbConnection
  542. how to refresh a query table every "x" amount of minutes
  543. Moving Data from Rows to Columns
  544. Mouse Scrolling not working
  545. repeat procedure with new range
  546. Simpl Q about the Workbook Object
  547. HELP Formula
  548. Automation Error: Object Disconnected From Clients
  549. Formula HELP !!
  550. File changing after saving - excel VBA problem
  551. Unhide row based on cell value
  552. Macro not saving properly? Can't see problem
  553. How to make userform work publically with hidden sheets?
  554. vba to click a command button
  555. Excel 2002 - Bloomberg
  556. subtotal/grouping problem
  557. comparing two excel files
  558. Help with Sum formula
  559. Worksheet Code Name question
  560. procedure call error issue
  561. Excel VBA & Arrays
  562. problem :Onclick event occurs after a Setfocus
  563. Connect an image to a cell and row
  564. Defining Loop Ranges
  565. Send named Workbook to Outlook
  566. Need to turn this in to VBA
  567. Have current date display in File Name
  568. Populating Document property values using macro
  569. Need help with MultiSelect List Box
  570. More than one Target.Addresses
  571. Convert UK DateFormat to US
  572. Answering pop-up question
  573. Open Workbook
  574. Maintaining Formatting in a UserForm
  575. pivot table error 1004
  576. need to find highest total
  577. data set for linear regression
  578. Cell changes highlighting
  579. Option Buttons -ActiveX
  580. Hiding/Unhiding protected columns
  581. How to change color in a funtion
  582. Run-Time Error 91 for Internet Explorer .elements(name).value
  583. Check for open workbooks
  584. reset control toolbox optionbuttons
  585. look up
  586. Searching for Alphabetical Characters
  587. Parameters and DateTime
  588. how can i get VBA to give rows numbers
  589. fill a listbox with data
  590. Leading zero in hyperlink TextToDisplay
  591. Refresh a pivot table then apply a macro
  592. Running program
  593. How to start a macro with a if statement
  594. Excel / Formatting a Cell / Setting a string range
  595. Help!!!. I am trying to calculate hourly pay mixing hours and dollars
  596. OLE and excel on Windows 2003 server
  597. CountU from an array - SUMPRODUCT, SUM(IF(...)), both?
  598. controltip carriage return
  599. Disable Auto Date Formatting for QueryTables.Add
  600. Extract a percentage from a text
  601. Listbox Looping
  602. Button supposed to be transparent but is not when clicked.
  603. How to export Excel data to Outlook tasks?
  604. Launch Excel from the Web
  605. Dynamic Pivot table range
  606. Number Grouping Formula or Macro
  607. Formula text and decimal place
  608. Tri state macro
  609. Copying Formula into a Dynamic Range
  610. Could This Be Done With VBA?
  611. Count and get position of spaces within a string
  612. Having Trouble deleting a missing reference
  613. ActiveCell.FormulaR1C1 question
  614. Assign Macro to Checkbox
  615. Column Headings in Pivot Tables
  616. First time a WinUser uses Spotlight
  617. Temporary Footer?
  618. Changing the print_area
  619. Conditional Formatting Cells
  620. Macro Question
  621. hotkey in usrform
  622. Select a cell
  623. COMPARE COLUMNS
  624. convert a Word macro to an Excel macro
  625. Need to add a copied line to 1st blank row via a macro
  626. Error Saving File With Password To Modify
  627. Caution Signal
  628. what is enableselection proprty does?
  629. sorting/no duplicate scripting dictionary in Excel VBA
  630. Excel and MS Query question
  631. difficulty opening userform
  632. Turn off R1C1 reference style via VBA
  633. What's the best way of writting a text file through VBA?
  634. Auto Open file to run Mail macro
  635. hide , unhide colums
  636. Basic If Statement
  637. Force recalcualte on cell format change
  638. Help on Formula for a cell
  639. Change formulas into values based on cell color
  640. Inter data into a cell
  641. How do I make a worksheet name equal to a cell
  642. IF (xORy) AND (xORy)...?
  643. suming instances in pivot table
  644. Excel combo box error message "not enough system resoureces to....
  645. Subscript Out of Range Error
  646. Lowest repeatable number in a range
  647. Formula Bar Shortcut Meny Insert
  648. Combining 3 workbooks to one
  649. Need help on Address
  650. Protect Checkboxes
  651. In Excel, how do I make a lookup table that returns a function?
  652. how do i convert selection.end(xldown) to use in Progress
  653. Macro problem when sheet protected
  654. Deleting a Row or Rows
  655. Updating Pivot Tables
  656. FoundFiles
  657. Error Reporting questions
  658. System error &H80004002
  659. Launch a .bat file with VBA
  660. Summarising entries on a Spreadsheet
  661. Conflict with 2003 Office
  662. Open an Excel document in 2007 document using the 2003 office
  663. exit sub
  664. select range for pivot table command
  665. URGENT HELP ON BLINKING/FLASHING CELL
  666. Subtotals
  667. flashing cell in excel
  668. SpecialCells(xlLastCell) selects old data
  669. Set an object variable to the vb editor itself
  670. Resize a range
  671. Tools menu
  672. What is better: Application.FileSearch or Dir ??
  673. Pivot Cells Values
  674. NULL into table
  675. Userforms
  676. Is it possible to recalculate a single workbook?
  677. Desperately Seeking FirstCell Find !
  678. Workbook with UDF needs "recompile" after opening with other Excel version
  679. protecting sheet tabs
  680. Stock control formulas, counting and reporting remaining stock
  681. How to scan directory , list all the file
  682. Formula in Excel for stock control records
  683. VB To Re-Name Worksheet Name
  684. Finding the last cell in a protected sheet
  685. Total Time Problem
  686. How to embed ^{1,2,3} in TREND Function in VBA
  687. Creating NamedRanges with VBA
  688. Assign shortcut to button on userform
  689. Formula for excel worksheet
  690. Problem copying to another sheet with specific criteria
  691. Excel: A document with the name is already open
  692. Open an excel attached to an email
  693. Launch Excel from the Web
  694. Autogenerating a number (Estimate Ledger)
  695. Excel 2000 VBA Reference
  696. Creating a Template for mixed Data
  697. Sort reference is not valid
  698. always the specific control has focus when F3 or Ctrl+q is pressed
  699. scheduling a server-based app
  700. Text to Speech
  701. Text to Speech
  702. Close Workbook If user disables macro's
  703. deploying Custom.xls
  704. working hotkey even if any control has focus in userform
  705. Importing Specific Rows from a text file into Excel
  706. Cannot select single column to the left of freeze
  707. Populate an array using a formula
  708. VBA programing
  709. Initializing UserForm
  710. Web Excel Workbooks versus Excel Workbooks
  711. How Do I Use List Box for VBA Script that Converts Excel Files to Any FIle Type?
  712. Newbie -& I am not getting this
  713. text box validation
  714. vba output: formulas or values
  715. Macro to keep 15 specific records and delete 1000 other rows.
  716. Folder shortcut
  717. Locating the third item in a Range
  718. Cell protection problem
  719. Appending cboBox values into cells
  720. How do I work on data starting to a cell a cell with a required va
  721. RE: Converting numbers stored as text into number-format
  722. How to add items to Multi-Column ListBox dynamically
  723. fill color to a cell when the value is negative or positi
  724. Novell server full path names of VBA references
  725. How are actual file location of VBA References treated?
  726. Print Preview Macro
  727. Modal/Modeless Forms
  728. Paste cells from one workbook to another
  729. LOOKUP BETWEEN 2 DATES
  730. template questions
  731. ask about excel formula.
  732. bold or fonts in a textbox control
  733. FileDialog grey's out the View box
  734. Regressive Logarithmic Retail Markup
  735. RE: Converting text to numbers
  736. custom formats for plus or minus
  737. Reason for increased size of workbook
  738. eliminating text between two specific characters
  739. Alow certain Date Range
  740. a better way
  741. IF statement to evaluate time data
  742. autofilter help
  743. Counting Loops
  744. Application.Run for every open workbooks (one by one)
  745. complicated copy/paste/delete
  746. Excel and MS Query
  747. Calling a macro
  748. setting a condition to call a macro
  749. GO FOR A REAL BACK-UP OF EXCEL FILES
  750. Hiding changing columns