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. Re: Group Names Change Upon Paste, Kills Code.
  2. Excel VBA - User form caption problem
  3. Re: ColorIndex
  4. Re: ColorIndex
  5. Re: Group Names Change Upon Paste, Kills Code.
  6. Workbook_Open Event
  7. Re: Auto Freeze Frame
  8. Re: Edit a userform
  9. Add another range
  10. Pass parameter to a form and then open it?
  11. Re: sub directories again
  12. Detect event if excel is in edit mode.
  13. Code to clear sheet
  14. Identify strange character
  15. Edit Text in Button
  16. Re: two... two... two questions in one!
  17. vc++ automation: opening chart as chart window and setting scale
  18. Filename and creation timestamp in 2-column combobox
  19. Help Transposing Data from Row To Column
  20. Re: Charting Weirdness and VBA
  21. Excel formulas efficiency
  22. Auto Hide
  23. Controlling Text Loading
  24. Re: HELP!! Macro suddenly not working
  25. NESTED IF
  26. PlotArea.Interior.Color ... all white
  27. User-preference Customizations in Personal.xls
  28. sub directories again
  29. Spreadsheet object
  30. Making a function available in all sheets
  31. Finding a Linked Cell
  32. Merge and Sum Tables
  33. Conditional Formatting help...
  34. Printing -
  35. matching and formatting...need help!
  36. Save in location button
  37. Create button with addin/reference macro in another file
  38. Excel VBA - Worksheet Coding Help
  39. Using a form to input data into a schedule
  40. Workbooks in use
  41. Repost: Smart Hyperlink
  42. Protected Workbook Opens Restored
  43. Keeping multiple sheets synchronized
  44. Import data, calculate, export data
  45. Question about IIF in SQL query
  46. How to set up an automatic SUMIF function
  47. Sending text from a Text box to a sheet
  48. Data Transfer
  49. Help!!!!
  50. Q: References: upgraded office, library changed causing errors
  51. How to pull in 2 different rows and compare them
  52. Menu Items and Disable/Enable in Excel 2003
  53. entirerow.delete multiple text conditions
  54. Printing during select times
  55. Sorting Columns using VBA
  56. Creating Password
  57. Events for Controls in a Multipage Control
  58. Invoke Outlook Express SendMail From Excel VBA
  59. Why this simple macro doesn't work?
  60. Copy to windows clipboard
  61. Worksheet name
  62. Buttons
  63. Search List of Data
  64. Consolidate User Input
  65. Macros
  66. Worksheet protection order
  67. ListBox
  68. Making a macro with random placement.
  69. excel--->access
  70. Turning off circular reference warning
  71. Attaching text to button
  72. Loading an Excel file
  73. Help Again with data comparison
  74. Delete names in workbook
  75. Public/Procedure Variable
  76. selecting workbook/worksheet from browse button
  77. Making an active cell the first one to appear on the spreadsheet
  78. Re: Custom sheet protection
  79. Excel 2003 and Macros from Excel 2000
  80. All cells not calculating
  81. Different passwords to separate ranges in excel 2000
  82. Linked ListBoxes
  83. Clipboard
  84. Rounding Based on Value
  85. Debug.Print
  86. Excel VBA - select firsty 30 characters of a cell
  87. Sorting lists of Named Ranges
  88. Formatting userform textbox - help required
  89. MultiPage control
  90. Adobe using VB
  91. Re: How do I create a combobox???
  92. How to specify a range in Excel macro
  93. Re: Refresh a PivotTable using VBA (SQL generated Pivot)
  94. Hiding all Toolbars
  95. format +44785656656 as text
  96. Using Countdown in Status Bar to Play Sound
  97. Excel Headers
  98. Sending Email Notification of a completed VBA process
  99. Keep multiple sheets in synch
  100. Running Code on Each Sheet in an Excel Workbook
  101. Excel VBA - Searching long words
  102. Excel VBA-How to open several delmited files & SaveAs Excel files
  103. VBA Forms
  104. XL97 - Apply colour to Pivot tables
  105. Problem with Format statement
  106. How to connect to Informix database using ADO???
  107. XML / XSL security problem
  108. rows().value
  109. Closing workbook
  110. CreateObject("Excel.Application") -> Access denied
  111. Can I rename a directory using a macro
  112. Protect Workbook
  113. TIME values
  114. Fourier analysis
  115. Sort data
  116. How to activate a file when the filename is represented by a string variable
  117. Number Validation
  118. Formula Palette
  119. Help!
  120. Create CommandBar in xl95 code - possible?
  121. Q: is this continually looping?
  122. email
  123. Excel 2000 drillthrough
  124. Customize CommandBars (disappear and reappear)
  125. Reading from ini file
  126. Using a listbox effectivly
  127. Adding to a named range on another worksheet
  128. In theory Excel vba work out a roster by itself
  129. Virus in my Immediate window?
  130. Error trap with object variable problem
  131. Application::DisplayAlerts not working
  132. Counting blank cells
  133. Resizing an image file
  134. Code works 1st time then Type Mismatch when checking for not blank cells
  135. Change date format
  136. Excel VBA - Problems using Protect/Unprotect a worksheet
  137. Summary of all worksheets
  138. "Assign Macro" is gone from menu
  139. Time Clock
  140. save file name with Chinese/Asian
  141. Drawdown Analysis
  142. Help With Runaway Calculation
  143. Saving a Favorite from code
  144. Open workbook without update all linked information
  145. writing on cells
  146. "Harlan Grove's resizing code",
  147. RE: Copy with criteria
  148. Please Help me
  149. GetOpenFilename
  150. Extract 1st word and in capitals
  151. VBA Array Population with a Single Line of Code
  152. GUI
  153. Largest value in a range
  154. Can Not Find declared dll
  155. Missing library?
  156. combo box
  157. DDE Argument exchange with Word
  158. open file
  159. Delete Selected Rows
  160. Open two text file in Excel
  161. Applying Macro to all workbooks...
  162. autoselection in a pivot table
  163. fast way to make reports from a database
  164. =IF in VBA
  165. Excel VBA-How do I increment columns in VBA?
  166. Re: Hash (MD5) in Excel
  167. Stutter in AdvancedFilter Unique Results?
  168. Excel Validation / Dropdown list Problem
  169. Filtered data selection using vba
  170. How to add line at today's date in chart
  171. Need help With Code:
  172. Button Error - Save at location
  173. Icon change
  174. Simple copy paste question
  175. Color Index and RGB Color
  176. Re: assign number value
  177. change background color of row until condition is met
  178. Changing caption text and hiding buttons
  179. Indirect function - relative reference
  180. excel column only numbers
  181. Popup Menus
  182. Re: Hyperlink to execute macro.
  183. Re: assign number value
  184. Macro skipping blank cell
  185. Re: Help! Calling hidden sheets?
  186. Excel VBA-How do I increment columns in VBA?
  187. Re: Excel - Calc current age of a person
  188. Re: Help! Calling hidden sheets?
  189. Automatic creation of an overview using several workbooks
  190. Re: Excel - Calc current age of a person
  191. Re: Help! Calling hidden sheets?
  192. Subscript out of range
  193. Run Excel Report on Server w/out human interaction
  194. Worksheet Controls
  195. Excel XP XML macro security warning
  196. Parsing out text entries in a text box
  197. Re: cell reference in formula
  198. RTD UpdateNotify()
  199. Re: cell reference in formula
  200. How do I: prevent user from scolling down and right?
  201. Re: cell reference in formula
  202. Is variable an integer?
  203. Reselect cell after macro
  204. Re: cell reference in formula
  205. Import table into new sheet
  206. Re: Just a tip I have picked-up
  207. Command bar Defaults
  208. Excel VBA .NET?
  209. UserForm Question
  210. File Browse Box
  211. Re: extract with criteria
  212. Use of Drop Down -- A New Beez question
  213. Enter pressed in Textbox
  214. Copying cells
  215. Re: Calculation involving Time format
  216. easy problem
  217. Select Case Information Needed
  218. Trigger macro to run when picture is deleted
  219. Open a Word Document
  220. Excel 2002 and startup
  221. TrailingSpaces
  222. Disabling Events
  223. Excel VBA-use variable in active cell formula problem
  224. Error -2147417851 '"The server threw an exception"
  225. Pivotfields.CurrentPage
  226. choosing from a list in VB
  227. Getting HyperLinked Cell to Appear at the Top of the Screen
  228. Setting width and height
  229. change caption font color at runtime
  230. What 's wrong with the coding? -- about using outlook to send attachment in excel
  231. Add column to left of "hotspot"
  232. Re: Hash (MD5) in Excel
  233. Importing from MS Access
  234. formatting
  235. Adding Validation (drop down)
  236. Help on writing a code to copy and amend lines
  237. extracting matching data
  238. run macros on a protected sheet?
  239. Slow VBA, Can someone please look at it?
  240. Delete Sheets
  241. v.basic misc programming ?
  242. Customized Menu Macro with Argument invoked twice
  243. Excel-Web Queries
  244. re-entering userform
  245. VBA Code needed to start different public sub
  246. Sheet to Workbook
  247. access-->excel-->access
  248. Return all page ranges in an array? (Repost - Tom?)
  249. A Word Problem...
  250. Moving Chart Objects
  251. Text Import Wizard
  252. Network printers, how?
  253. Visible property on Worksheets
  254. Positioning Data / Form dialogue box
  255. How to highlight cell match todays date
  256. MD5
  257. Update
  258. running windows system commands in VBA
  259. Web Query - No data
  260. Logical or
  261. FILTERING PRICELISTS
  262. how formatting CSV file to get alt-enter text in one cell
  263. Autosaving
  264. Exotic CheckBox
  265. excluding a value in a max determination
  266. Files in a dir
  267. Closing files without save
  268. Timer
  269. HELP URGENT PLEASE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  270. Re: Type mismatch
  271. seperate contents of a cell to two cells
  272. Cell Reference- Hiding Rows-Urgent
  273. Activeworkbook.Saved
  274. Limit worksheet navigation in Excel 2000
  275. Create new workbook
  276. Re: Excel VBA - Opening Files
  277. Help... This code consistently crashes for no reason.
  278. Cell/Variable content substitution
  279. Starting Excel from cmd pmpt, pass parameters
  280. Copying Range
  281. Removing dashes in entire column using VBA
  282. Re: AutoSequencing in a New Worksheet
  283. Open image from web in window same size as image?
  284. Fill emply column with formula
  285. forms and reports
  286. stock control
  287. Copy and paste selections and formatting to new worksheet
  288. Need help with a macro
  289. cell reference in another workbook
  290. VBA creating Pivot Table
  291. turn $12 to $12,000
  292. Cannot loop through rows in C#
  293. Combo box
  294. Changing Freeze Panes as I scroll down
  295. calculting stats of column array in 3D array
  296. BAR CODE Instruction
  297. Error 1004 in printing .ps (postscript) file from .xls file
  298. referencing a sheet in VB
  299. How do I sum across rows in a macro? SumIf?
  300. Opening a Workbook
  301. Copy recordset from an Access "make table" query
  302. VBCodeMod crashing Excel
  303. Export to Excel
  304. Making your UserForm print other workbooks
  305. Saving file without macros
  306. Removing Command Button
  307. Combining two arrays
  308. Progress Indicator in form
  309. Thank you re VBE Windows problem
  310. Populating a Named Range...
  311. Macro Security
  312. creating unique new worksheets
  313. data entry...
  314. Re: Property Set
  315. Can I turn off roundup automatically for a cell?
  316. Random Text
  317. Capturing Screen Size Help Needed!
  318. "IF" "AND" Functions
  319. MsgBox Question - HELP!
  320. Re: Type mismatch
  321. Run-time error 2147220960(80040220) mail with outlook
  322. Seperate with space
  323. Formula help please
  324. Format a header when using Range()
  325. Chart - Title Widths
  326. writing a formula in VBA
  327. Further Split-type help, please
  328. Configure Combo Box to Show Unique List Values Only?
  329. Iterating through workbook capturing text
  330. How to Unhide and Use Columns to the right of the worksheet
  331. Toolbars
  332. Radio Button Selection in UserForms
  333. Macro Library
  334. Downloading full pages to specific targets
  335. Printing problems
  336. Return an array of all page ranges in a sheet?
  337. CATO file import to Excel
  338. Selecting a PivotItem in code
  339. Autocomplete Possible?
  340. problem using Set statement to define range object
  341. VBA - Immediate Window not docking
  342. .xls file keeps referenced addin(.xla) filepath?
  343. Can I "compile" VB into an executeable program?
  344. Macro to Color Code Cells
  345. Clearing Collections
  346. Allow access to visual basic project
  347. add macro to wksht
  348. Adding a new Line
  349. Deleteing Rows
  350. Passing parameters
  351. CHANGE QUERY SQL CUBE FROM EXCEL
  352. Could not find installable ISAM
  353. Cell value in a formula --> Indirect function? Help please...
  354. Activating a modeless form
  355. Conditional Formatting to Validate Data in multiple worksheets
  356. Recursive Subs?
  357. RePost: Summing column in 5D Array
  358. Show All PivotItems in XP pivot table
  359. Excel template file, where is it?
  360. Data ranges
  361. Open As Readonly
  362. Disable Page Break Preview Button
  363. xp shell command using vba
  364. VLOOKUP return - #N/A
  365. Create/Remove toolbars
  366. Application.Run Method
  367. Out of Stack Space
  368. delete folder
  369. Use a cell with text on it as part of a SUM formula
  370. Excel VBA - Help with a loop, compare, delete problem
  371. Date Functions
  372. Macro Size Limit / open macros with macros?
  373. Copy data not format
  374. Extract parameters passed to a function.
  375. Dependents on another worksheet
  376. time conversion
  377. Date Update
  378. combo box not working
  379. Use excel in html format change the links
  380. .select efficiency
  381. Procedure loop limitation?
  382. I need help with a macro
  383. Reference names and hyperlinks to other files in other directories
  384. Now sure how to get data from another sheet
  385. excel macro
  386. Sorting algorithms used in Excel
  387. Plot data on map
  388. CopyText
  389. Att: David McRitchie
  390. Control Toolbox vs Forms
  391. find existing worsheet
  392. Userform idea
  393. Format Cell Content
  394. Help! (I need somebody)
  395. Problem with decimal number smaller than 1
  396. Non programmer needs calculation help!!!!!
  397. Switch To/Retry message appears
  398. .NET dll
  399. function wizard access violations
  400. Textbox formatting
  401. VBA: Finding duplicates in Change Event
  402. offset function
  403. Autorun a macro
  404. HELP - weird Negative Numbers
  405. safe protection of sheets and vba
  406. Command button
  407. Open data
  408. Custom cell formula
  409. how to run VB with excel chart at PC without Office2000
  410. Copied shapes are some times oblate
  411. Documentation
  412. PivotCaches.Add
  413. Blogs, sites, books, sample code, Excel+VBA+Finance
  414. Subscript Out of Range error in Array...
  415. Shared Workbook - insert row and keep validation & format?
  416. custom toolbar loses settings
  417. Create workbook for data export and then data import?
  418. protect formats
  419. nesting problem
  420. Error 40036 when activating a sheet
  421. Optional Arguements for Functions
  422. Updating entries on a spreadsheet via Userforms
  423. Extracting nth element of X dimension
  424. Sorting 2D portion of 5D Array
  425. subtotal with median
  426. excel 97 crash
  427. Excel Macro
  428. Two Questions...
  429. time keeping
  430. VBE Options
  431. keep the VBA modules in Excel transferable among different computers?
  432. Revisited: If Cell in row has data then do this: HELP
  433. Sum Multiple Columns with Macro
  434. Re: Custom Data Sort
  435. Copy entire Worksheet how?
  436. Custom Data Sort
  437. BROWSER
  438. Cancel Button
  439. Re: If Cell in row has data then do this: HELP
  440. Limited help from err message
  441. find last row on a worksheet
  442. Date Validation?
  443. Button - Save Location
  444. Macro
  445. SUMPRODUCT help, please?
  446. error control
  447. Add-In communication with outside Application
  448. Excel VBA - 3 Problems (Yes/no box, Password Box, Run Dialog)
  449. ADVANCED data strippping
  450. Form Textboxes
  451. Accessing a single worksheet in a workbook
  452. Copy Sum Rows to Totals Sheet
  453. Remove CommandButton
  454. control box
  455. unblock .exe attachments in outlook
  456. I need a macro that copies that data from one cell on one sheet to a cell on another?
  457. Chart - Title Widths
  458. import from txt file
  459. Hyperlinks
  460. Re: Adding Time
  461. Call a proc inside itself (HELP)
  462. Copying data from one cell to another
  463. Populating Third Dimesion Based on Average of three elements of Third Dimension
  464. Re: Arrays
  465. Toggle Acrobat add-in on/off
  466. Counting Days Between Variable & Fixed Dates
  467. Fancy Object Declaration
  468. Excel interpreting HTML and CR/LF
  469. date column
  470. Using Excel to handle Com callback procedures
  471. Cut & Paste Loop
  472. VBA code for set print area
  473. Macro for Multiple Sorts
  474. change font size and bold in cell?
  475. dynamic buttons
  476. Linking together data from Eeevvverrywhere...then printing it
  477. Showing plus sign on positive numbers
  478. Append from Excel 2002 to SQL
  479. Error Message..."No more new fonts may be applied in this
  480. Linking cell
  481. Printer Driver Function
  482. list box
  483. Array Join & Filter funcs
  484. counting column elements
  485. Append Excel 2002 data to SQL
  486. Self-certify in XP
  487. file prompt - more info
  488. ScoreCard
  489. SMALL(?)
  490. How do I? Link Row Headings
  491. Excel 2000 macro error
  492. Dynamic Status Bar Routine
  493. Dynamic Table of Contents
  494. Code is dragging selection when should copy
  495. excel reader
  496. Export textbox value into a spreadsheet cell
  497. identifying shortcut keys associated with custom macros
  498. Locking/unlocking cells
  499. Which workbook is stuck in memory
  500. Which workbook is stuck in memory
  501. Dump 5D VBA array to 2D excel array
  502. Problem with using a macro to create a chart
  503. file prompt
  504. Excel VBA - automatically extratcing data from two different files
  505. multi-file open to one workbook
  506. Autofill - Autonumbering
  507. Where can i find the vba documentation
  508. Limiting the cells a command button can change
  509. VBA - Only Selected area visible
  510. Determining biggest variable
  511. Tricky Question Re: File Properties
  512. Ascii
  513. insert row...with reference
  514. Excel VBA-Looping though MultiSelect on ListBox
  515. Sort Method Questions
  516. Insert
  517. ambiguous name detected
  518. Excel with Access
  519. MANAGING PRICELISTS
  520. Iteration programing
  521. Executing Windows Comands using VBA
  522. Adding up Time like decimal values ??
  523. Object Calendar 8.0
  524. Comparing 2 worksheets
  525. Disappearing Posts
  526. Hiding rows based on cell content
  527. Changing the contents of a cell... dynamically?
  528. ParsingName
  529. Hiding #N/A
  530. start up screen
  531. Excel VBA - Automatic adjusting of 2 windows
  532. Download (copy) file from the internet
  533. Crazy Combobox
  534. formula to follow preceeding value
  535. Macro dislocated
  536. Getting system information
  537. copying text from one group of cells and putting them in a table?
  538. Stripping data
  539. file browser when a cell in selected
  540. importing large numbers to vb results in the numbers being formatted to scientific
  541. Checking contents
  542. General question
  543. Remove value after decimal point
  544. Introduction to VB and Excel
  545. Finding out the workgroup templates path
  546. next available row
  547. How to find used range of a row/column?
  548. Deleting an Excel cell
  549. Excel VBA-Looping through Multiselection
  550. Missing Files
  551. VLOOKUP into another workbook
  552. Double-click entry
  553. Highlights
  554. Dumping multi demensioned array into excel
  555. What does "Application-defined or object-defined error" mean?
  556. running one macro from within another
  557. Max of VBA Array
  558. Automatic Macro in Excel
  559. Hidden Column in VBA
  560. Clip Board
  561. Calculating Average on variable sized datasets w/VBA
  562. 2003 tax copies
  563. Export information to Access.
  564. Run-time error '1004' PasteSpecial Method of Range Class Failed
  565. Macro to make a cell work like a check
  566. Solver and Excel programming problem
  567. Changing project desktop icon
  568. VBA code for: Saving to desktop?
  569. Excel VBA - Sort a table with BubbleSort
  570. Autonumbering
  571. Copy Table to New Sheet
  572. finding a common set of numbers in separate rows
  573. Setting a print range using variables
  574. If then Cell comparison with text.
  575. Reassigning macro to add in function
  576. SQLOpen VBA
  577. bug submission?
  578. multiple user DB access via Excel (troubleshooting?)
  579. Merging Files
  580. Problem, need urgent help!
  581. Sort using 4 keys
  582. Lookup 'Like' values???
  583. "Application-defined or object-defined error" while printing excel report
  584. Web Query
  585. Comparison
  586. Excel Relative Macros
  587. "runtime error 9"
  588. Multiple Macro help
  589. Simple programming question
  590. Macros to Create Pie Chart
  591. Macros work on my computer but not another???
  592. Macro moving a directory with XP
  593. How do I?
  594. Changing cell value depending on dropdown list
  595. Assign button to run macro
  596. Add drop shadow to cells
  597. The cell address of a button?
  598. Need vb to automatically download from https website
  599. Printing a legal sized document on letter sized paper
  600. Copying from excel sheet on IE webpage
  601. Selecting a printer
  602. Grouping Event handlers
  603. Convert "merged" cells to "CenterAcrossSelection"
  604. Macro to move, create formulas and loop
  605. Simple VB Script - Part 2
  606. need to append range name size with new entry automatically
  607. print row
  608. Resetting cells
  609. documented memory leaks in Excel 2003 or OWC11?
  610. Forcing legal to print letter
  611. XL97:Combo/DropDown box and Not In List
  612. Inputting data from Userform
  613. New to macros
  614. Any simple method to convert Lotus 123 program to Excel VB ??
  615. Combobox selection
  616. Comments
  617. Data Comparison
  618. Simple VB Script needed
  619. add end rows after suppressing prior rows
  620. If Cell in row has data then do this: HELP
  621. How to import Text file to Excel
  622. pull down menu
  623. Saving only 1 sheet of a workbook
  624. Calling Add-In subroutines from other modules
  625. Do not print if error
  626. how do I build a pause (or delay) into my macro?
  627. Trigger Code with Mouse Click
  628. Macro: Excel 2000 does not work, XP does...
  629. Icons on toolbar buttons (Was: Toolbars with macros)
  630. Inserting comments
  631. SQL Select statement with Date as
  632. Inserting comments
  633. cammandbutton into a graphic sheet?
  634. Column aliasing fails in ODBC queries w/multiple tables
  635. Problem with Application.Width
  636. Visual Basic Code
  637. Extracting info from different rows (& columns)
  638. Overriding Actions of Excel DropDown Menus and Poup Menus
  639. Excel Database in shared environment
  640. Vlookup - Multipel results
  641. Checking contents
  642. Mail ID from wabsite with VBA
  643. Need help with array formula to count rows w/ mult.criteria
  644. checking drop down
  645. MSDN Library
  646. Emulate Access with Excel - display form for data entry
  647. Macro problem
  648. Toolbar with Macros
  649. Navigating in big list
  650. Suppressing links message
  651. Set Range Var with address length over 256
  652. Watch cell value
  653. Mouse in Code View
  654. Eliminating Blank Rows + "COUNTIF"
  655. Data Tracking - Update only with "save"
  656. ListView to Excel Code (but needs SPEED improvements)
  657. VB.net and Excel COM exe
  658. Validate Cells based on if conditions
  659. Why "User-defined type not defined"
  660. Some VBA questions about cell selection
  661. Conditional Formating issue
  662. lookup and offset combination
  663. Copy-Paste while looping
  664. FileDialog
  665. ComboBox DropDown when Key is pressed
  666. Efficient Looping
  667. Copy Column and Paste
  668. Positioning the Insertion Point in a TextBox
  669. Sending email from Excel
  670. download a file from a webpage with VBA
  671. Data Validation Questions
  672. Custom menus clean-up
  673. link text box to Enter Key and button
  674. Showing Pictures
  675. Detecting a network connection
  676. Changing www links in spreadsheets
  677. Finding substrings within a string
  678. Clipboard
  679. Just a button
  680. comparing columns from different sheets
  681. Re: Clear Clipboard
  682. Re: Using BeforeClose for deleting a custom toolbar
  683. order worksheets alphabetically???
  684. Enable/Disable Button
  685. Responding to Outlook Errors when useing Sendmail!!
  686. Re: Picture Tiling property
  687. Using functions in personal.xls
  688. how to know the number of lines on the sheet?
  689. Trying to select the visible range of cells
  690. Re: How do I update calendar control 8.0 to 10.0
  691. Re: Delete characters up to ":"
  692. Re: Help
  693. join more workbooks in one and print sheets
  694. Re: Write a macro ro copy column at certain time of day.
  695. Re: Help
  696. Re: Workbook_Beforeclose vs BeforeClose Event
  697. Re: Screen flashing during macro execution: Interesting observation
  698. Re: Mapping macro
  699. Re: Help
  700. Strange vlookup problem?????
  701. Self-updating shortcut menu
  702. form macro
  703. Formulae required
  704. stars **** in cells
  705. Setting the default file name in the XLDialogSaveAs dialog box
  706. Run VBA from Hyperlink
  707. my stock quotes
  708. Convert MS Word table to Excel
  709. Can anyone help?
  710. Help with data entry form please
  711. 2 lists of values - identify differences?
  712. Find row number of maximum value
  713. FUNNY BUTTON
  714. Cell Background Color
  715. use a txt.value on a form to search a sheet
  716. Calling lookup table gurus.
  717. 2 or 3 rows, not just one
  718. Save As - using data from two cells
  719. Converting Access dll calls to Excel program
  720. Find cell select row and delete
  721. CreateTextFile not updating file
  722. Sendkeys and NumLock Key
  723. VBA code halts after opening a file
  724. VBA on the net?
  725. For Robin Hammond
  726. Can not set Y Values in XY chart
  727. What Tasks Can Be Automated?
  728. create worksheet and insert row
  729. COM Interface and IDE caching
  730. Scroll Bar
  731. Publish to Web, Zero Values setting not saved
  732. Creating UserForms in Excel
  733. Jump to section in Validation List
  734. If values in two columns are equal I want to automatically execute a macro
  735. Excel auto macro problems
  736. Re referencing an object
  737. Trying to make cells numeric only
  738. Array MATCH function for VBA
  739. Need help subtracting time values
  740. Understanding Selection "Type"
  741. Multiple Recipients in SendMail Method. HELP!!!
  742. Array Lookup
  743. Text box format VBA
  744. Date Function
  745. A counting problem?
  746. Passing Excel formats in VBA date variables
  747. Running Multiple Modules With 1 Command
  748. Macro help - copy row, clear, and paste on different sheet
  749. Dynamic 2D Array
  750. Print single sheets from rows of data
  751. Terminal Server 2003 + Excel 2000
  752. Canadian Postal Code
  753. Reference Access created form in excel
  754. Form.Refresh doesn't work...help !!
  755. keypress to fire command button
  756. CurrentRegion Selecting
  757. Excel Product Id
  758. colorize row if...
  759. Run-time error '424': Object required
  760. String to Range?
  761. Vlookup Multiple
  762. determining coordinates for screen placement of user form
  763. Moving the Command Button
  764. Code for Subtotalling?
  765. Macro - copy entire row and paste at bottom of another sheet
  766. excel VBA problem
  767. unwanted zeros
  768. copy and paste in different columns with conditions
  769. close(savechanges,filename,routeworkbook)
  770. formatting for feet and inches
  771. Shell
  772. CopyFromRecordset not starting at current row
  773. Number format in vba
  774. How to "push" a value into a cell
  775. Wrapping Text with VBA
  776. Link to User form
  777. class? Compile? XLA?
  778. String to Array Conversion
  779. path strings
  780. Please Help (text file to excel)
  781. Similarly helpful AccessVB forum?
  782. Security - Protecting Macro while generating workbook thru VB 6.0
  783. Running Code Automatically
  784. Overlapping combinations problem
  785. Print
  786. Graphics
  787. Reference an image in another sheet
  788. Range Question
  789. add another text box
  790. a label for each name in a list
  791. Change Event.....Cell character count
  792. Change Event.....Spell Check
  793. what does (ByVal Target As Range) mean
  794. check writing text
  795. import- export XML in excel without loosing XML format
  796. Disable Print Button In a Single Workbook
  797. Using Spinbutton to change a date
  798. bank account
  799. what's the Bug....tell me what's happening???
  800. #value
  801. Sum accross sheets
  802. Autosave of xls files in csv format with macro
  803. Publishing VBA Functions
  804. cells in ascending order
  805. Excel Automation Find/Replace Excel 2000 and 2003
  806. On error resume next statement ignored!
  807. Scenario
  808. Loosing Cell Selection
  809. Hide/Unhide sheets
  810. VBA and norminv
  811. Input mask for date
  812. sub directories
  813. True and True
  814. Need to randomly populate a 10x10 array of cells with 100 names - 5 people listed 20 times each...
  815. Automatically converting to HTML
  816. OnChar function
  817. Macro to Modify Another Macro
  818. Automatic execution of macro
  819. Automatically adding ':' to Military Time
  820. sheet.columns("K:M").EntireColumn.Hidden = True
  821. search for cell value and return row values
  822. Office Assistant Balloon User Input
  823. SetFocus in user form
  824. Populating a 2-D array
  825. Groupings
  826. Graph Simple/Quadratic equations
  827. edit a macro using a macro.
  828. Corrupt File
  829. Searching a txt file for splitting into different worksheets
  830. zip codes as numbers
  831. easy combo box issue
  832. MOST & LEAST OCCURRING INTEGERS !
  833. Protecting worksheets with Macros in Shared Workbooks
  834. option strategies
  835. How do i express this in number
  836. opening a form automatically
  837. Speed--Excel 2003 RAND vs. VBA Rnd...
  838. If statement or another formula help
  839. Runtime error '429': ActiveX component can't create object. HELP!!
  840. Speech.Speak error
  841. Global Variables using User Forms
  842. Urgent
  843. UPPER and Proper Case
  844. Export to CSV to speed up Loop
  845. Keeping name of worksheet who called macro
  846. Re: Change active cell properties with command button
  847. menubar buttons don't appear
  848. listing macros associated with shortcut keys
  849. Excel password but cant hide the sheets before entering password
  850. two things: auto email and archiving
  851. Insert a value based on unique valuse in a row
  852. Copying Text from TextBox into cells in table and then addign a new row
  853. Setting the Values Property of the Series Class
  854. Keeping button pointing to original workbook
  855. Macro not showing in Excel spreadsheet
  856. Adding Hyphens in a number
  857. capture paste event into a cell
  858. MouseMove causes Excel Crash
  859. Pivot table
  860. How do i find the last cell range in a sheet
  861. Change active cell properties with command button
  862. Turn Off Warning in Macro
  863. GROUP
  864. Help with Pivots (.Pivot Items) - Excel 97
  865. Can I make my own FaceID's?
  866. Calling Sub with Parameter from Menuitem
  867. Hide toolbars
  868. Maintaining column formatting when copying a row to another sheet based on a value
  869. Trap CTRL+C keypress event
  870. Forms Box
  871. auto sort
  872. Passing ClientCertificate data from excel to asp/aspx
  873. WorkbookOpen
  874. Check if activesheet is protected
  875. excel vba date format prob.
  876. Visual Basic editor terminates Excel 2003
  877. Linking EXCEL WORKBOOKS
  878. POP-UP
  879. chart updating
  880. How to fill a sheet in Excel2003 with CSV data?
  881. Convert data from MS Word
  882. Existance Check Fails
  883. Cell lookup
  884. Line insertion
  885. Please Help (text file to excel)
  886. Runtime 1004 unable to get find property of range class
  887. Hide all menubars
  888. Get Max Date From PivotTable
  889. Dialog boxes in Excel
  890. Kill Command
  891. filter problem
  892. Force Macro Enable
  893. Format dates in VB
  894. How to load a help file using VBA
  895. Code to make sheets in a workbook visible
  896. Excel App "invisible" to user
  897. Most Interesting Problem I Had Ever Got.
  898. Why does sendkeys seem to loop
  899. Help - setting up manual recalculation when opeing a file (but before it starts recalculating)
  900. linking excel sheet to access using code
  901. Autohide Rows based on condition
  902. How do I get the file properties?
  903. Excel 2000 code not working in XP
  904. Don't Update Links to Ext Workbooks using VBA
  905. Access protected VB code by initiating password dialog box
  906. Error Handling
  907. Double-click date entry
  908. OutlineLevel and Integer Variable issue
  909. Making GIFs from anything, with optional resizing
  910. Append data
  911. Excel 5.0 entering date
  912. Generating reports
  913. Oh no! Need help on unprotect password protection
  914. VB Error: Paste Special method of range class failed
  915. How to auto hide an empty row with VBA?
  916. How to retrieve content of the Excel cell?
  917. VBA - Today() not available in VBA?
  918. searching sheets in large workbook?
  919. SaveAsUI
  920. Import form from Access?
  921. Cannot install Excel 2002 Analysis Addin Toolpak
  922. VBA - Looking to strip alphanumeric from numeric
  923. Knowledge Base 247412 need help to make work
  924. how do I: launch a macro if two cells do not equak one another?
  925. Re: Command Button that changes cell properties
  926. Duplicate Email Addresses
  927. OnTime Help
  928. Date Entry Script
  929. Assigning a Range to
  930. File Searching
  931. RANGE & NESTED LOOPS
  932. lots of text in text box problem
  933. Log Normal Distribution
  934. Show changes after a Merge Workbook
  935. Timer control
  936. Stats Question
  937. Deleting Specific Rows - urgent
  938. need a function (not macro with ontime) to record a snapshot of a changing cell
  939. Filter on a Protected Worksheet
  940. also,
  941. Not Unloading a UserForm
  942. Identify Blank Cells in Col & move coresponding data
  943. Kung Foo Masters Only
  944. calculating age from date of birth
  945. VB coding for formatting time used in calculations
  946. Edit Array Funciton
  947. What's the best????
  948. Customizing pivot table with macro
  949. Globally define all Excel worksheets as text
  950. Excel VBA Save As
  951. SolverOK problem - very frustrated, please help
  952. CombBox - Object of What Collection?
  953. Forms blank out, periodically
  954. Auto filtering with form type pull down menus
  955. Problem with Alan Beban's ResizeArray
  956. Display unique values in a range.
  957. Merging copies of worksheets
  958. enter data from a form to "found" fields
  959. Defining Trial Period of VBA Code
  960. Matching problem....
  961. Pivot table question
  962. Select through last non blank row in a column
  963. Path in Footer
  964. Post Excel Data to a Web Server
  965. How do I get macros and hyperlinks to update when I change the name of a worlbook?
  966. pasting cell range in an email
  967. Comment Indicators - can I change the color of the little indicator ...
  968. Maximum Absolute with sign
  969. Toggle Hide/Show
  970. Userform web Data query table
  971. Conditional Formatting
  972. Merge multiple cells
  973. Second subroutine to run automatically
  974. 2 Collection questions
  975. Custom menu depth
  976. Modifying pivot table changes chart type
  977. Excel not prompting to save Add-ins
  978. Excel programming book recommendation
  979. Unhiding workbook when loaded
  980. Append Data to Table after Web Query
  981. Combine All Worksheets into one
  982. vba help doesn't work
  983. Concatanate odd rows
  984. CheckBox Event
  985. Testing for null or empty
  986. very Important
  987. OLE DB Provider
  988. Help with SaveAs
  989. Compile Error on "dim x as VBComponent"?
  990. Old Macros in Excel 2002
  991. Knowledge gained from Access to Excel VBA Automation User request
  992. #N/A Errors to 0
  993. Multiple Instances of Excel in WinXP Pro Task Manager
  994. Re: Toggle Hide/Show
  995. Linking a Word Field into Excel
  996. Acrobat 6.0 and UDFs
  997. Automatic TickLabel and TickMark Spacing
  998. Excel Version
  999. macros
  1000. Including .csv to end of filename