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