View Full Version : 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

  1. No Subject
  2. No Subject
  3. Excel table macro
  4. moving to cell Y if cell X has value Z.
  5. Re: Count number of prints.
  6. Strange thing with this formula written by VBA
  7. Problems generating an html link based on worksheet values
  8. Problems generating an html link based on worksheet values - SOLN
  9. xlfCaller
  10. Chart Date Label Problem - Is this a bug in Excel?
  11. Re: I need to determine a cell range based on a blank cell
  12. Linking To Excel Graphs
  13. Prompt
  14. Re: Count number of prints.
  15. [Excel XP] Orientation of cells etc.
  16. Question: OPEN return status
  17. Question: Macro overloading, passing variable number of arguments
  18. Question: Cell formula or macro to write result of one cell to another cell
  19. Re: Excel: Deleting Macros and Functions
  20. Time based macro
  21. Re: Excel Add-in path in UNC format
  22. Re: User defined functions - text for formula palette
  23. Add PivotItems to PivotTable / Enabling - Disabling PivotItems
  24. Re: Combobox Click event triggered when copying worksheet
  25. Re: Extracting Access data
  26. Re: Before Send
  27. Can we write VBA code to set all column/row's size back to default size?
  28. Re: Accessing the VBA project object model
  29. adding changing number of days
  30. Ah, I think...
  31. LoadPicture Pathname or no Pathname
  32. Re: Iterating through row cells on column Match, help please.
  33. Ah, I think...
  34. Re: Screen is flashing when VBA adding objects into Excel sheet?
  35. Before Send
  36. Re: Ah, I think...
  37. Re: declare a two dimenssion array
  38. Re: Associating one array with another
  39. Re: Ah, I think...
  40. Re: Opening an AutoExecute Macro Workbook from an AutoExecute Macro Workbook
  41. GetSaveAsFilename method
  42. Re: Cell contents changing colors
  43. Re: Mouse
  44. Excel Addins
  45. Auto Fill Program needed to get maps from internet onto excel
  46. Re: Check mark boxes in Excel 2002
  47. Re: dates in userforms
  48. Re: Can we write VBA code to set all column/row's size back to default size?
  49. Simulating the Format Painter, Selection.Select, and taking focus
  50. Lotus 1-2-3 macro
  51. Delete without losing references?
  52. Re: dates in userforms
  53. Hidden sheets becoming visible after saving from Browser
  54. Excel is very slow to load/save the spreadsheet
  55. Eliminating rows of data in excel spreadsheet that have blank cell in row A and data in row B - E
  56. Sorting ListBox results or transposing ListBox values to other cells for sorting
  57. For Next Looping (custom variables)
  58. Excel ADO Connectstring parameters
  59. Device I/O Error
  60. Undo, Redo, Repeat and Validation
  61. DateDiff problem
  62. Sizing windows automatically
  63. Re: Inputbox method using type:=8 - How to Cancel?
  64. Digital Certificate creation error using makecert
  65. Deactive Copy and Paste
  66. automatic updating cell
  67. formatting in macro works on one computer
  68. Re: Exporting Data.....
  69. SUMIF function
  70. Re: Macro Using Named Cell
  71. Unprotect method run-time error
  72. executing code when a module opens
  73. Re: Macro Using Named Cell
  74. Can I have a loop to open a set of workbooks get some data, close it one a time.
  75. Detect if file is open
  76. Getting the full path when from a File Open Dialog Box
  77. Re: Excel VB and Lotus Notes Address Book
  78. Use one column to identify values in adjacent column.
  79. Re: .Visible Property
  80. Name of workbook
  81. Macros
  82. Re: Single Sheet - Calculate Manually
  83. mortgage amortization
  84. Re: Inputbox method using type:=8 - How to Cancel?
  85. C Add-In clashes with VBA?
  86. Re: really dumb find question
  87. Certain methods do not work
  88. Datedif, Workday etc.
  89. cannot open and can not delete files
  90. Re: Single Sheet - Calculate Manually
  91. date conversion from m/d/yyyy to yyyymmdd
  92. subtract time from now()
  93. Copy and Paste lost
  94. RE: Automate differente excel versions + VBA protection
  95. Re: Save As Dialog
  96. Row to column data move base on row
  97. Re: Running sheet from another sheet ... and back
  98. ugh! Match/Index problem
  99. An ODBC question
  100. Default excel Template
  101. Re: system variable representing subroutine name?
  102. Re: Copy and Paste Lost
  103. Re: Why doesn't "Workbook.Range("myrange").value" work?
  104. Problems executing Excel VBA code in Microsoft Office 2003
  105. Concatenate Text to create Formula
  106. SQL with no headers
  107. Looping through Text boxes
  108. How to run VBA macro when the workbook is open?
  109. Re: More efficient code
  110. Re: Setting up a date and time stamp in a cell
  111. Re: Formula for autodating
  112. Cannot insert Activex boxes
  113. Re: CSV Format in non-English OS
  114. Sorting Odd & Even Numbers In Excel
  115. Re: Time based macro
  116. Re: Serial I/O
  117. Re: AutoFilter Dropdown Boxes Missing
  118. Re: AutoFilter Dropdown Boxes Missing
  119. Clock Timer/ Date Function
  120. Re: How to make a running XL app the active desktop window using VBAcode.
  121. String operations in VBA for "Substituite"?
  122. Active X Control
  123. macro selecting datalabel
  124. grid lines covered up
  125. Re: Passing a Password to a VBA Procedure
  126. inexperienced header entry automation resizing/scaling issue(s)
  127. Re: Mods to macro
  128. Re: calling word
  129. Re: Copying a Excel Chart into Word
  130. Re: Protecting a VBA project
  131. Re : MS Excel’s Offset Property
  132. Re: Protecting a VBA project
  133. 32,767 Significant Digits of Precision, with Number Formatting
  134. Save As Dialog
  135. Defining Ranges
  136. Conditional Formatting
  137. Select Range problem
  138. Re: How to become an excel MVP?
  139. Hide all toolbars auto_open
  140. Time active Macro
  141. dialogboxes
  142. Re: Excel2000 VB Help Problem!
  143. Variables in command lines
  144. Can these codes be summarized?
  145. Displaying progress on UserForm
  146. Mass update in Excel based on values in different sheets
  147. Subtotaling items from a list
  148. halting macro
  149. halting macro
  150. Code for moving textbox
  151. Reading a named range
  152. "Less than or equal to" symbol in a UserForm
  153. Saving Excel to web site
  154. A save question:
  155. Multipage
  156. RollOver buttons in UserForms (A solution)
  157. Showing Excel Sheet in IE
  158. Excel+Not Enough Memory..
  159. Re: excel symbols
  160. Re: Opening text files using macro
  161. Re: CountIf
  162. Tracing into a Function
  163. excel symbols
  164. Opening Excel 2002 VBA Editor
  165. Detecting Worksheet change
  166. easy way to test if a Named Range exists
  167. Moving Text Boxes
  168. Maintaining row position in a loop
  169. Error Reports
  170. Re: macro to send an email from excel
  171. Re: Find functions
  172. help with *.xlw file please!
  173. Auto numbering
  174. Re: Formula or code
  175. Removing Lines Identified by Autofilter
  176. Re: DDE Command to Format Cell
  177. ADO connection not always enabled
  178. Re: compatibility issues foreign versions
  179. Re: VPageBreaks in excel.
  180. vba tutoial
  181. Average/Sumproduct Array
  182. Using Microsoft query through Excel
  183. VBA code for Excel 2000, IF procedures and listboxes
  184. Need Before_Save code
  185. The expanding XLS spreadsheet
  186. Open another Office app from Excel
  187. Formula or code
  188. Parsing Data From HTML Source into Excel using VBA
  189. Re: Formula on cells
  190. moving macros to disc.
  191. list of accounts
  192. VBA Code to FIND
  193. MsgBox
  194. list box
  195. print current sheet
  196. Re: Substitute comma in csv file
  197. excel 2000 - manipulate two applications
  198. Re: CountIf
  199. Re: Excel 2002 RTD - GetNewValues and RestartServers
  200. How to code event for dynamically generated checkboxes
  201. formula returns formula
  202. Help: Copying Visible Cells only to Visible cells!
  203. JScript to move Excel Worksheet
  204. Calling HTML Source code from within VBA for Excel
  205. Re: Auto numbering
  206. Fill Color? Background Color?
  207. Making VB PasteSpecial method to work the same as Excels Application
  208. output of associated arrays
  209. check if worksheet exists
  210. adding uniform footers
  211. scan for repeating values and then delete
  212. Macro Prompt
  213. Pausing code execution
  214. Delete Rows with letter #VALUE in cell J
  215. Re: How to apply a function across a range of cells
  216. Deployment question
  217. Re: Workbooks.Open fails after upgrade to XL2000 from XL97
  218. Re: How to disable 'Update alert' when open a spreadsheet has link to other XLS
  219. m/d/yyyy h:mm date conversion to yyyymmdd ???
  220. variables for file names
  221. How to disable 'Update alert' when open a spreadsheet has link to other XLS
  222. Calling the Solver via a subroutine
  223. Chart automation problems!
  224. Where can I find other arguments & desc to the Workbooks.open("myfile.xls") cmd?
  225. Re: DDE Command to Format Cell
  226. Automation Procedure with Worksheet_Activate
  227. How to disable 'Update alert' when open a spreadsheet has link to other XLS
  228. customize a calculated field in a Pivot table
  229. Re: Inputbox method using type:=8 - How to Cancel?
  230. Extracting text
  231. Can this be done?
  232. update and store new high values
  233. Protecting a worksheet from veiwing but not from importing in data
  234. Re: Simple Question
  235. Re: Opening CSV files and #NAME? error in certain cells
  236. Eliminating Prompts
  237. Comma in TextBox Problem (Spanish)
  238. Unknown where is the problem on the Runtime error - Automation error
  239. How to get the position of a cell in Excel named range?
  240. Re: How to get the position of a cell in Excel named range?
  241. Re: Question about toolbars ...
  242. Automated copying & pasting from multiple sources
  243. Re: copying duplicate entries
  244. Re: Simple Question
  245. Re: UDF Array function
  246. Re: On opening an excel file
  247. recalc question
  248. Writing multilines to a text file without closing
  249. Text Format
  250. How to get data from Access Database in Intranet
  251. Can these codes be summarized?
  252. Find paragraphs in word and export to Excel
  253. Can you identify the maximum value in an array?
  254. Importing a sheet?
  255. A peculiar problem
  256. Compile error ...
  257. Averages
  258. listbox
  259. Re: How to get the position of a cell in Excel named range?
  260. Modifying the cell dependies
  261. programming a link
  262. Using the same variable in separate userform modules
  263. Re: A peculiar problem
  264. Programming links
  265. Change font to red and bold
  266. Page breaks in Sheet for copy via OLE?
  267. File Copy Routine
  268. Re: Pivot Tables not using all memory
  269. can i send an email or warning from excel
  270. Connectiong to an Excel Workbook with MSDASQL provider
  271. Importing from SQL changes date format
  272. Unprotect Worksheet
  273. PageSetup slow
  274. to modify cells from a function
  275. updating Access table with Excel data
  276. Printing .pdf from within Excel
  277. combining sumproduct and average
  278. help with sql in excel
  279. Custom Calculations in Subtotal
  280. Validation ?
  281. MATCH, LOOKUP, or ???
  282. Linking to other VB apps
  283. problem with tables in excel
  284. Procedure Too Large problems
  285. Re: Hidden Worksheet Error
  286. UpdateLink Method
  287. Re: Linking to other VB apps
  288. Dialogsheets
  289. Simple conditional formula
  290. Can't open a file
  291. Getting rid of Outlook warnings from excel macro
  292. xlDialogSendMail
  293. Re: how to define target frame names for the hyperlinks in Excel
  294. Re: Cond form formula
  295. Does MS Query have an object model
  296. Re: Cond form formula
  297. ChangeLink xlExcelLinks
  298. Counta anomaly
  299. Restrict Find to one column
  300. Worksheet Button Callbacks
  301. Excel Macro Strings
  302. Application.Run question
  303. ISERROR formula in VBA not working for me
  304. Re: List the Macros that can be executed from Tools-Macros
  305. Re: Switching to other apps while running macros in excel 97
  306. Cell Formatting
  307. concatenation of cells
  308. Find File and Open
  309. lookup lastmonth
  310. Unusual Operation of a User Defined Function
  311. Populating Textbox in UserForm
  312. Populating Pageheaders Using Vertical Lookups
  313. Import VBA Code
  314. Re: Looping through each directory
  315. rate formula
  316. Excel Add-in
  317. Re: Excel / VBA
  318. Setting Font properties in Code clears Undo list
  319. Re: Looping through each directory
  320. Excel-VBA and FlexLM
  321. Re: Hiding Links
  322. Re: Hiding Links
  323. What's this? (Application.Run)
  324. Common Dialog Box
  325. Macro Emailing Challenging Problem
  326. Re: "Substr" command in Query
  327. Re: Problem importing using MS Query
  328. prevent second copy from opening
  329. Appending/Updating records
  330. Re: prevent second copy from opening
  331. Re: Closing Excel Completely
  332. Re: SaveAs "subscript out of range" error (COM -> SOAP)
  333. Re: Closing Excel Completely
  334. Re: Closing Excel Completely
  335. Re: Consolidating multiple files using a row column range
  336. Newbie question about iteration technique?
  337. Trend function in VB
  338. Link Excel range to PowerPoint Application text box
  339. How to set global constants and get path of spreadsh ?
  340. optionbuttons
  341. Closing Excel Completely
  342. Adding a category to the Function Wizard
  343. Email one page of information on the same sheet
  344. Please somebody help me...
  345. Re: combining sumproduct and average
  346. Object doesn't support this property or method
  347. MOD function
  348. Re: WScript object not found (???)
  349. Put a timer on a MsgBox?
  350. Hide Slide Bar?
  351. Distributing code
  352. Preventing Duplicates using VBA (code)
  353. Listing files in directories.
  354. Activiating and Selecting Excel Cells in VB.NET
  355. Re: Help coding userform
  356. Creating a drop down window
  357. O.T. Copy Protection
  358. Re: Search Methods
  359. Re: Opened File
  360. programming outlook 2000 from excel
  361. Re: Opened File
  362. Handout of Excel Object's Properties and Methods
  363. Re: Expiry Date for further updates into Sheet
  364. Re: Excel / VBA
  365. Re: SaveAs "subscript out of range" error (COM -> SOAP)
  366. Need HELP to modify code (need more automation)
  367. Macro to rename all worksheets with cell value in each sheet
  368. Excel data to Access
  369. Open Searched File
  370. Re: Macro to list all Formulas in WB?
  371. Re: VBA button click need help. Need LEN help.
  372. Re: VBA button click need help. Need LEN help.
  373. Re: Code to display dialog for unhiding sheets
  374. Code to display dialog for unhiding sheets
  375. Re: Looping through each directory
  376. Data Box
  377. Help with If Not Intersect
  378. VB question...
  379. Header - only on first page
  380. macro for e-mailing excel file using outlook
  381. Is there a "cell change" event?
  382. Re: sort for variables
  383. OLE Excel data handling from VB
  384. Email question
  385. Re: Unicode StrConv/Substitute routine...
  386. Re: Formula help please
  387. Formula help please
  388. Mismatch!?
  389. Logitech's newest mouse scroll fails in VBE code pane
  390. Re: Detect more info when workbook does not ack right.
  391. Re: Formula help please
  392. preserving type library references when distributing macros
  393. mortgage amortization formula
  394. Re: Help with sheet protection
  395. contouring
  396. re-enable macros
  397. CopyFolder
  398. webbrowser control tab navigation
  399. Excel / VBA
  400. enormous file size - VLOOKUP function?
  401. Using VBA, subtotal a column only if there is more than one qualifier
  402. sendkeys
  403. Code for Page Footer Font Size
  404. Directory checking
  405. Date bug
  406. Re: Finding the last row of chart....
  407. Help understanding the following VBA code......
  408. Re: Referencing Named Range in Other Sheet
  409. Check for duplicate entries
  410. Upper & Lowercase
  411. Getting the coordinates/ size of a bar chart element
  412. Listbox lists
  413. Making Hyperlinks Unavailable
  414. Automating printing to PDF
  415. printing comments
  416. Get External Data, Import Text File, File name problem
  417. can not open and can not delete excel files
  418. Re: setting ctl to array of checkboxes yields type mismatch error.
  419. Re: creating a commandbarbutton with a custom bitmap
  420. Re: msgbox prompt when user selects data from combo box
  421. unticking option buttons
  422. Stop Problem
  423. UDF, Type it or use Insert Function
  424. Thanks - creating a commandbarbutton with a custom bitmap
  425. Re: Windows
  426. Reply to Tom
  427. Protection UserInterfaceOnly reading Hidden Formulas
  428. Landscape print with Letter paging
  429. Re: setting ctl to array of checkboxes yields type mismatch error.
  430. Menubars
  431. Re: "Can't Show Modally" - Run-Time Error '400' Problem
  432. Cell data format in an e-mail
  433. lock one cell when data in another
  434. retrieve data from SQL server and populate excel sheet
  435. SaveAs method
  436. Excell HTML Conversion Needs Refresh to Correct Format
  437. Pivottable date parameters ...
  438. viewing VBA behind existing pivot table
  439. Close Browser window with VBA
  440. Re: vba
  441. Can MS EXCEL remove duplicates and separate by color coded items ?
  442. Re: comments
  443. Keeping macros neat
  444. How do I find which cell called a function?
  445. passing data from one sheet to another
  446. Re: Using Named Cell References that aren't present yet.
  447. Re: Sorting a 2-dimensional array
  448. Re: Determine maximum length of a page
  449. Re: oRange.Interior.Color
  450. Controlling two different printer trays
  451. DATEDIF
  452. column header click
  453. Randomize the order of the contents of an array
  454. Re: Small programming task in Excel VBA
  455. help whit hyperlink
  456. opening webpage in excel
  457. Re: Small programming task in Excel VBA
  458. Direct manipulation of TextBox
  459. Selecting Cells
  460. Re: Newbie Seeks VLOOKUP help
  461. Re: Round error on home comp
  462. HELP sending email from Excel
  463. Help with some sheet code
  464. Setting up a Month Array
  465. Re: Help with copying please.
  466. Image Variable
  467. vba date XL2000
  468. Checking Military Dates
  469. Don Selecting cells
  470. Re: count pagenumbers?
  471. Reply to Tom
  472. help with VBA code re comparing cells and generating message with detailed info
  473. Re: Need help with decimal places
  474. Adding leading zeros to a calculated value
  475. Excel cannot save my digital signature
  476. Re: compiling multple worksheets
  477. Conditional Summing Cell Range
  478. Re: run Excel on schedule
  479. Splitting data in a cell
  480. Re: Create help for user-defined function
  481. As Addins load question
  482. Re: Listbox lists
  483. Controlling Font Name in a personnal Commandbar
  484. Behaviour of "Replace"
  485. lock-out rows from scrolling
  486. Code to Email with UNC in subject line
  487. Re: VBA & Solver Memory Usage
  488. Summing cells based on run-time criteria
  489. How to copy rows using fontcolor as bookmark?
  490. Need VBA Routine
  491. Maybe an array ?
  492. Re: logging excel events?
  493. Slight adjustment needed for Macro
  494. Re: Excel 2003: XML Validation upon editing ?
  495. Re: creating a chart in a form
  496. How do I Clean up this formula?
  497. Re: Sorting Odds & Evens
  498. determine page number in Word document
  499. Re: capture shift-double-click
  500. Macro to send mail to email id mentioned in a particular column
  501. Offset Formula
  502. Re: Expiry Date for further updates into Sheet
  503. cannot close workbook
  504. Re: Add new sheet and Name it
  505. SelectionChange code always available
  506. Re: How to open another Excel spreadsheet to copy data into current spreadsheet ?
  507. using excel 5 dialogsheet in excel 2000
  508. Copy worksheet from multiple files in one DIR to another DIR & rename
  509. Re: Sorting Odds & Evens
  510. Re: Why doesn't this function return TRUE?
  511. Problem using XNPV from VBA
  512. Problem using XNPV from VBA
  513. copying blank cell
  514. functions
  515. How to import more than one text file into Excel ?
  516. worksheet_change vs. calculate, and worksheet_change not running
  517. Re: Email using universal naming convention
  518. Re: worksheet_change vs. calculate, and worksheet_change not running
  519. Re: access 97 to excel 97: execute macro automation
  520. Re: VBA Hyperlink Question
  521. PrintForm Problem!!
  522. Macro To Update Data Table On DDE Link Change
  523. sorting
  524. Object required confusion
  526. Re: Sorting Odds & Evens
  527. Recalculating Cells error (and more)
  528. Re: add separator bar to right-click menu
  529. Error Msg: 'No Cells were found'
  530. FileSystemObject to get last 10 lines of text file.
  531. Conditional formatting
  532. Nested Find problem
  533. Copying an array variable to a sheet
  534. Placing an array on the active sheet
  535. Calculation for Dates
  536. Selective protection of charts: permit only BeforeDoubleClick ?
  537. ARRAYS
  538. Error Msg: Permission to use object denied
  539. User-Defined function not working
  540. Re: access 97 to excel 97: execute macro automation
  541. Header problem!
  542. Delete characters in cell
  543. Declaring Global Variables
  544. Combo Box causes system resources error
  545. Dates and Arrays Driving Me Nuts - Help!!!
  546. Re: Combo Box causes system resources error
  547. check if range containing values
  548. VBA Project Security
  549. Re: Checking the result of a formula
  550. Checking the result of a formula
  551. ChangeLink command
  552. sql results in excel
  553. Deleting multiple columns slowdown
  554. Re: Checking the result of a formula
  555. Re: Using a variable with .LookIn
  556. Menu toolbars
  557. How to get the PivotCell object??
  558. Re: Disable Menu and command buttons
  559. macros for other applications
  560. Re: Create Command Button from Code
  561. Excl 97
  562. Dynamic Row Selection
  563. A problem to solve, a little help
  564. Mandatory Cells
  565. Re: saving macros to a common folder for all users
  566. Turning off System Messages
  567. Re: Multiple IFs
  568. saving macros to a common folder for all users
  569. Finding first Null value in range?
  570. How to check if the Excel VBE is opened within Excel?
  571. see the full comment on a cell
  572. Move a "picture" object
  573. Re: Macro for Pivot Table - Apply to multiple workbooks
  574. VB Project
  575. Hidden Command Buttons
  576. Multiple IFs
  577. Cell properties
  578. saving excel table as text file
  579. Adding figures in excel if text is a certain colour
  580. Bugs using combobox 2-fmstyledropdownlist
  581. Running a macro from a desktop icon shortcut
  582. Adapt an array routine or a better way?
  583. Clearing a merged cell
  584. HELP - Communicating between C++ and VBA
  585. Disable Worksheet change event
  586. Lot Of Code
  587. Lists and masks
  588. Help with Inputbox Function
  589. Lookup table in addin
  590. Worksheet/workbook protection property?
  591. Size and location of chart
  592. Using a variable as a row reference?
  593. User-Defined Function Unusual Operation, Again
  594. Re: Can't set manual HPageBreaks
  595. Re: Convert Excel to text
  596. formating a cell with a conditional if statement
  597. Re: can i insert a picture
  598. Help Evaluating Cell Values and Changing Colors
  599. Re: SetLinkOnData help?
  600. Find First and Last Row Number in Column
  601. String length of Inputbox user input.
  602. Deleting a file using VB
  603. Re: Active Cell plus number of Rows
  604. Re: Active Cell plus number of Rows
  605. How to print Worddocuments with Excel VBA
  606. Custom defined formula
  607. User Input File Name
  608. how to declare a class module
  609. Re: Application.ScreenUpdating = False
  610. Excel Addin with drop-down menu
  611. Invisible Range Names
  612. Hide command button on worksheet
  613. Histogram parameters VBA
  614. sort multi-dimensional array on numeric data?
  615. Automatically Generate a unique file name...
  616. Picture in Web Page (saving to disk)
  617. Re: user form controls
  618. Declaring Dynamic Multi-dimensional Array
  619. User Interface
  620. Re: Excel changes file modified date when opening my add-in
  621. Row Number
  622. Simple problem refering to variable in For ... Next loop ...
  623. Detecting Calculation State
  624. Re: Display on cell
  625. Manipulating a spreadsheet opened in IE using VBA
  626. Re: Setting zoom for all worksheet pages
  627. Setting zoom for all worksheet pages
  628. Strange problem - extremely slow application.
  629. VBA Advise
  630. Blank Rows at end of Worksheet
  631. Data validation with the Select Case statement
  632. problem with user form
  633. need help with simple syntax error
  634. Row Deletion Using Text Trigger?
  635. Time Stamp
  636. Macro Error
  637. Value is not displayed on the screen
  638. Re: Accessing the Desktop
  639. Copy Method of Workseet Class Failed
  640. Translating spreadsheet formula to VBA
  641. Automated Print in Macro?
  642. Is something wrong with the code
  643. Re: Automated Print in Macro?
  644. COUNTIF criteria
  645. sql results in excel
  646. Question: Range().Select for more than one row?
  647. Modeless form for user interaction
  648. Custom checkbox
  649. Dropwdowns not working in Excel XP
  650. Right function disappeared
  651. Re: Registry
  652. OnAction
  653. Re: changing setting of tool box
  654. Copy range of many files in directory.
  655. Re: Auto Path in Footer
  656. Re: Automatically incrementing invoice number from template?
  657. Auto Path in Footer
  658. Delete row and Excel locks up
  659. Re: Setting zoom for all worksheet pages
  660. IF then formula
  661. Data Validation
  662. Can't terminate the excel instance from VB
  663. Pivot table
  664. Event macro
  665. Count # of Times Sub Executes
  666. Filtering on Formulas (makes messy sheets)
  667. Outline and hide feature
  668. different places to put excel code?
  669. Replace in VBA Excel
  670. Zero records in Filter
  671. Control Bar
  672. Re: Registry
  673. Re: Can't set manual HPageBreaks
  674. Re: Need Macro to Copy Visible Cells to New Sheet
  675. Re: Need Macro to Copy Visible Cells to New Sheet
  676. VBA Code for Links to Excel workbooks
  677. Code for Links from Excel to Access
  678. vb simple formula
  679. Re: How to tell whether a cell contains a formula?
  680. Naming Chart
  681. Extracting PDF report into Excel
  682. Re: How to tell whether a cell contains a formula?
  683. Excel on a Form
  684. resetting worksheet properties
  685. Events for cell deletion
  686. VBA for Dialog Box
  687. Re: Naming Chart
  688. List box initialization
  689. Re: window minimize
  690. Re: List box initialization
  691. Code for existing links
  692. Events for workbook close
  693. CUT And PASTE
  694. Re: Frustrated with Factorials
  695. Unable to set the Locked Property of the Range Class
  696. Displaying Last Editor's Name
  697. Get.document(50)
  698. Re: The Find Method
  699. Making menu item changes temporary
  700. Code Text Into Chart Lines?
  701. Open Microsoft Word and get Page count.
  702. Re: An Excel environment started from a VB script .vbs file.
  703. Load Vb Functions
  704. Can't find project
  705. Event - RaiseEvents Within Class Modules
  706. Link code
  707. Format text
  708. MultiPage UserForm
  709. Re: shape grouping text
  710. Re: retreiving number of e-mails from public folder in Outlook
  711. Having problem getting date into format: yyyy/mm/dd
  712. Changing PivotCache SQL Database
  713. Page Header with Fit to 1 page wide
  714. Modify Find Code
  715. Re: Email using universal naming convention
  716. Locked/Protect in Workbook_open not working in X2002
  717. Changing font color based on the values
  718. excel.exe error with query
  719. out of memory error
  720. Print Landscape AND Portrait Orientation in ONE Worksheet
  721. VBA Question
  722. 5.6 Scripting
  723. Re: Print Landscape AND Portrait Orientation in ONE Worksheet
  724. Camera_Toy_Videogame_Laptop_sale
  725. Location of Help File and SQLDMO
  726. VB code for printing one page at a time
  727. Re : Excel event handler Worksheet_SelectionChange
  728. Returning single/multiple values from array function
  729. Old button code not working in Excel2002
  730. Importing data from the web
  731. If..Else Statement in Excel
  732. Assigning the name of a userform/control to a changing string
  733. Combo Box Values
  734. Demo of Wheelmouse Scrolling Listboxes
  735. The Tab Function
  736. The Tab Function (Take 2)
  737. find next unused row
  738. A question on read the record from excel
  739. control toolbox
  740. Copy Multiple Spreadsheets into One Workbook
  741. ActiveX Controls on Excel sheets
  742. what is a vb script
  743. Re: Quasi array formula
  744. Beginners' Question : How to move selected columns & rows to a two dimensional array
  745. problem (bug?) using =HYPERLINK in database query column?
  746. Worksheet Change Event Help Please
  747. ComboBox Values
  748. Copy selected data to new workbook
  749. ResetColors failed
  750. Re: How to create picklists programmatically
  751. Excel textbox problem
  752. row highlighter
  753. Accessing/Clearing range in hidden workbook
  754. Newbie. Please help me find a loop solution
  755. Converting XML data from SQL Server to Excel spreadsheets for reporting purposes
  756. excel and powerpoint instructions. Possible?
  757. Re:Find out from a date if it is a red letter day or not
  758. Web Query fail to Refresh All but individual refresh is ok
  759. Web query timeout
  760. Two really easy questions
  761. tough problem - working out if data is within certain boundaries
  762. Code to Hunt Linked Cells
  763. removing text within a cell
  764. Code to copy chart
  765. Msg Box
  766. Re: Newbie. Please help me find a loop solution
  767. End loop macro with count
  768. Beginner's question
  769. Open Method disabling Macros
  770. PivotTable: AddDataField method
  771. Re: Code to copy chart
  772. Re-assigning the value of a variable for a for loop from
  773. Sending an array to DLL Function
  774. Modify Calculation
  775. auto find xls files and values
  776. Re: dynamically linking cells
  777. setting label to open folder
  778. Re: The Find Method
  779. Re: Macro - Pasting clipboard in a find box
  780. IF ___ then fill color???
  781. Re: Logic Question - Can you help please
  782. Creating a directory from a date
  783. Control Source
  784. Excel 2002
  785. Re: Paste in Find and Replace Dialogue
  786. Opening a worksheet with a button?
  787. Re: Importing files
  788. Re: Paste in Find and Replace Dialogue
  789. Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
  790. Re: Finding Empty Rows
  791. Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
  792. Re: Finding Empty Rows
  793. Formatting the default Excel sheet
  794. RS232 to Excel
  795. Excel VBA
  796. Re: Code for Grouping Text Values in Pivotfield
  797. Using Built in Functions in VBA Code
  798. TextBox.SetFocus
  799. Re: Excel VBA
  800. VBA to Find & Delete
  801. Web Query & Cookies
  802. Responding to Enter Key
  803. Vlookup issue
  804. Hide worksheets on start
  805. Re: UserForm Control
  806. Re: UserForm Control
  807. MS Excel - SQL Parser with VB .NET
  808. Sorting with worksheet protected
  809. Automate macro
  810. Re: Joining text in multiple cells
  811. newbie programming
  812. Replace File
  813. Creating worksheets then name it
  814. My Apologies
  815. I need help
  816. macros, functions, and command buttons
  817. Re: Worksheet name used in a formula
  818. User-defined function creating circular reference
  819. Changing Author Name in an existing cell's comment
  820. Using a variable to represent a Checkbox Name(OLEObject)
  821. Personal.xls only partially effective?
  822. Determining if a worksheet exists within a workbook
  823. Delete userform/module using VB
  824. Excel macro on a DOS command line
  825. SetFocus method in VBA
  826. find data on 2 different sheets?
  827. Re: Button To Cancel Macro
  828. Re: Delete cells in row A with just zeroes
  829. A code problem with short Estimating worksheets
  830. Re: macro that runs for multiple files
  831. disable menus on opening Excel
  832. _How could I get the code to find out the resolution that user has in the computer
  833. What order does VBA look at userform controls?
  834. Re: Counter
  835. Re: Counter
  836. Excel 2002 Automatic Macros
  837. Code help.
  838. Determining whether function called by Excel or VBA
  839. Macro
  840. Adv. Filter & Worksheet Change Event
  841. Command Button Properties
  842. Single command button to select one of several choices.
  843. Do Until loop with if statement
  844. Re: Collating Sheets question..advice plz
  845. Re: Worksheet name used in a formula
  846. Permit DoubleClick but prevent other editing
  847. Re: Empty Cells!??
  848. Re: Run-time changes to subtotal parameter list
  849. Re: Network drives
  850. Re: DDE and application.caller help
  851. Sending data to Outlook for emailing
  852. Setting values in another workbook
  853. Copy with NumberFormatLocal included
  854. DCOUNTA formual in VB Script
  855. Excel returns blank values using ADO/VB
  856. Spinn Button
  857. Re: ComboBox items
  858. Koppeling Excel en JPG-Afbeeldingen in aparte map
  859. Problem with using Protect when userinterfaceonly:=True
  860. Search For Data In An Excel Sheet Thru Code
  861. Looking for break even axample.
  862. Excel Spreadsheet Corruption
  863. Close button on Custom Menu Bars
  864. Re: curious date results
  865. Re: Need Code Enhancements
  866. Re: DCOM98 and EXCEL2000 collision
  867. Mouse Click Event
  868. Need Code Enhancements
  869. DCOM98 and EXCEL2000 collision
  870. Date function and combobox
  871. Decreasing/Increasing decimal places
  872. Counting Colums with Data
  873. Finding Duplicates
  874. Excel 2002 and 97 compatability
  875. run macro for all files in the directory
  876. Running a VB Script
  877. open for append
  878. Re: Excel Page count
  879. Re: Excel Page count
  880. Import and transpose tab seperated data from text file
  881. writing cells with variables from vba
  882. Re: How do I set the name of a WorkSheet?
  883. Macro Questions: Returning multiple results, description of parameter syntax et al.
  884. Re: writing a variable to a cell
  885. References question
  886. Re: writing a variable to a cell
  887. Re: Countif Function
  888. Macro to Paste Special
  889. Revisit "Close without Saving Changes", please?
  890. Recommend a good book for vba for a beginner
  891. Re: Automate Control Tool Installation
  892. Activate Column after locating text in a row
  893. Re: Countif Function
  894. Excel Getobject error
  895. Custom formula
  896. Re: Countif Function
  897. Re: Designing Multiple Spreadsheets with scaled data access.
  898. executing macros with variable names
  899. Cannot shift objects off sheet
  900. Countif Function
  901. Countif Function
  902. Re: Zero out the cell macro
  903. Project won't compile...
  904. Re: Macro to Paste Special
  905. expected sub, function, or property
  906. Disable Control s
  907. Put copy/paste between books in macro
  908. Selecting Cells to set up Advanced Filter
  909. Re: Unhide row
  910. Formula Probs
  911. Thank you all.
  912. upload a button image
  913. Pivot table not refreshing
  914. Re: Userform with template class module problem
  915. Re: Userform with template class module problem
  916. Running macros
  917. Formula Problem
  918. Format a cell IF...
  919. Trendline Equation
  920. 1.)Input Boxes 2.) Condensing a Code
  921. Re: Formula probs
  922. MSForms cancel
  923. Programatically Breaking Links of Copied Chart Sheet
  924. Obtaining Series Name and X/Y Value Ranges for Charts
  925. sql.request for secured Access Database record retrieval
  926. tool bar problems
  927. Copy formulas to certain sheets
  928. Unprotecting worksheet in a macro.
  929. Re: hiding vba code
  930. Re: Automatically generate a unique file name via macro...
  931. Re: worksheet tab - rightclick choices
  932. Re: Sheets(array) method for printing grouped worksheets
  933. Re: Enable Macros Warning
  934. Embedded form?
  935. Re: cboBox to read data from a spreadsheet Range
  936. How to make drop-down lists show more rows
  937. retreiving number of e-mails from public folder in Outlook
  938. Sorting Names in an Array
  939. Re: how to kill excel using a vbscript
  940. Re: Scroll
  941. Printing question - Spreadsheet......
  942. sorting zip codes
  943. Re: retreiving number of e-mails from public folder in Outlook, next step
  944. Re: Save as CSV without being prompted
  945. Re: Formatting in VBA
  946. Re: Automatically generate a unique file name via macro...
  947. For Each
  948. Re: pull value from last cell in a column
  949. Determining the immediate caller of a function
  950. How to Pause or Stop a running Macro
  951. Spin Button
  952. run a macro on an in-active workbook
  953. countif and AND
  954. Re: Page Formating & Macros
  955. Custom Toolbar (Macro path changes)
  956. Re: Save as CSV without being prompted
  957. Excel tries to reopen the file
  958. Searching / Calculating Multi-Dem Arrays
  959. writing to a cell
  960. Re : Excel event handler Worksheet_SelectionChange
  961. Possible to delete or edit a desktop shortcut?
  962. Pop Up Screens
  963. InStr used in SQL query
  964. Re: Value of Zoom print setting
  965. Re: cboBox to read data from a spreadsheet Range
  966. Re: Empty Cells!??
  967. LTrim
  968. Re: Beginners' Question : How to move selected columns & rows to a two dimensional array
  969. to kill a excel process
  970. Re: Sending data to Outlook for emailing
  971. Breaking a word by each alphabet and inputing it in different cells
  972. How to: reset the pull down menus to item 1 on start up?
  973. Re: How to: reset the pull down menus to item 1 on start up?
  974. FormulaArray and Formula prinicples
  975. Data Validation
  976. Re: Unload from Memory
  977. How can I create several instances of Excel ?
  978. Key behaviour
  979. enabling custom meu items?
  980. FindFormat
  981. Customizing the Legend
  982. Toolbars
  983. cell color within a function
  984. Number format in a message
  985. Highlighting 'corresponding' cells
  986. Re: charts
  987. Hide/Unhide a row in Excel
  988. run exe program and locate current workbook
  989. Protection
  990. Web Query
  991. Deleting Macros
  992. Conditional Formatting for Currency
  993. Cashflows
  994. Popup form from Excel not VBA
  995. Programming behind a button
  996. excel 2000 workbook.activate not 100% reliable with alt+tab
  997. Re: Change hyperlinks en masse?
  998. Richtext Control
  999. Re: Enable Macros Warning
  1000. show a userform