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. Add-in name capitalization?
  2. Disabling Auto_Open in distributed worksheet
  3. assign dataset to matching dataset
  4. Macro to concatenate multiple rows in a column, without selecting each group manually
  5. Lookup Value in Range/Array and Return Column Header Value
  6. msgBox
  7. Count & List Combinations
  8. Follow hyperlink but don't update links....is it possible ?
  9. Lotus Notes Task
  10. Formatting multi-line text
  11. Find and Paste Program
  12. Referring to cells
  13. Variably Hiding Cells
  14. macro which works in excel 2000 does not work in excel 2002
  15. making charts with vb 6.3
  16. Runtime error 91
  17. Extracting specific data from one column to another column
  18. comboBox properties
  19. After adding a new sheet, wanting to compare cell values
  20. Advance filter question
  21. Use String from another module
  22. Clean Exit from InputBox
  23. looping when checking isdate
  24. How to create chart using VB 6.0
  25. A fast way to fill cells in Excel
  26. variables
  27. Last Selected Cell
  28. Popup box to enter VLOOKUP value
  29. Re:Final days - London Excel Conference Registration giveaway
  30. How to path to user's desktop
  31. Place a User Form on Start Up
  32. IsDate
  33. Internet Navigation
  34. formatting input boxes
  35. Incorporating VB6 RichText control into Excel VBA
  36. Close user form when button is pressed
  37. Open 'n' Hide
  38. Re: Change colour of cell depending on content
  39. Re: Change colour of cell depending on content
  40. Read from text field
  41. Checking data in each cells of an array
  42. Change colour of cell depending on content
  43. show info when workbook opens
  44. Force macro on save
  45. How to check for Internet connection
  46. How to open .xlt containing PivotTable?
  47. need help using send keys
  48. Link to external file
  49. export file to excel
  50. define unique Advancefiltered range
  51. Hi All,
  52. Selfcert and Network
  53. Index number for CommandBar right-click on sheet tab?
  54. Using Controls on a Worksheet
  55. Split a string
  56. creation of name range without selection of cells
  57. Splitting a workbook
  58. Excel, reference a cell for parameter in SQL to import data
  59. Finding a value and going to that cell?
  60. Help! Security when using a VBA macro to access an Excel File
  61. Copy worksheet, rename, merged cell problem??
  62. How do I get a Function to return Null?
  63. Make Excel allow numeric fields as text
  64. need a formula to work out how much ......
  65. data import question
  66. Change from Column Selection to Cell Selection
  67. Can I Select an "Import" Template Based on a Doc's Filename?
  68. Simple worksheet selection question???
  69. Custom View Macros
  70. On Change Event
  71. Border question
  72. Disapearing formulas
  73. Additional Controls disabled
  74. Re: Shapes
  75. roster - printing out who is on
  76. Newbie Run Time Error
  77. on error
  78. VBA created in excel2003 doesn't work in 2000
  79. Multiple Cells
  80. Word wrap issue
  81. Using the ActiveCell function on 2 different worksheets
  82. Problems with Transposing. HELP!
  83. Max length for a menu command name
  84. Paste link With Worksheet that has password
  85. Combining R1C1 and absolute reference in SUMPRODUCT in VBA
  86. quit on error
  87. Multi Listboxes with data dependent upon user choices
  88. good gotos and bad gotos
  89. Empty cell instead of 0
  90. Event: Workbook_Change or Worksheet_Change
  91. What's the secret on scroll bars in textbox
  92. Setting an array range of cells???
  93. Tough - show a hierarchy
  94. Merge Cells in VBA
  95. Page Breaks Macro
  96. Trouble opening PC version of Workbook on MAC
  97. SELECTIVE DELETE
  98. Change Cell Background color Automatically
  99. Create a workbook with only 1 sheet
  100. Macro concatenate formula
  101. Baseball Combinations
  102. VBA - Multiple Array-Enter Command
  103. Sending email with selection of data from spreadsheet
  104. How to create a button to switch to a custom view
  105. How do I identify a range based on cell value?
  106. Re: matching values
  107. How to create a view option (or hide/unhide preselected cells) (Repost from Misc)
  108. How to read filesystem shortcut attributes
  109. How to cause a #num! error
  110. Prorated Average
  111. Ændre dato (tal) 20060615 til dato
  112. invoice template?
  113. Jump to "Defined name" range!
  114. Commas appear when typing
  115. Specify which sheet to paste to
  116. RE: Specify which sheet to paste to
  117. FORMULA FOR EXPERT, PLS MAKE THIS WORK
  118. Mulitple Entries in InputBox
  119. REPOST: VBA Acessing Member Variable in C# Com AddIn
  120. RE: FORMULA FOR EXPERT, PLS MAKE THIS WORK
  121. RE: Specify which sheet to paste to
  122. sort multiple columns of data but not change the data location... Possible?
  123. errors in emailing Excel
  124. Help with VBA export of cells to PowerPoint
  125. ChDir statement
  126. Hourly Macro Help
  127. Help!
  128. Margins in form items
  129. How do I get data validation message to appear using a macro?
  130. Retrieving Data from Multiple WorkBooks
  131. Query PVCS
  132. Run-time error 1004: Too many different cell formats
  133. Transform text in date format
  134. Buttons
  135. Query Refresh without filename prompt
  136. Subroutine calls between workbooks and object references
  137. Connecting button to macro
  138. Pause Code Execution
  139. Canceling a read file function
  140. how to set the value of a cell from another cell
  141. Excel macros for interprocess communication
  142. automating a process in pivot tables
  143. Excel Worksheet Delete "Data may exist"
  144. Adding two cells together
  145. How do I colour ill a cell in excel with a formula?
  146. Returning a value from a form
  147. VBA/SQL Question
  148. More Selecting and Deleting
  149. User form/Modul
  150. Managing Filtered Items
  151. Userlogin for excel speadsheet
  152. VBA Acessing Member Variable in C# Com AddIn
  153. Color Problems
  154. List of macro shortcut keys
  155. Using sheet name of workbooks
  156. 3rd stupid question from newbie - autoloading userform
  157. cell not changing
  158. pasting info from workbook to sheet in another workbook
  159. Format Page set up for all tabs in workbook
  160. Macro for Trimming
  161. Cell Deleting and Shifting
  162. VLOOKUP Formula from one cell to 2nd cell
  163. Naming worksheets in loop
  164. hide and unhide rows
  165. Display button
  166. Sheets reference change variable
  167. Checking if Validation exists in the cell
  168. pasting form 1 sheet to another
  169. Checking format on input
  170. Sum in vba only works for multiple values not for single values??
  171. Loops and Events
  172. Merged cells
  173. code for print dialogue
  174. how to see only youre userforms??
  175. code to unprotect sheet with password
  176. Import a CodeModule then call its method in Workbook_Open()
  177. Main first
  178. VNC and Excel
  179. Find + remove blanks if cell contains only numbers
  180. Pre-Open VBA
  181. SaveAs
  182. how to bypass password??
  183. Get data from Excel-cell and check format
  184. Rolling credits list
  185. Clear contents
  186. Insert blank cell and labelling if difference in comparsion
  187. Search for blanks
  188. Search and replace blanks
  189. Charts
  190. Delete Pivot table
  191. executing database
  192. How to link a form to a sheet in excel
  193. Conditional deletion of rows
  194. Replace Function using Wildcards
  195. Opening a file via VBA
  196. filling userform listbox
  197. Excel Menu Bar
  198. List of Different Cells
  199. Re: excel question
  200. Re: matching values
  201. ?????.Auto_Open ???
  202. Re: Clean up and Fix Two Macros
  203. Re: matching values
  204. Extracting data from 1 file to multiple files
  205. excel merging?
  206. Save Status Bar Disappers after running macro
  207. Changing cell colour depending on content??
  208. Text Box in Chart
  209. how do i use vba to zip folders?
  210. Application.FileDialog(msoFileDialogOpen) and error 75
  211. Print even & odd pages with different margins
  212. Dynamic Name Labels
  213. Worksheet Navigation Help
  214. Excel VBA Macro stops running when another program is activated
  215. Disable Link Alert
  216. Leftover Workbooks Named "Object" When Opening Excel In IE
  217. SQL? Index? Excel?
  218. use mouseclick to dynamically change chart series? Chart_beforeDoubleClick?
  219. DateTime picker control
  220. Please Help :)
  221. Another stupid newbie question.
  222. Formula appears as =RC[-3]+RC[-1] Whats this?
  223. Document security question
  224. Basic Compile Problem
  225. 20 Procedures one Command button
  226. If cell contains text, leave as is
  227. Find macro with wildcard as part of code
  228. If Statement
  229. run a macro when cell value changes
  230. Controlling switching to other sheets
  231. Execute macro many times??
  232. Working with Workbook array
  233. How to find the Dimensions of a Variant Range
  234. Copy Entire Row
  235. Hidden Text Boxes In Spreadsheets
  236. Display of Comments on Excel file saved as .mht
  237. spinbutton In Form
  238. Strange Request
  239. Add 1 to a number each time you print
  240. Having a floating row or hiding unused rows?
  241. Hide Printing Dialog
  242. SUMIF with Mulitple Conditions
  243. xlDown stops at next empty cell, not at last row of data
  244. Find/REplace from table questions...
  245. delete images in an excel sheet
  246. Rename with more than 31 chars an Excel sheet
  247. Display Value in 'Currency Format'
  248. Input Box and Message box Help
  249. Find and Replace within workbook - from Visual basic
  250. Running macro on open of workbook?
  251. need to seperate one cell's formula by delimiters
  252. Change Text Color When?
  253. Help: Excel Macro window run button disabled for all code in 1 module?
  254. Excel, OLEDB and uppercase problem.
  255. Printing all from drop down box
  256. Using Checkboxes to enable/disable vb
  257. Help function
  258. SUMPRODUCT USING <>
  259. slow processing with .find
  260. Formatting Text by when last modified
  261. Searching for a Partial Filename
  262. Copy contents of textBox to Cell in Excel
  263. Duplicated form at runtime
  264. search function without error if not found
  265. for..next statement problem
  266. substitute chatracters within a cell
  267. formula or VBA - would like to autofill cells based on start date and # of months
  268. Saving an Excel file & overwrite (C++)
  269. Newbie-question: recorded macro does not work - why?
  270. SUMIF
  271. Exclude first charachter
  272. Auto delete rows within a specified range
  273. Placing Data in a Range
  274. Save Single Worksheet
  275. Corporate Error Reporting with DW.exe
  276. How to disable all Excel Events and then re-activate them?
  277. macros in network restriction
  278. Looping
  279. MSFlexGrid to display Excel data on VBA form
  280. Hide and unhide rows for multiple areas
  281. Special Cell Selection
  282. create macro - delete all rows with zero in column L
  283. Creating a graph with existing data...clear data after save
  284. Cell address
  285. no builtin chart options for me..(Excel 2000)!!
  286. macros using find/replace
  287. is there a way to connect excel to a pop3 server?
  288. Difficult macros
  289. hide and unhide rows
  290. Import a external data
  291. Pivot Chart Problem
  292. advanced filter and format
  293. Userform Combo box list
  294. pop up box, searching worksheets and running macros help please
  295. Creating cub file using VBA
  296. find values and identifying cell-adress
  297. Passing values
  298. Data program
  299. Extracting Data - Open vs Closed
  300. import and export from SQL SERVER to Excel
  301. student's t table
  302. Importing libraries explicitly in macro code
  303. Dynamically change accumulation links when adding worksheets
  304. Destinct records macro
  305. VBA - If / And Statements
  306. Excel filter does not working anymore
  307. removing commas in csv
  308. autosave on changing worksheet
  309. Copy part of worksheet in VBA
  310. xlb as Addin ?
  311. Filtered Array for Listbox
  312. Save one sheet as .csv with macro
  313. Goto a named range using the contents of the active cell
  314. Accessing a 'column' in a VB array
  315. Using SocketWrench
  316. Undeclared variables allowed in a Module defined with Option Expli
  317. Macro and automatic update
  318. List box deselect
  319. Dynamic Headers via VBA - Probably Simple Answer?????
  320. macro to search for & select ranges to sum
  321. Data Validation
  322. Password on VBA causing problem
  323. Detecting Double Entries
  324. embed?
  325. double freeze pane
  326. Extract Date (04/05/06) into Text (040506)
  327. I would like to get a time stamp that does NOT update upon recalc
  328. Floating Command button
  329. how to format a label to 2 decimal places
  330. How to open a spreadsheet and make changes to it from code?
  331. Paste Special
  332. COM add-in doesn't work
  333. Pull mutil values from one LOOKUP formula
  334. REPOST: Calling Excel Automation Add-In in VBA
  335. Now I want the opposite
  336. Using COUNT value as variable
  337. How to perisist object in Excel
  338. Background color change
  339. Using Excel to generate an Outlook Calendar Event
  340. Protect formula without protecting the worksheet
  341. multiplication
  342. Date and Time
  343. macro to show list of worksheets in a workbook
  344. Hide row if date "A" is later than date "B"
  345. Deleting blank cells in a column
  346. Initiate Macro On Save
  347. Convert numbers to text
  348. Calling Excel Automation Add-In in VBA
  349. REPOST: Automating series generation for scatter plots
  350. Multiple Criteria
  351. Retreiving list of table & field names from Access into Excel using VBA
  352. Multiple Prompts
  353. Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist
  354. list all the find values
  355. keep track of previous excel range value after dragdropped...
  356. Calling Excel Automation Add-In in VBA
  357. Adding sheets and copying data problem
  358. Locking Cells from list
  359. cell with highest value g5 would be upto 80=1,81:160=1.5,
  360. vba encryption
  361. Referencing cell in Named Range in Function VS Formula
  362. unhide rows when cell is clicked
  363. Suppress workbook display
  364. Specific Cell Selecting
  365. Using Macro to copy latest data from one Workbook to another
  366. Conditional Formula
  367. Dynamic Headers via VBA - Probably Simple Answer?????
  368. Checkboxes
  369. Change Application Security Settings
  370. Inserting A row & page break
  371. In VBA, possible ot subtotal without selecting?
  372. Conditional Formula
  373. User defined functions without using VBA.
  374. AutoFill a formula down a column
  375. Copy Unknown Number of Sheets
  376. Auto "Save As" Cell value when data entered in cell
  377. Save WB from reference found in cell D1 to specific folder
  378. Selecting a Pattern of Rows
  379. Is there a way to setup Worksheet Tab Descriptions based on cell i
  380. Passing arguments to userforms
  381. Iteration Calculations between sheets
  382. When will bug 919127 be fixed???????
  383. lookup
  384. Multiple Links from drop down box
  385. E-Mail as Hyperlink
  386. PageBreak in VBA???
  387. VBA Loop Formatting Text Question
  388. Macro Question
  389. cell.replace strange behaviour
  390. Subscript out of range error - save copy error
  391. Subscript out of range error - save copy error
  392. Workbook_BeforeClose
  393. calling a userform
  394. Get FileSummaryInfo for files saved on Intranet
  395. select range between two empty cells?
  396. Why do add-ins reference specific path
  397. importing text from bookmark in Word to excel
  398. Excel Automatino/COM Add-In Question
  399. Resizing Pivot table column
  400. Deleting automatic page breaks in excel 2003
  401. How can I use VB code to execute macro when double-clicking cell?
  402. Excel Sheet.Copy Method (Excel 2003 SP2 )
  403. Delete a Column Based on User Entry
  404. still saving a record to excel even if i press the NO button
  405. 2 questions about developing.
  406. Save macro Truncating text
  407. Can anybody help me please?
  408. Can anybody help me please?
  409. Reading Row headers into a listbox
  410. Filter problems
  411. Filter problems
  412. Filter problems
  413. Timer
  414. Put 1D array into column
  415. Seclect Column or Range according to Cell's Contents
  416. VBA automatically change text format into general format?
  417. Query parameters
  418. London Excel Conference Registration giveaway
  419. EXCEPTIONALLY SLOW LOOP ....help!!!
  420. Putting the document number custom property in workbook
  421. Cannot Shift Objects off Sheet....?
  422. search worksheet
  423. Speeding up Array
  424. Read/Write from/to a closed workbook
  425. Query - Data Layout
  426. Message Box Help
  427. How to pass variable between closed workbook
  428. How to pass variable between different variable
  429. Average a range within an array
  430. Delete Unwanted Rows (Help with Range)
  431. Pagebreak and Zoom problem
  432. "" does not return blanck
  433. Problem in linking
  434. Using Range & Cell
  435. modeless
  436. do while loop
  437. Filter is not working anymore.
  438. Paste Values
  439. How do i parse a text string with a date?
  440. Name Manager: new version released
  441. creating form on worksheet
  442. Lock Cells with Specify Range If Cells contains value
  443. Summarise Worksheet Data
  444. making cells change relative to each other, cant figure out
  445. Summarising Worksheet Data
  446. Run Macro after update
  447. Refer to sheet2 - even when named
  448. Change delimiter in import function from comma to tab
  449. PIVOT TABLE DATE GROUPING
  450. Macro to add count forumla with dynamic range
  451. How to program keystrokes other than CTRL+something?
  452. How can I search in this forum?
  453. pasting into a list using a macro
  454. Delete selected sheet
  455. Custom button :Copy data to new workbook
  456. copy and paste from one sheet to another with VBA
  457. Runtime Error 9
  458. No sure why this isn't working
  459. vba select from Active Directory (LDAP)
  460. using variables to reference sheets
  461. Too many gotoos?
  462. Find out if a Value is Contained in a cell
  463. Problem deleting rows by index
  464. Need Help w/ Search or Find Macro
  465. Date from a cell........
  466. huge problem!!!
  467. Trapping error from Empty Dynamic Named Range
  468. I need more help with Absolute Reference
  469. Cell Colors Dependant on Date
  470. MSAccess 2000 Newbie Question...
  471. macro I shared isn't available in any other workbooks?
  472. Macro to replace error values
  473. data capture from screen
  474. sort grouped cells
  475. PageSetup.set_PrintQuality .NET method
  476. VBA - Strange behavior
  477. VBA Error Handler
  478. Formulas not working once macro is used
  479. Formulas not working once macro is used
  480. Stupid question from newbie re: data from multicolumn combobox
  481. selective protection
  482. WorkBook Activate event not working
  483. Macro to find columns to hide
  484. Gathering Data
  485. Case Statement - help required
  486. Set a range for all worksheets in workbook??
  487. Web service to Pivot table
  488. VLOOKUP in VBA
  489. Word crashed after repeated XL macro use
  490. Variable Range/chart
  491. Update Values Dialog
  492. "Too many diggerent formats"
  493. Duplicate prevention from Listbox selections to worksheet
  494. For Each Array Question
  495. excel help
  496. Save Userform as bitmap
  497. add row to the end of a list and data change
  498. modifying formula reference
  499. V Lookup Problem
  500. FAO Mat P:son
  501. Which sheet gets calculated first for iterations?
  502. comparing rows
  503. Macro to copy Column 1 of all sheets to a seperate sheet.
  504. Opening Multiple Sessions of Excel
  505. HELP! Conditional Formatting
  506. Date in VBA
  507. Sorting information
  508. Page# Return off lookup
  509. Opening the Autofilter dialog box
  510. Automate cell selection
  511. Re: Date Picker - "Linked Cell" Property
  512. Date Picker - "Linked Cell" Property
  513. Newbie question
  514. If cell is empty then run macro otherwise skip this macro
  515. Time range to workdays in relevant months
  516. Cell addressing
  517. Copy and Paste select data to another workbook.
  518. use of PROPER function in Macros
  519. Problem with macro for importing data to template
  520. Macro Opening or Looking for Another Workbook
  521. Reg : GUI
  522. formula for finding Friday
  523. Add value to cell...
  524. Is there an "OnOpen" event for Excel
  525. Macro for Row Processing
  526. Update Sheet1
  527. Creating User Friendly Templates
  528. Formatting Excel charts created with VBA
  529. Error 1004: Application Defined or object defined error
  530. Print multiple reports from list validation
  531. VB & autotext
  532. I need a QueryTable.Refresh solution
  533. Making Excel 2003 as the Default over Excel 2007
  534. In SelectionChange Make Last Rwo Dynamic
  535. Collect used areas of multiple spreadsheets into one...
  536. Modifying .txt file using Excel VBA
  537. RTD formula
  538. what went wrong?!
  539. Delete Rows
  540. Re: Sell Program - Screwed by Managers !!!
  541. Countif result in message box
  542. How to diasble save and save as menu but allow a save button
  543. Option Button Grouped
  544. Remove Chart Label with Percentage 0.
  545. Hide whole row when cel C3 is 0 (zero)
  546. Select.Range
  547. Read data
  548. Web Query
  549. MACRO HELP
  550. Number stored as text. How do I keep the number format?
  551. Locate and Format Row Macro
  552. Last week for regular registration - London Excel User Conference - July 19-21
  553. How Do I Modify Pearson's Code to Add "Treat Consecutive Delimiters As One"?
  554. Scheduling Worksheet
  555. fill blank cell with cell above: special case
  556. Programmer to hire
  557. Looping to update another sheet
  558. Command Button on worksheet
  559. how to select a shape
  560. Macro for sorting within groups
  561. Having problems with quotation marks
  562. text in ***
  563. Need Help Importing Text File Using Two or More Spaces as the Delimiter
  564. Help with Object Design
  565. excel close + save by button press. how?
  566. ActiveWindow VBA problem
  567. Running two arguments within same code
  568. Sort out data on seperate sheet
  569. printing special numbers!
  570. Last Column to first Column
  571. Need emplyee time card app, daily in/out, excel vba based.
  572. Fill FAX template in Word from Excel VBA
  573. Self-Contained "Database" file?
  574. Program to resave a collection of .xls files into tab separated .txt files
  575. Alignment of Graphs
  576. Error in code
  577. .xls values, like .pdf
  578. selecting a column
  579. Questions: Copy ranges, autofilter macro, subtotals, & naming shee
  580. Translating numbers into number with color pattern
  581. Read value from combobox (cleaned off duplications)
  582. variant to long?
  583. Add new sheets with code
  584. rng, varinant to long and offset questions?
  585. Delete all rows not today
  586. Trouble with this code
  587. Find last row through a macro
  588. user-level access to pivot table
  589. Upper-case all text in Excel 2003 spreadsheet
  590. Copying worksheet to new file by macro
  591. Creating an image file
  592. Workbook open event
  593. Problem with file finding macro
  594. Case Satement
  595. VBA programming certification
  596. How can I select a range of cells for header?
  597. Changing cell color if date is...
  598. Determining What FormatCondition Has Been Chosen
  599. Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row
  600. Embeded Wav
  601. Map/List of folders, subfolders & files
  602. "Force" user to save file with specific name
  603. CommandText
  604. Suming a column to another worksheet
  605. Bringing up sort command
  606. listbox to cells??
  607. Force user to save file with specified filename
  608. I need help with a (apparently) very simple VBA script
  609. Clear cells in Column D if not = Auto
  610. Determining if data is sorted in descending order
  611. Send email based on date value
  612. Orderly Validation Against Separate Ranges
  613. Help Template & Database
  614. Setting Timers in Exce.
  615. Shortcut Key
  616. Populate First Empty Cell In each Row with Text
  617. Excel crashes everytime I send focus from control to worksheet
  618. Excel sheet analyzer/generator
  619. Macro to Paste Items to All but Several Workshets
  620. Code deleting all rows in error
  621. Format prompt in VB InputBox
  622. Extracting data from some files in folder
  623. Simple iteration problem
  624. DATE & MONTH minus ?
  625. Need help with grouped counts
  626. Identify an add-in file that is not installed
  627. How Do I "Toolbar List"
  628. code dropping zeros in number strand
  629. How Do I "Toolbar List"
  630. move to new column after ,
  631. Syntax error in code
  632. CopyFromRecordset will fail if the recordset array data such as hierarchical recordsets ???
  633. Problem with Date Conversion Code
  634. extract data from pivot via vba (Getpivot is not convenient)
  635. Copy and paste data from one sheet to another in a single workbook
  636. Disable all "Refresh Data on File open"
  637. Add-ins passwords
  638. Delete entire rows where there is a blank in column A
  639. VLOOKUP with multiple criteria
  640. SUMPRODUCT - small correction required
  641. VBA replaced ?
  642. Filling out usernames in IE
  643. Help with Creating Email
  644. What in the world is it doing??
  645. Public function in Personal.xls
  646. MACRO HELP PLEASE
  647. Macro help please........
  648. Speed VBA Excel 2003 vs 2007
  649. Change color of text segment in msgbox
  650. How to save a file
  651. Sell Program - Screwed by Managers !!!
  652. Excel 2007 Beta
  653. getting info from multiple workbooks simultaneously
  654. findings text in columns
  655. First of the year
  656. Loops
  657. making text in Title Case automatically
  658. Simple question
  659. Factorial macro or formula.
  660. How to Show Existing IE Instance if Already Exists, Else Open One
  661. Password protect a workbook created and emailed by a macro?
  662. Match columns
  663. next empty row
  664. Find and Replace Values in Range
  665. userform cancel button
  666. Adding a hyperlink to a shape
  667. Macro to paste in the active cell the contents of a cell from another file??
  668. Save a Workbook as "Read Only"
  669. Please help with auto Date and Time with VBA
  670. adCmdText
  671. multi tab workbook
  672. Auto-Format Excel Spreadsheet?
  673. VBA/Excel Add-ins
  674. Easy questions about Auto Save
  675. Code For Date Accepts Text
  676. Creating an MSForm based on a table
  677. Textbox in userform doing weird things
  678. General Quesiton
  679. is a variant an object
  680. Extract data from many workbooks VBA
  681. Concatenating problems
  682. repost: Dynamic chart help
  683. saving website html as string
  684. What function(s) should i use?
  685. Macro Question
  686. socket in excel vba
  687. Hyperlink to Word Template
  688. Combining files and their respective VBA macros
  689. Excel IF function help
  690. More efficient copy/paste??
  691. Determine if folder exists
  692. What am I missing here?
  693. Help needed with Pivot table macro to remove data
  694. Won't accept textbox3
  695. FileSystemObject.copyfile
  696. Automatically update links in Excel 2003 after inserting rows in .
  697. Problem with Formula n VB Macro
  698. Accumulative total
  699. Return ADO recordset to worksheet
  700. help me¡¡¡¡
  701. COUNTIF criteria in VBA
  702. Quite simple macro, but I can't seem to fix it...
  703. Macro to copy specific cells from one workbook to another
  704. How to update an external excel sheet
  705. Application.Volatile
  706. Program to accummulate data on ledger sheet
  707. Macro to Move Excel Button
  708. Updating Data through Webservices using Excel
  709. Is this macro even possible?
  710. macro CopyData Help
  711. Question about a custom defined function
  712. Create an Excel splash screen without the caption bar
  713. how to remove a space after a string?
  714. Line number in error handler
  715. How to count number of pages in a named range
  716. Calling a button event from a .NEt application
  717. how to execute a macro assigned to a checkbox in vba
  718. Excel keeps reformatting floating point values to dates (e.g. March 17)
  719. Macro to Paste
  720. Retriving name of cobntrolelement
  721. Final days for regular registration - London Excel User Conference - July 19-21
  722. colouring the entire row to a color .
  723. Excell sheet help needed
  724. incorrect addition
  725. Data validation dependent of value of option button
  726. Fire events for all comboboxes in my sheet
  727. Find new value and replace with old one
  728. Formatting / centring Text in a Msg Box
  729. find and delete
  730. Context menu
  731. Log file...
  732. displaying the user form data
  733. undo delete
  734. Help with PasteSpecial
  735. RePost - Creating WBooks
  736. Dynamic chart to track progress by date
  737. displaying contents of a user defined directory
  738. Validation list to a Range?
  739. Custom Menu Bar
  740. C# RTD Server
  741. XML Files
  742. RE: xlCellTypeVisible - not working?
  743. RE: xlCellTypeVisible - not working?
  744. Locking cells with a checkbox using a macro.
  745. Double-Click on cell
  746. Passing formula value to variable, hide rows
  747. Excel crashes on simple procedure
  748. Create Named Range in VBA
  749. Wildcard search for string within a string?
  750. Referring to a worsheet in another workbook
  751. Application.Calculation = xlCalculationManual fails
  752. macro for copying a range to a column of cells
  753. Macro delimiting text if column has value
  754. Re: xlCellTypeVisible - not working?
  755. Input Box Size
  756. Complex SUMIF statement
  757. Macro that deletes certain rows only
  758. I hope not a dumb question.....
  759. Retrieve all Outlook calendar appoinments for a day
  760. Active Workbook
  761. Copy Formula Instead of Value
  762. Passing File Name To Macro
  763. Workbooks.Opentext - oldskool '97
  764. Selecting a sub range?
  765. Hello I am trying to write an If/Then statement. Here is the data.
  766. using row autofit but with minimum height
  767. Copy text from Excel to Word
  768. variant to integer format?
  769. Using Pivot Table to analyze multiple variables in satisfaction survey
  770. Count displayed rows
  771. Form Question
  772. Copy formula to a column of cells
  773. Compile error screwing with me
  774. after save event/procedure
  775. how will i create a formula that will copy the content
  776. 2 Questions 1 about Macro, 1 about VLookup
  777. Indirect reference to run macro in another workbook?
  778. Macro If And
  779. Conditional Copy Macro Help Needed
  780. Page x of y
  781. Check For Add-in
  782. MailEnvelope
  783. 2007 Bug? ChartTitle.Characters.Text not working
  784. Newbie Question on Setting Cell Value in Sheet2
  785. Set Cell Value
  786. Disable drag and drop and cut and paste
  787. extrapolate range coordinates
  788. Auto Hide Task Bar
  789. remove autofilter from some columns
  790. Convert EXCEL to TEXT FIle
  791. Round Robin Tournament Generator
  792. where do I find docs on excel automation programming?
  793. Download from FTP
  794. Newbie Questions 02
  795. Creating WBooks
  796. HELP... AUTOSUM........Add(msoControlButton, 226)
  797. 'extra' file in VBE project- can't delete it? XL2003
  798. Detecting key presses
  799. Pivot Table heading case sensitivity
  800. Last Used Row
  801. Embed a Userform into an Excel document
  802. CommandButton Question
  803. DTPicker to be dropped down on initialisation
  804. string parsing w/wildcard problem
  805. is it possible to automatically change the color of the bar chart as soon as it reach
  806. Select a sheet by name in a macro
  807. Delete row problem, could some help me on that?
  808. Two links changed on my site
  809. SendMail Error Trapping
  810. Array from row in worksheet
  811. transpose data from horizontal to vertical in a specific column
  812. Counter variable in For Loop
  813. SUMPRODUCT
  814. Macro If and...
  815. Excel PivotFields/Items
  816. Getting a hook on Toolbar Events
  817. vba check for disabled macros
  818. Finding duplicate values b/w two columes
  819. Path/File access error
  820. Selecting Blank Cells
  821. copy rows based on specific field value
  822. External Reference - Filename Change
  823. Change background color
  824. Set Path for GetSaveAsFilename
  825. Copy and Paste Visible Cells
  826. Solver error
  827. Arranging VBA windows
  828. New to Programming
  829. Newbie add-in questions
  830. A macro that shows updates - PLEASE HELP!
  831. runtime error -429
  832. Inserting new worksheet
  833. Date Format in Userform
  834. Run procedure when value changes
  835. Count number of cells that are highlighted
  836. compare cell formats
  837. CSng adds erroneous digits to the value
  838. Why is this a Type Mismatch error?
  839. Calling a private macro
  840. Newbie question
  841. inserting formula
  842. Can you count a certain color cell?
  843. To delete certain data in excel. eg contains #DIV/0?
  844. Autofilter dropdowns
  845. getting size or setting it?
  846. How to read the Amount and MinusValues of ErrorBars in a series
  847. Printing pages from different sheets in a set order
  848. how to create macro that will display the sub_subfolder
  849. Dynamic Range
  850. Could not sort the first row ??
  851. VBA vs VB.net
  852. custom button to copy a few cells and paste on somwhere else
  853. Flashing Curser
  854. Make a loop to Find a value then move a row of cells
  855. Change the Formatting of All Instances of a word in a worksheet in Excel
  856. Selecting values from a list to add up to a specific quantity
  857. Auto message box
  858. Ignoring Certain Characters In a Cell Using VBA
  859. moving cells to another column based on number of characters
  860. Sort out data with VBA
  861. Changing Value of Cells
  862. Is Excel is now going out of it's way to mess me around?
  863. Create summary WB
  864. Tricky data type error
  865. Validation Drop Down Box
  866. integrating row number in a formula
  867. Need a Matrix diagram - Please help
  868. copy and paste (visual basic)
  869. Read zip file on disc
  870. linking workbooks - expert advice needed!
  871. Determining Whether File Exists
  872. Confused about assigning DIM and such
  873. Dynamically refreshing Pivot Table Range.
  874. is it possible that the data values shown on the data labels be in a duifferent range
  875. Modify database
  876. speed of processing
  877. Array usage
  878. error handling
  879. calculate all possible combination from 10 variables
  880. Help!!!!!! - Find Function not working from C#
  881. End of Spreadsheet
  882. Pulling my hair out
  883. Inserting Values in a Multidimensional Array from Two Different Controls
  884. Macro to Create Sheet & Duplicate Sheet
  885. Converting a formula to its value
  886. Importing/deleting .bas files (a lot)? Repost
  887. how do i enable user logins
  888. Workbook Open not triggering
  889. The Ultimate Problem
  890. Form placement on spreadsheet
  891. Open excel at a set time
  892. Linking Tab Names to a single cell with a worksheet
  893. What is The ORng value after this code is run?
  894. Dim
  895. Range.Value2 is failing for lenghty strings
  896. Dynamic multidimensional arrays
  897. RE: Dynamic multidimensional arrays
  898. code failure
  899. Assign cell value to variable
  900. Find
  901. -2147221080 800401a8 Automation error
  902. RE: Dynamic multidimensional arrays
  903. Microsoft.Office.Tools reference
  904. RE: Find
  905. RE: Find
  906. two lists of numbers
  907. problem to access sheet from add-in
  908. work with invisible sheet
  909. Font of ListBox
  910. Logical operator inconsistency
  911. open workbooks to extract info into one
  912. Populating Cells using VBA
  913. RE: Running the second part of a macro only on Thursdays?
  914. Add Formula SumIf Relative Range D = A*
  915. save and replace
  916. Re: Have 2 Macros run in a specific order...Can This Be Done
  917. Duplicate all Macros?
  918. Have 2 Macros run in a specific order...Can This Be Done
  919. Variable Filename calls
  920. Disappearing Callouts
  921. Running the second part of a macro only on Thursdays?
  922. Runtimem Error 9 Subscript Out of Range
  923. Path/File access error (Error 75)
  924. Parsing a string
  925. Table Update
  926. Before Print - one worksheet only
  927. Refreshing Imports
  928. Changing font color in email
  929. Selecting many Checkboxes to align & size
  930. Data Entry and Display problem
  931. VB Macro to Automate a Search/Replace
  932. for next loops>> basic information
  933. Updating a cell that uses a .NET add-in function
  934. Won't Add Multicolumn Data
  935. Macro to insert lines
  936. Resize Print Area/Pages Macro
  937. RTD value changes not triggering worksheet change event
  938. Changing subject line in email
  939. Does library reference stay with the code?
  940. pull down menu in validation cell
  941. Seach & Replace Macro
  942. Chart Name
  943. Listbox Column Count and Width Dont work. Seems Easy
  944. E-mailing in Excel
  945. Excel VBA
  946. Hide rows with macro
  947. Save column J only using copy/paste & temporary copy
  948. Through a command button hiding rows
  949. Search Spreadsheet - Results in either listbox or new spreadsheet
  950. Why doesn't working? Application-defined or object-defined error
  951. Opening an Access Database and running procedure Via Excel VBA
  952. Exporting data to another spreadsheet
  953. Update E-Mail Data Base
  954. Using solver while disabling auto calculation
  955. Renamed ranges - PART 2
  956. Excel 2003 Performance/Status Bar Quest
  957. Challenging?
  958. macros
  959. Trouver la ligne et colonne sur laquelle se trouve un checkbox
  960. printing selected sheets
  961. Getting Word to work with Excel
  962. Getting Word to work with Excel
  963. Insert Diagram
  964. Macro to open search box?
  965. Excel 2003 vs 2000 VBA Compatibilty
  966. Excel workbooks , internet links
  967. Hide all Sheets
  968. option buttons
  969. Relative addressing with INDIRECT function
  970. Print 2 pages per sheet
  971. RTD feeds into excel not trigering a worksheet change macro
  972. Can this be done?
  973. Command Buttons on Excel Worksheet - font size decreases on click
  974. Excel "price-stop" formula
  975. Calling a sub method
  976. cell copying?
  977. how to log all excel files opened on my pc?
  978. emailing info
  979. Progress Bar Control
  980. Re: Shouldnt this work?
  981. Re: Shouldnt this work?
  982. sum format
  983. Ref. problem after sheet import
  984. submiting from form to sheet
  985. path xml mapping
  986. Excel - Polish version - SUBTOTAL
  987. Function runs more than once
  988. disable range selection
  989. Including an inputbox within a macro
  990. Match and find entry
  991. Insert Formatted Row at specific point within Dynamic Range
  992. Using DTPicker to change date in a cell when user selects cell?
  993. How do retrieve data from anotyher excel file...Pls Help..Urgent!!
  994. Pie chart slices too thin
  995. List of Folders
  996. MFC - CopyFromRecordset - Copy data to Excel
  997. Populating Lists in forms
  998. copy several cells if one cell is set
  999. Lookup or Index or Match, not sure.
  1000. copy several cells if one cell is set