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. Macro for several worksheets
  2. File...Send To...Email Recipient
  3. Explaining an addin
  4. One macro for many controls?
  5. Payback period macro
  6. VBA Code to wait 50-150 mS
  7. Detecting Macro code behind a sheet
  8. Making splash screen
  9. math powers, fractions and editing ASCII characters
  10. 7 segment LCD display
  11. Set an Access field "not" required w/ADO
  12. SpinButton Problem
  13. Macro
  14. excel for each ..next
  15. What's wrong with my NextRow code?
  16. Beginners plea for help
  17. Parse
  18. Removing the right click capability
  19. Printing
  20. Pull Data from a closed workbook, without opening it.
  21. Closing an Unsaved (but Changed) Workbook
  22. Changing a formula that is copied and pasted using vba with excel 2000
  23. Syntax
  24. Removing the rightmost digit
  25. Format comment username
  26. Re: Print Control in Word/Excel
  27. Get Object
  28. Message Box
  29. How to Copy worksheet to new workbook with dynamic name?
  30. Print Control in Word/Excel
  31. Tab support for worksheet activex controls
  32. Floating Command Button - How to???
  33. Can't Update Links
  34. Help modify simple existing code??
  35. Code to edit code
  36. Selective Protection of a Worksheet
  37. Is there an easy way to replace list A instances with list B instances (sorted lists).
  38. SQL string to return top row
  39. Using 'SAVE AS' within macro with mutliple files and keeping default savename
  40. Function Library Creation
  41. Strip Alpha Characters out of an Alphanumeric Dataset
  42. Class module
  43. Populate array
  44. macro that copies controls
  45. Record Count (There has to be an easier way...)
  46. Automation
  47. Dynamic list box
  48. Display problems...
  49. Left three text characters
  50. Special Cells to Loop back
  51. Pre-numbered forms, I think its impossible, but...
  52. Problems with combo boxes
  53. UserForm ListBox
  54. Pattern Files
  55. new error when try to load userform
  56. Image on heder at VBA
  57. FormatProblem
  58. Why an error?
  59. Re: Activate new window
  60. Functions and Ranges
  61. Re: Activate new window
  62. Re: Optimize Time In Filling Cells
  63. Re: Functions and Ranges
  64. Help Please
  65. Re: Close Open Workbook
  66. Re: How do I make an open workbook the active workbook
  67. Re: Optimize Time In Filling Cells
  68. Re: Close Open Workbook
  69. Weird double selection
  70. Show user form
  71. Web Query Failure using url.CFM with xl97
  72. Access field order using ADO
  73. Putting text in a cell
  74. Far too many "IF"s for my own good
  75. Automate printing. Some help please!
  76. Excel data format problem (Urgent)
  77. Excel data format problem (Urgent)
  78. OLE Object -TexBox Properties
  79. Testing to see if a Workbook menu item exists
  80. Get the name of a group given the reference to a shape within the group
  81. Use "VLookup" function
  82. VBA code to open file?
  83. Error
  84. Macro for selecting a row
  85. Making output go to a worksheet
  86. excel project
  87. Autoload custom menu on Workbook Open
  88. Access values from another workbook
  89. Problems creating "line and bar chart"
  90. Printing Ranges
  91. Testing for a open worksheet from Outlook
  92. How to get column values from other excel file in VBA
  93. SendKeys command not focusing on the correct open program
  94. How do I read text file in an EXCEL SHEET
  95. VBA Script in Excel
  96. Interactive Macro
  97. Printing A Range
  98. User Form
  99. Export Excel data to Access Security problem
  100. Fix InputBox - Returning Empty String
  101. Regular Expressions in VBA & Excel including an interactive tool
  102. Routing Slip Question
  103. Name define
  104. ListBox Result to a Specific Cell Location
  105. Changing font size in row and column headers ?
  106. Subtotal + Conditional Format Question
  107. Offset not working
  108. assigning macros
  109. Formula
  110. Text importing problem. Please Help!
  111. Stripping out non-numeric values from external data source
  112. Get List of Keyboard Shortcut Bindings
  113. Insufficient Memory Error.
  114. Range selection code in a macro
  115. Protect sheet while enabling outlines and custom views
  116. Control Order on User Form
  117. VBA Names madness
  118. Padding Numbers
  119. Assigning Macro in another workbook
  120. Runtime error Permission Denied
  121. Disable Macros for Template
  122. Using With to speed up macro
  123. Printing
  124. error 57121
  125. Moving a sheet from a closed spreadsheet & making it part of an open one.
  126. Creating a List Box on the fly
  127. Excel to Access using ADO
  128. Disable item in combobox
  129. Excel XP removes AS part of statement
  130. combo coding
  131. Lines in a Module(Procedure)
  132. Using VBScript to create Excel SS and sort by column.
  133. Help? Inverse factorial?
  134. How to set multiple filter values for a filter in the page fields
  135. Name manager version 3 Beta
  136. Saving only current sheet
  137. Using a command button to insert a new row.
  138. XLSTART default
  139. Text in Formula
  140. Number format as condition for not deleting a line
  141. How do I return to newly created worksheet?
  142. how to create an outside border using vba
  143. Upgrade
  144. Need strip out data from column A using VBA
  145. Pick Several, Add All, Remove All
  146. Macro for creating folder
  147. Highlighting text in a textbox
  148. Query Problems
  149. Microsoft Queries - copying and changing criteria PROBLEM
  150. Task ID for App
  151. Constraining custom toolbars to one file
  152. Spreadsheet to calculate payouts in tournaments????
  153. Excel Macros Slow in XP
  154. Performance tradeoffs of complex worksheet functions vs VBA? when to switch to a UDF?
  155. save data , images and hyperlink between two workbooks
  156. Search, find, copy muliple cells from new sheet and paste
  157. copy range from one sheet to another - basic doubt
  158. search/copy/paste macro
  159. Try to change the path of the Query of pivot table in Excel 2000
  160. vlookup problem
  161. Extracting info from a database
  162. Update on Current Selection
  163. About RoutingSlip
  164. Load Windows Explorer
  165. offset problems
  166. Last cell with data
  167. Change focus from Userform back to Sheet
  168. Populating word document from userform inputs.
  169. How to stop Excel from accessing the net
  170. Inserting Module into Workbook
  171. Close Workbook Programmatically
  172. Determining Last User Action
  173. save picture in worksheet into certain folder
  174. Disable Events
  175. AUTO-CHANGING THE DATE
  176. Impoting a text file - Excel 2000 VS. 2003
  177. Worksheet Mailing Conditions
  178. FAQ
  179. How to refer to a blank/null value?
  180. Viewing built-in functions
  181. Only Show User Form Once
  182. Viewing built-in functions
  183. What does F1 mean???
  184. Start and end criteria macro
  185. Selection.ColumnWidth
  186. Problem to calculate cells
  187. Naming Chart
  188. Showing PERSONAL.XLS
  189. VBA and X10
  190. Saving button on all workbooks
  191. Incompatibility between Excel97 and Excel95 macros
  192. Attaching a macro (module) code to button
  193. On error goto 0?
  194. Check Selection
  195. Re: VBA/Macro Help Needed
  196. ListBox problem
  197. Print windows opened with FollowHyperLink
  198. Editing code
  199. Using a Varible inside of a proper address
  200. Budget System
  201. Arranging cells to create a database
  202. Compiling a macro as a .exe?
  203. Spinning Numbers
  204. Freeze/Unfreeze Panes and window display
  205. how can I read date and time from ascii file?
  206. Making a Msgbox popup
  207. Pivotitem count
  208. Bloodhound.ExcelMacro
  209. Combining variable names
  210. Progress Bar
  211. Tabbing to Checkboxes
  212. Concatenate different ranges
  213. Open up rows
  214. Problem with Excel 2002
  215. convert text to number
  216. Can I sort without activating / selecting sheet?
  217. Help to modify macro please
  218. List macros for user to select...
  219. Can't get the logic right
  220. User enters data in popup box - its entered into desired cell
  221. Input Box
  222. Determine if Workbook is Open or Closed
  223. Data sorting macro
  224. TotalEditingTime
  225. Passing parameters to UDF
  226. multiselect listbox
  227. New Product Announce: Convert Doc to PDF For Word
  228. summary by date
  229. Excel percent adding macro
  230. ChartingQuestion
  231. Selecting Range After AutoFilter
  232. User Form / List Box
  233. Linking textboxes to cells with formulae
  234. return values rather than formula.
  235. ComboBox or what?!?
  236. Installing Files
  237. Compile VBA code
  238. Addins
  239. Creating 'yes' or 'no' option in a designated cell
  240. Complicated Time Formula
  241. VBA question involving numerous additions
  242. PlotArea picture from wbk?
  243. Controlsource
  244. Installing Personal.xls on other computers
  245. defined name question
  246. Define a name question
  247. Changing Data and Charts
  248. Linking a workbook to an add-in
  249. Linking Cells to ListBox - How?
  250. Opening Excel in my program
  251. counting cell conditions
  252. Writing to System Application Log
  253. Time intervals below 1 second.
  254. Selecting a range
  255. save on leaving a cell
  256. change chart source from range to raw data
  257. SaveAs...
  258. Shortcut to toggle active Worksheet
  259. VBA online help script errore
  260. Excel 2000 Macro
  261. How can we share more projects?
  262. second combo box will be dependant
  263. find in access database
  264. copying sheet
  265. Exporting data
  266. show userfrom from another application
  267. Reverse of Hlook up
  268. Cells values included in personalized e-mails
  269. Introduction to excel programmin
  270. VB PasteSpecial when range changes
  271. Update VBA Module Code
  272. Macro to copy a range
  273. WRITING TO A TEXT FILE WITH SPECIFIC FORMAT
  274. String Question
  275. MARCO to import text by selecting columns
  276. File Not found
  277. Strip out data using VBA
  278. Workbook Path
  279. Cant find workbook
  280. If Error
  281. Q) Last row/column ------ excel formula query
  282. ignores hidden columns?
  283. cell number in collection
  284. Combining names
  285. PivotTable Dynamic Range
  286. Debug Error
  287. list Workbooks in Current Folder
  288. Userform and Worksheets
  289. More help on closing Excel.Application
  290. Undo Please?
  291. HELP WITH CHART SETSOURCE DATA!
  292. Keping a UserForm open as VBA runs
  293. Images and Userforms
  294. move the cursor to a button
  295. Asign Array Variant to Column
  296. Option buttons to select a row of cells
  297. if then clause in a cell
  298. auto format 5 worksheets out of 6 when opening excel spreadsheet.
  299. How to build build a macro that automatically imports>
  300. read Access table from VBA
  301. Creating formatted Outlook Msg from VBA
  302. Simple help with macro please
  303. Creating e-mail in Excel
  304. BASIC VBA QUESTION
  305. Sorting
  306. How to run a Sub while opening the xls file (what event to use)?
  307. Multilpe Checkout problem in Office XP Dev
  308. Spreadsheet snapshot in UserForm
  309. How to paste data?
  310. Macro to paste a copied range
  311. Finding column Letter
  312. How to enable multiple selection for combo box?
  313. How can I know if a sheet exists ?
  314. Loop
  315. Listbox
  316. OFFSET problem
  317. Differences in formulas using HTML between 97 and 2002
  318. How can I set encoding in EXCEL
  319. How can I set encoding in EXCEL
  320. How to determin a Excel file has Macro
  321. Determine if a cell has datavalidation
  322. Sql query on a range in the opened worksheet
  323. Sort buttons by caption?
  324. Checking to see if a Workbook is Open
  325. time
  326. Basic Excel Question
  327. count Worksheet using Wildcard
  328. Where can I find TAPI code/reference for VBA?
  329. Executing code with opening target workbook
  330. Executing code with opening target workbook
  331. How to check for next empty cell in list
  332. intersection? of two cells
  333. Defining a discontiguous Range object
  334. Search/copy/paste Macro
  335. read from 1 cell read to and other using vba
  336. An Interesting Excel UserForm Question
  337. Window's System Menu, can't remove menu
  338. Change VBA Code,Stock look up
  339. C++ Com Addins for Excel
  340. Report: Copying pagebreaks of a reference sheet to other sheets
  341. Macro recording box
  342. Offset & Combobox's returned Value
  343. Printing using Acrobat
  344. vb code in excel
  345. Detect Comment + Happy Christmas
  346. My Add-in causes problem with opening a file twice
  347. Performing code without opening the Workbook
  348. OLE DB Query Table to Oracle using Parameters
  349. ListBox Result
  350. Form will not refresh without an unneeded msgbox
  351. Set range statement
  352. evaluation of a cell with a formula
  353. Trying to import data from many closed excel workbooks into one: Please Help :-)
  354. Merry Christmas To All
  355. How to get out of loop ????
  356. Cannot Type Text Into Excel VBA Help Index
  357. export method not working properly
  358. how do i set an entire row or column to a range?
  359. excel2000-question
  360. Need help Selecting, Sorting, Autofitting a range
  361. button to update cell
  362. FileSearch using VBA
  363. Running a Macro Automatically
  364. Excel 2002 - VBA code to insert copied cells??
  365. Macro won't run from CommandButton
  366. excel97: runtime error 1004 select method of range class failed
  367. Top left cell in used range
  368. please explain
  369. dumb question
  370. Function and needing to Refresh
  371. A simple problem...
  372. Slow Down...
  373. pagenumber of active cell (vba)
  374. Funny shade of green
  375. Save As Boxes and VBA
  376. programming vba in vb
  377. Practical Excel Range Looping Project
  378. Spinbutton sorting
  379. Add worksheet
  380. RaiseEvent from a class contained in a 2nd class collection?
  381. DDE very slow with Excel 2002, repost
  382. VBA searching a row
  383. activecell offset
  384. SOS:Know Deleted/Inserted Range in Excel 97/2000
  385. passing a range to a user defined function using a form
  386. "Out of Memory" when import text file
  387. Right formating with an ident
  388. Spinning numbers
  389. Copy and Paste from One Workbook to Another
  390. can I call a procedure using a variable
  391. User Defined Function description
  392. fso delete folder
  393. How do I figure out what I need to do....
  394. Manipulating text - 2 queries
  395. Proper Programming
  396. Pop Up icons
  397. Margin of Error Formula
  398. structure of classes,objects,properties,methodes,events...
  399. Formatting a workbook for database import
  400. FP2000 Publishing problem
  401. Excel VBA Examples ( Book or Program)
  402. Excel 95 Dialog -> Excel 2000 Userform
  403. Delete modules programmatically and save
  404. Trying to find string in a column or row
  405. Re: Highlight non- contiguous rows
  406. Define a range globally
  407. Remove Save Button from toolbar
  408. Help on closing object properly
  409. Argument with onAction in a menu.
  410. Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet
  411. Find / Replace / * -1
  412. Calling Bubble Sort Function
  413. Highlight non- contiguous rows
  414. Range Search
  415. Status Message
  416. reference new sheet in same workbook
  417. Run code from one worksheet to populate another.
  418. Exit Sub?
  419. Macro for worksheet to workbook
  420. How can I ?
  421. Templates Ignore Protection Settings
  422. Method selection of object _Global falied
  423. Chart Setting Xvalues
  424. XL97 - Command Bar Removal
  425. Flushing a File
  426. Footer word wrap
  427. Capitalization in Declarations
  428. Help printing to PDF file
  429. VBA application; Subscript Out of Range
  430. close window trapping
  431. Passing a named varaible to Excel's Autofilter
  432. "Enter"on keyboard problem
  433. Chart created in VB generates 2 additional meaningless series
  434. Counting names in a column
  435. Moving Rows
  436. SaveAs Macro Help?
  437. Cleaning up data
  438. Index / Match - desperation
  439. Run a macro when cell changes (due to calculation!)
  440. Passing Selected Sheets' Names to a Macro
  441. Searching range for value (code written but needs 'tweaking'!)
  442. How to disconnect when WebQuery done
  443. unknown combobox name
  444. Range objects (?)
  445. Surveys
  446. Close Open Woorkbook and Quit Excel
  447. copying and renaming sheets
  448. Attaching cells to word documents
  449. multi tab selection prohibition
  450. Retreiving info from a web page table
  451. DDE very slow with Excel 2002, 2003
  452. DDE very slow with Excel 2002, 2003
  453. activecell.formula syntax
  454. ADD-INS NOT WORKING IN XP WHICH WORK IN WIN 2000
  455. Locking cells in Excel
  456. Assigning Macro's to control buttons.
  457. List boxes, Arrays and Sorting
  458. Finding a date in a sheet
  459. Highlight Track Changes with VBA Code?
  460. dot 2 koma
  461. EXCEL FORMULAS
  462. unknown menu appear when installing an AddIn
  463. Excel Formatting
  464. Help in VBA programming
  465. Summing undetermined colums
  466. Finding the name of the pagefield clicked
  467. Excel & Custom Menus
  468. Programming help
  469. MsgBox Question
  470. Image set transparent becomes opaque on clicking it
  471. Delete Macro After Running
  472. Limit entry in range
  473. How to create transparent objects on images in Excel
  474. Working With Worksheets
  475. Make 2 long columns into 8 shorter columns
  476. registration
  477. AutoFit Selection
  478. Is there "pointer to a function" in VBA
  479. Vlookup to Access Dbase
  480. How do you combine lists
  481. Setting Conditional Formulas
  482. Moving a file
  483. enable / disable macros
  484. WHY?
  485. security for my macros
  486. Variables and range problems
  487. Disable save, but not save as
  488. Copy and paste isn't that hard (is it?)
  489. Deleting blank cells in a selection
  490. Run-time error 1004
  491. Open a new instance with a shortcut
  492. autofill range
  493. Automatically run macro when opening file
  494. changing the application name in the title bar
  495. Running Macros
  496. Help needed (idiot onboard)
  497. Longs losing accuracy
  498. macro code for sending e-mails
  499. Macro Question
  500. Changing the Style of a Combobox Via It's Name
  501. Cannot type text into VBA Help Index
  502. Random Selection
  503. Macro Question
  504. Memory Leak
  505. Fixed Width - Opening Certain Fixed Width Files
  506. File Path Problem
  507. Conflict
  508. Working with ODBC and filtering data
  509. auto-launch a MACRO?
  510. Disabling Selection of multiple worksheets
  511. Problems with a Form's behaviour
  512. simple excel VBA programming
  513. Excel crashes when .Net framework installed
  514. Loop within Excel Formula?
  515. String Manipulation
  516. VBA Editor SetUp
  517. Trouble with Excel Charts
  518. Deleting series of repeating rows
  519. Newbie: How to Print by VBA a Single Page in a Worksheet
  520. Syntax to define a variable for current file
  521. vba code to sort data?
  522. PDF
  523. VBA beating me up.....again
  524. Multi-column Combo Box
  525. textbox - format for dates (mm/dd/yyy)
  526. checkbox - default checked or un-checked
  527. Autocorrect in VBA
  528. Use VBA to replace 2002 by 2004 in Date
  529. Enable and disable worksheet controls?
  530. Username
  531. Delete Specific Range Names
  532. attach custom toolbar to spreadsheet: how?
  533. Charts
  534. Code Tweek Needed
  535. Insert Page Break in the Worksheet
  536. Re: variable name based on calculated info & iteration formula
  537. Security...
  538. Passwords
  539. Comment
  540. Feeding Date Values From C++ Using Automation
  541. CheckBox values
  542. refresh of screen -- commando
  543. Text Boxes
  544. Does anyone know how to do this?
  545. Linked worksheets
  546. Problem with named Range in ADO extract from Closed Excel File
  547. Excel Crash only if VBA not open
  548. Concenate (Kjede.sammen)
  549. refresh van uw screen commando
  550. How to use macro to enter password?
  551. Underscore in Excel Title Bar
  552. Group Function on a Protected Worksheet
  553. Refer to Hidden Sheet from VBA?
  554. Extend Excels range
  555. INDEX MATCH
  556. Opening a file
  557. Excel Macros Getting Cleaned
  558. Reference oleobject within shape group
  559. running macros in downloaded files
  560. Protection lost on Open
  561. Engineer calculations
  562. Before Right Click event
  563. Is there an easier way to address ranges??
  564. Macros in Template
  565. SpinButton Rounding Up
  566. How to find the current pagefield of a pivot table?
  567. Universaly available macros
  568. Excel as RTD server?
  569. Please confirm the following bug in Excel
  570. VLookUp.
  571. Browse Button for File Save
  572. Disable the Edit menu command 'Paste Special'
  573. Why doesn't my loop work?
  574. just copy the data, not the fuctions
  575. PasteSpecial macro
  576. Run time error
  577. re Password Change again
  578. Setting Cancel = True in WorkbookBeforePrint
  579. Advance Filter
  580. Enum
  581. spinbutton.enabled = false not greying out
  582. commandbar with own textfield for datetime input ??
  583. Conditional Sheet Attachment
  584. Worksheet Code Expansion
  585. List Box on worksheet
  586. Protect Destination Formatting
  587. Pivot Table question
  588. Excel 2000 Chart & VBA: why oh why?!?
  589. Re: passing strings
  590. input template
  591. Before right click in a sheet
  592. Find and replace '
  593. password change again
  594. Bank reconsolidation/Transaction Matching/OS List
  595. VB scripts from Office 97 that no longer work in Office 2003
  596. Sheet naming question
  597. Excel VB, Workbook.activate
  598. Outline Performance Degrades
  599. Printing a user form landscape
  600. Calling from C#.Net App Office._CommandBarButton.Execute() method in Excel 2003 throws a COMException
  601. Vba code
  602. Pastespecial via vbscript not working - REPOST
  603. Pastespecial via vbscript not working - REPOST
  604. help button
  605. Date Highlighted on Calender Pop-up
  606. Re: How to Get records from a query in access and put them in Excel
  607. get filename and filepath
  608. Slow Looping
  609. Question about VBA?
  610. FileSearch gives unexpected result
  611. using ranges to determine input
  612. Workbook_BeforeSave
  613. Re: How to Get records from a query in access and put them in Excel
  614. "running..." message
  615. Email a sheet code modification
  616. Populating sheet names in combobox
  617. User Form
  618. Setting range of cells format to currency
  619. PDF
  620. Delete Entire Row.
  621. change password
  622. Compatibility with older versions of Excel
  623. copy down to all Vlookup "#N/A" cells ONLY (in the same column)
  624. Switch images in VBA
  625. Re: Expanding Code
  626. Excel VBA - Web Query causes Excel to run out of Memory
  627. Re: Expanding Code
  628. Expanding Code
  629. Transferring ranges to/from arrays
  630. Re: Creating regressions with more than 17 data points...
  631. Re: Trapping warning message
  632. Screen off during Macro execution
  633. Code malfunction
  634. Amount of code in UserForm
  635. how to make sure the file is saved on a network
  636. combobox matter
  637. Changing "Cancel" in SaveAs
  638. CustomDocumentProperties
  639. Printing worksheet
  640. Macro in Excel
  641. HELP - How do I disable Excels menu items so others can't use
  642. modify cell references in a formula programatically
  643. Re: Time Calculations that roll past 24 Hrs
  644. Looping
  645. How to get Control M to move cursor down
  646. Re: Time Calculations that roll past 24 Hrs
  647. ListBox Question
  648. SubScript Out Of Range.
  649. Re: UserForms to deactivate workbook
  650. Stop open file through Document Property
  651. Named Array
  652. Updating worksheet problem
  653. Duplicate sheet error handler
  654. Variable scope question w/combo-box, 2ND try
  655. Running external programs
  656. Excel file
  657. Re: Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please
  658. Re: Worksheet Position
  659. Re: Worksheet Position
  660. >Message unavailable
  661. Re: Updating links
  662. Need some help
  663. Is this correct?
  664. Disabling Screensaver
  665. Excel VBA - Web Query causes Excel to run out of Memory
  666. Creating small "recordset" or sorting a numeric 1-dim array
  667. ColumnWidth not working...
  668. passing strings
  669. Excel schema using Jet OLEDB Provider?
  670. "Multiple-step operation generated errors"
  671. Pastespecial via vbscript not working
  672. Calculation Options
  673. formulas refer to columns that are deleted
  674. Automation and Add-Ins
  675. Work schedule help
  676. UserForm
  677. variable name based on calculated info & iteration formula
  678. ODBC errors with new pivot table
  679. excel macros
  680. On Paste
  681. Office 2003 not able to run wscript??
  682. Turning Colored Cell's Off
  683. Another little ? on CommandBars("Cell")
  684. Clear contents of row but preserve formulas?
  685. Cycle through a list (Part 2)
  686. Excel VBA and multithreding
  687. Weighted Average Question
  688. Forcing users to enable macros
  689. Excel to Access
  690. formula?
  691. specifying chart size
  692. Preserving Previous Formula Values
  693. FollowHyperlink
  694. What's this button?
  695. vba for excel
  696. Command for recalculating macros
  697. Transposition of data
  698. CommandBar("Cell") additions
  699. How to find out how many rows do my collumn have?
  700. Conditional Formatting script
  701. Excel and Windows Eventlog
  702. How to determine if instance of Excel is running
  703. Routine??
  704. delete rows with certain condition
  705. Userform and checkbox....
  706. VBA Index / match type formula copying formulas, not values
  707. How to insert a lot of values into cells?
  708. concenate or vba or sql
  709. Question about using AND or OR with If-Then statements
  710. Close second instance of excel
  711. Can this be done in Excel?
  712. Find text and remove row
  713. Excel 2000 Web query not returning all Table Data
  714. Sub Error with Sheet Protection Enabled?
  715. How can I get the worksheet name use micro function?
  716. How to check a Variant for its data type
  717. DB query syntax
  718. Find all formatted cells
  719. Macro Runs if Template name is .....
  720. Decimal Symbol
  721. External data query - need to use SELECT * (ALL RECORDS)
  722. show message
  723. how to specify the filename
  724. macro in excel to copy from excel to word
  725. Stepping backward through an array
  726. Create a HYPERLINK with a macro?
  727. Use Your Brain
  728. How to split text?
  729. New to this thing
  730. Use Your Brain
  731. Renaming Sheets in a workbook
  732. Define Range in Deleting Empty Rows
  733. help me...
  734. SaveAs and relative path
  735. Application.Close
  736. Send Sheet as part of macro
  737. Urgent info. on opening a mail merge with the datasource open
  738. Validate Appointment Times?
  739. alphabetic order
  740. How to change international decimal separator
  741. Scrolling a lstBox automatically
  742. deleting array element
  743. Run Query w/Function from Excel
  744. Sheet module VBA not copied
  745. Paste Code
  746. Creating properly formatted text file from vbscript using excel data
  747. Adding new rows to spreadsheet
  748. Range selection in a sheet module
  749. Easiest way to add functionality to ALL Excel spreadsheets
  750. Filtering for exact text
  751. Getting data from web site to excel
  752. autorefresh display autofilter criteria question
  753. Prevent Locked for Editing on a network
  754. bulk mailing problem
  755. ScrollBar1_Change() problem
  756. Can I edit .iqy file from code?
  757. "Out of memory" when running a Web Query
  758. "save as" macro
  759. lock out menus?
  760. how to validate a combobox?
  761. Pass a filename to a query
  762. Formula Modification Needed
  763. checking value in column
  764. Activate Workbook in Separate Excel Session
  765. Formatting of workbook window
  766. Macro Ceiling & Floor Calculation Problem...
  767. For Loop in Filtered List
  768. How do I delete ExternalRata range names?
  769. run macro in book1 from book2 - how?
  770. Word Search from Excel results in Duplicates
  771. Calculating number of days in month
  772. time/date formatting bug
  773. Rename wrksht tab from cell info w/Macro
  774. setting a chart size
  775. copy without formulas
  776. Import PDF information into Excel
  777. Directory browser in Excel VB
  778. Converting file formats
  779. Padding out reference numbers
  780. How to concatenate a range?
  781. Run Query w/Function from Excel
  782. Scroll selection into view
  783. auto enter date in cell on data entry in row
  784. new comer problems
  785. .CurrentRegion in Excel functions
  786. Go to record found by Criteria in Data Form
  787. For | Next ...OR... Do | Loop
  788. Howdo I password protect a list entry
  789. Check status row (hidden or visible)?
  790. followhyperlink
  791. Deleting Sheet
  792. Declaration?
  793. Check for Excel version before running?
  794. Invoice autonumber with mulitple number sequense
  795. Calling up a specific Help topic?
  796. comparing text
  797. Accessibility of Custom Functions
  798. Problem in activating a sheet
  799. import CSV file at location D7
  800. Counting items
  801. erasing checkboxes
  802. Help with Sorting tables
  803. Runnig a macro when excel opens
  804. Find a certain word in excel and select the cell
  805. How to code a timer to trigger a sub-routine ?
  806. Problem due to password
  807. Open Html file i Excel
  808. Office Clipboard: Clear all with VBA-macro?
  809. excel caused an invalid page fault in module excel.exe 0177:3003b3fd
  810. Unspecify Error in Range count
  811. Disabling Ctrl, ALT keys
  812. open excll from network
  813. Loop across Sheets and number of sheets
  814. Missing Numbers
  815. vbAccelerator sGrid control- spacing columns.
  816. Random Number Generator
  817. Connumdrum #2
  818. Connumdrum #1
  819. Type mismatch while running If statement
  820. Transposing numbers
  821. Best Way Question
  822. mass changes in formulas
  823. setting row in macro
  824. Excel Basic
  825. calling an Excel Add-in application
  826. Anyone successful taking data into Quickbooks?
  827. Help with this Find code please
  828. Macros - Range Selection
  829. Array Formula Question
  830. Import .BMP File From Web Using VBA
  831. Turning Off Cut & Copy in a Workbook
  832. Excel version comparison
  833. Format Cells ?
  834. Create Worksheets Based Upon Changing Column Values in XP
  835. Resetting variables
  836. Macro for dropdown
  837. bottom right cell on screen
  838. simple help needed please
  839. Close VB in Code
  840. ENTER key
  841. UserForm Result Posting
  842. Form display errors
  843. Editing Query Parameters
  844. Converting Range.value(error)
  845. URL String
  846. Excel 2000 VBA Question
  847. Creating a new Excel Addin
  848. setting cell contents to text using C#
  849. Find and Replace Data from one into another
  850. Display Saturday's Date
  851. Sub A1 Line Malfunction
  852. SQL.REQUEST - controlling refresh frequency?
  853. Copy Rows to Existing Worksheets
  854. using vlookup, but error #N/A
  855. Help with getting rid of unused cells or ranges
  856. RegisteredFunctions in C# fails when trying to get the list of addins and function
  857. Macro to insert hyperlinks
  858. Excel Shapes
  859. coloring a tab
  860. Problem with Find function
  861. Printing fixed columns and rows
  862. Dynamic Creation of rows in Excel
  863. ADO from Excel to Access
  864. Restore toolbars
  865. VBA conversion confusion
  866. Format when opening .CSV file in Excel
  867. Can you save an external macro?
  868. change a macro so that it copies and pastes data as values rather than references
  869. Summation of rows
  870. I have posted this message before but did not get any response can anyone help me?
  871. Call a macro in other workbook
  872. RTD Server disconnectdata
  873. check 2 speadsheets for diference
  874. Autofilter across Worksheets
  875. print a form landscape
  876. Log File for Excel Spreadsheet
  877. How to open a merged word document
  878. html tags with a cell
  879. Excel the best!
  880. MVP Challenge. Erratic Userform Compile Error
  881. heure
  882. Seperate numbers from letters
  883. Comparing two rows
  884. Restricting access to workbook
  885. Moving the Active cell to the left of the screen
  886. How find character position # in string from right end? Or how get range row num
  887. conditional format for vb code on pivot output
  888. ADO and Checkboxes
  889. AddInError Excel97 --> ExcelXP
  890. Please Help
  891. Creating "Plain Text" mail message in Outlook from Excel VBA
  892. Email Text Message
  893. Canned VBA Date Validation
  894. Add In Locations
  895. Cycle trhough a list of names
  896. Outline numbering in Excel?
  897. Autosorting and working out medalists for data.
  898. Using GetSaveAs
  899. Copying a selected prn file to printer.
  900. rows that dont want to be deleted!!!!
  901. Chart "Automation"
  902. Start macro on cell change
  903. Change the appearance of a built-in menu
  904. Test a file to retrieve format
  905. Change from a sum reference to the number
  906. Changing font size, bold and underline
  907. How to force repaint of popup commandbar?
  908. Copy selected columns only
  909. Excelmacro - Office -97 --> Office XP
  910. POJSDF
  911. How can I use a worksheet while running a userform?
  912. Help on cell formatting
  913. Worksheets and arrays
  914. Calculating a range in VB Excel XP
  915. Pie Chart formatting
  916. unable to set the colorindex property of the font class
  917. Excel Object in VB when running under scheduler control
  918. Create a new menu in VB
  919. Code to hide rows based on cell contents
  920. Help ('IF' Statements) Please !!
  921. Sheets ("").Copy not working
  922. xlR1C1
  923. Shortcut key
  924. Open a XLS from a Module
  925. Problem opening a komma separated file with Excel 97
  926. control in excel 2000 does not work any more under excel 2003
  927. Marco vs Lotus Note
  928. Acquiring filenames for multiple files with GetOpenFilename
  929. Autofilter and protection
  930. SendKeys problem
  931. Paste Error
  932. Email Attachment from Excel using Outlook.
  933. excel - count sleected items in a listbox
  934. FileSearch Hangs Excel
  935. Creating a MailItem in Outlook from Excel using Late Binding
  936. Macro not with a file
  937. VBA code need help on CopyPaste
  938. Use SUMPRODUCT to find duplicate rows (not one column)
  939. Dget in VBA gets Object required run-time error?
  940. Extract row based on a criteria
  941. Really Dumb Question
  942. printing and groups
  943. Input Command with Mainframe file and multiple variables
  944. How can I optimize this code?
  945. Help in conditional SUM
  946. For each loop
  947. Problem with logical sentence
  948. How to get right URL for a Web Query
  949. Help appreciated
  950. Possible to write Excel macros in JavaScript?
  951. Fill down range
  952. Copying and renaming worksheets
  953. Where is my syntax error?
  954. sending email within a macro
  955. saving .prn with more than 240 positions
  956. parameters in treeview
  957. Disable selection of shapes
  958. vb script to add names to tabs
  959. running macro upon a spreadsheet's startup
  960. insert 'x' number of rows???
  961. need help to for macro
  962. parsing words in a cell separated by commas
  963. Rank and Cell colour
  964. saving .prn with more than 240 positions
  965. Deleting data from Shared workbook
  966. This does not work: Range("A1").Select
  967. VB
  968. Inserting Functions
  969. Add Sort button
  970. Why Prompted To Save Again?
  971. FindMethod 2 col range
  972. ComboBox - Excel
  973. breaking out of a loop
  974. Help with setting range limits
  975. how to get hwnd from application object?
  976. running a macro saved as a string
  977. Excel Macro
  978. Adding icon to standard menu
  979. Set the elements of an array vertically to the cells
  980. Excel Help
  981. Urgent Macro help needed
  982. UCase in textbox, help
  983. Run time error 2147417848(80010108)
  984. Calling sub programs
  985. Inserting blank rows
  986. execute a macro from another macro
  987. moving folders
  988. Getting Window Owner in .NET
  989. MS Query Limit results
  990. Forcing Date Entry
  991. Need help with VB code for saving cell data
  992. Matrix Multiplication Function creation
  993. aligning entry in text box
  994. .Net and Excel
  995. Business hours calculation
  996. Column-replying macro
  997. Controling a dialog box after I've selected the datasource
  998. Help with IF statement
  999. Re: How do I Delete Lines from VBA Array?
  1000. Macro to only change selection