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 Rows From Worksheet Into Another Worksheet Same Workbook
  2. Excel Automation - Export Txt
  3. Worksheet button question
  4. Excel question.
  5. ActiveX Control in VB.Net
  6. Problem with multiselect listbox items selection
  7. better way clearcontents column?
  8. VBA code for INDEX MATCH Functions
  9. delete macros by macro
  10. Web services
  11. Set Global Variable Inside Object Module
  12. Copy Values From Worksheet to another Worksheet same Workbook
  13. .Value = .Value - Error
  14. Preset fields in Lotus Notes Code
  15. Add New Sheet when Multiple Sheets are Selected
  16. Check boxes
  17. Send mail problem
  18. VBA to open a shortcut to a workbook
  19. How Can I gets avaliable list of all criteria in autofilter
  20. With stmt and Range
  21. counting responses
  22. Running an excel macro from the task manager
  23. Trying to clean up code that I did through a record macro
  24. MouseUP event
  25. subtracting column from column
  26. another group archive
  27. Load user form??
  28. Pivot table
  29. Trying To Append String Variable To Another String Variable
  30. Chart runtime error 1004 please help
  31. commandbars.add problem
  32. Error Search
  33. OR clause doesn't execute the last condition
  34. Applications Extensibilty 5.3 Problem after upgrade
  35. password protect
  36. An Unhandled Win32 Exception
  37. How can I load a user form from within a worksheet subroutine?
  38. How can I load a user form from within a worksheet subroutine?
  39. named range
  40. Information from numerious excel worksheets
  41. Opening numerious excel files
  42. Page Margin Setup
  43. Aqua buttons
  44. Reading the PrintArea Pages
  45. Automate CD Changer
  46. Sum a column of data
  47. 5 Bells Ring Sound
  48. Trouble making another worksheet active
  49. linking the selection of a drop-down list to a quanity in another
  50. Macro in Excel 2003 will not run
  51. control should go to next cell
  52. built myself into a corner, how to exit gracefully
  53. Opening and retrieving information from numerous excel sheets
  54. Opening Message
  55. Sorting problem
  56. Copy Rows From To CSV File
  57. Enumerations or Collections
  58. Creating XML
  59. Form won't update!
  60. ExcelMedic.com
  61. Debra Dalgleish's Excel file that displays a comment in a cell instead of a pop-up
  62. custom icon in custom commandar
  63. Locking RAND()?
  64. How to make a few rows visible and hide some others ... faster
  65. Textbox filling cells
  66. Name.Add problem
  67. Find next blank column with Macro
  68. Stuck in endless loop, HELP!
  69. SQL
  70. Saving format detail of entire row/column
  71. Get names of all workbooks in a directory
  72. Stop the Debug option from coming up
  73. Debugging Help
  74. Colour change by date
  75. Deleting a sheet with the same name
  76. hiding rows
  77. Debug window displays for no reason
  78. Problem with Excel reports ::::Excel 2003 Migration To Excel 2007
  79. Problem with Excel reports ::::Excel 2003 Migration To Excel 2007
  80. AJAX : Dynamlically pushed JavaScript not working after Update Panel is updated
  81. Speed of Execution
  82. Calculate Last Digits
  83. Protect Workbook Code Queres
  84. SQL query from one excel worksheer to another one in the same book
  85. How do I tell when a Shelled Process ends?
  86. Can I automate the checking of the "Solver" box in VBA References?
  87. Code that includes Solver taking extremely long time to execute
  88. Selecting portions of a column instead of the whole colum
  89. Help with drop down list selection
  90. Help with code assistance
  91. Copying certain rows to another sheet
  92. Using Vlookup in vba not working or ending w/ error 400
  93. how do i use range of value in same cell example 1 to 100
  94. Determining the cell position of an object
  95. COUNTIF on changing range
  96. Data Validation used with VLookUp function
  97. test for next group doesn't work on the last one
  98. Copy ActiveWorksheet Columns B,C,F to Another Worksheet in Workboo
  99. vlookallsheets across workbooks
  100. Printing multiple named ranges on one page
  101. Random Select
  102. Autofilling Lists based on prior list choices
  103. update form
  104. Insert and lock picture into a cell
  105. Using Application.OnTime within a class module
  106. make cell appear blank if no date in that row
  107. need to make cell blank if no data in previous cell
  108. ADO SQL
  109. Delete Rows If Date Less Than Date Value
  110. can we hide the steps of a macro
  111. Looping : For... Next problem
  112. Can someone do me a favor? small script
  113. Create Outlook Distribution lists in Excel VBA
  114. Dealing with date formats on expiration date
  115. Color in Cells without Showing Up in Print
  116. I am getting duplicate decimal points on numeric validation
  117. Column Differences
  118. Making a Chart with VBA
  119. Is there a free RAM requirement
  120. Application.Calculate
  121. help with macro
  122. CSV codepage Excel 2003
  123. add some text in a cell that has just been inserted
  124. copy sheets to workbook and save as sheet name
  125. Cascading Style Sheets import into Excel
  126. how to get excel to calculate from ASP?
  127. Alternative to SendKeys for field that' not in tab sequence
  128. ELSEIF for multiple if ??
  129. Copy Cell Content to CSV file
  130. Context Menu Commandbar Question
  131. Context Menu Commandbar Question
  132. Programming the filter of a pivot table
  133. Print Performance in VBA
  134. Help with macro?
  135. dynamically linking subsistent worksheets to a master worksheet
  136. Texttocolumns and Date Format using Macro - UK International setti
  137. Error 1004 in WorksheetFunction.VLookup
  138. adds rows to all service groups except the first one
  139. Sorting a column with numbers into descending order
  140. Linking Workbooks
  141. Show / Hide Label
  142. Worksheet copy doesn't copy formulas
  143. Do while
  144. Macros and Formulas
  145. excel macro question
  146. pivot table
  147. Combining cell entries to one cell with code
  148. Disable Macro
  149. papou..Can you
  150. Changing file name for a data import from a text file
  151. Remove opening dialog box
  152. Cannot see my combobox on my worksheet??
  153. E-mail Each WorkSheet in collection to pertaining Manager
  154. Help with this code
  155. Worksheet Change: Display/hide columns depending on date
  156. Unhide All VeryHidden Sheets in a workbook (w/o naming them)
  157. Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.
  158. Run Sub from Button
  159. export chart as wmf
  160. #VALUE error on VLOOKUP of text
  161. rows to columns and colums to rows
  162. Macro that will sort and create different worksheets
  163. pop up window and protection of sheet
  164. Sum Product in Excel
  165. VBA drop down list help
  166. Verify correct cell
  167. Programmed error messages
  168. Using ADO Recorsets in sql SELECT sentence
  169. Add multiple IF statements
  170. Stock Quotes
  171. Saving format of row/column
  172. get column name
  173. Placing time with date
  174. HLookup Problem
  175. Click tool question
  176. Disabling or Restricting Web Page Preview
  177. Last Save Time for non active shared workbook
  178. How Can I gets list of all criteria in autofilter for any column
  179. Passing a string to Case statement
  180. Macro to delete 'tick' Character
  181. Call a procedure whose name is stored in a variable
  182. Change from row to colume n colume to row
  183. run macro only in certain file/worksheet
  184. Changing color of text added to a cell via a form
  185. Help! Serious problem with Excel and embedded files
  186. End property
  187. Fill each time one cell/row with a specific number,for defined col
  188. How do I write code to enable drag/drop from ListBox on UserForm to a cell.
  189. filtering?
  190. ? Object What object
  191. Data validation drop down list selection change
  192. vba entering a formula in a certain cell
  193. Sheet Range copy - error on destination
  194. graph of y=ax+b in excel
  195. Deleting column in a worksheet that is not active worksheet
  196. find, copy and paste
  197. Strange Right-Click PasteSpecial Behavior
  198. How to include boilerplate "terms of sale" below range
  199. Printing worskeets in several workbooks
  200. problem with active cell
  201. Names referring to valid range in the active workbook
  202. adding some rows in the middle of adding some other rows
  203. String to Variant conversion
  204. how to make chart on selected range?
  205. data over formula
  206. Run code only when a sheet has not been changed
  207. Moving numbers to different months
  208. calculated field
  209. Goto Worksheet with Defined Range Name
  210. IF
  211. Import Text File into Spreadsheet
  212. Macro or other code for deteming Months, Years, Quarter based on d
  213. Font Keeps on Shrinking
  214. Function ACOS in Excel VBA
  215. algorithm to add 20 rows at half way point & at beginning
  216. Listbox Locked After Adding ListRange via VBA
  217. Macro Free Workbook?
  218. Dates from InputBox
  219. Macro Fee Workbook?
  220. An empty cell = An empty cell ???
  221. Referring first row in range
  222. Conditional color formatting in a pivot - possible ?
  223. Simple VBA code questions
  224. Calculate and UDF
  225. Close other open excel files
  226. VB Code to link to website
  227. SheetName Worksheet Function
  228. macro/vba for a range of hyperlinks
  229. Compile Error - Help
  230. count used rows
  231. Specify an Outlook folder for already successful Task creation procedure
  232. function for checking for an odd number
  233. hide non active sheets in workbook
  234. Dim xxx As String & IF?
  235. Collection verses array
  236. Worksheet Calculate
  237. code that searches for current date
  238. Vacation Accrued /Sick Days Accrued
  239. menu bars
  240. get external data - new databse query speed help
  241. Macro for Menu at start up
  242. VBA---Tools--References automatic
  243. Filter a pivot table in a macro
  244. Thank you
  245. help with macro
  246. Excel Object Model
  247. Minimise worksheets
  248. VLOOKUP Trim vs. No Trim
  249. How to set a range equal to cells greater than 0 (Column "A" only)
  250. Deleting rows
  251. Using a cell value to trigger macro to run
  252. color font for listbox column
  253. renaming a workbook
  254. add-in, data in Add-in file (woorksheet)
  255. Solver working intermittingly...tried some previously posted solut
  256. conditional colour of cell
  257. Days added to a date
  258. Numbers to Lexicographic Index Number (CSN)
  259. Repeat entries in rows 5 & 6 into next blank column
  260. Change Excel Title Bar/Caption
  261. filter on date
  262. application.run
  263. retrieve ping status in ms excel
  264. Missing Excel Workbook Template - with VSTO SE installed
  265. extract pictures from excel file (c#) ?
  266. try to log in to web site by using excel vb, but not sure the butt
  267. Insert a blank row in a Pivot table
  268. Combine 2 IF STatements
  269. excell programming
  270. Email Using Template
  271. concatenating text with address reference
  272. re: click button to go into the web site but not certain where to star
  273. Date format changed after saving to .csv
  274. Verify two sets of data to find mistakes
  275. Range Validation property not working w/ Protected worksheet
  276. Registry is not updated
  277. Problem with Data Validation
  278. Query Data from MS Query
  279. return a concatenated formula into a cell
  280. first time array help
  281. returning formula into a cell
  282. Formula Help
  283. Expanding VBA to include more than one column
  284. Delete Hard Return; Special Character
  285. Trouble with cell value
  286. help with a spreadsheet
  287. Noob Question 3
  288. for loop doesn't advance
  289. Converting numeric Part No. to text
  290. Find next open row in a column
  291. Suggestion for books to learn VBA , Macros and User Forms
  292. Import CSV files into template
  293. Noob Question 2
  294. Loop through a range using a specific start and end
  295. SUM in Userform
  296. Re: Selecting a Range
  297. label on top of a listbox
  298. Variable rows to repeat
  299. Selecting a Range
  300. Programmatically maximize a userform
  301. Delete Row if Col. H contains either"Current Period" or"Year to Da
  302. how to Add a command button to the standard commandbar of the visual editor window
  303. Noob Question
  304. Filter
  305. name of calling routine
  306. Find used range and ignore blank cells when running macro?
  307. extra excel style
  308. Not enough memory for OLE checkboxes
  309. copy selected cells to new sheet.
  310. Delete Columns if rows 8 & 9 are blank and place border
  311. Listing the files from a directory
  312. how can i run a macro from a formula
  313. error handling for network connections
  314. Auto calculating the month end
  315. Remove Text for a text file
  316. RE: Get a total when number or rows is not know in advance
  317. Re: Get a total when number or rows is not know in advance
  318. How to let write only some simbols in the cell in Microsoft Excel
  319. Get a total when number or rows is not know in advance
  320. Excel Cannot Complete this task
  321. code to change color of negative cell
  322. Copy Workbook, Formula Not Working
  323. Moving blocks of data across worksheets
  324. What is wrong with my code??
  325. copy function
  326. Run time error 3085
  327. Insert formula in multiple worksheets & copy output to new sheet
  328. range object error
  329. On Key press
  330. compare cells in a column for duplicates
  331. Cursor movement upon an event
  332. Find Unique Records; Must Use Fuzzy Logic
  333. Find and copy duplicates to new worksheet
  334. Excel / Access User Conference - Oct 24-26, St Loiuis
  335. QueryClose problem
  336. Closing IE windows from VBA
  337. Help with Macro Error Message?
  338. keep on working while userform is active
  339. Pivot table: showing COLUMN summaries for some, not all, COLUMN fields.
  340. Accessing events of com objects
  341. Code to Check for Pivot Item
  342. Custom Menu
  343. Passing Form Values
  344. afterprint event?
  345. Calendar Control missing
  346. events=false not acting?
  347. Changing the default value of the tab key in vba
  348. math applications and formulas
  349. math applications and formulas
  350. last used cell function
  351. Populate Spreadsheet #2 from Cell references on Spreadsheet #1
  352. Incoming curve ball (still coming)
  353. Conditional Formatting while working with 2 columns
  354. Cancel Ontime routine
  355. Removing blank lines in a workbook
  356. Apply a R1C1 function to a specific range
  357. Parent/Child Macro
  358. Automated data logging with excel
  359. Automated data logging with excel
  360. I need a formula for some calculations...
  361. Select multiple sheets on a dinamic context
  362. Closing Form on pressing Enter or Return-key
  363. How do I create a list from another list with exclusions (such as blank cells)?
  364. ADO to pull data from Access query
  365. Customise Header
  366. right-Alt with SendKeys
  367. Range("A1,F96").Select - What's wrong with that?
  368. Error when returning user-defined class from "factory" class...
  369. File, Save changes all dates in column to 1/0/00, created with VBA
  370. Format sheet after importing a csv file
  371. add empty space in formula
  372. speeding up this code
  373. Re: Syntax - Loop through rows in a selection
  374. Syntax - Loop through rows in a selection
  375. VLOOKUP on 2 sets of criteria
  376. Can't print only 1 page wide-what am I doing wrong?
  377. Do Until Loop Not Working
  378. Do Until Loop Not Working
  379. Pasting formats in without conditional formatting?
  380. Re: Copy macro to a new book in 2007
  381. Copy macro to a new book in 2007
  382. Solver not working for me
  383. Macro triggered by an event
  384. Copy macro for a list box
  385. VBE Tools>Reference question
  386. Help! ... need to vlookup but can't make it work!
  387. VBA Vs .net components
  388. Looping Down a column
  389. VBA on error next .....
  390. If function and math formulas
  391. sum multiple named ranges if they exist
  392. Re: Looping through TextBox's
  393. Looping through TextBox's
  394. list of all cubemembers
  395. Clicking on link from VB?
  396. Populating a List Box
  397. Looping through images on a userform
  398. Implement Excel cell function using VSTO
  399. UniqueItems Array
  400. FormulaR1C1 v Formula
  401. For Statement
  402. How to find internal connection
  403. Cell content shows up in Print Preview but does not print - why?
  404. Sum of Value for duplicate number
  405. exiting the whole macro
  406. removing cell formulas
  407. Getting unexpected error message
  408. Unable to 'Drag n drop'
  409. AddIn
  410. VLookup in VBA
  411. Recalculate to hide rows
  412. Query - Through User form ?
  413. Saving as *.csv or *.txt with double quotes
  414. Excel with IE problem
  415. extract data from backend, display on frontend
  416. macro to scroll the worksheet and continue to run macro in backgro
  417. WEB query for zipped CSV file
  418. on data add formula
  419. Re-organize data in Excel - I need help
  420. How do I display Unicode Text on UserForm.Caption
  421. Licensing an Add-In
  422. Add-In Toolbar Control - Removing The Toolbar Question
  423. VBA Code to delete duplicate and extraneous data
  424. Validation Code Problems
  425. Two Pivot Table VBA Questions
  426. columns in refedit to a combobox
  427. Clearing Cells
  428. combind print copy amount
  429. update newbie
  430. Excel-How Do I prevent data conversion to date format
  431. Links
  432. Inserting page break conditionally
  433. Insert row code
  434. Minimise unwanted windows
  435. Invoke macro on Autofilter Criteria Selection
  436. Links
  437. When is a Loop Necessary ?
  438. can not locate the internet server or proxy server
  439. Named Range
  440. Find last cell with matching value
  441. Could I jump to another Sheet by clicking on a cell
  442. convert all formulas on a worksheet to aray formulas
  443. Disabling a forms 1.0 button
  444. Avoiding Redundancy (.Find Method)
  445. can an excel file compiled on a Windows PC be used on a Mac computer?
  446. commandbutton?
  447. saving an excel file with a serially increnmenting number
  448. Extract several variables from textbox content
  449. Copy Worksheets Into Master Workbook
  450. Create a macro which takes a column name and width and sets the column width to what it should be
  451. Works when stepping thru only
  452. Re: Rounding Up & Down
  453. Rounding Up & Down
  454. Web Query
  455. Custom VBA Code
  456. Email question
  457. Check SpecialCells(xlCellTypeBlanks) for >0 blanks
  458. I want to format a worksheet based on values in another worksheet
  459. Values from a range in one cell, seperated
  460. Any ideas of integrating Unix with Excel?
  461. Executing an FTP call
  462. Want to access the SUBTOTAL of a list from within a worksheet
  463. Import data from Microsoft SQL Server into Microsoft Excel
  464. Tag/Identify Cells
  465. Deleting characters to the right in a column....
  466. If function with average fomula to be tru or false
  467. Rounding error???
  468. How to reference variable worksheets and variable row
  469. create a series
  470. Select First Row to Last Row
  471. How Determine, cell has got reference.
  472. works and doesn't work
  473. how to have arrows appear on a form
  474. text box or list box values get sent to email distribution list
  475. Sort & lose links
  476. iif() function
  477. iif() function
  478. how do I make the title bar disapppear
  479. list box that has text that has hyperlink qualities
  480. Get row number using input box
  481. 1004 error - can't find text file to refresh ...
  482. Disable 2003 VB code for users using older Excel
  483. Start a macro when click on tab sheet
  484. Dates: How to check if date value is 10 months and or 1 year old?
  485. AVERAGE, STDEV, SEM with criteria
  486. Code problem working with QueryTable
  487. Single quote in sheet name
  488. restricting other applications from being opened when running a macro
  489. How to change the colour of a line
  490. Textbox Value Changes
  491. divide and copy rows
  492. Select & deleting all rows based on the contents of a cell in the
  493. Add a character to all cells in a column
  494. RE: format all column width
  495. Help with SQL and ODBC Text Driver
  496. format all column width
  497. Help with building a formula based on cell values
  498. RE: SUMIF
  499. Deleting Values in a Row based on a Certain Criteria
  500. Conditional Formatting help
  501. RE: SUMIF
  502. SUMIF
  503. Macro Copying Rows That Change Dynamically
  504. Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul
  505. insert an ICON in a cell
  506. Searching and storing Column Number
  507. How Do I list all range names in a worksheet
  508. Additem to ComboBox using the Column Property
  509. Save copies in different places
  510. Evaluate an Array Formula before inserting it in a cell
  511. RE: UFD to change color based on string
  512. Cut button is disabled
  513. UFD to change color based on string
  514. How does data validation work
  515. Hyperlink created with a macro, altered on save.
  516. Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..)
  517. I Disabled the Find Dialog Box?
  518. Professional Excel Development Chapter 5
  519. Delete Rows if any cell in Column H is blank but do not Delete Fir
  520. Help, One form Closes another Form when closing itself...
  521. "Run application" based on condition...
  522. Sorting on more than one column
  523. complicated search and extract.... i think
  524. Using or loading external code
  525. Calling a Public Function
  526. AutoRun Macro with a delay to give user the choice to cancel the macro
  527. Problem with 'Popup Menu' visibility
  528. generating a #VALUE
  529. VBA to autofill next blank cell in same column
  530. FieldInfo
  531. wrong calculation ?
  532. find word initial then final......
  533. Visual Basic Editor Layout
  534. More Efficient IF
  535. More Efficient IF
  536. Password Protection
  537. Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows.
  538. HYPERLINK TO FILES IN A FOLDER
  539. Can't right click embedded objects
  540. 2 Dim Arrays & List Box
  541. Insert row on multiple sheets
  542. Problem: Workbook contents vanish
  543. Ws Selection Change Event Code, Copy a Cell problem
  544. Comparing 2 files on date/time stamp, and based time difference do a subroutine
  545. Create VBA Function/Sub programatically within Excel VBA
  546. How to hold Macro running?
  547. VBA Forms
  548. System Call Failed
  549. calculateing cells on demand
  550. Formatting after Importing
  551. CopySheet After
  552. validation
  553. Trigger wrong time HELP
  554. Limitations to Excel Add-Ins
  555. Question about Pivot Tables
  556. Want to get text entered in a Userform TextBox after hitting Tab o
  557. Use Custom Document Property to identify xls files not yet process
  558. Conditional Combo Boxes
  559. VLOOKUP cell Address
  560. Delete Empty Series from Chart
  561. Adding "Add-Ins..." control to custom tooolbar
  562. Excel- find the last filled cells in column with empty cells
  563. Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio
  564. Evalute Array Formula in VBA code
  565. Load Value into textbox
  566. Append character to cell
  567. Notes "DocLink" Icon in a cell
  568. Last Row in Formula
  569. trying to use PasteAndFormat method in Excel VBA is not working
  570. changing active printer for Word.
  571. Vlookup in another workbook
  572. Solver Iterations-how to change number
  573. Export worksheet to .csv
  574. UserForm & listBox
  575. Countif to changing range
  576. Using vLookup function in VBA
  577. Help in connecting to MS Access
  578. tracking updates
  579. Update Pivot from datasheet in different folder
  580. Finding Duplicates in a list
  581. Creating 1 row from n rows using concatenate and if then statement
  582. Display message if "find" command comes up blank ??
  583. change values in a column
  584. Find a string
  585. Want to use Excel to parse a text file
  586. help statement unfinished
  587. Last Row in Column not working
  588. Optional Arguments in Custom Fuctions
  589. Protecting validation
  590. Error handling help
  591. Lists from other worksheets
  592. Removing hyperlink without removing the font settings /border sett
  593. Find Multiple Values, Copy Entire Row & Paste
  594. Mulitple If Statments
  595. Looking up the value of a cell in a named range
  596. Combined text and variable in a message box
  597. Need help on Excel macro.
  598. dynamic value not copying correctly
  599. Change hyperlink property to new location
  600. Protect Code
  601. Name of Added Worksheet
  602. list of all cubemembers
  603. Data recognition help
  604. Copy multiple values into a single cell
  605. Travel through no of sheets in a workbook.
  606. File format conversion on server
  607. Problem with script, please help
  608. Hiding rows
  609. File Link
  610. Moving up one cell
  611. What are {}, how do you use them in IF statements
  612. CopyFromRecordSet extremely slow
  613. Copy, Paste Special Values all sheets in workbook
  614. Managing objects in VBA ( specifically good practices with destruction)
  615. selectionchanged event
  616. Synchronous execution using shell function
  617. Email
  618. Accessing cube functions (ie cubevalue) from VBA
  619. Can i hide specific data series in an excel chart yet show the values in the legend???
  620. protection,distribution
  621. SQL doubts
  622. Can this be Done?
  623. replay from a database through RTD
  624. load .xla addin's when open Excel sheet.
  625. Excel cannot complete this task with available resources
  626. UserForm with ListBox
  627. Extract Data
  628. Select next Cell Down
  629. Automate Formatting to Changed Pivot Table
  630. Trouble exporting using Chip Pearson's export
  631. Web Queries
  632. supress display during execution of an excel macro
  633. Re: How can I remove leading zeros?
  634. How can I remove leading zeros?
  635. Beforesave - Save copy on my desktop
  636. Popluating data from ms access
  637. Delete variable # of rows depending on conditions
  638. Restrict area where I can use button with macro
  639. How to Set Focus a row - Option Button Click
  640. Lookup Code
  641. Conditional formatting
  642. Use a Piece of Data for File Name
  643. hide vba code
  644. Access VBA outside of Excel
  645. Accessing data stored in the worksheet (named range) in .xla file
  646. Workbook contents disappear
  647. Help! creating code for time to decimal calculations
  648. Formulas not working
  649. VBA6 cores when hitting Reset button on the VBA IDE
  650. Adding New Workbook
  651. FORM Drop Down issues
  652. Clear data in a FORM row
  653. Making calculations with times.
  654. Workbooks.Open Fails
  655. Variable coding
  656. WorkBook Open & Right Before Close Subs Not being called
  657. in vb, what is the 1-line code of assigning a macro using click
  658. Button to change view location
  659. Can not read file
  660. Help. Converting word to PDF
  661. Determine Workbook Mode
  662. counting weeks and days between dates
  663. Detect New Worksheet being added
  664. Trouble with Sharing Addins
  665. Sending data to excel
  666. Workbook contents vanish
  667. VBA access to call stack
  668. LEFT(D2,3) but no spaces
  669. Adding leading zeroes to selected alphanumeric cells
  670. Copy specific range from files in folder => enhancements needed
  671. Rename an Array
  672. Application.Caller Problems
  673. Absolute Reference to the Left Until Change in Row
  674. Loop to specific rows
  675. Excel creates massive files on calling vba workbook.save method
  676. Date Query
  677. Activating Javascript with excel Part 2
  678. Input box to allow user to select column
  679. linking data from text file on ftp server to excel file
  680. Is there a formula that I can use that will give the row data?
  681. How to select Cell address between Specified Range
  682. Using DEC2BIN(range,6) in VBA Code
  683. Slow Calculating and optimizing
  684. Syntax problems
  685. Sub to clear range above n below diagonal
  686. Macro Question
  687. Sub Vs. Function
  688. Need thoughts on integration approach
  689. Checking cells for value
  690. displaying a information window on opening an excel file
  691. Problems on XLSTART DLLs in Office 2003 SP3
  692. Check overlap sunday/weekend
  693. copy unique values to validation list
  694. Remove VBA code
  695. Highlight a row
  696. Problems with Web Query
  697. Hidden formulas.2
  698. double click macros
  699. Automating Excel Macros
  700. Writing hex numbers to a binary file
  701. how to change 1 line of data to multiple rows again...
  702. How to zero out non-contiguous ranges
  703. Worksheet Calculate
  704. need macro to add 100 years to a selected range.
  705. Office (Excel) 2007 & 2003
  706. Please help with Loop
  707. Calculation state
  708. Please help me find veryhidden sheets
  709. AutoFit - Merged Cells
  710. Save Textbox "" value
  711. EVALUATE Method and arguments
  712. Object varaible or With block variable not set?
  713. Finding the first blank cell in a row..in column "A"
  714. Specify Image Location?
  715. preserve last row while looking through a column of duplicate information
  716. How do I Import a spreed sheet
  717. macro save as delete original file
  718. Can I "hide" the database login info?
  719. Wrap Text Format
  720. Close/Delete corrupt or open spreadsheet
  721. Random Number Genarator
  722. Show cell value based on list selection
  723. VBA VLookup or equivalent
  724. Form
  725. Formatting Word Tables
  726. Sort columns by color
  727. Browser Functions Problem
  728. How can I lock the header cell so it's not alphabetized?
  729. count if and format ranges
  730. Access to hidden sheets
  731. Building a Phonebook
  732. button macro
  733. Printing with restrictions - VB
  734. how do I get donor names to list by alphabet
  735. What is the #define equivalent?
  736. Redim with string input (MATLAB Zeros function)
  737. Formula to capture Document Properties
  738. how to copy first 2 characters only from prior cell
  739. INVOLVED - I Suck With User Forms...
  740. Datagrid-Flexgrid
  741. Userform design - keyboard to move controls?
  742. Help Files
  743. command button on form to open sheets
  744. Delete Rows based on cell values.
  745. Detecting user cancel out of "File Open" input box
  746. Using validation to move cells
  747. Need help with For-Next block
  748. Need Help Sorting
  749. Data Transfer B/W Excel with Calculations
  750. Displaying different worksheets based on user input