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. VBA compile error with Split Text Function
  2. Extract Data from Text Files
  3. image1.bordercolor not showing
  4. Background Calculation acts as though it's disabled
  5. pass value to excel userform - is there a constructor? how to pass
  6. VBA code to copy and paste by values from one Excel workbook to another
  7. Worksheet Activate
  8. highlight a row when total is in column A
  9. run all worksheet macros
  10. Updating links in a spreadsheet
  11. Listbox Selection
  12. sounds easy but I can't figure it out.....
  13. I receive "isref" when i do an autofill in a column in Excel
  14. Let the user select a range from a window
  15. slower by 10 times by adding an easy function????
  16. Multiple Language in Excel
  17. Another Userform Date Problem
  18. How to break the rowheight limit
  19. Dynamic linking or referencing of cells
  20. Run-time error '1004' - The file could not be accessed.
  21. What can cause Excel to save slow?
  22. VB Script to Remove Letters from a number
  23. Can you ask a chart which worksheet it's data is located?
  24. Trouble Adding Worksheet via VBScript
  25. password recovery tool
  26. Parse Data - Code form Don G.
  27. Open XLS as though an XLT - unsaved copy in memory
  28. Link loses formatting
  29. Referencing Cell Location
  30. Define Range Question
  31. Test if Worksheet is not in an Array
  32. Add result feilds to a pivot table
  33. value doesn't get passed to a sub-routine, loop doesn't iterate
  34. Vlookup Question
  35. Date format problem on form
  36. Loop until X or Y?
  37. Copying non-contiguous cells
  38. is it possible to have excel insert zeros into data??
  39. Inserting a row in excel 2000 although the worksheet is protected
  40. Find Blank Cells and List Each Cell Address in Another Sheet
  41. sorting a worksheet with vb code
  42. Row and Column Reference 2007
  43. Selection.Copy throws an Object Required error
  44. Delete all cells in range matching certain values
  45. Validation Object error
  46. If the sheet exists...., then
  47. Excel running Access query
  48. save Changes and close book
  49. 2 problems with my vbs script
  50. Overwrite saved workbook in VB Script
  51. Real Time Graph
  52. How to use VBA to copy selected data from one worksheet to another
  53. Import Data from txt file
  54. Loop +2, +4, etc. help
  55. Receiving error 1004 - Method 'Rang' of object '_Global' failed
  56. Next Loop
  57. Time Sub
  58. Automatically Selecting "Yes" in an Externally Called Message Box
  59. Set Row Height depending on cell content...
  60. I want to put the text in the cell of column B in front of the the text in column D.
  61. reformat to get more hierarchical view
  62. Kill a file
  63. Goto in a sheet
  64. 2003-->2007"programatic accses to visual basic project is not trus
  65. Copy data and page break settings from 1 sheet to another
  66. Fill the cell in column D if column D is empty
  67. Pivot table Page field content display?
  68. Shell Script
  69. Use AddIn to Open an addtional Excel Workbook
  70. 2003-->2007 recognize if i'm in 2007 or 2003 via code.
  71. How to auto update currency exchange rates in EXCEL from website
  72. Insert line every x lines until end of data
  73. Automation error with XLA addin, fails on commandbarbutton onaction
  74. Help
  75. Data Validation blanks
  76. need to divide value across added rows
  77. inserting page-breaks
  78. Programming the VBE Find/Replace dialog?
  79. Worksheet Arrays
  80. Duplicate value are not being removed
  81. label position affected by wide screen?
  82. for next loop problem
  83. Insert image from Cell value
  84. MockReader.com
  85. MenuItem Check Mark
  86. Worksheet printing
  87. How to Differentiate between a Student's Score of "0" and a Score of Null?
  88. run macro on other computer but not this one (workbook open event)
  89. Connecting to SQL -Looking for best methods
  90. Debug.Print convert vba
  91. Debuging Macros
  92. Probelm with Application.Run Method
  93. time question
  94. Going from total to details
  95. Supress Confirmation Prompt
  96. Auto_open to check for folder
  97. copy columns paste in rows
  98. use of variable in array formula
  99. reverse or flip rows
  100. Sub to write formula results into comments
  101. run macro in workbook open event once only
  102. saving web pages
  103. Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal)
  104. Reverse Values in an Array
  105. Save Control To Userform Toolbox
  106. How to find the most common pair and triplet numbers?
  107. deter worksheet deletion
  108. Loop Until Last Worksheet in Workbook
  109. How to tell if xls is open?
  110. if any range on sheet2 change put "a" in sheet1 cell a111
  111. Data validation
  112. Stopping the confirm popup on file save with same name
  113. Help including exception handling - try block
  114. Importing JPEG data into spreadsheet
  115. Problems Adding Columns--but data close to IV and no hidden objects
  116. pass a variable to a public sub
  117. WordArt
  118. idea which I don't know how to work out
  119. Dynamic Charts
  120. why my excel data lost on cd ?
  121. why my excel data lost on cd ?
  122. Working with column and page widths
  123. array formula in macro
  124. Duplicate rows, based on date difference
  125. Duplicate rows based on date difference
  126. auto run macro on open of workbook if cell a1=A
  127. Invalid page fault in module RPCRT4.DLL
  128. Output 0 to 100
  129. how do I compile data entered using a drop down list
  130. Excel 2000 custom toolbar button macro assignment
  131. Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA
  132. Function to return column where a date is entered
  133. Updating Pivot Tables via VBA
  134. help with calling a sub procedure, doesn't compile
  135. Can I convert years to months in the amortization template?
  136. problem with protecting sheet
  137. problem with protecting sheet
  138. Copying range from selected workbook to open workbook
  139. Can Excel recognize code I didn't write?
  140. Move data from sheet to sheet based on ColA
  141. Text Box - Moving Formatted Text
  142. Import Data from Access/Query Criteria Not Enforced in Output
  143. Help with Saving to a Folder
  144. Userform TextBox
  145. shortcut key to macro variables
  146. Text via ODBC truncated at 255 characters
  147. Recording a macro to copy into a series of variable ranges
  148. how do i create a nomogram in excel?
  149. Read a Range into an Array
  150. VALIDATION USING ALPHA-NUMERICS ONLY
  151. VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
  152. how to programmatically clear Document Recovery entries
  153. FunCustomize - general how-to question?
  154. Help me fix this function
  155. Syntax for getting value of named workbook range
  156. Dynamic Data from Excel to Word
  157. Replacing "IF" or "LOOKUP" formula's with VBA Function?
  158. Help! Can't find bug in program
  159. ComboBox Toolbar
  160. Copy button caption
  161. filtering out duplicate data values
  162. VBA and "If"?!
  163. highlight row / spin button
  164. Lotus Notes email from Excel - formatting body text.
  165. retrieving named ranges from another sheet
  166. generating random cash flow with same IRR
  167. RTD only alive when Excel is active app?
  168. VBA small code error?
  169. hide row + buttons and password protect
  170. Error trapping is not working for errors related to files
  171. comparing a date range within another date range
  172. spin up / spin down
  173. Macro - cell content left then....
  174. Can this be done with coding?
  175. Help, Query Refresh windowm appearing....
  176. Validation of the First Character entered in a cell.
  177. decimal places????
  178. Incorrect data when using xlset with autofilter
  179. list box / scroll bar
  180. Replacing "IF" or "Lookup" formulas with VBA function
  181. UDF with IRR
  182. How can I parse time and address from cell with non standard extra text?
  183. VB Programming for Excel (and Office in general)
  184. Macro Looks for Cell Contents & Performs Action
  185. Custom Filter loses blank rows
  186. excel search function
  187. Saving Files into a Folder
  188. controlling the Range.Replace method.
  189. Special SUMIF Formula
  190. Search and replace using a named array on another worksheet
  191. If certain text is in a cell . . .
  192. Cut & Paste data in new Worksheet
  193. Change font size?
  194. Disable AutoComplete with VB Code for a Single Workbook
  195. Range addressing question
  196. The operation cannot be performed because the object has been dele
  197. Macro security via Windows login name (or other)
  198. Specified dates within a date range
  199. Toggle Button Caption
  200. An executable file to run a VB script?
  201. newbie c++/excel issue
  202. VB to find text and delete that row and three beneath it
  203. reset checkboxes
  204. How to improve my code?
  205. Forms and worksheet focus
  206. Improving this code
  207. Auto select when using Combo box in worksheet
  208. Trying to find an "A" in the last position of a variable length Part Number in Cell
  209. SPC XL2000
  210. msoControlComboBox Value
  211. Does this code Delete pictures or simply makes them Invisible
  212. add in, ribbon, tab menu problem
  213. Relatively easy data comparison Q?
  214. Checkbox Name Change?
  215. Help in calculating # of columns dynamically
  216. Excel 2007 Error
  217. Excel._Worksheet.SaveAs
  218. Filter and Move Row Macro
  219. Find end of column and paste formula in adjacent colmn
  220. How do I set up a formula for greater than but less than in Excel
  221. Capturing cell address and contents
  222. A formula that evaluates the value of a cell relatively addressed.
  223. help with inner loop to search for matching strings
  224. Open text file as text not numbers
  225. Recalc Alarm
  226. User Data form and populating a worksheet
  227. Copy sheet--Some cells more than 255 characters
  228. Double Vlookup Problem
  229. Permission to print from batch job printing Excel spreadsheet
  230. need help on inner loop
  231. commision on multiple invoices with sliding scale.
  232. xlDialogOpen
  233. Applying Bottom and right border
  234. End of data
  235. Incomplete query return, who can help?
  236. look up multiple fields
  237. VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
  238. Highlight the row and the column that the mouse pointer is in.
  239. Capture name of last worksheet opened
  240. Saving Files into a Folder
  241. Export from Access using vba
  242. macro button
  243. Testing for a value's inclusion in an array
  244. Please help! Data Validation is Suddenly Acting Strangely
  245. If Toolbar Exists
  246. remove little green error triangle - how loop through to ignore er
  247. finding minimum value
  248. construction billing
  249. Conditional Formatting
  250. Detecting a single quote from a cells value
  251. Macro to find end of column data
  252. Macro to find end of column data
  253. Multiple Target Addresses...
  254. Copy / Paste Errors
  255. Protect Drawing Objects bug in 2003?
  256. Sub or Function not defined
  257. printer exception, error handler, need to loop through network num
  258. SaveAs matter: How can I save the worksheet on an external .xml keeping the .xls opened?
  259. How to make code waiting until Outlook finishes its job
  260. Data Validation, Dynamic Named Ranges, and Dependant Lists
  261. LINEST & How Nonlinear is it?
  262. Macro Import Excel Sheet into Excel Sheet
  263. Access to Excel
  264. Simple popup box question - font size change
  265. error handler, goto errgetfile
  266. Autofiltering macro does not work correctly
  267. Conditional Formatting / Positive vs. Negative
  268. Searching VBA Code
  269. Macro Selects Directory to Save File Based on Sheet Criteria
  270. How to output a sheet as PDF file
  271. pop up box
  272. Using IF statement
  273. Conditional Testing Glitch
  274. Copy and past as values
  275. Converting CSV text
  276. Set Document Focus to Top of Datasheet
  277. how to reduce execution time of my code?
  278. Text boxes and Spin buttons
  279. Macro question.
  280. Updating pivot items on 3 pivot tables contained on one sheet
  281. Value or Value2
  282. How to copy part of a sheet as a new sheet into another workbook?
  283. Sort by two columns using VB Script
  284. workbookbeforesave
  285. Importing Soccer results from Internet Site
  286. Need help saving an image from webbrowser!
  287. Send an email from Excel VBA
  288. Date Format
  289. Still retuns to begining of range, Please Help
  290. Duplicate a Formula in 1000 Spreadsheets
  291. Determing closing method
  292. Excel memory leak?
  293. Summary of Different Workbooks
  294. Combine data in two columns into one and sort the combined column alphabetically..how??
  295. MS Windows Common Controls-2 6.0 (SP4)
  296. List box in tool bar
  297. Encapsulating Communication Between Objects
  298. Re: VB to identify and delete any text box on a sheet
  299. Programming Solid edge with VBA
  300. VB to identify and delete any text box on a sheet
  301. Answering an Excel generated msg box Yes
  302. Returning to first offset point.
  303. HELP!!! Macro doens't run on clients maschine
  304. copy and paste problem
  305. Macros detached from buttons on charts
  306. Case Statement with multiple checks
  307. How can I find the rowheight and use it in a formula?
  308. just looking for some suggestions
  309. Issue with command button visibility
  310. Command button
  311. Add a Pictures File Name and Path to a cell ?
  312. Hiding entire rows
  313. Merging Access e-mail field into Excel worksheet
  314. Run a macro when I open any file
  315. Help! - Need help with combo box list
  316. numbers change to text
  317. Object doesn't support this property or method (Error 438)
  318. Macro and Today's Date
  319. VB Code generates error on another machine?
  320. Delete a cell when found
  321. VB6 faster than VBA in Excel?
  322. Find All Instances of a Value
  323. Cancel Print
  324. Inconsitent Formula Error
  325. Range column and row using variables
  326. Save file with different names
  327. VBA Excel.WorkBooks.Open can't open an XML format xls file
  328. comparing data
  329. Select Case with Nothing
  330. Compile Error: Proceedure too large
  331. Barra de rolagem
  332. Removing Everything behing 3 Spaces
  333. help collecting data!
  334. Transposing data as it is being returned from an query
  335. Value ( Excel 2007 Version )
  336. MS Windows Common Controls-2 6.0 (SP4) using VBA in Excel
  337. How to speed up sheet copy?
  338. Select Window Containing specific text
  339. Copying hyperlinks with VBA in Excel 2003
  340. Pivot Table
  341. Problem with Excel ActiveWorkbook.SaveAs
  342. Macro to Delete rows on a criteria
  343. Tab through & hit enter through a message box with a macro
  344. drill through to SSAS CUBE
  345. Screenupdating=false not working
  346. Macro for workbook
  347. Data Validation dropdown shows blank choices
  348. Suspend program for data retrieval
  349. how to skip to next instance?
  350. Have the width/height of a autoshape placed in a cell
  351. Add Scroll Bar to CommandBar
  352. Updating pivot items in three pivot tables on one sheet via VBA
  353. how to make merged cells on a new sheet
  354. Filling a Multi-Column Listbox
  355. Align the form to the top left
  356. Programming Comments in Excel 2003
  357. bLANK cELL
  358. Some basic excel skills...
  359. Greg Wilson - XY coordinates of a worksheet
  360. Column headers in CSV file for excel
  361. SUMPRODUCT
  362. Calculation on/off in excel
  363. Looping thru open word documents to find a specific one
  364. Simple i think.... breaking SQL
  365. Create a Macro to Insert a number into a column based on criteria
  366. Excel Problem
  367. Excel Problem
  368. message scroll like stock index screen
  369. Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
  370. VB Question - AutoFilter related - 'Criteria1:' secion of my code
  371. Access variable from form and module?
  372. Auto adjust Y-axis for chart with 2
  373. Cannot open Excel
  374. ChartObjects.Count is incorrect
  375. VBA to sort automatically in a custom order
  376. Excel Hacks - 2nd edition
  377. Progress Bar Query
  378. problem with find and replacing
  379. easy e-mail one
  380. scheduling macros to run automatically
  381. Can this be done?
  382. SUM IF AND
  383. Help with programming Excel User Forms
  384. converting a simple formula into VBA code
  385. creative solutions wanted! No coding involved (yet) ....
  386. Start on select cell
  387. Rename an Pivot Item
  388. passing Nulls to SQL Server 2005
  389. Copying from internet explorer
  390. Select a variable range
  391. Pop up Message box
  392. Macro creating chart gallery giving problem
  393. Divided by zero
  394. OpenXML Excel query
  395. openoffice xlsm query
  396. User Defined Function to run procedure
  397. Change tab colour for active sheet
  398. UPPERCASE, lowercase issue
  399. Getting fields from DAO database and placing them in variables
  400. Loan Amortization in a cell
  401. Toggle common tasks
  402. inserting new row in datatable
  403. optimizer
  404. label_to_number
  405. google newsgroup
  406. Increment Columns by 1
  407. skip to next from if
  408. I've a problem~
  409. Macro Problem TextToColumns
  410. xl2000 vs. xl2003 RangeFromPoint and Grouped Shape
  411. Calendar Control
  412. ComboBox .List problem
  413. Macro
  414. Sorting Items in a ComboBox (ActiveX Control) in Excel 2003
  415. Add Ins basics
  416. deleting rows in large database (+20k rows)
  417. Macro that names a sheet
  418. C# adding textbox to excel sheet
  419. Multiple vlookup and a little extra.
  420. Compound Sumif
  421. Closing without saving and without asking the user to save...or no
  422. web query as background activity
  423. Dynamically populate spreadsheets in a workbook
  424. Logical Formula
  425. Distance Calculation
  426. Need to create cascading dropdowns in Excel
  427. How to generate code from VBA and... run it !
  428. Moving Cell Values Instead of Formulas to Another Sheet
  429. ADODB.Connection Error
  430. macro dont continue after save as
  431. Syntax for looping through rows and columns in Excel
  432. Toggle buttons
  433. Simple For-Each question ... but not for me ...
  434. Range.select error
  435. Adding a scroll bar to a cell to scroll its contents.
  436. macro dont continue after save as
  437. Advice on Using "xlDialogPatterns"
  438. Hide another Office app from xl vba (PowerPoint)
  439. Access to web tables
  440. For/Next Loop through worksheets
  441. AutoFilter results plus show next row
  442. Auto send spreadsheets as email attachments
  443. Finding named range references in formulae
  444. Is there an "On Break" similar to "On Error"?
  445. deleting a cell based on character length?
  446. copy an offset value when select
  447. Update links without opening other files
  448. Updating numerous Pivot Tables in a Workbook
  449. Need Save As Dialog Box
  450. Merging Question
  451. hide menu bar
  452. Sum new Column Added
  453. Vlookup in VBA
  454. need a complete list of Precedents and Dependents
  455. Call Event as Sub
  456. Return all matching cell values
  457. I need to stop this Loop
  458. Excel macro - truncate cell at X characters (left to right)
  459. Validate an account number
  460. Help with Rounding total off but leaving .00
  461. Excel VBA Wookbook Routines
  462. Bloomberg print
  463. Application.quit
  464. 2003-->2007 Mid function
  465. Runnig a macro relative from a form control
  466. Automatic Timeout & exit workbook
  467. column heading
  468. How to prevent a VB dialogue box appear
  469. Worksheets(i).Select - driving me crazy!
  470. UserForm Error 459
  471. data in different work book
  472. Superscript/subscript selected text within a cell
  473. Need to support mutiple Excel versions from C#
  474. Call Search Application
  475. 'OR' Condition
  476. Cell formatting not applied
  477. 2003-->2007 require variable declaration
  478. Logging to a network folder with username/password
  479. Grouping and summing values based on a condition?
  480. Worksheet change event - Spinner button
  481. texttocolumn, limit the number of used columns to 1
  482. Formula
  483. Input Mask - Credit Cards
  484. Conditional Sum Wizard - 2007
  485. Naming multiple parameters/worksheets
  486. Cells orphaned from update precedence tree - test condition?
  487. Sorting
  488. printing formula to a particular Count
  489. Splitting Cells
  490. Excel 2007 - Error inserting column
  491. Sort by find
  492. If Then
  493. Excel drop down lists
  494. How do i hide rows if a condition is met
  495. first and last cells of manually selected regions
  496. Insert rows/copy formulas fro above
  497. Check Boxes
  498. Userform Initialize
  499. Sum using r1c1 style
  500. How to trap auto filter?
  501. insert checkbox to modify cell value
  502. getting System.Runtime.InteropServices.COMException
  503. How to avoid getting the IDE window visible?
  504. Find a Specific Column
  505. AutoText for VBE?
  506. Display caption on Mouse Over
  507. Change Interior Cell Color
  508. Paste Special (Values)
  509. Creating a chart that has a variable data ranges?
  510. Activate code by clicking in cell
  511. Starting New Group in Custom CommandBar
  512. Must reduce file size
  513. green arrow for error
  514. How can Relative Cells/Ranges be Cleared when Rows are Inserted?
  515. web query as background activity
  516. Last Row
  517. drop-down populated from external data
  518. Determine Column Number in a function
  519. c# programmatically grouping a range of cells
  520. Query Parameters
  521. Excel 2003 to Excel 97 macros
  522. Change events
  523. Displaying the results of a Search
  524. Can't find String functions.... Missing library
  525. ActiveWorkbook.SaveAs
  526. VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007
  527. Consider Posting Replies to the TOP!
  528. Not showing Comments,when using arrow keys.
  529. Vlookup, GetDirectories Question
  530. CommandButton still visible until enter and then exit design mode
  531. Closing a Workbook if Macros aren't enabled.
  532. Text to multiple worksheets?
  533. mscal issue
  534. PickList
  535. calculating weighted average cost of capital in a macro
  536. Setting Last Row
  537. VBA Find function does not work for merged cells. Potential BUG
  538. Check if a column is hidden or visible in VBA
  539. Access picture data
  540. How to Create Main Macro File
  541. Custom button-lock
  542. How to interpret my code
  543. vba code...... on update...........
  544. Security
  545. Clear UsedRange except specific cells?
  546. ComboList Source
  547. Loop back to Case vbNo '#2
  548. Autonew
  549. Preserving date format in VB
  550. Convert Named Ranges to Addresses
  551. NumberFormat not working
  552. Refering to the current workbook in a macro
  553. If-Then, with an OR --- not working!
  554. Obtain Value in sheet from C#
  555. Copy hidden sheet and then make copy visible HELP?
  556. run macro on data validation cell change...
  557. Insert and replace row
  558. Send mail using default client
  559. Maximum amount of usercontrols on excelsheet in Excel XP
  560. Still having Filter/Copy problems
  561. copying named ranges to other sheets
  562. How to Export Excel Data for use in a Database Table
  563. Link a column to another sheeet
  564. summarise multiple worksheets
  565. Inhibit 'Save Changes'
  566. Userform questions -- code included!
  567. 2003- to 2007 menu
  568. VBA to make e-mail address in a cell to a hyperlink
  569. Using a macro to protect a sheet after the information update.
  570. adding data to a list
  571. Mulitcolumn listbox - Add Item
  572. noobie question
  573. hyperlink to sheet name where sheet names=cell content
  574. Exporting data to Excel from VB6/VBA
  575. How do you select images progammically
  576. email conditions
  577. Find Last Cell in Range
  578. Goto
  579. Adding custom list and text boxes to the custom tool bar from Excel C API
  580. How can I enable my macro to only open for one particular workbook
  581. Can only open Read-Only Word documents from Excel using VBA
  582. New computer and VBA errors
  583. How to refresh sheet while UserForm is open
  584. Zipping files and using them in a program... Is it possible?
  585. A check box to open and close Columns
  586. Copy Worksheet, Excel 2000 & 2003
  587. Email Upgraded from Office 2000 to Office 2007
  588. Cannot .select
  589. UDF not recognized after conversion to 2007
  590. Not Select locked cells
  591. Copy to Worksheet question
  592. VBA:programmatically invoking menu items from Excel Worksheet menu
  593. Automatically protect cells after updating information
  594. Custom Menu Checkbox
  595. Combo boxes
  596. Do loop
  597. Creating a path to save a file
  598. Using Instr to produce table contents
  599. reading xls file, speed problems
  600. Update Links, Scheduled Tasks and UDFs
  601. Why doesn't this work
  602. Customise Graph Data labels
  603. select case question
  604. Conditional formating for a range of cells
  605. Help - Apply Formatting To Current Row
  606. Copying rows or cells using Java
  607. how to design a form in Excel like this?
  608. Importing Web Page with Hyperlinks into Excel
  609. Random
  610. Sorting a Column of Formulas
  611. Graph Macro range question
  612. Old/New Mp3 Free Albums
  613. Function to Sum A Cell Containing Numbers and Text Abbriviations
  614. Humaneyes sucks!
  615. Humaneyes sucks!
  616. Web query: Want to pause macro while Web query completes refreshin
  617. Conditional Formatting if a certain condition is met
  618. Prevent Saving command if data is not validad
  619. Mail Body
  620. TextBox validation before moving to next
  621. How to Protect MACRO with Password
  622. Question about named area
  623. FillColBlanks - two columns?
  624. problem with find in merged cells
  625. "cell selector" control?
  626. Get count of active (non-empty) rows and columns
  627. Coding the Spinner
  628. Query not returning all the rows
  629. Selection_Change?
  630. Worksheet_Change event
  631. Open tab text file method
  632. Excel VBA Window - Problems with the display
  633. People favourite sites
  634. deleteing peoblem
  635. set olap pivot table selection
  636. How many rows?
  637. PasteSpecial question
  638. PivotTable Custom Field - formula for no value, with blank cell displayed?
  639. convert formula to text
  640. Remote Data Validation
  641. Sheets(2) = 2nd tab? = Sheet2 (Sheet2)?
  642. Comparing data, need help.
  643. Memory jam after too many worksheet copy steps?
  644. path syntax
  645. Find and Replace - delete the remainder of the text in the cell after my Find
  646. have a macro recognize added rows
  647. Macro to split and wrap text
  648. Select File names and select a location of file
  649. how make a random draw of teams of 4 golfers from a list of 40
  650. Pause VB Code to Allow User Input on Worksheet
  651. Help with boolean statment for active row
  652. Menus not working in embedded Excel
  653. Autosort multiple columns, Keep records intact.
  654. SQL query across computer domains
  655. over my head- need function help
  656. worksheet_change can reference excel range on other worksheet
  657. Select any row, copy data from specific columns
  658. 105,000 line XML to Excel
  659. Loop help
  660. User defined Type
  661. #N/A search across multiple worksheets.
  662. Excel datamap question
  663. Autosort but leave header alone
  664. sum only if all are numbers, return 'NA' if non-numbers exist. How?
  665. Save options
  666. replace formula with actual value
  667. Unprotect on open
  668. Use filters from a different sheet
  669. loop to add data in array
  670. How to save clipboard into emf or wmf file using Excel VBA
  671. Check data item is date not text format
  672. Days of the week's special format (i.e., Mon = Mn, Tue = Tu ... Sat = Sa, Sun = Sn)?
  673. Filter and Copy?
  674. IRTDUpdateEvent - Events
  675. Initializing Option Buttons in Excel 2007
  676. Need to Modify Existing Code
  677. Hide rows via Pulldown
  678. Worksheet_Change not changing
  679. Fast Fourier Transform help..
  680. Pivot table using Cube object - data overflow error
  681. Macro Needed
  682. please help me w/ changing my formula
  683. Custum Menu won't dropdown
  684. Excel 2007 used with Oracle ADI
  685. Can Text be Treated as Values for use in Calculations with Numbers?
  686. Open XLT for edit and set Addin to False
  687. Dante's Inferno: Compile Error: Loop without Do
  688. Search Value If Found transfer Data in same row to specified locat
  689. Conditional DeleteRow, if portion of string found
  690. Macro to hide column based on value on another sheet
  691. Use of 'Text to Columns' within VBA
  692. copy paste flexible with vba
  693. Printing solution
  694. Save workbook not macro
  695. Help With Macro
  696. Format TextBox on UserForm
  697. Join Sheets after Running Macro
  698. Which Shape Ran The Macro?
  699. Moving through worksheets and enacting formatting macro
  700. Do Loop
  701. Userform as mini-worksheet? XL2002 on XP
  702. Copy Hyperlinks to other cells
  703. Truncating trailing Chr(10) in Cell w/ Len() > 256 w/o losing Format ...
  704. Complex Formatting of cell
  705. Count If Range?
  706. Code Problems
  707. Update file
  708. StatPro in Excel
  709. Validation List arrow visibility
  710. Late Binding Help please
  711. Run-time error '1004': Methor 'Range' of object '_Global' failed
  712. Run-time error '1004':
  713. Workbook_Open not working?
  714. Copy Paste a sheet to new workbook
  715. Eliminating bland from Data Validation list?
  716. Export cell data to a template in Word
  717. "Enter" event for text box control?
  718. Selecting columns with column numbers not letters
  719. Preserve the formatting of a cell when pasting into it
  720. Is there any way to search image of my local drive with Image name or Image Title, Description
  721. Exception from HRESULT: 0x800A03EC
  722. Excel height and width of a pictures
  723. Noob Question Probably! :S
  724. Disable close button on all froms & MsgBoxes
  725. Help required on creating names using VBA code
  726. MsgBox Label...
  727. Is CopyFromRecordset a bug of Excel?
  728. Please Help--How can I get a Flag, if I try to schedule someone too many times
  729. Conditional formating wiht complex formula
  730. Determining build date of an Add-in
  731. How to reference a named area
  732. asp.net html export to excel - error
  733. Cell Reference for Minimum Axis Pivot Chart
  734. Copy Variable Range to New Worksheet
  735. How to add a macro when Excel window is Restored
  736. Wild Card Search Excel 2003
  737. finding largest value
  738. Search value, if found transfer select data to specific locations.
  739. Sensitivity Table for Financial Model
  740. Dueling events
  741. Install package - registration
  742. taking a .txt email list that are separated with spaces and sort them in to excel cells
  743. HOW TO TURN DEBUGGER OFF
  744. "Live" Advanced Filter (for unique records)
  745. defining range is my plot problem
  746. VBA how to copy a cell value and not the formula
  747. excel save as csv quotation mark
  748. Useful code
  749. Call Workbook_BeforeClose
  750. How do I get this Macro to apply to ALL sheets in workbook?