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. Looking for Userform examples - site on web, download examples
  2. VBA to return how many Excel instances are open
  3. How do I select multiple worksheets for print preview?
  4. Writing data table to user form
  5. execte stored proc
  6. Printing from a macro
  7. HIDING A BUTTON
  8. Excel 2002 and VB Macro
  9. sheet tabs are gone (screen resolution)
  10. Help on formatting using NumberFormat
  11. Chart Resizing Problems
  12. test
  13. Why 2 clicks on a command button
  14. A bit of help with Names, please?
  15. How to reference in sheet module value on another sheet?
  16. macros
  17. delete chartobjects!
  18. Re: How do I put a "date & time saved" stamp inside an Excel Wksht?
  19. compare and find added or deleted rows
  20. How do I put a "date & time saved" stamp inside an Excel Wksht?
  21. Creating a user interface in VBA
  22. Can I use CreateObject for Windows Explorer?
  23. VBA equivalent of MATCH()
  24. Chart to worksheet programmatically -- coordinates?
  25. ReDim Object array as parameter of Variant array
  26. Protecting & Unprotecting Sheets
  27. Picture Too Big and Will Be Cut?
  28. Coding best practice question
  29. Running Animation
  30. See code enclosed - Convert to formulas with absolute reference inculding the sheet references!
  31. Excel startup settings
  32. MultiPage - How to set MutiRow property?
  33. Finding text and replacing in VBA
  34. Calculations with different date formats
  35. Protection in VB
  36. Application.EnableEvents = False not working
  37. Creating first ever userform but not going how I wanted
  38. Importing XML into Excel 2000 without writing code
  39. More Efficient code than this
  40. grouping of cells in protected sheets
  41. Further Information
  42. Named ranges
  43. how do i do something for every spreadsheet i open?
  44. Using VBA to Unlock Cells
  45. Help with faceid and button images
  46. Excel Newbie Question Please Help
  47. BUTTONS
  48. BUTTONS
  49. Loop Macro?
  50. Translating English-Spanish on cells
  51. Linking
  52. AutoFit Madness
  53. Validation Dropdown List
  54. VBA save an object
  55. Trying to develop a shipping calculator to compare courier rates
  56. SQL statement in VBA
  57. skip worksheet
  58. newline in a msgbox
  59. CREATING NEW WORKBOOK FILE EVERY MONTH AND NEW WORKSHEET EVERY DATE
  60. Simple form question
  61. array
  62. Quick question on Error Trapping
  63. Chanagin buttons images
  64. Create a macro to move info from one column to another
  65. EXCEL Visual Basic Questions
  66. Filename as Data
  67. How to protect a sheet with pasword
  68. set print to pdf filename
  69. Dynamic Entries
  70. opening files
  71. How to remove an add-in that doesn't show up in the add-in list
  72. Using Excel Solver multiple times with macros
  73. Placing values in a range on a non-active sheet
  74. How to get rid of VBA-reference??
  75. List Box Moving
  76. Add row after various groups of numbers.
  77. Pivot Table Query
  78. how to match up cells in different columns in Excel 2003
  79. Outlinelevel event ?!?
  80. Validation question
  81. selection of several worksheeets
  82. Can a dipendancy list "Auto Competle"?
  83. how to program a button...
  84. Language portability problems when setting LeftHeader text from external app (=non-VBA)
  85. Workbook-level public variables
  86. Error in Code
  87. coinitialize
  88. PROBLEM DISPLAYING USERFORM
  89. on error
  90. Remove extension
  91. newbie question
  92. Paste function without affect locked cells
  93. disable form movement
  94. change value on a form
  95. Extracting part of a spredsheet based on the date
  96. Audit function needed
  97. Select entire columns in worksheet and place into combobox
  98. LIST BOX ON USERFORMS
  99. Insert Values into combo box
  100. Format Individual Characters in a Cell
  101. Updating closed excel files
  102. Excel 2002 UDF screen tips
  103. Hide / Unhide Columns with checkbox
  104. File list
  105. baht
  106. Checking Options in UserForms Collection
  107. Re: Check if workbook is waiting to calculate
  108. checkbook register template
  109. Is worksheet 100% refreshed
  110. VLOOKUP
  111. Email
  112. Protection not working for data validation lists
  113. Send E-mail from Excel VBA without Security Warning
  114. hjf
  115. Send e-mail from Excel VBA without Security Warning?
  116. Workbook link help needed
  117. sum if
  118. Excel VBA Code to hide dark black selector box?
  119. league table
  120. Creating absolute references including active sheet name in the formula
  121. Replacing blank cells with zeros
  122. Simple Form questions
  123. How control where the CommandBar will be placed?
  124. DELETING DATA FROM USERFORM
  125. vba script help
  126. finding data within a range
  127. Creating folders using VBA
  128. How do I reference a cell that has a colored background?
  129. What function will give me a random full number from 1 to 6
  130. How avoid errors when you Copy chartobjects paste in powerpoint
  131. How store PageBrakes locations - Coded pagebrakes are deleted in Workbook_BeforePrint
  132. Generate random password
  133. Automate defining names
  134. Programme Printing of Several Sheets
  135. ones more the same question
  136. How to get a UDF to ignore all sheets but its own?
  137. Macro to highlight cells that are 5 business days from trade date
  138. How do I enter $1225 as $12.25 without typeing the decmial?
  139. Setting CommandText property of PivotCache fails if cache has >1 PivotTable
  140. Lookup Functions
  141. Get rid of bar from the top
  142. error 70 - Permission denied
  143. Copy and pasting specific sheet data to a master worksheet
  144. Initialize Option Buttons
  145. how to change cell sign and values
  146. Sheet Tabs
  147. Slow Function
  148. Locate and length functions
  149. Global Variables
  150. Excel Returns Blank
  151. In Excel If then with multiple possibilities
  152. VBA msgbox function
  153. If Then
  154. transferring multiline text from userform to worksheet - line break problem
  155. AutoFillDown
  156. FollowHyperlink meathod closes workbook (Add-in) in 2003 and not 9
  157. Select a chart without the handles appearing?
  158. Setting Worksheet Name
  159. Mouse Wheel & Mouse Drivers
  160. Unreachable public variables
  161. Help me in writing macro
  162. Check Box and range selection
  163. Basic question - modules and class modules - what's the difference?
  164. Help with named ranges
  165. Box Characters in a form
  166. copy sheets
  167. Countif
  168. Excel Autofilter
  169. Only CreateObject Syntax works.
  170. A couple RTD related questions, plus VBA timer object
  171. Textbox Query
  172. Detecting a another workbook has opended
  173. what row a value is in?
  174. random pairings
  175. How to open UTF-8 files with Workbooks.OpenText
  176. Trouble with Formula
  177. Open, allow link updates, and Save
  178. Adding a sheets name to the worksheets that are copied over from an addin file to the activeworkbook
  179. Question re incrementing Dates by one month
  180. Why use VB over VBA?
  181. Broken macro in Excel 2003: part II
  182. Autofill and programming -- I'm SO confused -- please help!
  183. Variables and arrays
  184. query only returns numeric - can I get characters ... ?
  185. proximity position test for character(s) function - an example
  186. Re: How do I set up incremental numbering of Invoices in Excel?
  187. Excel loses email field data when upgrading from XP to 2003
  188. Retrieve Value from a PageField
  189. Search for a string sequence in a cell
  190. VLOOKUP in a Macro
  191. VB Editor complains of undefined variable for VBE
  192. Excel already open test
  193. Recalculating single cell
  194. User type not defined
  195. Re: Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good
  196. hidden folders
  197. How to Remove Non-Contiguous Columns from Worksheet
  198. Worksheet in VB COMPONENT
  199. Counting times a value occurs
  200. reducing a fraction
  201. RE: Adding Sheet Invalidates Digital Signature
  202. Easier way?
  203. Using an input box to enter information into the header section of page setup
  204. Macro help
  205. Workbook.Save not saving the updates
  206. Add bookmarks to an abobe doc from excel?
  207. Problems with path to XLA file
  208. Error when setting chart Axis value
  209. Include headers/footers when saving as HTML?
  210. Clearing Contents
  211. Need WebBrowser programming help
  212. Worksheet_chage (from Excel 2000 to 2003)
  213. Naming new workbook
  214. Empty Pivot Chart
  215. DDE and MS Office Language Settings
  216. Dataforms
  217. stopping or closing exe files from excel
  218. Macro to cut rows into another worksheet if a cell contains a specific word
  219. Superformula required for looking up Duplicates in a range
  220. Allowing only blank or cell with "X" in it?
  221. Macro Programming in Excel 2003
  222. Fetch list of table names in access to a record set
  223. Distribute Excel Macro
  224. AutoComplete in Pivot Table
  225. Testing to see if a specific name has been already assigned to cellor range.
  226. EXCEL & OUTLOOK 2003
  227. Attension MVP's
  228. multipage form
  229. Fixed Decimal in Text Box
  230. How do I do this?
  231. How to stop automatic calculation
  232. Macro help required
  233. XML Data Island in Excel Workbook?
  234. Setting Relative Conditional Formatting via Macro
  235. Stoplight indicators in Excel
  236. Can't Seem to find problem with this VBA Code
  237. Create Folder If It Doesn't Exist
  238. How to determine the parent directory
  239. UserForm and TextBox Arithmetic
  240. perform multiple actions in an IF
  241. VBA CODE to Subtract two cells
  242. Where can I download (buy) Excel 97? thanks.
  243. Button assignament and translation in cells
  244. List Box Resizing
  245. Re: Automatically Defining Ranges
  246. Not allowing users to enter data into certain cells if another cell is empty
  247. SELFCERT, a step further
  248. Use a button to create a table in excel without overwriting cells
  249. working with decimal remainder
  250. Copy partial cell character format(s) from one cell to another - an example
  251. Using ADO Find
  252. problem with autofilter and question about menu bar buttons
  253. Forms>button question
  254. How to exclude all letter using find and replace function?
  255. find data in one column and use data in the next column over Exce
  256. Macro problem - help please
  257. Trouble calling macro
  258. Hover over variable?
  259. LDAP Query Not working For All Groups
  260. Include headers/footers when saving as HTML
  261. macro won't run macro
  262. ADO recordset closed, cannot read
  263. Operator Question
  264. Macro or Formula needed to search data in cells
  265. How to compare one column to another?
  266. Can I copy the odc files and will they still work?
  267. Disabling macros is not an option!
  268. RE: Why do identical formulas sometimes act differently?
  269. Where can I find documentation on Excel macro statements?
  270. Column Counting
  271. Checking for Changes in File's Cell Layout
  272. Re: Adding Sheet Invalidates Digital Signature
  273. Filename Variable?
  274. Linked Cell Updating
  275. RE: Adding Sheet Invalidates Digital Signature
  276. animation
  277. control toolbox objects and formulas
  278. Random Generation
  279. Retrieving data from a password protected web site
  280. Can't edit module? How do i change this?
  281. Formula
  282. Column Delete
  283. WHAT COMBINATION OF A SET OF NUMBERS COMES CLOSEST TO A FIXED NUMB
  284. Re: Broken macro in Excel 2003
  285. executing action only when cell has changed
  286. updatefromfile in Excel VBA
  287. Re: Copy & paste image from UserForm
  288. Knowledge from this forum
  289. Re: Help Dialog Box
  290. Excel v10. Extra lines printing to Text file
  291. Pasting after last record
  292. Adding a row with macro
  293. RE: Help Dialog Box
  294. Error handler help
  295. Re: Automatically Defining Ranges
  296. Re: Visual Basic Editor Question???
  297. Re: Visual Basic Editor Question???
  298. Re: Application Title
  299. Pivot Table: Calculated Fields
  300. setting up drop down combo box with VBA
  301. RE: Why do identical formulas sometimes act differently?
  302. RE: autofilter and vba problem - FIGURED IT OUT
  303. RE: Broken macro in Excel 2003
  304. RE: Automatically Defining Ranges
  305. Completed Excel Program Request
  306. I need help, sorting and changing
  307. any idea
  308. Class Module for setting Automatic Calc
  309. Need help
  310. determening sheet number
  311. Trying to automate
  312. Worksheet Selection
  313. Backup to specific folder if workbook names begins with "NSR" or "MAC"
  314. Deleting garbage
  315. Month Additions
  316. how Do I save a customized Toolbar
  317. Changing a QueryTable data source
  318. How to save a menu bar
  319. Run-time error '424' in VBA event handler on XL shutdown
  320. How do I compute a sum based on two columns
  321. Chart source data automatically fill in
  322. Macro to copy and paste between two workbooks
  323. Check if filename exists.
  324. Delete ascii character 127
  325. =ColorCell(Color)
  326. unable to open file
  327. Run Time Error 1004 Copy method of Worksheet class failed
  328. Mass Change Hyperlinks
  329. run an exe file as a screensaver in excel
  330. Event sometimes stops firing?
  331. Get a value out off a chart just by a mouse click
  332. Excel question
  333. populating list box with contacts
  334. Truoble Opening CSV file in Excel from IE
  335. Question??
  336. tst
  337. add-ins gone
  338. Row deletion based on matches
  339. make a custom menu available to other users of
  340. Emailing From Excel
  341. Input box - Select a chart during macor
  342. Is BEEP all there is??
  343. add-ins don't work
  344. Numerous OR criteria in a Filtered Macro
  345. External data - change cell color
  346. Insert object into worksheet
  347. How to download into Excel from web?
  348. Graph in form
  349. running a command button from a program
  350. Formating
  351. Personal file slows navigation
  352. How do I make a formula that recalculates itself every 24 hours?
  353. Duplicate date from cell above
  354. Increase Speed
  355. Open find file dialog multiple files
  356. pageheader size
  357. Display text based on a numeric range
  358. Userform
  359. Programming in VBA, use XLS or XLA as source??
  360. Need to look at vba code in a file but excel locks up each time I
  361. Matching selections on pivot tables
  362. Determine memory usage of objects (like Dictionary)
  363. Combined VBA line syntax
  364. User asked for VBA project password
  365. ActiveSheet.ShowDataForm !!
  366. Excel and VB6 Questions
  367. Passing the Name of a Control Between Macros
  368. VBA code to count colors/shapes?
  369. Rich Textbox
  370. Worksheet_Change Event (Excel 2000 to 2003)
  371. Centralised error handler
  372. Calender Help
  373. Please help about SQL in Excel...
  374. How do I post values from source workbook to destination workbook
  375. Import macro from another workbook by macro
  376. AddressOf in Excel 2002 VBA?
  377. Excel
  378. How to disable a sheet's x(close) button?
  379. I'm Confused........................................
  380. pocket pc expense report
  381. How to do this in VBA?
  382. Excel addin from C# - Trap excel events
  383. applcation.run
  384. Avoiding a circular reference or value error while trying to calculate commission - a challange for me!
  385. SecSvr32 Operation exception
  386. VBA | Individual Iterations faster than Loop Statement
  387. formula for programing end dates
  388. Automation Error
  389. DialogSheet - Reference for someone who never used Excel 95?
  390. ADO Weirdness: Changes dots to #'s in FieldNames
  391. Charting - Cells and Range - Error 1004
  392. Combining Macros into One Command
  393. Label the Groups
  394. Text Highlight
  395. Macro to Synchronize workbooks
  396. How can my macro select an option in a pull down menu?
  397. Putting a formula in place one time for the entire spreadsheet
  398. Is it possible to insert a calendar control object in excel?
  399. Preventing VBA editor from Popping up
  400. Weird Sorting Behavior
  401. Hosting Excel in a WinForms application
  402. Create copy of sheet using VB with columns in different order
  403. "object-defined error" when Run but okay when Stepping
  404. With and End With issue
  405. Disappearing Shapes
  406. Need help with offset sort function
  407. Programmatically alter the Project Explorer
  408. Commandbutton enable/disabling
  409. unable to read file
  410. Activating userform and filling it with data form row where userform is activate
  411. Watermark
  412. Hide, not close, one workbook
  413. Cell switching
  414. Import/Export Cells
  415. How do I pull data from multiple files and copy into one file
  416. Password protect hidden cells
  417. Problem with loop
  418. Template questions
  419. Make columns
  420. sum of textboxes
  421. Strange problem running Word from Excel
  422. pasting pictures into Excel
  423. Using wildcard in VBA comparison? need a hint please.
  424. merge cell and padding
  425. Quick Books interface
  426. Does Cell contain Formula or Hard Number?
  427. Betting Pool for Kentucky Derby
  428. set up prices for a drop down list?
  429. Detecting user idle time
  430. SourceSafeTypeLib help
  431. I need help with QueryTable Events (AfterRefresh)
  432. Accessing Excel from VB
  433. move part of cell to new column
  434. Problme with Macro in one ?Unique? system
  435. Interrupted sheet copying causes phantom Book2
  436. New to programming VB in Excel
  437. Reference Dropdown Menu Items in Macro
  438. Text Box
  439. Unable to set the xvalues (or values) property of the series class
  440. Efficient Frontier/Mean-Variance Optimization
  441. What is a Conditional pull down menu?
  442. How to assign macro to menu button?
  443. Pictures in Spreadsheet
  444. Cell Contents
  445. Select sort key from drop down box
  446. inserting cells to multiple sheets
  447. Problem with find function in VBA
  448. Sub folder lList
  449. VBA Code for IF B1 <> "" then C1="FILLED"
  450. save as different filename
  451. bimodal problem
  452. Calling excel-macros from script?
  453. Dynamically highlight the cell under the Mouse Pointer !
  454. Email to from Excel
  455. Filtering Records Help Please
  456. Delete Column
  457. overwrite all files
  458. problem with custom menu
  459. Close Workbook
  460. problem with custom menu
  461. Cancelling the Sheet calculate Event !
  462. Controlling IE from Excel
  463. Is this an Excel / VBA Bug (XL 2000) ?
  464. VBA Help
  465. Can I use a variable as a sort key in VB?
  466. Can this be done ?
  467. Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit
  468. Excel Add-in for SQL Server Analysis Services - refresh problem
  469. Excel Add-in for SQL Server Analysis Services - refresh ør
  470. Excel Add-in for SQL Server Analysis services - refresh problem
  471. Excel Add-in for SQL Server Analysis Services - refresh problem
  472. Put a checkbox beside each chtobj's and then export selected to powerpoint
  473. Help with Opening with deleing end of File
  474. Command Button to Hyperlink to a Different worksheet
  475. BOM and Unicode CSV's
  476. How do I obtain the drive serial number in EXCEL spreadsheet
  477. W2K Scheduler and Excel sheet from ABWR Syskoplan
  478. Read unicode (Asian Languages) from Excel spreadsheet
  479. Hiding a column in a multicolumn combobox
  480. Getting column width of a hidden column?
  481. VBA for plotting charts: Question re-worded
  482. Inserting and copying
  483. Digital Signature
  484. Run time error 1004
  485. Comparing data in columns and delete if not equal
  486. How Do I Reference Individual Dropdown Menu Items in VBA?
  487. Referencing Dropdown Menu in macro
  488. Keep original wkbk open after SaveAs?
  489. Creating a Macro to Chart two columns
  490. Multiple Frames on a userform
  491. Query the User for Cell Location
  492. Need help - Filesaving - need to increment filename
  493. Sequence Question Again (Please Help)
  494. Excel Scenarios
  495. IFELSE question, as it applies to multiple cells
  496. How to prevent Worksheet_Change loop?
  497. Program formula Add On
  498. VBA ComboBox SetItemData type feature?
  499. ActiveX dll with progress feedback to Excel .xla
  500. cycling through columns?
  501. Correcting a cell formula via a patch
  502. Important please read this Thank you `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·.
  503. Next in the sequence
  504. Uninstall Excel Addin
  505. Fill Default/Fill Copy
  506. Mock AVERAGEIF statement not working
  507. Macro to only change specific cells
  508. add-ins don't work
  509. test
  510. Unprotecting and reprotecting within a macro
  511. maximum number of fonts exceeded
  512. Pivot Table Selecting Items
  513. Type Mismatch
  514. Hide Rows based on Time Selection in timesheet.
  515. CharacterLimit
  516. negative numbers
  517. Connect to com port
  518. test
  519. Macro Help Please
  520. ActiveSheet.PageSetup.PrintArea variable ?
  521. Copy range and formats to new Workbook
  522. Correct way to call active worksheet?
  523. document control number
  524. attach file as icon in a worksheet (hope it's not so tricky)
  525. Bimodal data
  526. Date Format
  527. Update a DB (Access)
  528. Import Excel Data in dotNet dataset with oledb
  529. sum variable # of rows
  530. Help - now really stuck! File transfer problem
  531. Macros on workbook close and save
  532. Function parameter description
  533. Clearing the Clipboard task pane in XL ( XP ) !!!
  534. Dynamic Range with another workbook
  535. folderexists code no longer works after moving to excel 2003
  536. Workbook Switching Strategy
  537. Help with macro opening 2nd sheet
  538. The Dialogs collection
  539. using worksheet functions INDEX and MATCH within a macro
  540. Pull Current Month's Data Out of List - Repost
  541. Complex Sorting Problem
  542. Hand cursor/icon like with Internet Explorer hyperlink
  543. Mouse over effect on chart - anyone know how to do this?
  544. Saving the clipboard
  545. Macro that deletes certain rows and not others
  546. Macro&SplitScreenProblem
  547. multilanguage custom menus
  548. Next Number in Sequence
  549. Recal problems
  550. Change Listbox Sheet reorder code
  551. Tracking changed cells in two identical worksheets
  552. How get data into IE6 as "Favorites"?
  553. Copy Sheet in another workbook
  554. URGENT: sumproduct variation question
  555. Conditional formatting alternatives?
  556. Array Formulas and Last Cell
  557. Macro, or excel program to "Close All' while in a workspace
  558. Sharing data with Java?
  559. Macro, or excel program to "Close All' while in a workspace
  560. Charts Range Setting
  561. Cancel OnTime
  562. message box
  563. CF in VB Code - Simple Request
  564. User Defined Functions Behaving Weird
  565. shortcut key help pls
  566. Still needing help with last date attendend.. :(
  567. empty vs. "" vs. Null vs. Nothing vs. not Used vs. Argggh
  568. insert/names/apply - how to "select all" ?
  569. Subclassing Excel !!! So frustrating !!
  570. Subclassing in Excel ! ...So frustrating !
  571. Page Break Preview Page Number
  572. Range collection
  573. CopyFromRecordset
  574. Automated deletion of decimals
  575. run an add-in from a macro
  576. Displaying Timer
  577. Why wont this code work?
  578. Intercept protection message
  579. Rich Text Box
  580. Setting VBA Project Password
  581. Change hardcode to ....?
  582. Start sub in Col B
  583. using listboxes as input
  584. Create button code stops working
  585. Restrict Worksheet_Calculate() to its original worksheet !!!
  586. Determine if cell was modified by Enter , Paste or Delete
  587. Calling a macro from ActiveX Script.
  588. Multiple Listbox? Population
  589. vlookup, index-match
  590. No subject was specified.
  591. Unwanted bar appears at the top of the sheet
  592. Explain to a user the meaning of a control
  593. Selecting a Directory
  594. xl97 userform combobox time
  595. non english custom menu
  596. HOW I SET WORLDS AS MATCHING THE FIGERS IN EEXEL
  597. Simple Function question
  598. "if" statement within a macro
  599. SUMIF Question
  600. smart button
  601. Accessing previous page
  602. Printing problem
  603. add button syntax
  604. Command Button text changes size
  605. Persistent Data in a Combo Box
  606. call up a calendar
  607. Weird behavior of VLOOKUP
  608. Digital Signaure required?
  609. How to add code module to Excel programmatically
  610. Can .FindNext return Nothing??
  611. In-Line Subtotal Madness
  612. How to save excel spreadsheet and word doc with one save
  613. Talking about difficult things¡¡¡¡
  614. A little help with SaveAs Method please
  615. Code to Insert Formula in Cell
  616. Help! Query table refresh hangs excel
  617. Saving workbook from VB
  618. Can you have a macro always running on a sheet waiting for data
  619. How do I code a button to filter on worksheet2
  620. If Then Help
  621. Need to export file name to users sheet to the next row
  622. page break after
  623. Navigating Excel Sheets with C++?
  624. custom function
  625. Identify Current Row for ActiveCell
  626. Hide "Excel" when running VB
  627. Window Event
  628. presence of SOMETHING in a range of cells
  629. RTD Problem
  630. Keypress for enter in text box
  631. shapes caption on chart
  632. Appending Data from one sheet to a master sheet
  633. Function to automatically fill in an array of cells
  634. How can I report all new customers that have booked training?
  635. Unclear Error Message
  636. Auto move a row
  637. IsEmpty() Returns False in empty cells
  638. IF THEN ELSEIF - newbie needs help
  639. HOW DO I SETUP ELAPSED PRODUCTION TIME?
  640. objects (buttons, dropdown list) move after print
  641. Need Macro to print a sheet conatining drop down menu
  642. Trap whether it was TAB or arrow keys etc
  643. VBA Runs fine on my PC but errors on other PC's
  644. Re : Excel Sorting a 2-Dimensional Array
  645. abort macro dialog box
  646. user defined type not defined ??
  647. Returning Column of active cell
  648. What is the difference beyween "Sheets" and WorkSheets" in subrout
  649. Please help
  650. How to Set ListFillRange to Another Sheet
  651. abort macro dialog box
  652. How to refresh a Excel workbook with pivot & ADO query report in batch mode
  653. how to detect added or deleted rows in compare
  654. Excel2000: Reading values from range, passed to function as parameter using an expression
  655. DisplayAlerts
  656. Data Validation twist
  657. Copying Sheets to New workbooks
  658. VBA SumIF
  659. Radomising rows in a spreadsheet
  660. Adding a tab to Tools->Options dialog of MS Excel
  661. sort function vba
  662. Changing format of column from "general" to "currency"
  663. Rename file based on current date
  664. Choose Invoice# fills Userform again
  665. Scheduled Macros in Excel
  666. veryhidden sheet make restrictions ?!
  667. Database Access
  668. add-in on W2K SP4
  669. text driver problem
  670. Copy Sheets to New WB Without Linking?
  671. I need Code to open DBF file in an excel worksheet
  672. Leading 0s and Col Formatting
  673. Formatting column
  674. Problems sorting from VB when some rows include Borders property
  675. VB Code Refactoring
  676. Error '1004' - the specified value is out of range.
  677. Combobox Add Item
  678. Print multiple files withour opening
  679. VBA Program error...???
  680. Need an assist with existing code
  681. Need a macro to compare values in a workbook
  682. Help with McGimpsey's Seq No Function, please?
  683. How can I print flash cards in excel, word or other ms products.
  684. Elusive Problem with Arrays
  685. embeddable object
  686. XSL FO from Excel
  687. Open all files, ignore some
  688. Arrows on Keyboard working weird IN Excel
  689. Create a hyperlink with querystring from cell
  690. removing #DIV/0! in VBA in a calculated field in a pivot table
  691. How can I select / deselect columns for printing
  692. Deleting non numeric characters.
  693. Use command button to send email
  694. Run formatting macro if filename has a particular substring in it
  695. Where to place Code question
  696. copyfromrecordset fails after upgrade to XP and Excel 2003
  697. macros
  698. Auto / Timed Closure
  699. Using vbCritical, vbQuestion, etc icon in custom dialogs
  700. Selection Change Event
  701. Turn OFF Autosave just for a particular workbook?
  702. Status Bar Display Problem
  703. Reading Web site based combo box type values
  704. Fire Event only when Cell Change?
  705. Moving to Excel 2003 from Excel 97
  706. Office VBE SourceSafe Integration Improvement?
  707. How can I pull and format an SAP aging report into Excel?
  708. Case Statement using a Range of Conditions
  709. Areas, rows and colums
  710. Dim MyArray() as Long, Dim MyArray() as String, etc.
  711. Copy disable
  712. How to make error handle for mis-typed variable?
  713. Class stops working
  714. How do you create a calendar drop down in excel?
  715. Bind datatable to excel worksheet
  716. Can Excel Do This For Me????
  717. VBA Help with changing shape color for selected shapes only
  718. Re : Excel Formulation of 2-Dimensional Array
  719. parsing a string
  720. Problem with Excel 2003 and VBA to Open Doc
  721. code to delete a file
  722. remove code from behind worksheet
  723. Code to Open a dbf4 file in a Worksheet
  724. group of rows and element
  725. Entire Column Delete
  726. Problem in graph automation in excel.
  727. Working out first and last column and row in a range
  728. Problem with save some code
  729. textboxes problem?
  730. What's wrong with this picture
  731. Standalone Macro
  732. Module problem
  733. re:Check for dated sheet
  734. error traping
  735. Cell coloring problem
  736. Sheets added by VBA invalidates digitally signed VBA project
  737. Choose Invoice# fills userform
  738. Using date in cell as variable
  739. how can I hide macro list from user?
  740. Date Transfer to userform
  741. MsgBox Code Error
  742. Filling Formula down???
  743. Opening a DBF4 file in Excel
  744. personal macro workbook error
  745. Excel application title bar
  746. VBA Range select
  747. updating a chart series automatically
  748. Creating an excel function
  749. How do I retrieve my personal macro workbook?
  750. How do I view the value of a variable in my code?
  751. Check a user-input value against a list of values?
  752. Clearing a date vaiable
  753. Problems with the buttons language
  754. VBA + add multiple cells in code.
  755. Number format and decimal positions
  756. Excel range into a vb.net dataset....
  757. shopping cart like application help please
  758. Formulas
  759. Conditional Validation !
  760. VB Slows to Crawl when Deleting Rows
  761. RE: VBA + add multiple cells in code.
  762. Relative Reference and AutoFill- Macro
  763. VBA code translation - compile error
  764. Append data to a separate workbook
  765. Custom Form Coding
  766. PLACING PIC IN WORKSHEET USING MACRO
  767. PLACING PIC IN WORKSHEET USING MACRO
  768. Selection Change Event
  769. RE: Problems with the buttons language
  770. Relative Value Macros
  771. "relative reference"
  772. Out of Memory: Array Transpose
  773. RE: Clearing a date vaiable
  774. RE: How do I view the value of a variable in my code?
  775. Determine Last Cell
  776. convert to value
  777. VBA code for making a pivot table
  778. Array to copy from one workbook to another
  779. Printing hidden worksheets?
  780. Best way to implement "refreshable" reports
  781. how to open workbooks with different names
  782. RE: Formulas
  783. Returning a date value from combo box
  784. Copy Button & Code question
  785. Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you
  786. Macro to set header
  787. VSTO removin formulas and email
  788. Urgent help!! How to automatically resize all the charts? Thank you!
  789. Re Large Concatenate - (RP)
  790. Office Assistant ...
  791. Screentips ...
  792. Prompt to save changes
  793. SubTotals or Outlines to the left? / on Top ?
  794. Move Row based on dates
  795. SendKeys with DOS program
  796. dde
  797. Array Check
  798. form size and protection
  799. Checking Before Updating Template
  800. Sheet Refs in Add-In
  801. Worksheet Navigation
  802. Refresh to Multiple Files
  803. Excel Autofilter options (version)?
  804. Memory Leak Excel 2003 vs 2000 using linked pictures
  805. Formulas using multiple { }
  806. Adding files to a print queue
  807. Looping through controls
  808. Numbers of minutes in Verizon Wireless phone bill
  809. Help with Open and Read txt file, please?
  810. Error Message "Select method of worksheet class failed"
  811. export record from excel...
  812. Redundant data increasing file size?
  813. VB Code stops working
  814. Detecting when user deselects an add-in
  815. Unprotecting/Reprotecting
  816. Working with range
  817. Adding up #s in Excel
  818. No of Records returned by a Query
  819. If then Macro in Excel
  820. Multi Selection in a ListBox
  821. Count nullstrings in pivot table (databodyrange)
  822. Workbook window setup
  823. Template Functionality
  824. how do i append 4 differnt worksheets in a new master work sheets
  825. Filter & clear cells
  826. Usersform in VBA for Excel
  827. Re: How to program a spreadsheet to do this?
  828. Difficulty with MOD operator when using Mod 1
  829. Macro Excel
  830. Excel2000: How to check for Optional parameter=Nothing
  831. Excel VBA to send email using Lotus Notes
  832. Combo help?
  833. Saving a xls as a xlt
  834. Macro help on Cell Selection
  835. Updating source data while in Pivot Table
  836. Help please! Loops? For Each? Variables?
  837. Set the value of a combobox
  838. random numbers
  839. Forms that are modal in 97 are not modal in 2003
  840. dell w/XP what do i need 2 open & open excel
  841. SetFocus from ComboBox to Calendar gives Run-time error
  842. sequential numbers on invoices
  843. need help with a If=then situation.
  844. merging cells and then deleting rows and duplicate entry
  845. Dynamic Percentages Using Subtotals???
  846. Macro Help
  847. Date + Filename using save copy as
  848. Validate Combobox entry
  849. How to know what caused SheetChange event..
  850. Combo Box easy question?
  851. CountA Problems
  852. show date modified in a cell
  853. Large Concatenate - (RP)
  854. Searching Powerpoint from excel
  855. select method of range class fails
  856. Displaying the Highest Value in a user-variable range of cells
  857. comparison of data
  858. Autofit ?
  859. Problem using ASP with XML to Generate Multisheet Excel file
  860. Transferring information from textbox to new spreadsheet/document
  861. Unable to get the Open property of the Workbooks class
  862. Find and Replace on all worksheets on all files in a folder
  863. copy a sheet with all formats - column widths, etc?
  864. Excel CheckBox on UserForm Event Loops
  865. Using it twice AGAIN!!!
  866. Excel to word
  867. using "or" twice
  868. Address of Cell that lost focus?
  869. Need code for transfering cell value to text box.
  870. Deleting Duplicate Rows
  871. Passwrods
  872. Moving data from one cell to another
  873. help with macro
  874. CSV files
  875. Dependant Combobox
  876. help with code please
  877. How do I turn off macro warnings?
  878. RE: Automatic Refresh for Pivot Table
  879. TextBox and KeyCode
  880. Always keep the same 4 PivotItems visible
  881. FORMULA COPY AGAIN!!!
  882. Email using Lotus Notes & FollowHyperlink
  883. AND/OR Formula
  884. How to import a matrix of size 2057x2057
  885. Intersect Operator vs Explicit Cell References and the Dependency
  886. Re: EXCEL VBA
  887. File size mystery
  888. End if w/o if?
  889. Formula Copy
  890. Worksheet Form
  891. Re: automatically running a macro
  892. Excel form scrolling
  893. macro
  894. Helpful userform tricky to program
  895. ActiveSheet.Shapes
  896. How do i create a tennis ladder?
  897. Run time error '1004': Generaol ODBC error
  898. SUMPRODUCT WITH AN "OR" MAYBE????
  899. Change File DATE created & modified
  900. Shell can open an application, can it close an app too?
  901. CheckBox Change Event
  902. Micro
  903. string compare with wildcards
  904. Excel 97 - VB question
  905. sorting in pivot table
  906. How to trap delete row event and hide column event?
  907. Is it worthwhile to upgrade Office 2000 to Office 2003?
  908. Re:User form Yeah!!!!
  909. Can I send results of a formula to multiple cells?
  910. List box
  911. Architectural guidance, please
  912. vba is converting text to values!
  913. referring to a named range on another worksheet
  914. Protecting Hidden Areas
  915. Automatically Installing Add-Ins?
  916. Querytables parameters
  917. SUMPRODUCT OR SUMIF
  918. Invisible cells in VBA
  919. lost ability to see worksheets
  920. Making Address function & references as links to external files ??
  921. How to Write a sub to execute the following
  922. VBA to copy sheets (as values) that begin with the same sheet name
  923. request macro to save file to multiple, separate locations
  924. printing labels
  925. rounding to .5 in VBA
  926. Hyperlinks / server / cd
  927. Delete Row Based on Listbox Selection
  928. Re: Reading registry with Excel
  929. Reading registry with Excel
  930. Formatting Textbox
  931. Cells(col,row) keep moving to lower case and I can not ref. a cells in a differnet sheet
  932. Restrict Macro Availibility
  933. Excel file very large in size?
  934. excel solver
  935. Help with macro
  936. variable not set error?
  937. Over 29 args in a UDF with double parens
  938. How do I repeat key strokes in Excel?
  939. How do I sort nulls within date field in Excel
  940. Macro to force cell entry before running
  941. Sheets.Add using other worksheet as "template"
  942. switch rows & columns?
  943. subtotaling becomes slow
  944. Macro Copy Active Cell to Range Name, loop
  945. Reading data from a filtered list
  946. Userform - Entering Time
  947. Variable in a Search and Replace macro
  948. MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET
  949. .wait for 1/2 a second
  950. How do I format a document?
  951. Array
  952. automating macro
  953. Bold some of the cell contents
  954. Control on Sheet - Drop Down 1
  955. INSERTING A PICTURE ON WORKSHEET
  956. Creating a unique ID number based on date and time
  957. Multisheet IF Function
  958. OnTimer Event
  959. Two Userforms
  960. My workbook filename
  961. Show what options are in custom function?
  962. VBE References Missing from Exported File
  963. how do I insert an ' in front of many rows of numbers?
  964. Updating VB Code
  965. calling a stored access query from excel vba
  966. Copying in VBA
  967. Excluding NULL values in an Excel List
  968. If/Or/VLookup Formula
  969. Record macro to export xml
  970. visual studio tools for office
  971. Workbook_SheetChange
  972. Excel and VBA.
  973. How do I set up an error bar in Excel and a vertical line together
  974. I need a macro to grab specific data and transfer it to a now worksheet
  975. VBA questions
  976. I was Asked an Interesting Question
  977. Adding Sound to Program Revisited
  978. Opening Forms error with Workbook_open
  979. Adding Sound to Program Revisited
  980. Excel2000: Declaring function parameter as an array
  981. LoadBehavior problem
  982. How to sum using vba
  983. how to tracking function run time
  984. question about Excel file writing and reading
  985. Open an Excel file in a new Excel session
  986. Print Area
  987. Send Email (Active Sheet)
  988. Copy data into cells until changes trigger new copy
  989. Using Autofill knowing row and column number
  990. Ok try agian. User form LastRow
  991. Listbox - Text Field
  992. Coloring cells
  993. excel on multiple computers
  994. Difference Escape and Ctrl + Break to interrupt code
  995. stringing macros together
  996. adding rows to spreadsheet after macro is written
  997. Pop up a Form when Clicking a Cell
  998. Placement question
  999. Type Mismatch error
  1000. shape object on a userform?