PDA

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. Update custom outlook form from within Excel
  2. deleting blank rows
  3. Help! Excel Macro Delete function!!
  4. "Out of Context" Message?
  5. .NET remove .net code from Excel spreadsheet
  6. Need help passing an array as an argument
  7. Date as worksheet name
  8. Excel Date/Time problem
  9. Error with Form
  10. Add page breaks from VB
  11. auto-populating columns
  12. match problems
  13. CheckBox on UserForm
  14. Event for a file being changed?
  15. Spreadsheet Dropdown ?
  16. specific name for saving.
  17. Macro or VBA help
  18. How do I use VBA to add a formula?
  19. Re: Incorrect msgPrompt
  20. Add a multiselection list box to a spreadsheet
  21. What if AutoFilter is NOT on?
  22. Running Macro in Minimized Excel Window
  23. Re: Excel if & hyperlink formula
  24. Is it possible to load an .xls file
  25. Using Variable in Rows(x:y) function
  26. Q. Consolidating a long list, in single workbook.
  27. Create an .xla
  28. code to delete a defined name
  29. Does OnTime slow macro down?
  30. Macro Expert Help needed...
  31. Using LinEst function within VBA macro
  32. New to ComboBox
  33. Opening & setting data from Excel to webpage
  34. Excel VBA-Creating Menus
  35. IF THEN STATEMENTS
  36. Unprotecting Worksheets in VB Script
  37. How to change Text
  38. Msg Box
  39. Msg Box
  40. Msg Box
  41. Named range
  42. Directory List - Ron de Bruin
  43. combo box
  44. A Turing Machine in Excel
  45. Re: Grpahical selection of points on Excel charts
  46. How to make Excel the Top-Most application programmatically?
  47. general validation question
  48. Re: range class problem
  49. Buttons
  50. Re: Creating pick box with unique input values from a worksheet in the
  51. Simple table query
  52. Mail Merge Error
  53. Mail Merge Error
  54. Multiple Column Cell Compare looping through Rows
  55. Re: Populating blank cells with the data in the cell above.
  56. VBA Script to detect user input
  57. decimal & percent format
  58. activeworkbook.saveas - saving format changes
  59. Please help..urgent !
  60. function called from worksheet and bad result!
  61. Unprotecting!
  62. Unprotecting!
  63. Unprotecting!
  64. Filling An Autofiltered List
  65. Filling An Autofiltered List
  66. Custom Menu return to Excel Menu upon Closing
  67. Problem with TabBehavior on UserForms
  68. which declaration to use
  69. Insert Excel Sheeet using VBA
  70. Problem with printform
  71. Permission to use object denied.
  72. Go To Home
  73. Programatically navigate to depedent cell(s)
  74. Option of Print Preview or Save As
  75. need time calculation formula
  76. Autofill Destination
  77. How To:
  78. How to save a bar chart as an image file programmatically?
  79. Excel VBA: Create new conditions
  80. print userform (for MVA)
  81. cannot unhide rows!
  82. cannot unhide rows
  83. cannot unhide rows
  84. cannot unhide rows/columns in the worksheet.
  85. Freeze pane
  86. Excel Grid to Template/Form?
  87. Open Office Kills my secrets !
  88. Setting printarea through range object
  89. Help in Excel VBA Programing - How to check an Excel Worksheet?
  90. Recommended Book on Visual Basic for Excel
  91. Changing Cells, How to
  92. Trouble opening worksheet
  93. Check if empty
  94. How to justify in merged cells
  95. Remove reference names
  96. Problem with external_data
  97. Excel Chart Class/Object not work propely in IE
  98. If/Then Matrix? Can Excel do this?
  99. Object variable error
  100. Command buttons duplicating themselves
  101. Deleting named ranges by looping through range collection
  102. How to create new sheet in excel using VJ#.Net
  103. calling windows with variables
  104. Turn Off Scientific Notation
  105. Turn Off Scientific Notation
  106. How to set default font for forms?
  107. How to locate record in VBA of Excel2000
  108. Find
  109. Possibilities Enhancing Auditing Features?
  110. Rows Count of a particular column
  111. Rows Count of a particular column
  112. Using same VBA program in diff. Excel versions.
  113. VB Code
  114. Quick question about dynamically adding and naming worksheets
  115. Excel 97 - Prevent Renaming/Deleting Protected Worksheet
  116. code help cont.
  117. Re: If Statement
  118. code help
  119. sorting rows
  120. Filling a Word form from an Excel spreadsheet
  121. ComboBox on UserForm
  122. Command buttons stack up!
  123. Excel "Work"menu option
  124. filter code help
  125. DDE function
  126. loop to delete rows...
  127. Have a Macro create a Macro
  128. Multi Check Boxes (Selecting Just One)
  129. R1C1 vs A1 addressing
  130. Macro Names
  131. last cell in filter
  132. Help in opening powerpoint file variable from excel
  133. Dynamic Cell Selection
  134. Pivot code
  135. TextBox focus 4
  136. application.enableEvents
  137. dbx file duplicates QUESTION
  138. prevent coping from CD
  139. Populating other cells with combo box selection
  140. Copy and paste subtotal to another worksheet
  141. dynamic chart title
  142. Worksheet change subs.
  143. activating cells
  144. Device I/O Error
  145. CONDITIONAL DELETE
  146. Jon Peltier question: use of MATCH
  147. Excel/PowerPoint E-Mails
  148. Advancing A Number With The Push A Button
  149. Textbox error checK problems
  150. Excel <-> Application clipboard data transfer
  151. Infinite loop? Help.
  152. Create Concatenated List with Incremental Values
  153. ComboBox on UserForm
  154. combo box
  155. VBA / IF - Then / Custom Toolbar
  156. Number to text with leading zero
  157. How can I insert 4000 rows of Excel data into a sql database
  158. unique entries
  159. Excel Math Bug
  160. .Protect ET .Validation.ShowInput
  161. On Error GoTo
  162. Marking ActiveX control as safe
  163. Write no closed workbook ?
  164. button
  165. Help with Mr. Dave Peterson's Code for Consolidating Many Sheets to One
  166. how do you change a row height in a protected worksheet
  167. How to create a digital certificate>
  168. How to create a new sheet in VBA?
  169. file can not be opened
  170. Resource of excel to connection mssql to get data
  171. Excel bug, variables reset?
  172. Getting external data...
  173. Adding other bars disabled ???
  174. Scrollbar macros
  175. Help Needed to Search and Find Specific Data
  176. Protecting Macros
  177. Update Links on file open
  178. Use a RefEdit to select a single cell
  179. Forms Unload for No reason
  180. Which function to use to open an .asc file?
  181. Changing Text in grouped shapes
  182. enhance trace precedent via dialogue box?
  183. Disabling Circular Reference Checking
  184. Combo Box
  185. Option button problem
  186. Avioding "Version Update" Dialogue Box
  187. Using a Macro to Write A Marco
  188. Programming Formulas
  189. Excel 2000: Web Query not working for https site
  190. Text Box - Restricting Entry
  191. Writing to Network Workbook
  192. Convert CSV Files to XLS
  193. Dynamic Range
  194. Re: Reference Error
  195. specific cell values in two ranges
  196. combination of numbers in lottery
  197. Coverting worksheet macro to regular macro
  198. Populating Cells in a row.
  199. excel with project embeded in it
  200. Using Querytable.add to import data from a closed workbook
  201. List Selection to First Empty Row
  202. VBA Function to evaluate hlookup text string as formula
  203. Date Conversion Formula from Bob Phillips...
  204. Connect a Template with the data source.
  205. Opening a new file from a template
  206. Re: A development of a Macro by Tom
  207. How to create a "combination drop-down edit" box?
  208. Setting LinkedCell on a CheckBox Control
  209. Re: How to determine column letter in a spreadsheet?
  210. ICD9 Code Evaluation Function - an example
  211. Splitting first and family name
  212. Macro to copy text from ColumnA to B
  213. Immediate window error
  214. Listbox refuses to resize
  215. wrap text in combo box
  216. Macro compatibility between excel XP and 97
  217. Personal Settings Causing Error?
  218. Cannot assign value to Filesearch.Lookin
  219. multiselect on a listbox from Control toolbox
  220. UDFs: A simple question.
  221. Re: How to determine column letter in a spreadsheet?
  222. Microsoft Script: <x:Name>Auto_Close</x:Name> causes errors
  223. Error check and resume
  224. can not assign value to LookIn
  225. "value" works in sheet, not vba
  226. IF THEN ELSE in VBA
  227. VBA - Cells
  228. add a workbook.
  229. Kill Syntax and path
  230. Invisible AutoFilter Drop-Down Arrows
  231. copy to the same workbook
  232. Insert row if box on userform is checked
  233. Slow coding in VBA Excel 2003
  234. Wrting values with macro.
  235. Removing Outlook Warning Dialogs.
  236. Removing Outlook Warning Dialogs.
  237. Move to a specific cell
  238. Macro problem with protecting worksheet...........
  239. Help with Vlookup in VBA
  240. Linking Or Copying Filter Arrow
  241. Should be straightforward answer...
  242. Concatenate formula with relative cells
  243. Saving Excel 2000 files as .xml
  244. Empty keyword in statment Application.caption?
  245. Conditional splitting of cells
  246. Month end report ? expansion
  247. Conditional Formatting
  248. SolverOK, he not so OK
  249. Import modules EXCEL caused an invalid page fault in EXCEL.EXE
  250. Deferred Mail(2)
  251. Workbook_Open() not running
  252. Userform date format problem
  253. How to check that a string is a valid formula ?
  254. Pivot Tables Messsyyyyyy
  255. Code Execution Has been Interrupted
  256. Re: Left JOINS in multiple table MSQuery in Excel
  257. Excel 2000 V Excel 2003
  258. Re: Please help me improve macro to convert spreadsheet to tabular for
  259. Force a new Excel instance
  260. Detect Macro Completion
  261. Search "Total" in all worksheets and delete rows containing "Total"
  262. Copying ranges from one sheet to another
  263. information From Global Address Book into list box.
  264. Creating a powerpoint presentation from MS-Excel
  265. Combo box
  266. Returning range object from custom functions
  267. Cells.Replace need to keep track of result
  268. 6E+02 what is this ugly scientific format?
  269. Check active sheet not the one with macros
  270. Passing Dates to SQL From Excel
  271. Modifying an Excel Chart in VB - DOM question
  272. Macro Error(??)
  273. Create a days in calendar year add-in
  274. Re: Assigning 10x1 array to 2nd collumn of 10x3 array
  275. WAV Files
  276. Best Course to Import XML with DTD...
  277. if it looks like it matches, it's a match
  278. RE: Would like to add 0 counts to worksheet after data is returned fro
  279. Re: Assigning 10x1 array to 2nd collumn of 10x3 array
  280. Re: Need Help! VBA screen capture question
  281. Excel macro to control Word Problem
  282. Importing Text Data into Excel
  283. Macros with vlookup
  284. Select cells in a column
  285. Re: Macro with Query
  286. Re: Modules
  287. shifting headings over on column
  288. How to Process Query Data after Query is Refreshed
  289. shifting headings over on column
  290. Re: Modules
  291. For loop with non consecutive number
  292. User Defined Function used in Macro returns #VALUE
  293. Page Break Preview
  294. Directory List
  295. Convert Date Format of 7/29/04 to Date Format of 072904
  296. Excel 2000 VBA - Using Split() with no Lelimiter in string
  297. Break mode not working
  298. Need help with report output....macro???
  299. workbook-specfic Macro Menu in toolbar
  300. Autotext equivalent in Excel?
  301. SumProduct function
  302. Autosave
  303. How to find this value
  304. colorize celle from a range of date
  305. AutoLoad UserForm ?
  306. saving excel file
  307. compare two ranges in different workbooks and copy data to a new workbook
  308. Print Excel files without Blank Pages
  309. Re: saving excel file
  310. VBA code for Excel File Save As
  311. XL2K: ADO's Find method (once again.)
  312. Query in Excel...
  313. question about the macro vb some one help?
  314. Query in Excel
  315. Re: Resize Dynamic Ranges
  316. Input Box Code Please Help!!
  317. How to extend a standard class (like Worksheet)
  318. Groups and coding...
  319. Can I do this with a TextBox?
  320. created form, want to require input
  321. How to Mute/Enable Windows Sounds whilst running VBA code
  322. Removing Range Names
  323. Run macro after Pivot Chart refresh
  324. Worksheet Change Event
  325. How to insert a bitmap image into a Excel Cell?
  326. Re: Resize Dynamic Ranges
  327. textbox
  328. Resize Dynamic Ranges
  329. List boxes
  330. sizing columns in code
  331. How to insert a bitmap into Excel Cell in C# program?
  332. Tim
  333. Event Procedure Programming
  334. How do I convert Dates from Text back to Date format using macros
  335. XL & Access 2000, ADODB and the Find Method
  336. Get source from a web page into a worksheet
  337. Finding name of last user who modified Excel Spreadsheet
  338. When opening a worksheet I want it to go to a specific cell
  339. auto Filter broken - frozen?? please help
  340. "Refresh Data" Question
  341. Re: Insert blank row between data
  342. Using named ranges in a function
  343. Copying ranges from one sheet to another
  344. Publishing Worksheets as Webpages
  345. Using a field to let user +/- from values.
  346. Macro Modification Help
  347. Unsafe ActiveX Controls Issue
  348. Re: ActiveSheet.Printout
  349. Excel - Visual Basic Complie error
  350. Conditional Formatting Formula
  351. Calling Macros From VB6
  352. recording
  353. Re: saving files in a macro
  354. Excel VBA - String concatanation problem
  355. Help a Newby Please!!
  356. Runtime error 91: Objust variable or with block....
  357. memory problem with excel
  358. TextBox focus 3
  359. Odd results getting files properties
  360. Array Question
  361. Number display in formula bar
  362. A fun but not essential problem...
  363. Deferred Mailing from Outlook
  364. Problems with solver and vba
  365. End-of-line markers in tab delimited text file
  366. Printer Set Up in VBA
  367. Compare and delete cell?
  368. How many new customers every month?
  369. adding XML element using Excel 2003
  370. Why I get "Stack overflow" err 28
  371. SORTING AFTER AUTOMATED REFRESHING OF DATA
  372. Excel Macro help
  373. Chart is being dumped into the wrong sheet
  374. append row
  375. Re: Retain SQL Login information for Microsoft Query using Excel VBA
  376. Adding data from Excel sheet to Access database
  377. Is workbook open on the network?
  378. Copy and past drawing objects name problem
  379. Insert VBA code with a macro in a .xls file by workbook open event
  380. Consolidation: Combining groups of identical items
  381. Shell Command - Net Time (Cannot create text file)
  382. changing the source cell for an embedded/linked object
  383. moving worksheet to another workbook
  384. Help on nested loops
  385. how prin in cells by using vb macro
  386. auto download file everyday
  387. Delete/Hide PivotTable PageFields "(ALL)" Option
  388. Cell Echo Help Required
  389. Need Excel Solver Add-in
  390. Converting to tabular format?
  391. help with displaying information
  392. Macros and if statements
  393. Assign Results from If...Then and Loop to an Array (VBA)
  394. Re: Would like to add 0 counts to worksheet after data is returned fro
  395. Keep my activecell on A1, no matter about the cursor
  396. Scope of macros
  397. Help reading binary file
  398. Problem with using the "Like"-Operator.
  399. Re: Excel VBA Test For Blank Cell
  400. Macro to hide rows based on a zero value in a particular cell
  401. Random Function in VB
  402. Missing movements from kernel32?
  403. Can you sort a list based on catagory names without useing a custom list?
  404. Click Button to Load External Data Into Spreadsheet
  405. Need Help: Dynamic Range
  406. GetSaveAsFileName
  407. Re: ThisWorkBook BeforeClose Event
  408. Re: ThisWorkBook BeforeClose Event
  409. Using variable names in formula
  410. Combobox
  411. RE: If-Then Formula
  412. RE: If-Then Formula
  413. Error 1004
  414. How to select a celrange?
  415. Web query - using cell contents as part of URL
  416. Multiple-step OLE DB operation generated errors
  417. Re: saving files in a macro
  418. Resource / Time consuming macro
  419. VLookup problem
  420. Please HELP VBA problem!!!!!!!!!!!!!
  421. Re: Help getting code to work.
  422. Trying to set cell value using macro
  423. Inserting CGM images in Excel changes image aspect ratio
  424. Need Help Please
  425. Excel VBA Test For Blank Cell
  426. Process data in a sheet within workbook using SQL query?
  427. Excel VBA Test For Blank Cell
  428. Selecting a worksheet with a ComboBox
  429. Conditional formating
  430. Programming command button to execute on a different worksheet
  431. Line continuation error
  432. Problem running a probram using SQL 2000 Job Scheduler
  433. Replace with total
  434. SendKeys to a remote server application
  435. Feeling beatup by Combobox
  436. CommandBar code does NOT work if Excel is Already Open :(
  437. Publishing an autoupdating Excel Worksheet
  438. Count Rows with VBA
  439. Re: Date in userform being saved as general not date which affects sor
  440. Find folder with next to latest date
  441. Help getting code to work.
  442. Searching and matching the textvalues in specific column ranges
  443. Subscript Out Of Range Error Message
  444. Re: Subscript Out Of Range Error Message
  445. Macro to Create text file from range of cells?
  446. Help
  447. Dynamically determining .From address when using CDO
  448. countif help
  449. Macro Help
  450. SaveCopyAs
  451. Opening and pasting in active workbook
  452. Please help..
  453. Scroll view doesnt work in Code
  454. Cascading ComboBoxes
  455. How to check cell data
  456. detecting row or column insertion & deletion
  457. Picture scaling in Visual Basic
  458. Data Formatting
  459. Re: Need help on challenging question
  460. File name into a variable
  461. Programing buttons
  462. Manipulating a Range
  463. Access query vs. Excel query
  464. cell entry
  465. Removing text
  466. opening and viewing an access-database
  467. Re: button in sheet
  468. Formulae to sum up values including special symbol?
  469. Excel 97 VBA - CURDIR, not reliable
  470. Re: button in sheet
  471. Cells format
  472. code interferes with function charts()
  473. Hidden Macro
  474. setfocus on multipage tab form gives error message
  475. Need Help with interesting Find & Replace macro
  476. Excel importing of .csv and .xml
  477. Excel 2003, XML, databases and macros
  478. Changing Cell location within a formula
  479. Addin for Excel - general doubts
  480. Alternative to SendKeys
  481. modifying conditional format
  482. VBA to VB
  483. Worksheet_Change problem
  484. Add-in not working
  485. Excel VBA -making Objectnames variable
  486. Invisible macro?
  487. Excel 97 macros in cells?
  488. VBA - hyperlink
  489. comments' pos
  490. File size grows enormously
  491. Workbook opened with macros disabled
  492. BEFORE SAVE
  493. colour text
  494. Check rows and paste
  495. Crazy problem when using a WHERE-clause in a SQL query
  496. help wanted urgent
  497. help urgent
  498. help urgent
  499. help urgent
  500. Copy PasteSpecial
  501. Disable Save As dialog on ReadOnly spreadsheet
  502. MS Query & Criteria
  503. macro coding
  504. Data Validation Boxes and Ealier Versions of Excel
  505. Using Cell Contents to Reference External Workbooks
  506. Find ColorIndex
  507. Linked excel objects in word, and my resulting problems :)
  508. Linked excel charts, changing filenames generates exception
  509. help: selecting rows within an equation
  510. Userform - Label Caption - How to update from a variable
  511. Replacing characters with leading zeroes
  512. can vba import code to vba project ?
  513. Dropdown Rowsource
  514. Programatically Entering an Array Formula
  515. Select Sheets via Array Macro
  516. avoiding hang when formula is being edited
  517. VBA QUESTION
  518. Combo Box Question
  519. naming ranges
  520. Lookup...maybe
  521. Locate all occurrances of a value then transfer to 2nd table on another sheet
  522. Locate all occurrances of a value then transfer to 2nd table on another sheet
  523. Using array to select rows to copy
  524. disable print option, not Workbook_BeforePrint
  525. value lessthan x and greaterthan y
  526. Problem updating Excel using ado.net
  527. declaring a public array
  528. Disable sheets tabs right mouse button!
  529. How to Reference Global Variable for external application.
  530. Re: inserting a row with data
  531. Help with xlDialogsSendMail or other way
  532. Macro from a different workbook
  533. SpecialCells used to enter data
  534. Next Empty cell after Row A10
  535. Command buttons etc
  536. Counting records in a filtered list
  537. Keeping user-inputted data with pivot table contents
  538. sql.request
  539. Re: readonly attrib on a open workbook
  540. Adding Range for Search
  541. Re: Run-Time Error 1004
  542. Self-Resizing Formulas
  543. Help with VBA/macro for Excel data
  544. Creating a new sheet
  545. Converting a Date to a string
  546. Converting a Date to a string
  547. Excel Clipboard Problems
  548. Re: Importing web data to a VBA Array
  549. Unprotect and protect....
  550. using functions as parameters
  551. using functions as parameters
  552. If Satement Modification
  553. Deleting Duplicate Rows but keeping the most recent.
  554. What's wrong w/my code?
  555. Re: Adding values in textboxes?
  556. sendmail issue
  557. SeriesCollection
  558. Simple If Statement
  559. Haeder/Footer param
  560. Find text in Column to sum
  561. Freezing panes?
  562. Help กกกกกก Please
  563. summing range
  564. AutoSave a WB copy everynight at midnight
  565. Re: Right Function Doesn't Exists in Excel 2003?
  566. Launching other Applications from Excel
  567. Run-Time Error 1004
  568. Re: Run-Time Error 1004 Copy method of worksheet class failed
  569. Selected Cell equals x then..
  570. Excel 2000 VBA - Set Print Range in dynamic range
  571. Re: attaching range (from different rows) to combobox
  572. Re: Force a Number to be Formatted as Text (keep leading 0's)
  573. variable inside a formula?
  574. Re: Formatting Number as Text
  575. Re: Resetting menu option on close...
  576. To Mark Rosenkrantz
  577. Formatting Number as Text
  578. Formatting Number as Text
  579. Formatting Number as Text
  580. Excel spreadsheet/template for developing a retail price calculation
  581. Formatting Number as Text
  582. Re: Two Questions.
  583. Re: How? Can i avtivate the buttons
  584. Re: Control
  585. Re: OrIf formula needed
  586. Re: Calling a private sub
  587. Re: If-Then Formula
  588. Re: Hi
  589. Re: OrIf formula needed
  590. Re: faster than VBA macros
  591. Re: Run-Time Error 1004
  592. Re: Combobox Problem
  593. RE: Run-Time Error 1004
  594. Re: Inserting rows with a formula
  595. Re: If-Then Formula
  596. Re: Looping Through Names
  597. Re: Combobox Problem
  598. Re: inserting a row with data
  599. Re: Adding values in textboxes?
  600. Re: Looping Through Names
  601. Re: how to format a date/validate for a text box entry on a user form
  602. Re: copying cells
  603. Conditional Formatting comparing multiple values
  604. Re: How?
  605. faster than VBA macros
  606. Re: Macro code question
  607. chr() for quotation mark
  608. Re: Conditional Formatting comparing multiple values
  609. Re: Sheet After Double Click event?
  610. Re: Inserting text to certain cells
  611. Re: how to disable listbox change event
  612. Re: User form search criteria example
  613. Re: Conditional column selection
  614. Re: Display values in combo box
  615. Re: faster than VBA macros
  616. 1st attempt vba-how do i whatnext in this sub
  617. Re: Protection Error
  618. Re: Inputbox to enter date
  619. Re: Adding values in textboxes...
  620. Re: Positioning a graphical object
  621. Re: Adding values in textboxes...
  622. Macro Names
  623. Multiple conditional on conditional format formula
  624. Protection Error
  625. Re: Multiple conditional on conditional format formula
  626. Activechart.SetSourceData Source???
  627. Excel 2000 VBA - Selecting populated range
  628. Macro Help - check existing tabs
  629. progress message in status bar
  630. Worksheet change code
  631. IsArray on Variant/Object/Range returns true??
  632. Frustration -- >Filtering a list with the click of a Button
  633. Error missing file when running macro.
  634. Placing checkmark beside menu item
  635. ActiveCell.Address
  636. Excel 2003 - Showing Userform
  637. Automate delete macros
  638. Protecting a sheet with filters
  639. pulling out info. seperated by a comma
  640. Sequential Page Numbering
  641. Changing Excel Object's page setup wthout having a printer installed
  642. Object Variable question
  643. Control & Break
  644. Pocket Excel
  645. Validation Drop Down
  646. Default Path for Add-Ins
  647. VBA-Make Custom Menu Item Fire
  648. Concatenate function with 200 arguments
  649. Inputting data on one sheet and automatically updating other sheets
  650. trouble with a listindex value...
  651. Getting records from Access 97 to Excel 97
  652. VB Delete Sheets
  653. Pivot table giving an error
  654. TextBox focus 2
  655. Set range based on cell contents - help required
  656. Extract MS word data to MS Excel
  657. Formatting textbox currency on userform
  658. Sub Menu Items
  659. Worksheet name
  660. Workflow OnExpire Event
  661. Finding and pasting over a row
  662. matching rows between worksheets/books - best practice
  663. How to handle other workbook events through personal.xls workbook
  664. flickering organization chart
  665. How to use mouse events inside an Excel Sheet ?
  666. How to create a Macro to Copy Information in one sheet to another sheet.
  667. Clicking the text in a textbox erases all the data in the box
  668. Excel Macro - Relative Path
  669. Copy and paste
  670. Transpose Dynamic Ranges
  671. Re: mswinsck.ocx
  672. Converting Time in a userform
  673. Locking(?) an excel session
  674. CheckSpelling + TextBox
  675. email question
  676. works on 2000, but not on XP
  677. It works on 2000, but not on XP
  678. Re: Copy cells
  679. GetOpenFilename changes dialog to modless
  680. How to get the macro record button back
  681. One on One Training needed in Houston
  682. passing variables
  683. MACRO for copying active sheet without using a certain name
  684. DisplayAlerts Error
  685. Excel VBA : Coding Problem
  686. Mail
  687. Excel Pivot update from Access
  688. Find column name/number of a value in a row
  689. Excel trouble
  690. xlDialogsSendMail
  691. Assign named ranges
  692. Combining Macros to make one Macro.
  693. userform & textboxes
  694. Excel and Outlook Email
  695. Macro syntax error when running query
  696. Define a Dynamic Range Based on an Index
  697. Customizing commandbar problems
  698. Open Macro Dialog Box
  699. Is it memory problem?
  700. right-click shortcut menu
  701. help with hide or delete
  702. Precisely reposition a graphic
  703. Labels in User-Defined Function Not Working Right (First Problem)
  704. Macro again...
  705. Mapland Excel Addin - Programatically Create 1000 distinct maps
  706. TextBox from Drawing toolbar - 2 questions
  707. Referencing Listbox on Worksheet
  708. Splash Screen
  709. macro prompt to show/hide rows
  710. Setting variable = to sheet name
  711. Spin button questions
  712. help: extracting Execel tables with ADO without reordering them
  713. Dumb Question
  714. VLOOKUP for spreadsheet compare
  715. Up Capture
  716. If Then
  717. Visual Basic code help needed
  718. VB.Net: Create Excel File/App?
  719. userforms
  720. Inserting Blank Lines in Selection
  721. Splash
  722. Email using CDONTS
  723. please help...
  724. Re: Hi Guys...
  725. Getting Grades
  726. "Last Saved" information
  727. Calendar Control issues
  728. Functions returning multiple answers
  729. NEED HELP ON FORMULA!
  730. Excel 4.0 Macro to VBA
  731. select a range base on Column A
  732. Keybindings Collection in Excel
  733. Movement
  734. parsing complex numbers
  735. How to tab to a command button?
  736. Date checking
  737. WAV Files
  738. Offset
  739. Delete a Macro
  740. Deleting
  741. error message on combo box
  742. How to Activate procedure with parameters
  743. auto fit-wrap texted merged cells
  744. Help needed...
  745. macro to create a chart from several worksheets
  746. Prevent User from saving
  747. Pivot Table - Sum up Average's in Pivot Table
  748. VBA Integrated Development Environment basic question
  749. SQL statement returns zero records
  750. Excel If Statement ??
  751. New Menu Name
  752. inserting a formula with reference to a new sheet in a cell using VBA
  753. Load and Unload Form commands
  754. ADODB Recordset problem
  755. Merging cells must be text format
  756. Running Powerpoint from Excel
  757. macro to run a separate macro dependent on value in cell
  758. Playing music
  759. Is there an easier way?
  760. How to use digital certificate in xls file
  761. Problem Loading Data from SQL to Excel
  762. on error error
  763. ruuning part of a macro from another macro
  764. VBA for opening file/populating combo box with sheet names
  765. English and American dates...
  766. saving excel 2003 file in excel 97
  767. Help on counting occurences
  768. Hiding columns
  769. tuning possibilities with checkboxes?
  770. "LabelColor" an appointment in Outlook with VBA in Excel.
  771. Does file exist?
  772. Copy the results of an Access query into an Excel spreadsheet
  773. Is workbook open?
  774. Is workbook open?
  775. MultiSelect Listbox (Forms Toolbar)
  776. Macro to Insert Rows After a given Text in Col A
  777. Renaming Sheets automatically
  778. Maths-Integration
  779. save file via Marco
  780. Help with very repetitive task in excel...is there an answer?
  781. option buttons run Click code when value is changed via VBA code
  782. templates
  783. combining cells' data into one cell
  784. Capturing an Error
  785. auto type text onclick in a cell
  786. Sheet Update Help
  787. Help in calling excel files under portal
  788. Please help with inserting hyperlink
  789. Change range name
  790. search or goto command needed.
  791. if then elseif on text file imported into excel
  792. rename sheet automatically
  793. Change the assigned chart number
  794. "Pausing" a macro for recalculation
  795. Locking VBA code via Project properties but cannot save the workbook over itself
  796. urgent!
  797. Get Date today from WeekEnding
  798. Solver: an unexpected internal error occured, ...
  799. Solver
  800. Text and TextBox problem
  801. Artistic Spreadsheet
  802. Macro
  803. deleting rows
  804. code help - onkey
  805. user defined functions
  806. "Member not found" exception...Help!
  807. Paste range of cells on E-maul Msg Body
  808. Date formatting a file
  809. Rounding & Formula Bar
  810. How to format listbox
  811. Cost Transfer System
  812. Thank You
  813. Populating data on userform
  814. how to protcet my code?
  815. Add an event / meeting in Outlook via Excel ?
  816. Modify a conditional format formula in code?
  817. more than one item Y/N ?
  818. how to call Access's function in different module in Excel VBA
  819. Text Box Focus
  820. urgent-pivot table
  821. Charting by column name
  822. inserting a column to the right
  823. Multiple conditional branching in excel
  824. Progress Applet
  825. Changing this code ... Please advise
  826. Code not rounding
  827. create a subset range in a VBA UDF
  828. Loss Deviation
  829. Thorny Problem
  830. UDF Help.
  831. Date local format
  832. Same workbook, different problem.
  833. How can I do this
  834. TextBox - CheckSpelling question
  835. help with macro
  836. Code generation
  837. Sending Mail from within Excel
  838. changing format
  839. Help with VBA programing
  840. Importing a document
  841. Identify Cell Color Index
  842. Removing conditional formatting if it exists
  843. Counting the number of different names in a row
  844. Getting rid of one side a border?
  845. Changing a conditional formatting formula?
  846. Changing a column's number of decimal places
  847. Sheet number
  848. Chart - display point details on MouseMove event
  849. excel missing library
  850. how to call Access function&module in Excel VBA??
  851. summ gg
  852. RE: Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B
  853. RE: Carriage Return / ALT-Enter in Textbox control
  854. Date format
  855. Excel shortcuts in Root Directory out of nowhere
  856. rename sheet automatically
  857. GCD & LCM: ANALYSIS TOOLPAK
  858. Re: Creating a list of directories
  859. I know selected picture is a shape but typename says is picture
  860. excel VBA - keypress code
  861. Progress Bar with Timer
  862. Slow Array formula or is there any alternative
  863. PS to PDF Problems
  864. [/B] Problem: multiple DATA SERIES [/B]
  865. Populate cells with arrays
  866. Select a range and copy to new workbook
  867. Best Way to protect sheet & workbook with VB
  868. Time formatting
  869. Canceling SaveAs dialog box without saving workbook
  870. Macro doesn't perform correctly when using right click menu
  871. Re: Copying merged cells
  872. INSERT INTO..SELECT
  873. LEAP YEAR Validation
  874. dynamic multipage
  875. Help!!!! Selecting a cell in another workbook
  876. How to make the macros work for different Excel versions?
  877. Excel VBA - Has someone already created this
  878. Importing with ODBC
  879. web to variable
  880. Excel VBA INPUTBOX() - Please Help
  881. Hiding 0 in Pivot Table
  882. Re: Copying merged cells?
  883. if a cell is >0, how do I select a range of cells?
  884. Increase a range size by X rows and x Columns...
  885. Creating a log sheet
  886. concatenate two cells, but with conditions
  887. hang when formula bar open
  888. looping through to assign type
  889. ActiveXTextBox with SpellChecker ?
  890. Display range values
  891. Searching multiple files and copying text
  892. Update Range upon Load
  893. Cell referencing
  894. Updating For Loop statements
  895. Change Formula Name
  896. which optionbutton is on
  897. Input VBA
  898. copy cell to another specific cell
  899. Macros not working in different versions!
  900. PivotTable Field Selection
  901. Excel VBA - Type mismatch during While
  902. Long autonumber beginning with a 0 (zero)
  903. Invalid Property Value Error
  904. VBA - Transferring Information via "If - then"?
  905. Can we copy a sheet from workbook1 to workbook2 with out open workbook1?
  906. Re: Identifying Button Clicked
  907. Date
  908. RE: VBA macro to join up strings
  909. Re: Identifying Button Clicked
  910. Re: VBA macro to join up strings
  911. Running Unix commands from within Excel VBA
  912. Re: Timesheet /sum client fifteen minutes intervals activity
  913. Problem with a macro
  914. Conditional Mean
  915. Re: Carriage Return / ALT-Enter in Textbox control
  916. hiding processes
  917. Input Box
  918. Re: Deleting Columns in a range through VBA
  919. application.run for returning arrays
  920. Range type variable oddness
  921. Re: Win32::OLE.pm and Hyperlinks
  922. Re: Colorindex in a Conditional Format
  923. Re: Passing Variables
  924. In Memory Recordset Without Creating Database
  925. Re: SELECT statement
  926. Checking if Target is within different ranges
  927. vba command button
  928. Textbox restriction
  929. macro - copy values only
  930. Finding Last Row
  931. Searching across all sheets
  932. VBA retrieving row and column info from user supplied range(s)
  933. Excel crashes on close - macro related
  934. Listbox - write newly selected item back to the worksheet
  935. Can't fix VBA code of workbook - Form
  936. need to ad one more step to code
  937. Display data in form from worksheet using Filter
  938. Efficient User Form vba coding for saving to worksheet
  939. Hide rows before printing
  940. Adding to List Box
  941. Hiding 0 values in Pivot Table
  942. #VALUE! from OLAP CUBE
  943. Creating a sortable column
  944. print userform and setting margin
  945. Find last real row of filterred data table
  946. Help with Message Box Please
  947. Loop cells - get all rows with matching data - paste into different wb
  948. algorithm to INVERT a multiarea selection ?
  949. Array Combinations with a Twist
  950. Re: Returning to original workbook
  951. validation of input in textbox
  952. Customizing the tool bar
  953. Capturing an error and then ignoring it
  954. opening worksheets
  955. Option button problem
  956. ByVal?
  957. Automatically paste cells that return a value, otherwise maintain existing formula.
  958. Selecting specific excel charts using VBA
  959. Setting chart data range automatically
  960. ListBox Error
  961. Formatting worksheets
  962. Help
  963. VLOOKUP MACRO
  964. Giving help to the user of my function
  965. Printing worksheet with printer tray # 3
  966. Active Sheet
  967. Excel VBA-Changing cell color with if then function
  968. Calling (Function?) from Userform_Initialize to generate list of unique values for Combo box
  969. select date range and copy
  970. Deleting worksheets
  971. Count rows in text file by loading into array
  972. Formatting text with VBA
  973. How to capture screen through VBA?
  974. changing nested if statements into a user defined function
  975. listing sheet tabs
  976. Excel 2002/2003 Macro Compatibility issue
  977. Addresses To Columns
  978. MVP Site
  979. Creating worksheets with cell values as names
  980. Converting text files to Excel - a difficult one
  981. function 's cell caller
  982. Microsoft Excel Error
  983. Pop-up box with no 'okay' buttons
  984. Turn Off Macro Warning
  985. Pasting Data in VBA
  986. Enumerated constants defined where?
  987. How do you delete a row in a macro?
  988. VBA IDE
  989. Is there a maximum number of Add-ins allowed? - strange Excel behaviour
  990. Return Row Heights for Rows in Active Worksheet - an example
  991. Fill in forms
  992. Hyperlinks.Delete without losing formatting?
  993. Re: Slow Code
  994. Linked DropDown's
  995. ISNumber VBA
  996. Re: Splash screen stops Solver add-in working
  997. Addin installation
  998. Size Format of Images in Worksheets
  999. Re: Copy range content as picture - truncation problem
  1000. ActiveX combo box