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. From Access to Excel Question - VBA review
  2. Find the Length of a Text File
  3. vba to loop until process finished
  4. Iterating Through Workbook if Don't Know Sheet Names
  5. How do I Compare common fields to update a Master table
  6. Comparing multiple fields in an array with multiple fields in a table.
  7. RefEdit Control
  8. Merge into a Template Form?
  9. Need help with formula please
  10. Adding two columns ...please help
  11. copying every other row
  12. export to outlook task list...
  13. Long shot? Copy rows but have XL2K insert a space between each row??
  14. Insert to Access table
  15. Complicated Formula?
  16. Highlighting whole row in this macro
  17. Worksheet_Change - determine how it is triggered
  18. Procedures stop with no indication of problem
  19. Capturing a Drop Event
  20. Need error trap
  21. Function reading range with formulas
  22. Macro to select multiple columns
  23. Determining formula reference type
  24. Open a wb and keep the focus on it
  25. Looping over non-contiguous column selection
  26. Forcing PT page filter values to equal my cell value on summary pa
  27. Macro to change pictures
  28. Problem with Format function
  29. Customized Menu Executes Without Mouse Click
  30. Save a copy from cell data and close orignal
  31. Nulls within a .Find command
  32. How to detect if a macro is in the middle of running
  33. How to insert the Thousands Separator (comma) in Excel?
  34. Sum Range of Cells to a Target Value
  35. help me clean up this code
  36. combo box list error
  37. Find and Replace Exact Match
  38. Cut/Paste Duplicates code?
  39. Automatically "Click" Default Button on Message Boxes
  40. Testing each cell for error
  41. Created automatically sequence numbers
  42. Replace method problems
  43. create formula with seperate cells
  44. ADODB over HTTP?
  45. distributed vba project - multiple thread / concurrent file access
  46. Entry Form Problem
  47. Charting - bubble series
  48. Accessing external excel files
  49. Missing "Examples" and "See Also" in VBA help
  50. Worksheet_Change function and circular reference error message
  51. Private Student Loan Consolidation Programs
  52. Uppercase in non adjacent columns
  53. ADO: run a stored Access query from Excel
  54. Selection.Item Query
  55. is date?
  56. Huge Repository!!!
  57. Add-in / XLL beginner
  58. Insert...Function ???
  59. What language to learn?
  60. Copy range to / from CSV file
  61. Paste into a 2-column listbox?
  62. More on N-by-M assignment into a Worksheet
  63. Non-blocking socket listening
  64. VBA compare two file paths and delete common root
  65. Customize/ Hide data in pivot table
  66. Create Macro to copy a formula to range of cell
  67. Create Macro with variable search feature
  68. selecting a printer within a macro
  69. Referencing set columns on multiple worksheets
  70. A shortcut to set colmn to count (example: A2=A1+A)?
  71. Excel Chart macro to paste into Powerpoint
  72. Export to MS Access
  73. Excel Cell Data Limit
  74. Macro for conditional formating more than 3
  75. ActiveCell.Value copies unwanted currency format of source cell
  76. retrieving top/bottom n rank()-ed data
  77. using dateserial in vb
  78. File size Limit in Excel 2003
  79. Extracting Trendline Coefficients
  80. Code Help!! PLEASE
  81. Use cell content as range address reference/count?
  82. Can't call Excel Services UDF from macro, object not found error
  83. Excel Sort Problem...
  84. Application Event Procedure <Falling Over>
  85. Pop up message
  86. selection.find question (bet it's an easy one)
  87. Relocate Value Axis Title
  88. Command Button
  89. enter a value for a cell according to a criteria in an other cell
  90. VBA Permanent Code
  91. VerticalAlignment = xlTop also removes indent
  92. How to use custom validation
  93. Conditional Formatting Not Working Out
  94. fix switch view....
  95. StickyKeys Status
  96. Combobox item selection+pop up list
  97. browser integration
  98. How do you stop the Find method?
  99. Turn off toolbars
  100. Importing from CSV file with the BASIC procedure
  101. Running an Add-In on the fly
  102. listindex and blank rows
  103. xloper structure, excel
  104. Simple VBA code not working on new laptop
  105. How to extract data from File Path
  106. Copy range from multiple .xls files - output to separate columns per .xls file
  107. Help with updating transaction entries
  108. filter and copy
  109. Excel Print All Tabs Macro
  110. Vlookup
  111. Filter Problem - show column difference
  112. VB macro != NUll expression
  113. Formula for calculation
  114. protect unprotect sheet vba
  115. Custom Floatable Toolbar Popup Menu
  116. INPUT BOX
  117. Searching and extracting data within a defined dataset
  118. Little help please...
  119. Arrange columns
  120. Can I run a parameterized macro with medium security?
  121. Protection
  122. clear contents
  123. Capture Screen Position
  124. How to group rows using VBA
  125. Disable Auto Calculate Office 2004 Mac
  126. Exporting comments
  127. Converting Tab Delimited Text File to A Comma Delimited Text File
  128. Using User-Defined Functions in Cells
  129. Baffling problem with XML Reference in Excel Add-in
  130. Tracking changes in rows
  131. Error on Excel Startup
  132. Multiple Worksheets Make HUGE file
  133. Deleting rows based on values in a column
  134. Simple database questions - Export query output to a sheet.
  135. Modifing a userform txtbox code
  136. Project Explorer and Properties window (VBA) have disappeared
  137. Conditional Formatting > 3 conditions & referencing cell values
  138. Alternative to &Caption for a button in VBA
  139. Use Excel to update Access tables
  140. output data on range
  141. Best practice to install vba addin to excel
  142. VBA add-in removing
  143. refer to cell in range
  144. Add Data Range To Lotus Notes Email
  145. SUM with variable range
  146. Automatic count of the rows for the given file name.
  147. Issue in querying the Reporting Services exported Excel
  148. Average doesn't work in pivottable calculated field
  149. Test condition never satisfied in loop
  150. Programming exercise, array
  151. Problem with Range Object
  152. Copy active sheet to new - do no copy buttons
  153. save changes on close using vba
  154. How to Use VBA to copy a file?
  155. Linking the ENTER key to a Button on a Form?
  156. Can I have "Shift-Click" or "Ctrl-Click" Code on Form List?
  157. Block Equation Copy
  158. UserForm initialize event run when UserForm is shown
  159. Reading File and adding contents to spreadsheet
  160. Store cell & workbook references, to retrieve later in Macro
  161. Looping "For Each" problem
  162. Select sheet, Pause till Enter pressed, return to previous sheet
  163. saveas and excel template
  164. Getting a list of files in a Sharepoint Folder
  165. how do you use microsoft excel to calculate year to date average
  166. Array values with UBound
  167. Finding blank row and entering data in row from userform
  168. Search form
  169. major errors with macro code - VB question constantly doing "ELSE" part of if statement
  170. Why am I getting a recordcount of -1
  171. ADO from Excel to Access
  172. Add New Line Feature in Form
  173. Do Until
  174. If row 2 contains nothing then move onto next macro.......
  175. Prompt to Select Cell
  176. Userform, all fields required
  177. Bug?
  178. Adding/Updating Records in Access with Excel
  179. assign a button to a macro in excel 2007
  180. Correct Useage of .FindControls
  181. Can you help me figure out why my macro is running slowly?
  182. Excel add-in problem
  183. Excel print to Adobe.pdf
  184. Writing data to an excel workbook
  185. Does Excel has different behaviour than other application like MS-Word inm printing
  186. Manage groups of WS
  187. Error: Cannot expand named range
  188. ON_OPEN Question
  189. 1d Variant arrays?
  190. link list
  191. email layout
  192. data validation
  193. Summary Worksheet totals
  194. sorting w/ errors
  195. copy cells in two columns if in bold to another sheet and insert rows
  196. Problems Pasting in Macro
  197. Insert " " into a string
  198. Cut/Paste duplicate rows?
  199. Read range to array
  200. Moving a sheet along with macros
  201. How switch off space auto-completion in VBA editor?
  202. Funny Character ????
  203. Range reference
  204. ODBC takes time to update
  205. Homemade symbols importet and used on the QAT?
  206. Excel Outlook VB
  207. Subtract named cells
  208. IF/THEN/ELSE for sequential numbers
  209. Off Set printing
  210. change cell on exit vba
  211. Decrementing row after deletion
  212. Re: Strange calculation in PivotTable
  213. macro to find a max value in a column select corresponding userfor
  214. macro to copy columns
  215. Passing an Array between Forms?
  216. Multiline textbox for data entry
  217. VBA for prompt to fill in the certain cell
  218. hide option dialog box
  219. Adding a new file extension for Pipe Delimited files
  220. Switching from VBA to C#
  221. Dealing with merged cells
  222. checking if a column is hidden
  223. Modulo 43 spreadsheet
  224. File length of large files
  225. How can I update VBA code in a module that is running my VBA code?
  226. Looking for best method to automate monthly Excel report
  227. Change Printer from A4 Portrait to A5 landscape and back again
  228. input box default values (current month, year)
  229. Distinguish between '<' and '.' with KeyUp?
  230. Cannot Find Button From Control Properties
  231. Msg Box With Exit Sub - How to quit application
  232. if statement
  233. Getting XL to work with only selected range
  234. Relative cell references
  235. VSTO updating excel dlls
  236. how do I automatically group according to text color?
  237. Disappearing Posting
  238. Toggle between two opened files
  239. Please help
  240. VBA Intellisense
  241. Activeworkbook and Internet Explorer
  242. Going Rate for Excel consulting fees
  243. UserForm In Range Out of Range
  244. linking arrays
  245. referencing cell via another cell
  246. tip text for user defined worksheet functions
  247. Changing values of an array of arrays
  248. Autofill Question
  249. Code work but a easier way to do this.
  250. find count of multiple excel instances
  251. Protecting WordArt objects in Excel
  252. Interactive Sheet help
  253. Data/From Web
  254. Macro to delete certain rows in a spreadsheet
  255. workbook_Open
  256. Slow Structure - Row Deletion
  257. Excel VBA Key-Code Effects Rendered by vbKeyLButton
  258. Worksheet name
  259. display alerts= false not working
  260. Cube Analysis Addin and c#
  261. XlSaveConflictResolution
  262. error - Cannot shift objects off sheet.
  263. How to limit user's input with data validation
  264. SaveAs Issues
  265. Get right Excel application
  266. Excel to Access and Access to Excel
  267. Offset not working with variable
  268. Office Web Components compatibility
  269. Error when VB tries to open file from Windows Explorer
  270. Deactivate automatic macros on import
  271. Find & Replace String Array - More Than 255 Characters?
  272. 1004- Unable to set the hidden property of the range class
  273. Turn off Excel changing all date like strings to dates
  274. Pulling data OUT of Excel in real-time.
  275. Forcing Jaws PDF Creator
  276. Paste data to a Word bookmark
  277. check userform values in combination
  278. commandbutton on workbook assistance
  279. Copy fixed range of multiple sheets into new workbook
  280. What is the best way of collectiong as much debug info as possible when users hit problems.
  281. File Name Select Case
  282. SEGREGATE THE SIR NAME
  283. Customize column field of pivottable
  284. Lists in Visual Basic - Excel
  285. Check if i'm connected to the internet
  286. Command button code
  287. Drop down list with pricing
  288. Cut is unsafe - call for solutions
  289. Excel Progress Bar
  290. Avoid Outlook macro security for Excel bades macro
  291. Copy
  292. Deployment of Excel addin (.xla file)
  293. Problem with code
  294. Outlook Object Model via Excel -- return code after send?
  295. Copy, then Paste "Value" to the same cell...
  296. Macro to Delete Partial Text in a Cell
  297. Sorted appearing table (vlookup, if, concontinate)???
  298. CDO, SMTP Server Name, and Excel's SendMail Method
  299. Importing Multiple Text Files
  300. MS Query From Excel to Access
  301. hyperlinks.follow result saving
  302. Write data inthe worksheet / array
  303. controlsource cells(2,3) ?
  304. How to lock the Data Controls' location from being altered by othe
  305. SELECT THE FIRST CELL IN ADVANCE FILTERed worksheet vba code
  306. Radio button glitch (SC)
  307. Command button code(SC)
  308. Forgotten VBA Password
  309. If then statement in excell?
  310. Slow Macros in Excel 2007
  311. Selecting column within a selection
  312. Calendar Control 12 printing problem
  313. Trying to set print area dynamically
  314. How to select the last 6 entries in range with a formula?
  315. type mismatch
  316. Search Specific Column for a matched entry
  317. Saving user data outside Excel
  318. K-Means, X-Means or other Clustering Algorithms
  319. IFF files
  320. Anchor Reference in a Formula
  321. How do you program Excel to import/export data to XML files
  322. What is the command to select a button in alert message?
  323. Create and name new sheet...
  324. Changing drive letter in VBA
  325. Select a range by column number
  326. Saving to a specific location
  327. xlFileFormat of Office2003/XP
  328. Need help with one line of code
  329. Add item to 'Cell' context menu with XML (RibbonX)
  330. Help! Search Range Using Two Criterias & Returning Cell Contents.
  331. Pivot Table from MS Access Database
  332. Help with Logon Information
  333. Revisiting "New issue with "With" statment" post from 6/7/07
  334. Catching edit mode error
  335. Add-in programming
  336. Get data from all workbooks in a folder. Paste into my worksheet.
  337. strikethrough row number
  338. convert date from oracle format to MS Excel mm/dd/yyyyy
  339. GetOpenFileName - no array?
  340. Number of UserForm Control Objects
  341. Scrollbars won't show
  342. Check for Addin before Update Links
  343. Hidden personal file not hidden anymore
  344. Long error handling section, safe to break out?
  345. find text match, then grab text following
  346. Button
  347. Custom Button Images
  348. Progress Bar Stuck after Crashing
  349. Do not allow excel to minimize
  350. User Form Link to Query
  351. Run an Add-in
  352. need help
  353. DAGNABIT!!! Where'd my form go?
  354. Switch Between Workbooks
  355. pivot field order
  356. Keeping a Macro in a New Book
  357. How should I change Macro?
  358. Problem: True vs. False
  359. [Range].Find Help
  360. Repeat formula on each page
  361. Loop in a loop syntax
  362. Execution ends without error message in middle of program
  363. uppercase to lowercase
  364. Appending / Concatenating by Client Number
  365. lookup in a different spreadsheet
  366. Find a cell value in a column then add two rows above
  367. Sum all integers of a given number
  368. Find specific string in range of cells
  369. Vlookup issue?
  370. Perform SUM based off COUNT
  371. Copy cells that vary in range
  372. Unassign Macro Keyboard Shortcut?
  373. Updating cell value by case
  374. Column Number from Column Letter
  375. New QueryTable?
  376. Macro: Clear contents of unlocked cells
  377. How do I create a new VBA project when I run VBA from Excel?
  378. Variable Selection Summation
  379. Issue with Cells.Find statement within With
  380. move data in bold to a summary worksheet
  381. mail merge in Excel Please HELP
  382. Worksheet selection change (running marco when cell selected)
  383. Mail Merge issue please HELP
  384. Importing XML to Excel
  385. Problem auto generating e-mail to several recipients - argument not optional error message
  386. Delete rows depending on cell Value
  387. Sending File From Excel To Domin Web Access Version 7
  388. Lib parameter in Function Declare
  389. Navigation in TabControl.
  390. need some help, encounter run-time error 1004
  391. Malformed GUID error
  392. Capture Time/Date received info from Outlook
  393. conditional formatting a Combo Box
  394. Forward mail items
  395. VBA Editor How to Question
  396. Initiating multiple combo boxes with the same values
  397. New issue with "With" statement
  398. userform question
  399. Combine col & row headings and sequence them to single product val
  400. Find not equal to "0"
  401. Macro - Multiple printing
  402. Worksheet.Unprotect within WorkbookBeforeSave event fails if Save
  403. Macro
  404. Worksheet.Unprotect within WorkbookBeforeSave event fails if Save initiated by VB
  405. Excel 2003 Additional Workbooks After Excel Crash
  406. Copy and transpose paste from one worksheet to another
  407. How can i read Command Line parametres from Excel 2003 file???
  408. Deleting files in a directory
  409. Create dll file and call it from Excel worksheet or macro
  410. API to find position of active cell no longer working in 2007.
  411. Application-Defined Error 1004
  412. Showing two forms
  413. Help with my procedure
  414. Find duplicates, validate each dup row is same as first occurance.
  415. making cells mandatory entry?
  416. Getting and Saving a Cell Reference
  417. Getting Outlook contacts to list in Excel 2003
  418. Problem with transferring data
  419. Making a book catalog? Possible ??
  420. Edit String Variable "on the fly"?
  421. Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........
  422. External Data Error
  423. Issue with code execution -- it is very slow
  424. Packaging an Excel Addin and .dll for deployment
  425. Conditional Row Delete on Steriods
  426. Capturing Cell Values
  427. From EXE to DLL
  428. Shell function problem (MS Access)
  429. Significant performance issue with this site
  430. Protecting a worksheet
  431. formula for price increases and markups
  432. Form with no Cancel option
  433. Userform
  434. Event after "Save changes?" prompt when exiting
  435. code not working correctly
  436. Getting a "File Not Found" error when trying to show userform
  437. signature
  438. From EXE to DLL
  439. Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets
  440. Return to Column A and current row
  441. Macros in menu
  442. "Added apostrophes from VBA to Excel??" response
  443. Do without loop when using query
  444. string
  445. Added apostrophes from VBA to Excel??
  446. search for cell and clear contents
  447. How to use worksheet function Index
  448. Finding times between 6pm and Midnight...
  449. SUMIF Conidtions
  450. Macro Menu
  451. Pausing in Macros
  452. VB formula not working in Excel
  453. Getting back to file A from file B
  454. ACTIVE X Component cant create object (From Excel To Lotus 7)
  455. Sheet shows macros embedded but none are in VB editor
  456. Worksheet Load
  457. Changing Excel Version for Automation on the fly?
  458. Search Column for matches to a Range of Data, then modify cell
  459. Grr, encountering really annoying issues.
  460. disable shortcut keys
  461. Returning just the integer portion of a number
  462. VBA macro
  463. Excel/Access automation
  464. About using CDO to send email within Excel
  465. testing.....
  466. Unwanted ActiveX warning message
  467. Dynamic path for dll
  468. Help with a macro
  469. Fill cells with code based on content of preceeding cell?
  470. Sending An Excel File To Web Based Lotus 7 (Recent Migration)
  471. VBA code or macro to auto e-mail spreadsheet
  472. macros
  473. execute simultaneous macros
  474. String Building for Where Clause in Query
  475. Find word then use offset to change value in another cell
  476. String Building for Where Clause in query
  477. duplicates
  478. More efficient code
  479. automatic hyperlink
  480. Help with Code
  481. Close Excel from Access
  482. Run-time error 1004. Application-defined or object-defined error
  483. Operating Matrix in vba
  484. is this possible?
  485. The Microsoft Jet database engine could not find the object Sheet1
  486. The Microsoft Jet database engine could not find the object 'Sheet
  487. Toggle Button
  488. Reading XML node data
  489. Date format
  490. The Microsoft Jet database engine could not find the object 'Sheet
  491. Need function to raplace cell value by a range
  492. paste special error
  493. How do I create a progess bar
  494. Unused Variables
  495. Sorting the Data and Saving an Excel file before ftping it to UNIX server
  496. Last posting dated 6/5/2007 - What's Up?
  497. Digital Signature
  498. how to prevent a bitmap from "bleeding" over two pages?
  499. draw a math function
  500. Problem with dates
  501. Does VBA have a "continue" statement like C?
  502. New form of application.run
  503. Formatting Cells
  504. HELP! Reading range into array
  505. Get user-picked list of file names on Mac?
  506. Change font of row cell reference characters
  507. How to autopopulate column w/May using a col w/ 05/15/07(Excel)?
  508. External Data Failure VBA Code
  509. Printing printranges from different sheets in a specific order and as one print job
  510. HELP "ByRef Argument Type Mismatch"
  511. Ask for cell A1 value before printing out worksheet.......
  512. When pasting formulas to other WB, the references still linked to old WB ...
  513. find value in column and move row to 5 rows after the last one..........
  514. Check File Name Existence in Array
  515. Paste a constant
  516. Running out of memory when adding logos to reports
  517. Code for activating shift key
  518. Programming for Excel
  519. Closed workbooks still appear in VBE?
  520. Pls help when "for each" is empty
  521. Using Range Object With Two Variables
  522. Project a formula result from change
  523. CMS 13 vb code - no data in csv file -set info = csrsrv.report
  524. Rename worksheet event
  525. Outline macro
  526. Copy cells with varying ranges (VBA)
  527. Using contents of cells as input for variable?
  528. Formating Multiple cells
  529. Excel.Application not defined
  530. Pc to fast/slow or something like that...
  531. basic date entry by user
  532. Find duplicates, validate each dup row is same as first occurance.
  533. open a text file
  534. Populating a combobox
  535. Charts(3).SetSourceData Not Working
  536. Password mask
  537. Macro for page setup of worksheets is slow
  538. Conditional Formula
  539. Question about counting numbers
  540. Excel function in VBA
  541. Range(Selection, Selection.End(xlToRight)).Select
  542. SPEECH problem
  543. Error Handling
  544. Speed Up MS Query update
  545. text box 2 based on text box 1
  546. Excel to PDF
  547. Hide similar rows
  548. Pivot Tables
  549. Stepping through each character in a character string
  550. how to copy formulas from one range to another range in other work
  551. How to find the unique cell value?
  552. Save As Error
  553. How to find the unique cell value?
  554. copy and paste formulas between deferent workbooks.
  555. Email Notifications are Terrible...Difficult to find post
  556. on worksheet load
  557. How do we make Inclusion-Exclusion Principles on Excel?
  558. Hidden 'data' worksheet
  559. Excel User Conference
  560. office clipboard
  561. VB Editor
  562. Copy and transpose paste across several worksheets
  563. ??? Cannot find and replace in macro
  564. Calculating percentages based on the number of checked boxes in a column
  565. Adjusting code to loop
  566. Converting Excel Cell Location into X and Y Coordinates
  567. find latest date modified file
  568. Small Macro Revision - to highlight rows and enter how many times they appear in a cell rather than a msg box.
  569. How to check for duplications in a single column
  570. selecting specific columns with data and put it in a new sheet
  571. enter a set value in adjacent cell
  572. To delete specific color index row
  573. using excel formula to indicate the active cell
  574. Excel 2003 Pivot tables
  575. export to html
  576. how to get reference of a cell instead of value in the cell
  577. Can I update User Form CheckMark without running _Click code...?
  578. Lost discussion threads
  579. How to increase a salary sheet by a set percentage in all cells?
  580. Assign macro to text in a cell rather than a control
  581. macro - email current page
  582. save page ,clear page, reuse same page
  583. Range question
  584. Programmatically create DWORD value - how
  585. How do I prevent a bmp from printing over two pages
  586. DISCOUNTED CASH FLOW PROBLEMS
  587. copy data from one cell to another
  588. time vs Day format
  589. Issue with SpecialCells method
  590. Issue with setting Range
  591. Stripping Selective Data from .CSV file to Excel w/VBA
  592. Find Dups in a column, validate all dup rows are identical.
  593. Create macro button
  594. lock a formula result
  595. Using Wildcard to Activate & Rename Workbooks
  596. Copy and transpose paste
  597. Making UI Ribbon, and xlsb files
  598. Increasing the Sheet #
  599. string matching
  600. Data Entry Restriction
  601. ActiveWorkbook.VBProject
  602. Change formulas to variable row in range
  603. Categories
  604. Macro for setting range of Vlookup formula's
  605. Range to Array
  606. hide cells
  607. VBA format date in footer
  608. Validating subsequent duplicate rows based upon the first occurenc
  609. Issue with Sort
  610. Master file that sorts data into sub tabs
  611. some squares on status bar
  612. Create 3 dependant lists from one list
  613. Remove formula and keed data using VBA
  614. Group policy screensaver - turn it off!
  615. simple text
  616. Vlookup slowness
  617. Find a row with a given value in column A and delete all rows belo
  618. Closing a file
  619. HELP No return data from my stored procedure
  620. write to word
  621. keep losing vba macros for IRibbon menus
  622. Failure to execute Private Workbook_Open
  623. how to refer to a merged range value
  624. Importing XML records individually
  625. Email using Outlook
  626. Number discrepency
  627. Do ALL labels at ONCE
  628. Execute code from book1 of code from book2
  629. Creation of Import Files
  630. Excel crashing on macro execution
  631. Excel 2002 VBA macro deployment troubles
  632. How can I access a webcam from Excel using Visual Basic?
  633. executing stored proc from Excel
  634. how do I enter a formula to work out tangents
  635. Problems manipulate excel2003 via .net
  636. Name range example
  637. Function to search different worksheet
  638. Refresh data
  639. Excel Sub / Functions
  640. Transpose data using Vba
  641. Find & Count text within a cell
  642. Using userforms to edit cells
  643. duplicate row based on calculated number of months
  644. How can I test in VBA what edition of Office a user is running
  645. Optimisation Required - Tech Heads to the Resue!!
  646. How can I popup instructions using VBA?
  647. Looking up and reporting values across tabs
  648. Recommend a good book to learn Class programming
  649. Application-defined or object defined error
  650. Convert string
  651. Bug using "Microsoft Visual Basic Help" in debug mode ?
  652. Bug using Help in debug mode ?
  653. VBA code to erase an array element returning Error 2042 ???
  654. Sheet Dimensions
  655. Require macro to create toolbar in xl2007
  656. Autorun
  657. autofilter problem
  658. Conditional Formatting
  659. Conditional formatting of a Command buttton
  660. Excel RTD function calculates functions twice
  661. Drop Down List Referring to a Named Range on Different Worksheet
  662. Issue with refreshing pivot tables in my code
  663. Issue with With statement
  664. Disabling automatic hourglass cursor whilst VB Code running
  665. fill cell comments automatically
  666. Run-Time error 1004 issue just not making sense
  667. Automatically copying formatting
  668. How to avoid macros getting disabled
  669. macro - copy all rows with colorindex 36
  670. HELP with App_WorkbookBeforeClose!!!
  671. My macro doesn't work with other people's computers?
  672. VBA - specify where data is placed on new sheet
  673. Excel help needed
  674. Run VBA on any file open
  675. Application.Quit out of Do loop
  676. VBA code syntax vs XL Conditional Formatting & Watch Window
  677. solver
  678. [Office 2007] Ribbon scaling
  679. [Office 2007] Ribbon scaling
  680. excel build query from cells
  681. Include new column (from macro) in pivot table
  682. Change Background cell color depending on date and last value of c
  683. Array Help
  684. HELP "has too many arguments specified" error
  685. Quick XmlImport Compatibility issue
  686. Excel 2000 macro to warn before sorting
  687. Putting in an if statement
  688. if statement that tests format of cell
  689. sh.Cells.Find()
  690. Writing MACRO
  691. VBA Digital Signature for macros dropped
  692. code modules included in sheet count?
  693. checking if user selected cells are within a specified range of ce
  694. Future support of Visual Basic for Excel
  695. Reading MDI Files
  696. indicate activecell range
  697. Formula Conditional Formatting
  698. Hide Macro Actions
  699. Formula Conditional Formating
  700. Can I have the TAB name be a calculated field...?
  701. Insert Multiple Rows - variable
  702. Excel 2007 on server
  703. Help converting a macro from Outlook2007 to Excel2007
  704. Pivot Table Emailing
  705. Pivot Table: Show Description instead Name
  706. Text currency to number
  707. Remove VB code from a sheet
  708. Excel VB: Turn Off Display
  709. [Office 2007] Auto-hide ribbon toggle button and control recent do
  710. Password protected workbook
  711. How to override windows settings for date?
  712. UserForm
  713. find multiple criteria
  714. Validation OK to named ranges in Veryhidden sheets?
  715. Where to check authorisation of computer and username
  716. Create Outlook Meeting Request from Excel
  717. SUMIF FUNCTION
  718. trouble using functions from Strings library
  719. For Each and Collections
  720. registering Help Context IDs automatically
  721. Suppresing Insert Row fuinctionality
  722. hyperlink
  723. compaq visual fortran dll
  724. Use of IF function with years and months
  725. object variable or with block variable not set mean
  726. Creating Excel simulation in VBA
  727. Exporting Logo from Access 97 to Excel 2000 by copy and pastespecial is stopping Cell A1 selection
  728. Need a little help with loop(ing)!
  729. Copy cells from work book then auto close without losing data
  730. memorize cells position
  731. Iterating through a collection (For Each)
  732. Calculation mode and recalcs
  733. Insert pictures
  734. How to generate Bar Code by Microsoft Excel
  735. Run time error, Open event, Wbk is Read Only
  736. Enter "Empty" if cell is blank within a variable range
  737. Hi-lighting items in a multi-select List box
  738. Conditional Format on copied worksheet stop working
  739. Function Excel:If a Date>actual date create a RED alert in a cel?
  740. Macro that can switch between tabs
  741. Parsing string to multiple columns
  742. Row Insert, Add Text, Add Formula
  743. execute macro on Worksheet selection
  744. Excel VBA dead ?
  745. non r1c1 name definition
  746. turning Excel into a monthly budget
  747. Hyperlink to a Particular Cell ---- but allowing flexibility to add new rows and still keep the link
  748. Excel 2003 user functions.
  749. VBA code to insert rows in table
  750. make chart points interactive