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

  1. Custom menu problems
  2. Rename Multiple Sheets from a List of Available Names
  3. Date Format
  4. How to rename autoshapes on a worksheet
  5. Copy, paste to another sheet
  6. "Private Sub" v "Sub"
  7. Copying Sheets to New Workbook
  8. Excel formula to calculate Target Grade
  9. Re: Copying Sheets to New Workbook
  10. VBA Password Msg Shows Up Mysteriously
  11. Reduce a value by spliting the data
  12. conditional macro
  13. identifying subtotals
  14. Copy from one workbook to another
  15. Finding last record in month for each of several types of record.
  16. drop down list/box that has formula built in for other cells
  17. Cubic splines
  18. Trying to get data between dates ranges to analyze
  19. Merging Excel data from identical copies of a workbook
  20. Textbox questions
  21. Short List
  22. Paste Small Range into Big Range
  23. Scheduling sending an email
  24. Sorting Protected Sheet
  25. Apply CSS Styles to HTM Output
  26. Check for subscript out of range
  27. how do you set up a progress bar when running a macro in excel?
  28. use macro to insert characters at the beginning of a string
  29. Add sheet to end
  30. dialogue box / pop-up upon opening file - URGENT
  31. Row insert fails to update Sum formula
  32. Help - loop through cells in a range that are not together (several different cells as Target)
  33. Add and Subtract ranges (with multiple cells) in vba
  34. How to e-mail a shortcut to the active workbook
  35. Web Services using vba
  36. Web Services using vba
  37. Converting Excel range to JPG, BMP or PDF
  38. Re: TextBox
  39. Called subs versus functions
  40. help with macro
  41. Hlookup Code Improvement Suggestions
  42. Drop Down list box
  43. Userform Image Control and embedded images
  44. Loops or Do/ while or STEP !!!! A better solution
  45. ebook for Excel.
  46. Windows Zoom
  47. Drop down list box
  48. Emailing Page-breaks as seprate sheet
  49. Last rites declaration of Ioannes Paulus PP. II (Karol Wojtyla)
  50. Newsgroup connection test
  51. Convert Multi-Sheet Workbook to Standalone Executable
  52. Add new worksheet and assign it to an object variable?
  53. Parsing XML data into worksheets
  54. Contains function help
  55. Controlling the Footer of Word Document from Excel
  56. edit cell by macro
  57. 3D sum using VBA
  58. Run Macro from specific cells
  59. error runtime 9: deleting a worksheet
  60. 2 sheets to print
  61. programming excel 97 from .net 2003
  62. Not visible workbook
  63. Zip & Email - VBA
  64. Time conversion
  65. Change the color of a cell change dependant on a result
  66. Help with macro!
  67. Combobox - Sorting Data
  68. Exit Menu Troubles
  69. Copy Range Issue
  70. Help with code
  71. AVERAGE IF formula and not equal to ZERO
  72. Return double digit month
  73. Sendkeys issue
  74. Save As behaviour
  75. cacatenation script
  76. Custom Button Labels
  77. Undo macros
  78. Coloum Width | OS Problem
  79. Scenario Analysis... simple
  80. Dir function resetting
  81. removing file->save as option
  82. Fill a combobox on a form from a txt file
  83. Form Focus and SelStart
  84. auto "page of page" requested
  85. arrays
  86. formName.Show is not working
  87. Sorting macro
  88. Calculate my expenses
  89. How can I delete 1 from the value of a cell when I press a Button.
  90. ListBoxes - RowSource
  91. Conditional Formatting of Rows Based On More Than 4 Conditions
  92. Mouseover or Mouse Move events
  93. How to round all numbers in a worksheet to, say 1,000s?
  94. commandline argument in excel 2003
  95. How do I print a selection of cells using a macro?
  96. Application activation and pasting
  97. How to I use nested quotation marks for 'SUMIF' function in Excel.
  98. pdf printing OFFENDING COMMAND: STACK:
  99. Is it possible to add a 650 character footer in Excel?
  100. Is it possible to add a 650 character footer in Excel?
  101. error trapping
  102. Formula for a Rotating Work Schedule?
  103. 5461 element limit
  104. Extracting from Access
  105. Saving copied info while running a Selection Change Macro
  106. For loop with letters
  107. Code is not correct
  108. PivotTable DropBox's - Reset to New Value / Set Default Val
  109. For each syntax using a worksheet array variable
  110. date in filename
  111. Combo Box
  112. Error on Opening : data may have been lost
  113. Click event on listbox
  114. help with this formula
  115. Opening Excel from VB .NET application
  116. Referring to a cell in another sheet
  117. Creating a password form
  118. minor modification to macro, need to delete cells
  119. IF statement
  120. CDO Email
  121. copy ???
  122. Scope of variables
  123. Excel opens all files in My Documents folder
  124. Cell Precedents
  125. Range ID and drag & drop to a cell
  126. How to exclude a list of number from another list?
  127. Error Trapping
  128. Setting an Open-file password
  129. excel 2002 runtime error 1004
  130. Starting with A2!
  131. VBA color palette
  132. Erratic Behaviour of Buttons
  133. Macro Templates
  134. Macro to Set width of cells
  135. How to disable drill through on total cells?
  136. Passing parameters from excel to access
  137. Ghost of Excel
  138. How can I sort a protected page
  139. Changing Chart Series Names
  140. Puzzling Memory Error !
  141. I want to use hourly update from SQL query
  142. how can i setup formula in excell
  143. Refreshing Linked Picture
  144. Array problem?
  145. Automatically naming sheets
  146. Need HELP with QueryTable, ADO, EXCEL and EXCEL'S Formulas
  147. Copy data
  148. Different Calculations in Pivot Table Subtotal Rows
  149. Save original workbook name, referenced by macros in other books?
  150. Muliple Userforms and multiple Stacks
  151. sorting by 4 categories
  152. Hyperlinks on Protected Sheets
  153. Excel vba code disappears when saved workbook is re opened
  154. Combine "Total" and cell contents
  155. Solver in Visual Basic
  156. help writing formula
  157. how do i setup a macro which is initiated by a button?
  158. Cell.interior.colorindex - does not work in Excel 97
  159. How to check for the existance of a Sheet (or not)
  160. Combobox List - Which Property
  161. 2nd Post - Cannot select day on Calendar if ValueIsNull is True
  162. Books on VBA
  163. variable code
  164. Show method (Error 438)
  165. Adding CC: to workbook e-mailed?
  166. Outputting a formula in a cell using VB
  167. how does excel decide a suggested name to a range?
  168. how do i program a vb script in excel to tell me which cell has f.
  169. Combo box values based on other combo box value
  170. Procedure too large" error ...DAMN
  171. Polling directory for changes
  172. Numbers vs Values
  173. Insert code into worksheets programatically??
  174. hyperlink in listbox
  175. Olap Cubes - Automatic Select
  176. pivottable or querytable
  177. excel columns collection?
  178. Dealing with Pivot Detail Explosion
  179. convert to number
  180. How to
  181. Range Manipulation Question
  182. How do you hide a row if a certain cell equals zero?
  183. automatic vs. manual
  184. Setting Focus not working as expected
  185. finding last line in macro
  186. How to associate data with schemas programmatically using .NET
  187. Code to open new workbook, prompt for 'save as' name.
  188. referencing a cell on another sheet
  189. Searching & Extracting Data
  190. activesheet
  191. Running a macro on action
  192. Reformat existing 4 digit number as hh:mm?
  193. How to restrict the TitleRow only for a specific range of rows?
  194. linking
  195. Use Graphic as Hyperlink
  196. Range naming columns and rows
  197. Dates
  198. Excel could not save all of your data and formats
  199. Centered Text Not Working in saved htm
  200. inserting rows and open file dialog
  201. outlook htmlbody
  202. generic macro on close of excel workbook
  203. Need a left pad formula method
  204. what is the formula for adding a new number to the existing numbe.
  205. Always open Excel file with Userform
  206. Working with Charts
  207. Creating a Function
  208. Toolbar Problems
  209. argument in command line
  210. Problems in Excel 2003
  211. Combobox to choose Worksheet
  212. Copying Outlines
  213. PrintPreview slows Code Execution
  214. subtotal question
  215. Function Creation
  216. Problem naming a range.
  217. Calling an eventprocedure
  218. Is it possible to create distribution list for Outlook?
  219. Match and Copy to array
  220. Combobox in each wks
  221. microsoft.public.excel
  222. Same operations on a variable number of rows
  223. need macro: convert formula to value
  224. Excel macro crashes when it sets a cell formula
  225. Data Validation - Code Not Recognizing Something
  226. changing pivot selection
  227. VBA problem pulling data out of variant/range input variables
  228. Open Object as Wkbk opens
  229. Pivot table reports cannot overlap another pivot table
  230. CopyFromRecordset Question
  231. Pivot Table Deselect all items
  232. Macro to copy cells from another sheet
  233. Sum Intermitten Data in one Column
  234. Cancel Macro is user selects 'cancel' at save menu
  235. Compare 2 lists and if not on list then delete row
  236. How do I get external web data that requires a password?
  237. Help building string for Names.Add RefersTo, pls?
  238. Displaying help in a UDF
  239. Macro to create the new worksheets.
  240. Understanding this code snippett
  241. Using user defined workbook name in macro worksheet functions
  242. Temporary Sheet with Cell Selection
  243. How do I output a formula into a cell and then autofill using vb?
  244. Looking for Rod over in the corner...
  245. Formula in VBA!!!
  246. Cell Change Event
  247. Run-Time Error 1004
  248. if statement with functions
  249. Hide Access when macro run from Excel
  250. VerilyHiddenSheet-VBA Editor
  251. shapes on a sheet
  252. Creating a Log
  253. Chequer-box Pattern
  254. Editing recorded macro code. Referencing workbook name in functio
  255. navigation keys are turning off
  256. Add-in removal
  257. How can I remove the Excel COM addin from the Excel program?
  258. Numbers
  259. MsgBox not displaying right away
  260. Macro to Copy Hyperlink to another file as a HYPERLINK, not text...
  261. automated spreadsheet
  262. problem with formula
  263. Looping letters (or columns)
  264. Excel 2k - A bug or bad vba...?
  265. Lookup using two values - like an SQL in the same workbook
  266. Closing Form problem
  267. Search dates differences
  268. OnTime / TimeValue
  269. Delete Rows from multiple Sheets.
  270. Application.DisplayAlerts
  271. Weird Startup Lines
  272. Chart help please!!!
  273. Web query in macro doesn't work until you manually edit it
  274. Reading CSV file from Excel (VBA)
  275. Why autoformat increases file size?
  276. THE GREATEST NEWS EVER !
  277. can't clean up the clipboard in excell
  278. THE GREATEST NEWS EVER !
  279. Modules and add-ins
  280. Numbers
  281. Cut N Paste
  282. VBA Closing File
  283. Why does the error pop up- can't enter command mode?
  284. Run Time Error 424 Combo Box User Form
  285. How do I not delete an enitre row when running a duplicate delete.
  286. strange problem subtotal
  287. Excel Find Method
  288. Help with code please
  289. Excel Automation using .NET
  290. Range Question / error 1004: method Range of object Worksheet has failed
  291. Using a drop-down list to lookup
  292. Creating a back key
  293. Auto look up
  294. Excel Add-in and Citrix Client/Server
  295. This is what I want to do: =if(a1 CONTAINS "BIRD","YES","NO", false)
  296. How do I hide my Visual basic code in Excel?
  297. The Perfect Mix
  298. Enter Text or Date on Multiple Sheets
  299. Trouble with VLookup
  300. Please assist with TextToColumns Thanks!!
  301. Add-In will not allow worksheet to be opened.
  302. vlookup function
  303. GetOpenFileName method different in Excel
  304. macros execution problem
  305. sort method
  306. referencing a name from another book
  307. Counting columns using VBA
  308. LOOKUP Help!!!
  309. THE GREATEST NEWS EVER !
  310. Delete column if ....
  311. Please Help
  312. Hi,Question about Worksheet Security
  313. Question about Worksheet Security
  314. How can I use the XOR function?
  315. help
  316. VBA CDO XP Firewall / Transport Failed Connect Server
  317. Variable holding across multiple subs?
  318. sheet code help
  319. OK, so I can't click on a link in IE
  320. Problem with Do Loop and If
  321. Early and Late Binding Vba Excel
  322. Range Error
  323. displaying a col based on nt account.
  324. help!
  325. How to declare variable as public.
  326. In a Shared Workbook of Excel, how do I change the color of a Cel.
  327. Reference Cell Range Using Cell Value
  328. number as text confusing code
  329. Create Message Box containing different variables.
  330. Array and optionbutton?
  331. Text Import Wizard from vba
  332. Problems with the excel find function in vb.net
  333. THE GREATEST NEWS EVER !
  334. "Open with.. Excel" in vb
  335. I need to find the first empty row in a sheet to paste data to
  336. Finding "last cell"
  337. DSCR Error
  338. Hyperlink information in Excel
  339. Unprotect a Excel workbook using vba macro
  340. Locking and unlocking a Excel project for viewing
  341. Checking difference between the dates
  342. Can you build a dialog box to fill a column
  343. Month/date problems.
  344. ideas for exel
  345. Creating a Pivot Table directly from an Array
  346. Re: Hard question - creating a database
  347. RE: Importing Access Tables
  348. SumProduct Error?
  349. RE: Object range method runtime error
  350. Re: Ó¿Ò, THE GREATEST NEWS EVER ! °º¤ø,¸¸,ø¤º°`°º¤ø°º¤ø,¸¸,ø¤º°`°º¤ø°º¤ø,¸¸,ø¤º°`°º¤ø°º¤ø,¸¸,ø¤º°`°º¤ø
  351. lock cells
  352. RE: Importing Access Tables
  353. RE: length of square
  354. Filter in place question for sort of unique records
  355. Personal.XLS file doesn't remain with Excel file when emailed
  356. This'll stump you! Problem with Copy Sheet between Excel versions
  357. RE: military time function
  358. Update the time in a form caption
  359. RE: change size of object
  360. Patrick -- 424 Combo Box User Form
  361. Exporting Chart to GIF File
  362. RE: Help with cell references dependent on strings
  363. Change XLS-File Format via VB .NET
  364. Access error to registry configuration
  365. Check for Existance of sheet - problem with UDF
  366. RE: can't change query definition in MSQuery
  367. shell question ?
  368. How to get name of named range where activecell is
  369. Adjust the font in Data Validation dropdown box
  370. Autofilter change opens another document!
  371. Need help on "Aligning text boxes in a chart sheet"
  372. Simple macro needed to export a worksheet
  373. Re: Solution Found, but strange: Application.Quit en Excel crash
  374. Conditional cell coloring
  375. calculate remains in status bar
  376. Create/Remove Custom Menu Items from Add-in
  377. Simple Tables in Excel
  378. Automation behaviour - strange but very useful
  379. Car assign simulation
  380. Open MS Office Outlook
  381. Re: disable copy paste
  382. Delete Worksheet.
  383. Re: length of square
  384. eMail problem
  385. cell addresses
  386. Do not display information in cells
  387. RE: Open Test file with VBA with a changing file number
  388. Import csv files, delete rows, arrange columns ....
  389. sheet.activate
  390. How do I count blank cells in a column of dates?
  391. Can I make a cell change colour automatically
  392. Protection of confidential data
  393. Best way to display a subset of data in a web page
  394. Sending data back to parameters
  395. Save As
  396. print ptoblem
  397. Extracting data from alternate rows
  398. For Each Loop w/ a range
  399. sum column A based on column B
  400. How can i read from RS232 using a macro (VB)?
  401. Print Preview and Changes
  402. How do I change the size of font/display in a dropdown list I've .
  403. referencing a named range from a closed workbook
  404. Loop through a range
  405. Recording the 1st Change in the value of a cell
  406. Saving space in Array formula Sum(If(())...
  407. Trouble using the { } in array formula (for multiple criteria)
  408. XmlMapQuery and XmlDataQuery Samples in Excel 2003 and VB.NET
  409. Macros
  410. XmlMapQuery and XmlDataQuery Samples in Excel 2003 and VB.NET
  411. Re: Find first and/or last cell that matches data
  412. Need Help with a File Search
  413. IE history
  414. Prepopulating a dropdown list in excel
  415. Programmatically creating a map from data in Excel
  416. Re: GetOpenFileName help
  417. How to get data from comment
  418. Shorter Sub
  419. Referrencing columns by header and from different worksheets
  420. Date question
  421. Prompt user for a filename
  422. Array / Looping Question
  423. Storing Data in Access Database...
  424. Selecting and editing unlocked cells problem
  425. choice of reference link option?
  426. can i create barcodes in excel 2000
  427. SQL.REQUEST Calculation Order
  428. Nameing a range while still selected from copy
  429. change by value in drop down list
  430. Excel 97 Enum
  431. MacroOptions doesn't stick
  432. msgbox yes or no
  433. Read write non contiguous cells
  434. Please help with code?
  435. Custom toolbar xl97
  436. Help with Hours Minutes Seconds Please
  437. Excel vba
  438. tricky one to match between 2 s/sheets
  439. Opening files in other programs
  440. Toolbar Menu problems
  441. Using a Userform instead of Data Validation
  442. Open a workbook
  443. Binary numbers longer than 10 characters
  444. Break down, rebuild a matrix
  445. import external data, web query
  446. Creating a macro by using Excel
  447. Controlling the windows taskbar from VBA?
  448. Run macro problem
  449. Opening Dabase with Password
  450. add data to a closed workbook
  451. Evaluate using a variable - Help please
  452. InputBox a date
  453. Mapping Tables.Fields from a data source to my MS Access Table Structure
  454. New from Template Issue
  455. Blank progress bar
  456. Looping through visible rows only
  457. Re: Conditional Formatting
  458. Application.Cursor = xlDefault not working
  459. activate marco command
  460. VBA code manipulation cells
  461. Keeping original data format into a Pivot Table
  462. Distributing an Excel file
  463. Action after Activate a cell
  464. Update Chart data Range with VBA
  465. can anyone help me please?
  466. RE: simple ? problem with value or/of formula ?
  467. Referring to a sheet
  468. On Error Resume Next
  469. How to use Access tables in an Excelapplication?
  470. Lookup value
  471. XLA or Reference or Nothing at all
  472. Lookup Value2
  473. Email from macro problem
  474. Application-defined or Object-defined error
  475. acknowledge divisability of $20 indicate mathematical results
  476. Based on Data in One Column, need to SUM another
  477. XLA versus Reference versus Nothing
  478. Excel / Access ODBC connection
  479. worksheet_change or worksheet_selectchange ?
  480. Object Error
  481. numbers in chinese
  482. Creating a Database with VBA
  483. List all Addin Project Name
  484. "Remember" second last clipboard?
  485. job openings for programmers
  486. Conditional sort
  487. Find string and format 54 columns to right
  488. Charts and Userforms
  489. I want to be prompted for an entry that already exists in excel
  490. Build lists with non contiguous cells
  491. Test if spreadsheet id open in IE
  492. How to dynamically add a reference to personal.xls ?
  493. fixing the result of a formula after a certain date
  494. Sheet NameTab Protection
  495. What is the formulae to write a work timecard in Excel
  496. Uninstall Addin
  497. CommanButton Caption Orientation
  498. Back color of dynamically-created buttons
  499. Automatic Downloading of files (PDF or HTML) using Excel
  500. Generating another worksheet from existing two
  501. Microsoft Windows 2000 Scripting Guide
  502. Microsoft Windows 2000 Scripting Guide
  503. built-in function doesn't work properly
  504. Forms?
  505. VBA Question
  506. Database Querry
  507. how to set range in excel
  508. How to detect Internet connection
  509. Clicking checkbox Changes the Label Font
  510. Problem with Excel list box
  511. What are the values for ColorIndex 's 56 colors ? i.e. green=3 .
  512. Insert comment behaviour on custom shortcut different
  513. Sending rows to another worksheet based on value of cells in column A
  514. Automatically Display a data input form when active sheet changes
  515. Change cell color dependin on date ...
  516. Numberformat: automation from MS Access
  517. Calling functions in different modules
  518. Macro help
  519. Email from Excel
  520. Print to PDF from Excel
  521. Printing PDF from Excel
  522. ByVal Target As Range
  523. Argh, trying to put " and & into the formula is driving me nuts!
  524. problem on passing value
  525. Using word during macro.
  526. Change Cell Background color when Cell changes
  527. Macro syntax - how to find them
  528. Thanks Tom Ogilvy
  529. Use array to do advanced filter?
  530. Whole Number Validation in Input Box
  531. using match in vba without assigning a cell
  532. Write a bsice macro
  533. Delete row based on letter
  534. Public Variable in ThisWorkbook
  535. Duplicate data in row 2
  536. number less than 100
  537. Copy a code module
  538. Global range name
  539. Digital Certification verification
  540. how to automatic upload data between excel spreadsheets
  541. looking for a function
  542. Formula's don't work until I "touch" them?
  543. ClearContents command causes routine to stop
  544. create a fill-in form using a scanned-in semi-transparent overlay
  545. looking for a function
  546. VBA error code
  547. vba sorting stopped working
  548. VB to set a constant in another procedure
  549. Disabling 'File/Save' Menu Item
  550. IF/OR Functions Together?
  551. How do I copy a range of cells in Excel using variables?
  552. Problem with webbrowser control
  553. can SUMPRODUCT Do this
  554. Form Combo Box, Protection?
  555. AWESOME MOVIE! << I found this movie link in an AOL chatroom. It is based on real evidence and I give it a big thumbs-up.
  556. Error 1004
  557. find last row in another worksheet
  558. Basic info I have forgotten....
  559. pivot table, vba or ???
  560. How Can I send customized email content by Excel VBA
  561. Patrick- do you still have the file
  562. Selecting data from column heading
  563. Max with similiar values within the range
  564. Compatibility Excel 2002 and 2000 in automation
  565. Changing formula programmatically
  566. External Data from Stored Procedure with parameters
  567. EXCEL AND VBA
  568. Schedule sending an email on a particular day picked from excel
  569. Row autoheight for merged cells
  570. Checking a Date format
  571. Selecting All Text in TextBox
  572. listbox problem #2
  573. Decalring Workbook level arrays.
  574. Can I print only specified pages from a print range such as pages 1,3,4,6
  575. Add-In Problem
  576. MS Query - From in SQL
  577. Can you get the range reference for each page in a worksheet print range?
  578. Does ActiveX control on spreadsheet exist?
  579. How can I programme excel to create and send an outlook meeting request?
  580. Printing List Box Contents
  581. Protecting (hiding) the Code in an Add-in
  582. Sharing a custom function bewteen workbooks
  583. Creating Charts in VBA Code
  584. Deleting certain string within the string
  585. AutoFilter, Looping through the Rows? (Newbie)
  586. variable for path name in ODBC connection
  587. Pivot Chart and EnableItemSelection
  588. Pivot Tables : Total Time incorrectly computed
  589. Cant view excel worksheet in web browser
  590. OpenText Method failure
  591. Count entries when two criteria are met
  592. Application is already Calculating during a "Change" event
  593. What is wrong?
  594. Customize the right-click menu
  595. Combo Box Problems
  596. Changing VB Component Names to match Worksheet names using VBE
  597. Thanks Bernie
  598. Prtinting antoher worksheet
  599. Problem with Select Case construct?
  600. Milliseconds in Excel
  601. changing a SendKeys "(^+{home})" to a function
  602. Excel OLEDB format problem...
  603. NTFS file system
  604. copy worksheet and replace
  605. VBA: Device I/O error (Error 57)
  606. RE: Script to insert the next Friday
  607. RE: excel macro problem
  608. RE: Looking for a Next friday Date Script
  609. ShowModal property
  610. RE: excel macro problem
  611. Looking for a Next friday Date Script
  612. How do I access a Pivot Table using VBA for EXCEL when the pivot .
  613. Script to insert the next Friday
  614. Hex2Bin in VB
  615. Pivot Table Field Settings
  616. Displaying zeros as dashes on a worksheet
  617. hyperlink with more then 255 characters?
  618. Shift data to left
  619. Worksheet close event?
  620. Re: Copy same range of data from all workbooks and paste into consolid
  621. Re: Copy same range of data from all workbooks and paste into consolid
  622. problems with a form and a cancel button
  623. Re: Copy same range of data from all workbooks and paste into consolid
  624. Worksheet close event++?
  625. Re: CLEAN Formula in Excel
  626. Create new worksheet from exisitng data
  627. Re: CLEAN Formula in Excel
  628. Getting Data out of a E-Mail
  629. Boolean Question
  630. Passing reports to PowerPoint?
  631. locking a cell after input
  632. Re: copy/paste will work seperately, but not in the function i've writ
  633. Error control?
  634. Change Pivot Table's query
  635. Excel Data Validation Lists
  636. group results by certain value
  637. Save Workbook Problem
  638. Save as CSV
  639. how to use offset with non-adjacent named range
  640. retriveing old AND new value of a cell in code
  641. Format columns using a variable name
  642. Hide and Unhide rows automaticely
  643. Get worksheet names
  644. Using variables when copying values between worksheets
  645. Pivot Chart Series description
  646. variable/Input box problem
  647. Switching calculation to manual using Workbook_open
  648. Changing a cell color based on date entry ...
  649. Import External Data w/ CSV & Line-Breaks ...
  650. Re: disallowing blank cells
  651. Ctrl+Alt+Break
  652. Re: Flashing Text or message
  653. Re: Flashing Text or message
  654. Storing a column of input data
  655. Macros reassigned by XL?
  656. Re: How to write a autosave macro for a shared workbook?
  657. Re: Running Macros when opening Excel
  658. No control for option buttons, invisible macro??
  659. Excel process stays in memory after Using Quit Function
  660. xy-chart with dates on x-axis
  661. Re: Getting a list of filenames
  662. Re: Getting a list of filenames
  663. Can I determine in which cell is a listbox postioned?Or how to get the listboxes in a certain cell?
  664. Re: Trying to toggle visability of button
  665. capture DDE update value in VBA macro
  666. Re: Running Macros when opening Excel
  667. Re: Trying to toggle visability of button
  668. Re: Changing cell values
  669. Need help w/ programming an Exel addin
  670. Re: Can Excel interact with other Windows functions
  671. Re: how to call a form
  672. Select copy and paste
  673. Move Rows & Append
  674. Re: Automation Error in Excel VBA
  675. Re: Changing cell values
  676. Getting protected external data
  677. If Checkbox checked/notchecked then
  678. Creating a list from 2 or 3 different worksheets
  679. Please Help, Newbie VB programmer
  680. Re: triple state option buttons
  681. Re: Turn off confirmation messages via VBA
  682. Re: Turn off confirmation messages via VBA
  683. Re: 2 Timers
  684. Re: Saving FileName
  685. Message Box
  686. Multipage Userform Events
  687. Formatting unlocked cells on protected sheet
  688. Re: Look up function
  689. status indicator on screen
  690. Opening Files Using VBA
  691. Calling an Excel/VBA User Created Module from WSH
  692. XY Chart with many curves: Independent legend entries?
  693. Using VBA to create (complex) charts on the fly
  694. Re: Looping through a Type
  695. using the clipboard to avoid VBA / Interop
  696. Re: Looping through a Type
  697. Subscipt out of range
  698. Data Validation in Cell changes Range ID?
  699. Re: Need formula that will read time as min:sec in excel
  700. RE: Toggle Button Updating Concern
  701. Re: FileSearch & .zip file
  702. Re: My VBA code works in the step though mode but not at full speed
  703. Do...Loop not working
  704. Value of next visible mycell within a rng
  705. SQL Server Listing and SQL Databases
  706. MS Query in VBA
  707. Creating Calendar appointments
  708. RE: How do I get a form to lookup data for 3 different controls? (co.
  709. Sorting problem
  710. Printing
  711. Missing help in Excel 2003
  712. sendmail works in excel 2002 but not 2000
  713. I need help writing a macro to replace cell contents. (new to VB)
  714. RE: My VBA code works in the step though mode but not at full speed
  715. Search for Value from InputBox
  716. Web queries and Excel
  717. how to get some rows and columns on every printed page
  718. beginner problem: getting selected rows, row by row
  719. Put a predefined name range in to a ComboBox in a Form (VBA)
  720. Changing Named Ranges
  721. Hide tool bar
  722. Pivottable Pivotselect string
  723. Re: How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
  724. Re: Application.Calculate & VLOOKUP
  725. Re: How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
  726. Run external program.
  727. cell vs range problem with formula
  728. Re: average
  729. Loading a spreadsheet from memory
  730. Re: Application.Calculate & VLOOKUP
  731. how to catch errors from outlook
  732. Macro better solution than cell formula with date?
  733. Re: User picks a text file, macro defining the array
  734. Re: Environ function.
  735. Re: toggle button or worksheet_activate causing form to open twice
  736. Re: Custom Function - Adding Help Information
  737. Re: Conceptual Question about ReDim
  738. Re: Conceptual Question about ReDim
  739. Re: Automation Error(-2147467259) in Properties Collection
  740. Re: Automation Error(-2147467259) in Properties Collection
  741. Re: how do set up a database to prepopulate details to a form in exce.
  742. Re: Pasting pictures from Excel to Word (2000)
  743. Fixed Decimal point
  744. having trouble writing string to cell-xl2k
  745. Re: formula question/elapsed time
  746. Move sheets To New Wbk - recover workbook
  747. plz help: creating named range in VBA, loop goes haywire
  748. Re: Need a property that will give me true if a value is close
  749. selecting range of cells - variable # of rows
  750. present data as hierarchy/tree structure in user form
224