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

  1. If..Else Statement in Excel
  2. Assigning the name of a userform/control to a changing string
  3. Combo Box Values
  4. Demo of Wheelmouse Scrolling Listboxes
  5. The Tab Function
  6. The Tab Function (Take 2)
  7. find next unused row
  8. A question on read the record from excel
  9. Debugging F8/ tracing
  10. control toolbox
  11. Copy Multiple Spreadsheets into One Workbook
  12. ActiveX Controls on Excel sheets
  13. what is a vb script
  14. Re: Quasi array formula
  15. Beginners' Question : How to move selected columns & rows to a two dimensional array
  16. problem (bug?) using =HYPERLINK in database query column?
  17. Worksheet Change Event Help Please
  18. ComboBox Values
  19. Copy selected data to new workbook
  20. ResetColors failed
  21. Re: How to create picklists programmatically
  22. Excel textbox problem
  23. row highlighter
  24. Accessing/Clearing range in hidden workbook
  25. Newbie. Please help me find a loop solution
  26. Converting XML data from SQL Server to Excel spreadsheets for reporting purposes
  27. excel and powerpoint instructions. Possible?
  28. Re:Find out from a date if it is a red letter day or not
  29. Web Query fail to Refresh All but individual refresh is ok
  30. Web query timeout
  31. Two really easy questions
  32. tough problem - working out if data is within certain boundaries
  33. Code to Hunt Linked Cells
  34. removing text within a cell
  35. Code to copy chart
  36. Msg Box
  37. Re: Newbie. Please help me find a loop solution
  38. End loop macro with count
  39. Beginner's question
  40. Open Method disabling Macros
  41. PivotTable: AddDataField method
  42. Re: Code to copy chart
  43. Re-assigning the value of a variable for a for loop from
  44. Sending an array to DLL Function
  45. Modify Calculation
  46. auto find xls files and values
  47. Re: dynamically linking cells
  48. setting label to open folder
  49. Re: The Find Method
  50. Re: Macro - Pasting clipboard in a find box
  51. IF ___ then fill color???
  52. Re: Logic Question - Can you help please
  53. Creating a directory from a date
  54. Control Source
  55. Excel 2002
  56. Re: Paste in Find and Replace Dialogue
  57. Opening a worksheet with a button?
  58. Re: Importing files
  59. Re: Paste in Find and Replace Dialogue
  60. Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
  61. Re: Finding Empty Rows
  62. Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
  63. Re: Finding Empty Rows
  64. Formatting the default Excel sheet
  65. RS232 to Excel
  66. Excel VBA
  67. Re: Code for Grouping Text Values in Pivotfield
  68. Using Built in Functions in VBA Code
  69. TextBox.SetFocus
  70. Re: Excel VBA
  71. VBA to Find & Delete
  72. Web Query & Cookies
  73. Responding to Enter Key
  74. Vlookup issue
  75. Hide worksheets on start
  76. Re: UserForm Control
  77. Re: UserForm Control
  78. MS Excel - SQL Parser with VB .NET
  79. Sorting with worksheet protected
  80. Automate macro
  81. Re: Joining text in multiple cells
  82. newbie programming
  83. Replace File
  84. Creating worksheets then name it
  85. My Apologies
  86. I need help
  87. macros, functions, and command buttons
  88. Re: Worksheet name used in a formula
  89. User-defined function creating circular reference
  90. Changing Author Name in an existing cell's comment
  91. Using a variable to represent a Checkbox Name(OLEObject)
  92. Personal.xls only partially effective?
  93. Determining if a worksheet exists within a workbook
  94. Delete userform/module using VB
  95. Excel macro on a DOS command line
  96. SetFocus method in VBA
  97. find data on 2 different sheets?
  98. Re: Button To Cancel Macro
  99. Re: Delete cells in row A with just zeroes
  100. A code problem with short Estimating worksheets
  101. Re: macro that runs for multiple files
  102. disable menus on opening Excel
  103. _How could I get the code to find out the resolution that user has in the computer
  104. What order does VBA look at userform controls?
  105. Re: Counter
  106. Re: Counter
  107. Excel 2002 Automatic Macros
  108. Code help.
  109. Determining whether function called by Excel or VBA
  110. Macro
  111. Adv. Filter & Worksheet Change Event
  112. Command Button Properties
  113. Single command button to select one of several choices.
  114. Do Until loop with if statement
  115. Re: Collating Sheets question..advice plz
  116. Re: Worksheet name used in a formula
  117. Permit DoubleClick but prevent other editing
  118. Re: Empty Cells!??
  119. Re: Run-time changes to subtotal parameter list
  120. Re: Network drives
  121. Re: DDE and application.caller help
  122. How can I do this using MS Excel ?
  123. Sending data to Outlook for emailing
  124. Setting values in another workbook
  125. Copy with NumberFormatLocal included
  126. DCOUNTA formual in VB Script
  127. Excel returns blank values using ADO/VB
  128. Spinn Button
  129. Re: ComboBox items
  130. Koppeling Excel en JPG-Afbeeldingen in aparte map
  131. Problem with using Protect when userinterfaceonly:=True
  132. Search For Data In An Excel Sheet Thru Code
  133. Looking for break even axample.
  134. Excel Spreadsheet Corruption
  135. Close button on Custom Menu Bars
  136. Re: curious date results
  137. Re: Need Code Enhancements
  138. Re: DCOM98 and EXCEL2000 collision
  139. Mouse Click Event
  140. Need Code Enhancements
  141. DCOM98 and EXCEL2000 collision
  142. Date function and combobox
  143. Decreasing/Increasing decimal places
  144. Counting Colums with Data
  145. Finding Duplicates
  146. Excel 2002 and 97 compatability
  147. run macro for all files in the directory
  148. Running a VB Script
  149. open for append
  150. Re: Excel Page count
  151. Re: Excel Page count
  152. Import and transpose tab seperated data from text file
  153. writing cells with variables from vba
  154. Re: How do I set the name of a WorkSheet?
  155. Macro Questions: Returning multiple results, description of parameter syntax et al.
  156. Re: writing a variable to a cell
  157. References question
  158. Re: writing a variable to a cell
  159. Re: Countif Function
  160. Macro to Paste Special
  161. Revisit "Close without Saving Changes", please?
  162. Recommend a good book for vba for a beginner
  163. Re: Automate Control Tool Installation
  164. Re: Countif Function
  165. Activate Column after locating text in a row
  166. Excel Getobject error
  167. Custom formula
  168. Re: Countif Function
  169. Re: Designing Multiple Spreadsheets with scaled data access.
  170. executing macros with variable names
  171. Cannot shift objects off sheet
  172. Countif Function
  173. Countif Function
  174. Re: Zero out the cell macro
  175. Project won't compile...
  176. Re: Macro to Paste Special
  177. expected sub, function, or property
  178. Disable Control s
  179. Put copy/paste between books in macro
  180. Selecting Cells to set up Advanced Filter
  181. Re: Unhide row
  182. Formula Probs
  183. Thank you all.
  184. upload a button image
  185. Pivot table not refreshing
  186. Running macros
  187. Formula Problem
  188. Format a cell IF...
  189. Trendline Equation
  190. 1.)Input Boxes 2.) Condensing a Code
  191. Re: Formula probs
  192. MSForms cancel
  193. Programatically Breaking Links of Copied Chart Sheet
  194. Obtaining Series Name and X/Y Value Ranges for Charts
  195. sql.request for secured Access Database record retrieval
  196. tool bar problems
  197. Copy formulas to certain sheets
  198. Unprotecting worksheet in a macro.
  199. Re: hiding vba code
  200. Re: Automatically generate a unique file name via macro...
  201. Re: worksheet tab - rightclick choices
  202. Re: Sheets(array) method for printing grouped worksheets
  203. Re: Enable Macros Warning
  204. Embedded form?
  205. Re: cboBox to read data from a spreadsheet Range
  206. How to make drop-down lists show more rows
  207. retreiving number of e-mails from public folder in Outlook
  208. Sorting Names in an Array
  209. Re: how to kill excel using a vbscript
  210. Re: Scroll
  211. Printing question - Spreadsheet......
  212. sorting zip codes
  213. Re: retreiving number of e-mails from public folder in Outlook, next step
  214. Re: Save as CSV without being prompted
  215. Re: Formatting in VBA
  216. Re: Automatically generate a unique file name via macro...
  217. For Each
  218. Re: pull value from last cell in a column
  219. Determining the immediate caller of a function
  220. How to Pause or Stop a running Macro
  221. Spin Button
  222. run a macro on an in-active workbook
  223. countif and AND
  224. Re: Page Formating & Macros
  225. Custom Toolbar (Macro path changes)
  226. Re: Save as CSV without being prompted
  227. Excel tries to reopen the file
  228. Searching / Calculating Multi-Dem Arrays
  229. writing to a cell
  230. Re : Excel event handler Worksheet_SelectionChange
  231. Possible to delete or edit a desktop shortcut?
  232. Pop Up Screens
  233. InStr used in SQL query
  234. Re: Value of Zoom print setting
  235. Re: cboBox to read data from a spreadsheet Range
  236. Re: Empty Cells!??
  237. LTrim
  238. Re: Beginners' Question : How to move selected columns & rows to a two dimensional array
  239. to kill a excel process
  240. Re: Sending data to Outlook for emailing
  241. Breaking a word by each alphabet and inputing it in different cells
  242. How to: reset the pull down menus to item 1 on start up?
  243. Re: How to: reset the pull down menus to item 1 on start up?
  244. FormulaArray and Formula prinicples
  245. Data Validation
  246. Re: Unload from Memory
  247. How can I create several instances of Excel ?
  248. Key behaviour
  249. enabling custom meu items?
  250. Re: writing a variable to a cell
  251. FindFormat
  252. Customizing the Legend
  253. Toolbars
  254. cell color within a function
  255. Number format in a message
  256. Highlighting 'corresponding' cells
  257. Re: charts
  258. Hide/Unhide a row in Excel
  259. run exe program and locate current workbook
  260. Protection
  261. Web Query
  262. Deleting Macros
  263. Conditional Formatting for Currency
  264. Cashflows
  265. Popup form from Excel not VBA
  266. Programming behind a button
  267. excel 2000 workbook.activate not 100% reliable with alt+tab
  268. Re: Change hyperlinks en masse?
  269. Richtext Control
  270. Re: Enable Macros Warning
  271. show a userform
  272. Re: Automatically generate a unique file name via macro...
  273. Calling a function from within EXCEL
  274. Print Macro : Object not set
  275. Symbols in UserForms
  276. Rename attachment
  277. Rename a sub
  278. Re: This is just a test!
  279. Re: Macro to print on both sides
  280. Help with Formulas
  281. Worksheet_Change Event "Circular Reference"
  282. Application.Calculatefull function
  283. ON ERROR
  284. column drag-and-drop
  285. Re: Loops
  286. Passing a value to a variable from Userform
  287. Sort method of range
  288. Saving macros before re-install
  289. Re: Formatting Problem on Double-Zero String
  290. Re: Macro to print on both sides
  291. debug errors....
  292. User Form
  293. Please help: Running a macro only once
  294. Excel Web Query
  295. Close database if it is open
  296. Non-absolute named ranges
  297. Keeping original data format in a pivot table
  298. Form output naming
  299. Conditional Formatting
  300. Re: Does destroying the ADO Connection close the database?
  301. variables in last cell
  302. Re: Does destroying the ADO Connection close the database?
  303. DateLastModifed and Open File
  304. Copying files ...Network to Network
  305. Re: Naming Worksheets in VBE
  306. Re: Naming Worksheets in VBE
  307. Unlocking Cells
  308. Re: marco variables or substitution
  309. Re: Unlocking Cells
  310. Copying ranges
  311. using end and down keys when recording a macro
  312. Deleting a Prompt Message
  313. Proper way to pass errors up the line
  314. Re: marco variables or substitution
  315. Pivot Table - Change SQL Statement Problem
  316. I can't solve this one...can anyone help
  317. RunTime code problem
  318. The Macro Window
  319. Re: Enable Macros Warning
  320. Creating a new word doc and putting some VBA code behind it
  321. passing variables from excel to word
  322. CLEAN function does not work
  323. SUM using Three ranges. Two Comparisons and the SUM Range
  324. Re: Userform button options
  325. Re: Date Created reported as wrong
  326. Re: UserForm not passing Boolean variable
  327. code break
  328. Why am I getting NA
  329. Unable to launch html helpfile
  330. SUMIF
  331. Re: Programming a current procedure
  332. Age function how to
  333. Re: Dynamic Values in Procedure
  334. Pivot Table Problem
  335. Delete row where active cell is located using VBA
  336. Re: Delete the row where the activecell is located with VBA
  337. Data Entry on a Form
  338. Re: finding a range of cells to match a date
  339. Re: Hangs on Outlook after sending excel ss
  340. copy to hidden sheet
  341. Please help
  342. Excel 2002 to automatically e-mail me a reminder
  343. How can I get "File Close" to prompt me to "Save Changes" ??
  344. Re: copy to protected sheet
  345. copy to protected sheet
  346. Assigning Selected Cells to Code
  347. Help Creating XLL
  348. Re: finding a range of cells to match a date
  349. Starting a macro by changing a cell in a column.
  350. send page by email
  351. execute code for all 12 months
  352. Contect Menu Help
  353. counting non-empty rows in a column
  354. inserted code into project but can't run it in run dialogbox
  355. Newbie : Advanced Filter Criteria
  356. Use list box to navigate to different sheets...
  357. Variable Filename/Worksheet/Workbook
  358. Help with some code please
  359. hide row automatically
  360. backup file
  361. CommandBarControl class
  362. data validation
  363. Re: VLOOKUP
  364. Re: VLOOKUP
  365. coloring limits
  366. Line numbers
  367. Re: icons for custom menu choices
  368. Macro Help, Please
  369. Re: Unwanted Protected Code
  370. Undo & ErrorHandler
  371. Insert colum with 0's
  372. Help files will not display
  373. Change location of where file is stored
  374. text box on a form
  375. Hyperlink question
  376. Re: cannot get total
  377. Extracting values from multiple EXCEL spreadsheets into one
  378. Using Arrays in InputBox Method
  379. Re: cannot get total
  380. Comparing Two Columns - Multiple Words in Same Same Word
  381. Comparing Groups
  382. Running a batch file from Excel VBA
  383. help
  384. ...................................WOMAN IN DESPERATE HELP!!
  385. Apply macro to closed workbooks
  386. Exception 0x800ac472 when accessing Excel
  387. CONCATENATE
  388. Re: Hiding rows quesion
  389. re ControlButton numbers , Id:=???
  390. Re: CONCATENATE
  391. Evaluate OptionGroup in XL Dialog
  392. Enable Macros
  393. Validation code not functioning correctly
  394. scraping text from the active window
  395. Re: Duplicate values
  396. Re: Duplicate values
  397. Checking Listbox Items
  398. Re: Problem - Deleting a Picture from a Cell
  399. Templates
  400. looping through worksheets
  401. Randomly fill in rows
  402. SumProduct or Array Function for summing by month and year
  403. icons
  404. Copy VB code to other workbook?
  405. relative vs complet reference
  406. Randomize a list of names
  407. add VB6 Clipboard object
  408. INDIRECT reference
  409. utility to add standard comment
  410. programmatically close help file before Excel closes?
  411. C# (sharp) and Excel
  412. VBA Runtime Error
  413. Macro records in R1C1 style
  414. locating and separating out duplicates
  415. Re: looping through worksheets
  416. Excel not warning if another user has the workbook open
  417. Data validation using calculated list
  418. how to assign ranges on different sheets to an array
  419. auto add column
  420. File save location with Application.GetSaveAsFilename
  421. Form control not working
  422. subtotalling where # of columns vary
  423. Controlling the mouse
  424. Need help creating a userform with optionbuttons
  425. formatting
  426. Click event on Scrollbar
  427. Re: Find button in excel worksheet
  428. XLL support discontinued?
  429. DATA VALIDATION
  430. Start Excel from Java
  431. DATA ENTERING IN DATA VALIDATION
  432. Re: adhere to cell menu left-margin
  433. DATA VALIDATION
  434. error with data validation
  435. Free animating ActiveX control
  436. User Defined Functions
  437. Web Data
  438. protect sheet blocks filter
  439. Re: 3 problems giving me grief. Any help appreciated.
  440. Building a form on the fly
  441. Resuming code after closing a print preview
  442. Whole vs decimal
  443. create column & Row in userfrom
  444. List all Functions
  445. Auto_Open disabling
  446. Default Date: Today
  447. chart titles
  448. Replace Function
  449. Re: Replace Function
  450. Event Question
  451. Re: Simple Question
  452. Random file name
  453. Re: Automatic print area
  454. Changing SQL Statement for PivotCache linked to multiple tables
  455. converting workbooks to worksheets
  456. exception at 0x6503999b (VBE6.DLL) - Please
  457. Menubar locked in Internet Explorer
  458. Re: Set Value for Date/Time Picker
  459. Counting selected entries
  460. sum with two conditions and a wildcard
  461. Replace Excel-Icon on Worksheet Menu Bar
  462. VBA Excel 2000 - one shot multiple cells modification
  463. Copy and Paste ranges between files
  464. Excel97 cannot access file
  465. api call routines
  466. long IF statement with lots of OR's
  467. Re: Save CSV as TXT
  468. Re: PAYMENT CALCULATIONS
  469. use shell function in vbscript
  470. Break Modes
  471. Trouble with Focus
  472. ListBox Populate
  473. Macros disabled on all but one of 3 windows in excel
  474. Compile Error! Can't find project or Library --- Help!
  475. Copy Word table to Excel
  476. Macro to change security level
  477. Cell Formula
  478. Any way to grab a .csv file from a folder using Wildcards
  479. Frequncy of unique values in array
  480. XP vs 2000 macro error
  481. Script?
  482. add-ins error + setting workbooks
  483. Exclude directory from .FileSearch
  484. mail message 1.0 Type library
  485. Re: How to set focus back to sheet after showing a user form
  486. deleting rows, takes a long time!
  487. copy/paste macro
  488. time of day automation
  489. Using the Vlookup formula
  490. looping from one column to the next
  491. Force File Read-Only?
  492. User Defined Type Structure - want it to be variable not numeric literal
  493. Force Read-Only?
  494. excel chart embedded in asp page
  495. Error Handler not handling error...
  496. code for lookup,& triggers.
  497. Re: right right$ left left$ mid mid$
  498. Finding a cell
  499. Re: right right$ left left$ mid mid$
  500. selecting a range
  501. importing prn file
  502. Excel crashes when created files open ...
  503. Getting Application.Sum to act like =SUM
  504. Two AddIn Questions
  505. Re: right right$ left left$ mid mid$
  506. Time of Day Update
  507. Commenting custom formula fields/formula on formula editor
  508. Stuck myself - can't bring back "VeryHidden"
  509. hide #VALUE! and ######
  510. Re: Color Coding Cells
  511. Option Explicit and Arrays
  512. Is it possible to assign a macro to a pivot table?
  513. file search with excel vba
  514. Userform Textbox writing to a cell
  515. Conditional formatting
  516. Disable a command from with in a workbook
  517. Fill & Filter in VBA
  518. CommandBarButton.OnAction prop fires when set? Arg!
  519. How to enable macro when Excel doesn't give you an option
  520. Stopping pivot table refresh
  521. Running a macro on a template
  522. Event triggered by Hiding/Unhiding columns?
  523. Re: external range in VBA (user defined formula)
  524. How can I start a XLL using VC++?
  525. macro that loops to multiple columns
  526. Re: Find button in excel worksheet
  527. Re: how to assign ranges on different sheets to an array
  528. Application.save gives a workspace file?
  529. Microsoft AccessLinks add-in
  530. Selecting A Range
  531. Re: Selecting A Range
  532. Re: Save CSV as TXT
  533. Re: Clear destination, then copy betwen workbooks
  534. Macro to Select Pages & Show Print
  535. Control tip text
  536. Bitwise And
  537. HOW TO: embed binary data in Excel - an odyssey
  538. Linking two userforms
  539. Scrolling text
  540. FYI - VBE Breakpoints Skipped due to Conditional Format
  541. Selecting A Range
  542. Re: external range in VBA (user defined formula)
  543. Re: Text Boxes on Userforms
  544. After save event
  545. Selecting a range
  546. How can I get the record from excel whit asp?
  547. About disabling Excel window size-change ...
  548. Re: How to set focus back to sheet after showing a user form
  549. Re: Approach to a Menu of Multiple Print Ranges
  550. Saving only active sheet
  551. DataCombo seems locked after changing TabStrip
  552. DataCombo seems locked after changing TabStrip
  553. Magic Shrinking Listbox
  554. count cell styles
  555. Re: grey ghost toolbars in Excel
  556. menu question
  557. If Worksheets("Test") Exists Then Delete It
  558. Opening CSV Files
  559. Help with borders
  560. Multi Select List Box
  561. save txt file
  562. Event detour
  563. Creating a custom calendar form
  564. Excel to Text
  565. RE: Stuck myself - can't bring back very hidden
  566. How do DLLs Work?
  567. HELP: converting HH:MM to text
  568. How do I move a pagebreak?
  569. Re: Copying from one cell to another
  570. Excel/VBA GetOpenFileName/MultiSelect Problem
  571. Loading text file
  572. List Box catalyst to cell reference
  573. Randomize a list
  574. syntax for a sub ( )
  575. Re: Help with selecting a range...
  576. Re: Freeze Panes with Object Model
  577. Re: Help with selecting a range...
  578. Re: Help with selecting a range...
  579. COM addin call missing
  580. Re: unprotecting pswd protected sht
  581. Re: Change Sheet By Macro
  582. addin a module on fly
  583. Re: unprotecting pswd protected sht
  584. Macro fails without VB help files
  585. Time Format & Unload problem
  586. "window scroll" event
  587. subtotalling - # of columns vary
  588. Automating Acrobat from Excel
  589. Send Mail
  590. Printing Multiple Ranges from Multiple Worksheets
  591. Re: Excel macro
  592. macros disappeared
  593. en-/disable macros pop-up
  594. Check my code to use template?
  595. Re: Import and transpose tab seperated data from text file
  596. Replacement for INKEY$
  597. Windows Common Dialogs in VBA?
  598. Better way to 'unhang' my workbook
  599. Default recordset type?
  600. Re: activex component can't create object with SAP 6.20
  601. "Store" ufm.checkbox values for later use
  602. i need help with a formula
  603. Re: disable pop up when overwrithing saved files
  604. Custom Functions used through the wizard
  605. Re: disable pop up when overwrithing saved files
  606. Re: get value of a cell with a mouse click
  607. Exporting data from Excel 2002
  608. "Microsoft Excel has encountered a problem..."
  609. More UserForm problems
  610. naming multiple public variables generated by single function
  611. disable pop up when overwrithing saved files
  612. Images will not display
  613. Embedded Word Document not painted until I click on it and activate it with the mouse
  614. reurning currently opened file name
  615. Modifying the right-click popup menu of a shape
  616. windoes system directoty?
  617. Passing parameter from Excel to stored procedure?
  618. Print all data from list on seperate form
  619. Updating database table from Excel?
  620. Combobox
  621. Using Dialogs Save
  622. Using Outlook with Excel to Input Names into Email
  623. Date/Time data source refreshed function
  624. Re: Macros run slow in XP
  625. Excel macro to VB executable
  626. Need UDF help; cycling through various sheets using VBA name property
  627. Saving excel spreadsheet in a cell
  628. macro to clear rows
  629. Re: Other applications
  630. Highlight Cell on Focus
  631. Re: Paste Clipboard from Word to last row in excel
  632. Text paragraphs and image
  633. move this rectangle to hide the unused cells
  634. Re: Ignore MsgBox if run by automation
  635. Re: Ignore MsgBox if run by automation
  636. Option buttons - disabling
  637. Preventing print when cells are blank
  638. Unwanted MS Acccess Query in Excel spreadsheet
  639. Hidding columns
  640. Re: Record Worksheet Content as Macro and Execute from another Worksheet
  641. Re: Using VB to find next cell in range
  642. Re: Using VB to find next cell in range
  643. Ever see a link with these symptoms?
  644. Toggle State on Custom Menu
  645. Re: split data in many workbook
  646. Re: Object Arrays
  647. Userform and passing date values
  648. Re: Object Arrays
  649. Re: Object Arrays
  650. How do I disable the Margins button in Print Preview Window
  651. Find links with code; change from G drive to C drive
  652. Selecting a range : New Question
  653. Code page for data in Excel spreadsheets
  654. Cannot run macro from toolbar in a file on another pc
  655. running macro while in the edit mode
  656. Cell Lost Focus
  657. Repeat importing text
  658. Adjust RowHeight progammatically based on number of lines of text in a cell
  659. Add submenu to custom menu
  660. visual basic macro in excel
  661. Place Subform data onto specific cells
  662. Microsoft Excel cannot find the data...
  663. visual basic macro in excel
  664. Place Subform data into specific cells
  665. Problem with saving REAL type to txt file
  666. How many entries can you have in List Data Validation
  667. dynamic range without using OFFSET()
  668. Deleting Shared Files???!!!
  669. sum & VLOOKUP
  670. Reverting to open workbook in excel
  671. What is the equivalent of 'Shift+Enter in a cell' in VBA?
  672. data validation in excel 2000
  673. Looping thru custom controls
  674. Automatic coping on 2 column
  675. why don't buttons work?
  676. sorting using VBA
  677. Code to Change Chart Type
  678. determining last column
  679. Disable read only
  680. What's wrong with this line of code?
  681. Mask an entry using InputBox function
  682. Which formula should I use relative to a date.
  683. colour and value transfer
  684. Variable TextBox
  685. Re: tried to execute application from VBA
  686. Re: dialog raise event?
  687. Missing Word 10 Object Error References
  688. Re: accessing CheckBox on Worksheet
  689. Form Popup
  690. Re: tried to execute application from VBA
  691. On Event Macro's?
  692. Please explain why following code doesn't work....
  693. Last Active
  694. Is there a way to remove numbers w/o remove formulas
  695. Hllapi Call to Extra!
  696. ADO newbie help please
  697. Re: Date Format - Unchangeable
  698. Saving a new file with a macro
  699. Password to hide and unhide sheets
  700. Password to hide and unhide sheets
  701. Re: additem to listbox built on the fly
  702. Re: protecting macro code
  703. Re: Change Sheet By Macro
  704. Copy one spreadsheet into another without activating second spreadsheet's user form
  705. Print Range
  706. Error in formula will saving
  707. Use numeric data from a textbox on an userform
  708. Inserting Hyperlink from a Query
  709. Get User Input
  710. Finding the first few characters in a cell
  711. picking up real time updates from bloomberg
  712. Saving an Excel file as a CSV using a Macro
  713. Formatting with IF Statement
  714. Strange (forms) ListBox behavior
  715. Disabling the Update links message
  716. XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select
  717. Re: Assigning Multiple Macros to One ComboBox Control
  718. Populating Active X Controls
  719. Cell in Range Testing Function
  720. Re: external range in VBA (user defined formula)
  721. Re: Asking user to set a printarea when none is defined
  722. Should I use Excel for this software project--or something else?
  723. Re: Assigning Multiple Macros to One ComboBox Control
  724. looping to create multiple files
  725. BeforeRightClick() and Cell menu
  726. Coping Values - Not the cell
  727. Re: Manipulating Excel pie charts with VB
  728. Array Questions
  729. Help with version control
  730. date question
  731. Re: Inefficient VBA Code - Worksheets Property
  732. KERNEL32.DLL error after running EXCEL Macro
  733. Can't find informations on TrendLines
  734. collapsing columns base on criteria
  735. Running a macro to concatenate
  736. Stopping "Link Worksheets?" message box (using automation)
  737. Even Better
  738. Re: Copy/pasting between 2 workbooks...
  739. Re: Calling Excel FUNCTION MACROS Programmatically from VB
  740. Re: Timer function
  741. NETWORKDAYS
  742. Re: tried to execute application from VBA
  743. Re: Copy/pasting between 2 workbooks...
  744. Using Excel Interfaces
  745. Assign data to chart series, using array
  746. Re: Get User Input
  747. Macro to delete last charcter in a text string
  748. Opening an Excel Pivot table sheet with right information
  749. User Form Apology
  750. Re: Run Macro on many files at once
197