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. Subscript error in 2007 when testing if Addin is installed
  2. Macro help
  3. simple cell formating question.
  4. Delete selected Item from listbox
  5. Help Please
  6. Autofilter
  7. Counters
  8. why can a pc open file but not mac
  9. Validating Data in User Forms
  10. Disabling Autocalculation when opening CSV files
  11. Help Wanted
  12. Find data and copy and paste
  13. Refresh background query in Excel 2007
  14. Can I automate the launch of a macro using the result of a formula
  15. Problem using VBA for Excel to protect a Workbook with a password.
  16. Using VLOOKUP and HLOOKUPS with named ranges
  17. Geting around XIRR error
  18. Macro to close without saving
  19. Problem with Workbook_Activate event
  20. HOw to create the progress bar in excel through vba.
  21. Removing confirmation POP from excel
  22. RE: Removing confirmation POP from excel
  23. Macro to break one row of data into multiple rows, with calcuation
  24. RE: Removing confirmation POP from excel
  25. RE: Removing confirmation POP from excel
  26. C#: Adding OLEObject--how to set object properties?
  27. EXCEL VBA
  28. Text and formula in a same cell (Excel)
  29. Load UserForm ComboBox And Autofill 124 TextBoxes
  30. Iserror with Search
  31. Excel process slows down
  32. Buttons and macros
  33. Design question
  34. Need help with a date
  35. Excel VBA advanced course, London
  36. Retreiving only numeric values from a string
  37. Is it possible to make a workbook "undeletable"?
  38. Compiling Spreadsheet Into Application
  39. listbox
  40. What Range was Missing
  41. Excel automation in ASP.NET, error 0x800A9C68
  42. Command Button
  43. Excel Macros Tie Up Computer
  44. Send e-mail option- delivery to route to group mailbox
  45. I need a macro to run on a set condition
  46. Blank cell with Formulas
  47. Loop through charts
  48. Need help with Calculations
  49. Auto increment a cell
  50. Add text based on imput in another cell
  51. Send mail with outlook message options-Delivery OptionS
  52. Problem using multiple criteria to get a count
  53. Latest Office Automation Techniques
  54. Improve method of calling a private function in a private module
  55. Visual Basic Copy Clipboard Paste as KeyStokes
  56. BeforeClose order of events?
  57. Compare Rows
  58. Running Macros in a Shared File
  59. formula for last cell
  60. Group worksheets
  61. method or data member not found
  62. excel macro and java applet
  63. help with macro
  64. Use VBA to copy macros from one workbook to another
  65. converting date combobox to show date
  66. If extension of a path in a cell is .pdf then
  67. RTD methods in excel called before workbook_open event
  68. I'm having a problem with excel formaula... need help?
  69. Problem comparing dates
  70. List Box Populating problem
  71. get access data using ADO from an password protected mdb
  72. Log web data
  73. Chdir does not seem to change the current directory -- ??
  74. Tracking 'last written to' range
  75. Lost in the shuffle: where is my old NG page?
  76. drop down menus
  77. Convert VBA to well written Excel formula or similar?
  78. How do I know if user is pressing a key from the CommandBarButton class
  79. Excel Range calculation breaking application.calculate - horrifyingproblem
  80. distribution of work
  81. Mismatch Error
  82. AutoFill to start with Selected Cell
  83. Open or switch to a file
  84. Last modified user
  85. VBA Currency datatype and NumberFormat
  86. Related to Excel-2007 MACRO
  87. Update Pivot page field from a cell entry
  88. Re: excel VBA text
  89. Can I refresh more than 1 external (web) query data at once?
  90. excel names in a group
  91. Get Names of ActiveWorkbook.CustomViews
  92. How to export a linked cell sheet to get only values.
  93. Excel XP VBA Called Dll , throw Run-time error '-21462
  94. RE: COMException 0x800A03EC Whn Calling CheckOut
  95. COMException 0x800A03EC Whn Calling CheckOut
  96. clear user form after entry
  97. Golf for a league (teams of 4)--Help
  98. Delete chart without being prompted?
  99. Command Button to Swap Cells
  100. relatuve reference
  101. Excel and Shift-JIS
  102. what is the not equal symbol?
  103. Re: Excel VBA drawing Arcs programmatically - not lining up!
  104. Creating gallery in dynamic menu
  105. Create a subfolder in Outlook contacts called delintel
  106. Macro Help for Filtering
  107. set of dependent list boxes
  108. set of dependent list boxes
  109. Confused about the ListBoxes.
  110. Ribbon displays labels even when showLabel is set to False
  111. Time sensitive please help..
  112. Error in Personal.xls - calendar
  113. Delete every other row in a 2007 spreadsheet
  114. RTD update problem with Excel 2007 when Excel is not the active ap
  115. Moving sheets in code
  116. Format font base on DirectDependent address
  117. VB Code
  118. .SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  119. How to Reference a Cell
  120. If File exists Then NewFile="XYZ"
  121. Send mail with outlook message options-voting importance
  122. Matrix Creation
  123. Font format according con cell content data type
  124. RE: Excel VBA drawing Arcs programmatically - not lining up!
  125. Excel 2000 vs 2003 date format issue (reposted)
  126. AutoFilter Selection to Change Page Header
  127. Adding to Excel menus
  128. MAJOR PROBLEM! --- Menu Bars don't unhide?
  129. Text insensitive formula
  130. MACRO HELP NEEDED
  131. method or data member not found
  132. Matrix Import Help
  133. vb for nested if with more than 7 statements
  134. Macro Needed to pull specific columns from worksheet
  135. Copy Sheet
  136. How to set a textbox to be a print object
  137. I need Help with VBA link between Poject & Excel
  138. Specific Mile Calculation
  139. Indent and format based on Col A
  140. Deleting non-alphanumeric characters
  141. change in the formatting of data series
  142. changing font size of chart title
  143. email macro using sendto
  144. Unexpected formula generation using named ranges
  145. Loop through folders
  146. Asterisk in VLOOKUP search
  147. Miles Calculation?
  148. Set statement for non active worksheet
  149. Replace in ranges does not work.
  150. Named Ranges Disappear In Excel 2007
  151. Sharing information between classes
  152. looping problem
  153. Inconsistent behavior of listboxes
  154. Needing help with code in a macro
  155. Excel crashes while adding calander control on form
  156. Resizing Image in Excel, Saving to Sharepoint. Size changes
  157. Loop code, capture exceptions, and display pop-up
  158. Type Mismatch Error
  159. Select Cells in a specific Row
  160. loop on pivot items
  161. SUM a row of data and then use VLOOKUP to paste the total value intoanother worksheet
  162. Re: name prefix for DA
  163. Excel2000 worksheet Change event doesn't work in Excel2003 or higher
  164. Font.Bold Property slows down macro
  165. Changing values in column 1 and 2 based on values in col 3 & 7
  166. Error handling part way though code
  167. compare and paste macro
  168. Re: PrintPreview in I.E. ???
  169. Re: name prefix for DA
  170. Re: name prefix for DA
  171. open new workbook
  172. Help! I need a macro to check dates and autopopulate cells
  173. Syntax error
  174. method or data member not found
  175. Mouse Over PopUp display Lookup Result
  176. SumIf Calculation in Code Problem
  177. Excel 2007 Compatibility mode error "Not enough storage to process
  178. password in a cell
  179. Open a file in 2003
  180. Can't get pop-up calendar date passed into worksheet
  181. What is VBA's procedure calling syntax matrix?
  182. Deleting a command button...
  183. Can I simplify my Modules
  184. EXCEL Questions and Answers
  185. Registry changes
  186. IF function with AND, having problems.
  187. Registry changes
  188. Web query problems
  189. Where am I ?
  190. Save as Shift-JIS?
  191. Listbox autosize?
  192. Sorting question
  193. User form issues
  194. run once function
  195. Unshare and Reshare a workbook
  196. button to seach columns for blank cells, then sort by two columns
  197. Alter ribbon button label on the fly?
  198. vb code question
  199. Inserting Cells
  200. Who opens my file?
  201. Print Preview - 2 pages
  202. VBA Newbie
  203. Why so much non-OOP syntax in VBA?
  204. Stock quotes from web site
  205. command Button
  206. automatic macro
  207. Entering values into a ListBox.
  208. Counting Rows in 2007
  209. Check for format in form field
  210. "The file could not be read:" xlsMacros.txt. "Programmatic access toOffice VBA project is denied"
  211. Can XL send email via Novell Groupwise?
  212. modifying countifs
  213. Automated Excel Workbooks and Task Scheduler
  214. Shorter 'Or' Statement?
  215. How to make a public function procedure with undefined number of r
  216. colour cell on condition
  217. Excel 2003 'SpecialCells' VBA cell Selection - how do I do this? Helpneeded please
  218. Getting values from other applications
  219. Using browser to login and fetch CSV
  220. Cell Format
  221. Input Box Trouble
  222. Filter and select the upmost rows
  223. Excel VBA open with Password
  224. format listbox columns
  225. re-visit old question
  226. Identifying rows in a message box
  227. vba newbie - explanation
  228. Script: Clmn A = Row Number
  229. Text Box as opposed to HourGlass
  230. Comparing cells written in text to cells producing text from a for
  231. Worksheet_Change event very slow
  232. How do I assign large number of named worksheets to a varArray
  233. Excel 2003 to 2007 Gotchas ... so I can be prepared
  234. Formula
  235. Hiding columns in a named range
  236. run a macro to extract hyperlinked sheet to new workbook
  237. Macro to record data monthly
  238. Import csv to different tables
  239. IsNumber (in Rick Rothstein's example)
  240. counting only results in a column of formulas
  241. Import tasks from Outlook into Excel
  242. Macro code to set range
  243. Hide Custom Command Bar if Workbook opened Read-Only
  244. how make an angle to show in degree, minute,second instead of degree
  245. Timeouts on VBA code
  246. XIRR and #NAME? Error
  247. Close 2007
  248. error with oleobjects.add
  249. losing Application.FindFormat.NumberFormat after finding first cel
  250. Detect Delete
  251. userform property change race
  252. Getprivateprofilestring Crashes in Vista SP1
  253. Excel 2007 Print Preview
  254. Excel 2007 Sorting Question
  255. From SelectionChange into UserForm
  256. macro to add button to a spreadsheet cell
  257. How to quickly name cells in a row using VBA?
  258. How to dynamically modify unserforms
  259. Require data entry in column before moving to next cell
  260. Referring to a relative cell within a function
  261. Lookup Formular on Table
  262. Open Excel sheet, modify, print and lock
  263. Use VBA to get values from named range that contains an array formulaexpression
  264. Edit/read from data base
  265. Auto List Members
  266. sort data and copy to another sheet in a different form dynamicall
  267. summing a range if it meets criteria between 2 dates.
  268. Need help creating a TRIAL version of an EXCEL template
  269. Catching Ctrl+clicks and getting to the selection
  270. Extract time for comparison
  271. Select same cells in all worksheets
  272. Problem With Recording a Macro in Excel 2007
  273. PLEASE CAN ANYBODY HELP WITH MACRO
  274. SaveAs command
  275. How to use the Worksheet Change event to monitor if cells haveerrors?
  276. Refer in macro to cell
  277. Varible scope
  278. FindNext Errors
  279. Get max & min dates from column
  280. Compare 2 sheets against 2 colums
  281. Static references into variables
  282. help with dates on form combobox
  283. can i send excel workbook as attachment form excel.
  284. lucking a cell automatically ...
  285. Lucking the cell during operation automatically...
  286. Retrieve value from .Shapes.AddFormControl(xlDropDown...
  287. Permanent Date/time entery
  288. Urgent Help
  289. Formula and Macro Needed
  290. make a spending tracker sheet
  291. ActiveCell.Value
  292. Hot Key on Menu Bar
  293. MACRO TO DELET ROWS DEPENDING ON CELL VALUES
  294. Automatically create worksheets by entering a number
  295. UserForm
  296. Cannot Update Links ??
  297. Text To Columns Looping Macro
  298. vlookup using contents of clipboard?
  299. List property
  300. Deployment of XL programs in 2003 vs 2007
  301. Problem with VBA code - Can't figure out what is wrong
  302. Excel 2003 sticks to the low macro security level
  303. Can file history be seen in Metadata?
  304. Counting Conditional Format colors
  305. Ranges - Location InTable
  306. Adding random #s in a range to equal a specific #
  307. Delete cell value in ColE based on value is ColA
  308. How to copy and paste multiple files
  309. Copying functions and formatting
  310. Amend sub to read from names in col A
  311. group 3 optionbuttons and call them
  312. Automating Excel and closing program
  313. Sheet disappears from Project Explorer
  314. Code to get the Active worksheet on change of worksheets
  315. Help - Loop Function Giving Incorrect Output
  316. Chart difference between Excel 2003 and Excel 2007
  317. Comparing cells with text to cells with numeric values.
  318. Functions
  319. How can I use excel to accurately predict A4, & A5 ?
  320. How to program move one cell down and copy?
  321. supress/answer "name ... already defined" msg when overwriting w/m
  322. macros on an invoice
  323. Autofilter
  324. Re: Select Case - 2 causes problems
  325. Unique Random Numbers
  326. This workbook contains links to other data sources
  327. ScreenUpdating and ATPVBAEN.XLA!Random
  328. Re: Select Case - 2 causes problems
  329. Assign ChangeEventMacro to unknown SheetName
  330. Ineed a combo box to change its list dependant on the active cell
  331. searching for data labels with specific text
  332. Problem with ScreenUpdating Property
  333. hi, how to compare two string values, if the string values r from inputbox in VB
  334. Method range failed
  335. Need VBA Code
  336. Sorry, No Word Macro Forum. Macro To Search And Copy All Occurances
  337. Trasfer data to SQL Server
  338. Help...first time macro user question, loop needed?
  339. Macro Help
  340. Use Dir() to fill out missing components from Path?
  341. add to listbox
  342. I am new to VBA - Help needed on Macro
  343. Call parameter query in Access from Excel VBA?
  344. merge
  345. PLEASE CAN ANYBODY HELP - MACRO NEEDED
  346. Column Breaks
  347. Cubevalue (Excel 2007) versus Cubecellvalue (Excel 2003)
  348. Excel Programmatic (Existing) Workbook Access in .NET 2.0
  349. Sort Current Worksheet
  350. Using IF EXISTS inside CASE block in SQL
  351. password & Links
  352. Why does Range.Group() method crash after 7 calls?
  353. Pivot Macro
  354. Update my spreadsheet with MLB team records?
  355. university courses in VBA
  356. File Size Matters
  357. PivotCaches.add Difficulties
  358. Auto_open won't run on multiple files
  359. Sub to copy n rename book according to list
  360. Have code, need to travel
  361. Compile error using array
  362. additem
  363. How To Use The Number Part Of A TextBox Name As A Variable
  364. How to count rows with text
  365. A macro that deletes all green triangle error indicators in workbook
  366. vb code question
  367. PLEASE HELP MACRO NEEDED
  368. Reading file saved from Excel as Unicode text
  369. Background Processes in File Save versus File SaveAs
  370. Attaching an Excel Worksheet as An Object...
  371. Merging 3 rows of numbers together
  372. Force to run maximized
  373. Select Leftmost Spreadsheet
  374. Many to One Lookup Match in Drop Down List
  375. MACRO TO WORKOUT PERCENTAGE
  376. Troubleshoot formula's between 2003 and 2007
  377. Vlookup not refreshing data values
  378. How to delete that row if same cell in preceding row is identical
  379. BLINK CELL COLOUR OR TEXT COLOUR
  380. Range.Group() method fails after 7 calls
  381. Save As Macro options
  382. Message box and Save as Macro
  383. VBA Excel decimal formating problems
  384. Adding a calculator(Numberpad) to a text Box
  385. comparing abr. Date Text cell to a date formatted cell
  386. Macro Help
  387. joining spreadsheets together for reports and queries?
  388. Query
  389. Selecting Range of Cells
  390. Workbook_Open() won't run macro unless breakpoint set
  391. Need Help With My Loop That Creates Output File
  392. PasteSpecial failed
  393. XL 2007 records print command as XL4 macro
  394. Sort and Extract Macro
  395. Sort and Extract Macro
  396. Automated add-in UDF lookup in Excel 2007
  397. why won't this work???
  398. VBA Routine to split cell data...
  399. How can I protect cell from user entry but able to alter/clear in
  400. Code to do edit checks when user moves out of a cell
  401. Savepicture
  402. Re: Chart Deselect in 2007
  403. Choosing Multiple items from Data Validation Lists
  404. Calculate command
  405. Getting <Title> out of HTML source code
  406. A puzzling duplicate data issue...
  407. Is string allowable as a file name
  408. Modeless UserForm
  409. Add Row after last entry
  410. Username
  411. Is there a VBA command that will keep an program always on top
  412. Listbox data
  413. Macro to compare names
  414. Help getting next sheet
  415. UDF for multiple heading indexing
  416. auto_open problem for Expiry date
  417. Dropdown menu
  418. Non-modal dialog tracking Ctrl+click'd selection
  419. Conditional Formatting via VBA in Excel 2007
  420. Worksheet_Change doesn't work
  421. Macro copy data into another workbook
  422. Getting the function name (NOT SYMBOL NAME) - not quiteapplication.registeredfunctions...?
  423. APPEARENCES DURING THE MACRO RUN PERIOD
  424. open then modify file via hyperlink
  425. Copying worksheet into another worksheet
  426. check lettered ticket number
  427. Excel 2007 Chart-Objects don't work properly
  428. Vista has broken my SHDocVW
  429. Workbook before close
  430. Vba code
  431. entering value in a cell
  432. Where am I going wrong? (losing the variable because of need for quotation marks)
  433. The specified device is not open or not recognized by MCI -"mciSendStringA", VBA
  434. Compare two columns, delete rows that match?
  435. VBA / Formula
  436. Help with Vlookup of Find date
  437. replace copy and paste
  438. Using More than 7 possibilities in a formula
  439. I need help with a "Run-Time Error 13: Type Mismatch"
  440. spread out fields in different column
  441. Protect a sheet
  442. Macro for e-mail
  443. Previous active cell
  444. Code format question
  445. How to link PP shape to individual sheet in a workbook?
  446. Refresh form
  447. Insert new row after a name range
  448. hyperlink to password enabled website.
  449. Textbox
  450. VBA - before delete
  451. median of combinations from values in a column
  452. Get Dimensions of Image File Outside Excel
  453. Ignore a sheet
  454. If ...Then Statement
  455. Highlighting fields based on a dropdown in Excel 2003
  456. Shorter way to create multiple identical Event Procedures?
  457. xml toolkit not working in Excel 2003. Why?
  458. find box
  459. Excessing excel error responses
  460. How to delete the duplicate pivot cache.
  461. Task bar
  462. Controling a Pivot Dropdown
  463. Objects/properties that don't trigger the intellisense
  464. need help.
  465. Combo Userform
  466. Copy cells & sheet name to master sheet
  467. Cell color
  468. Excel 2007 Macro Security
  469. Call a callback to toggle a tab visible/hidden?
  470. Select Cell when hover over action hotspot
  471. Can't paste today
  472. Dynamic List box
  473. Revision clouds?
  474. Dynamic comboBox on Ribbon
  475. hiding columns in grouped worksheets
  476. Computer freezes when user clicks "enable" macros
  477. Command Button Changes Data Each Time It Is Pressed - Want it to workonce per worksheet.
  478. Insert text in cell using VBA
  479. Format Selected Chart
  480. Workbook name is read only property?
  481. find workbook names that are in sheet
  482. How to set page orientation to "landscape"
  483. Dates US and UK
  484. PopOver Help
  485. Change colour
  486. User-defined type not defined
  487. Macro: Copying to all possible rows
  488. cell ref in a formula
  489. XLAM for global macros cannot be run
  490. Find End of List
  491. Info about "Office Developer"
  492. Final space removed when moving to Object variable
  493. Change column headings or freeze row 1
  494. RibbonX Separator problem
  495. Pivot Table - VBA
  496. Userid
  497. Protecting sheet through vba while allowing some actions
  498. macro to change number format of a highlighted range in Excel 2007
  499. Macro to mail and save range from one sheet
  500. Class Module Method
  501. Error Message - VBE6EXT.OLB could not be loaded
  502. calculating percentage on timevalues
  503. macros -enabled Workbook is getting slower and slower!!
  504. Automating F2 to edit
  505. Listbox
  506. male & female lists
  507. charts, data in arrays, can same be done for ErrorBar figures?
  508. Avoid multiple select constructs
  509. Error Handling construct
  510. Combinations Sequence
  511. Lookup value
  512. Sending a date from VB2005 to Excel
  513. Calendar Control Drops on Distribution
  514. PLEASE CAN ANY BODY HELP
  515. Opening hyperlinks in separate windows
  516. Triathlete Club Needs Help!
  517. Lookup value
  518. ADO recordset: Convert RTF field into plain text
  519. Taking hours to save excel file
  520. how can i no margin string in listbox from left
  521. Chk sheet exits, copy all to another book.
  522. Edit VBA Code without opening the workbook
  523. Do Not Export Button Objects
  524. Address of cell invoking current UDF call?
  525. Why am I losing my Range object?
  526. Extract a section of a text string to anew column - Excel 2003
  527. lock a workbook until certain cells are filled
  528. Is it possible in Excel to have the result of a formula hide rows.
  529. Remove end folder from path found with ThisWorkbook.Path command ?
  530. Re: IsBlank() in VBA code?
  531. Simultaneous scrolling for 3 worksheets.
  532. Unselect Forms Toolbar Listbox
  533. Recognizing When An IE window changes URLs and closing the IE wind
  534. Find filename of open file
  535. copy several files into one file
  536. "Dim" query
  537. VBA Checkboxes
  538. Need to create table that shows last rolling 30 business daysdifferences on 4 accounts
  539. RE: IsBlank() in VBA code?
  540. check for numeric values in a column
  541. Re: IsBlank() in VBA code?
  542. VBA Code to go to one Bookmark.
  543. asset allocation optimization
  544. Password issue
  545. How can I unprotect multiple same passoword worksheets at once?
  546. combining multiple find/replace subs
  547. ADO Field Size issue
  548. Automatic Conditional Row Deletion?
  549. visual basic code runs very slow in 2007
  550. On Change Event and Intersect
  551. Macro to hide rows?
  552. FileSearch worked in Excel 97 but not in Excel 2003, how to fix???
  553. Split Workbook based on user Input
  554. CAN ANYBODY PLEASE AMEND MY MACRO
  555. Dates in SQL query won't match
  556. macro: Copying to all possible rows
  557. Protect cells based on Date and previously entered data
  558. Calendar Control
  559. calculate time if greater than a given time
  560. Read value from text file line, process, then Loop until EOF
  561. GetOpenFileName to select a .URL file
  562. disable objects on form
  563. Excel 2000 open using C# error - Unable to cast COM object of type
  564. Textbox
  565. ToyotaKV
  566. Format Cells with VBA?
  567. DELETE DEBIT AND CREDIT FIGURES ROW BY MACRO
  568. The hunt for the disappearing textboxes.....
  569. Copying cells from one worksheet to another, within the same workbook
  570. Adapt code to copy out pictures as well
  571. 'object disconnected from client ...'
  572. Find WkBk Path, Then use this path to open another WkBk in Subfold
  573. Last Item of Listbox not getting displayed
  574. Using CREATE TABLE DDL on Excel creates two tables
  575. All macro are disabled due to encryption?
  576. VB CODE for password protected sheet to release part of the worksh
  577. Protecting Workbook on Network while Allowing VBA Updates
  578. Switching monitors
  579. Automation:Selecting a different worksheet from another excel work
  580. List Directories and Subdirectories
  581. copying rows to all possible records during a macro
  582. Copying worksheets - loosing range names
  583. Inserting a row in one named range and having it update another
  584. Link Sheet tabs to Org Chart
  585. Stock Quotes to Excel
  586. Printing what is between tags
  587. VB to run a .exe file
  588. Using RIGHT function to get right-most digit for each cell in acolumn
  589. How do I bold entire row with an asterisk in the text?
  590. MS Internet Transfer Control
  591. How do I refresh user defined function data?
  592. Programatically set control source - not working
  593. Random selections with criteria
  594. Row Height and Printing
  595. Toggle Command Button to Show/Hide the Shaded Headers Columns
  596. BEST suggestion to keep formats?
  597. distinguish Range and "Single"
  598. Excel 2000 vs 2003 date issue
  599. Copy A File From Internet To My Desktop
  600. Solver dialog box
  601. query code failes on different PC
  602. INDEX
  603. Paramters or Argument Auto-Label/Balloon Tip for User-DefinedFunction
  604. A macro to deactivate Input Message textbox without deactivatingError Alert messages
  605. Microsoft Visual Basic UserForm 2 columns, Excel 2000 & 2003
  606. Error after chaging file access in Office 2007
  607. Copy totals from master tab to other tabs
  608. Selecting tabs - tab names given in a list
  609. Points, pixels, in, and fonts
  610. Excel 2007 - Deploy a function across the network
  611. Vba Password
  612. Automate Pivot Creation
  613. Form Help (Re-post)
  614. Pivot Tables in VBA: Problem with AddFields Method
  615. Sort on no less than sixteen keys
  616. Sheet names in a MenuBar menu
  617. Re: Referencing Sheet names/numbers
  618. RE: Referencing Sheet names/numbers
  619. Make a copy of a sheet and add it into a new workbook?
  620. Help with vlookup
  621. Query Help
  622. Formula/Function to lock and unlock a cell in excel
  623. Re : Excel AutoFilter being Toggled of VisibleDropDown
  624. MULTIPLE CALCULATION
  625. CALCULATION IN BACKGROUND
  626. Formatting in Text Boxes
  627. A little help for a newbie
  628. Standards and tips for VBA
  629. Selection.Cut Selection.Offset(1, 0) HOW to understand this code
  630. RaiseEvent Problem
  631. sorting with a macro
  632. Shade date headers, if Weekends or Holidays
  633. data pulling with sharing violation
  634. Macro to add the " symbol to the beginning and end of cells selected
  635. Can I blanket update all controls inside a frame?
  636. Lookup help needed
  637. imagelist filling at designtime
  638. creating labels using MS exel and MS word mail merge
  639. Cells will not change from text format.
  640. VB CODE for double click?
  641. Copying Worksheets with macros
  642. multiple web querys
  643. Extending a range selection
  644. VB CODE for moving the range of cells down by one row?
  645. VB code for Active cell to the last cell
  646. Replacing formulas with values programmatically
  647. Menu disappears when selecting a graph
  648. Save & Load A Range
  649. Record Name of Workbook on Close
  650. How do I lock certain cels i a worksheet
  651. Need help with a formular ?
  652. Paste-Transpose macro needed
  653. Automation Server Events Usage in VBA
  654. Can an array be redim inside a for loop?
  655. array of labels
  656. archery scores templates
  657. Get Folder Name
  658. How to enter a macro that performs when a file is closed
  659. Help please - real beginner at form code
  660. page problem
  661. Code for form
  662. Displaying active cell in particular position on screen
  663. Date formatting
  664. Pivot Tables and Macros
  665. HOW TO SELECT RANGE IN MACRO
  666. Error control dont work!
  667. Cecking for duplicates
  668. copy and sort data then past in specific area on new sheet
  669. How do I loop in EXCEL !! Pls EX-cel-erate me!!
  670. Lookup Macro
  671. How do I loop in EXCEL !! Pls EX-cel-erate me!!
  672. Can I change the format of a control at Runtine?
  673. How to align decimals in a Listbox
  674. Is there a way to view the VBA code dynamically...i.e., while usingthe record macro tool
  675. ComboBox Query
  676. xla and add-in
  677. clear data and named cell
  678. Can Chart Refresh be Disabled temporarily?
  679. What's meaning of the Number Format?
  680. HyperLink function runs wild when unrelated column is filtered
  681. urgent help required.
  682. Want to select row
  683. totally newbie question about macros and programing it
  684. Listbox
  685. MAKE SUBTOTAL APPLICATION ON AND OFF IN MACRO
  686. HOW TO SELECT SPECIFIED RANGE IN MACRO
  687. Funtion as Matrix function?
  688. why is this form code not working
  689. Activate Excel application event
  690. Checking the connection to a network Share
  691. Is this a valid IF statement in Excel?
  692. Macros dont work when file used on another computer
  693. Copy dynamic range
  694. Avoid DIsplay of links
  695. Extracting Values and inserting Rows/Values
  696. Unlock certain cells based on ColorIndex
  697. FTP MVS to Excel
  698. Application.StatusBar or equivalent for user defined functions
  699. get cell value where offset cell = X, use this value to populate list
  700. Not exporting controls to a new workbook
  701. Problem creating PivotTable from ADO recordset using VBA
  702. Day of year (Not Julian)
  703. Initializing Form Controls
  704. Worksheet Protection Question
  705. Automatically resize a picture to a cell
  706. Why null reference to ListBox?
  707. how can I make a graphic that have two scales?
  708. CONDITIONAL FORMATTING TO VBA. Row format based on cell value.
  709. replace special character for filename save
  710. Moving the last character within the cell so it will be the first
  711. HIDE-UNHIDE VBA MACRO
  712. Re: Run code based on version
  713. Re: Run code based on version
  714. Help with VBA Code - once again
  715. execute a make table query in an access database
  716. Show Image When File Opened
  717. undoing a pivot table
  718. Show Image When File Opened
  719. Letting users calculate Excel forms on the web while hiding the logic
  720. What is missing from this form code?
  721. Problem with formating
  722. VBA code to run & wait for cmd line interface application
  723. Excellent resource on line for the Ribbon
  724. Before Print Event
  725. sum certain columns
  726. listbox
  727. Get Text Value of Dropdown
  728. Limit an GoTo Function command
  729. Macro
  730. Help Needed in Macro
  731. Hyperlink Help
  732. Bug? Unwanted date format pasted on two sheets when csv file importedin excel using ADO
  733. Shell or shellexecute
  734. how to plot a chart with 3 axes?
  735. Multiple Conditional Formatting in VB
  736. F8
  737. how to export a column as text separated by comma?
  738. Insert a line at the bottom page
  739. Variable not set
  740. Deleting excel rows based on multiple criteria
  741. worksheet_change not working
  742. Help on coding please?
  743. VBA Worksheets save new file to Folder on Desktop
  744. ListBox1 - returns no value
  745. Using excel to access MS Access saved query
  746. Vba to go to another sheet in same workbook
  747. I have formulas larger than 7 functions, how can I use them?
  748. Creating a conditional formula
  749. CAN ANYBODY PLEASE HELP ME WITH THIS MACRO
  750. MACRO TO LOOKUP AND SUM