PDA

View Full Version : Microsoft 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 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. FileSystemObject does not work on SharePoint
  2. Sorting a worksheet with weird conditions
  3. For..Next Problem
  4. Sorting data
  5. ActiveX Contro
  6. open workbook for sharing
  7. Need a way-probably a macro for sending e-mails
  8. Macro formula for counting rows
  9. Application.Run and pass variables to Sub
  10. ReferesTo
  11. Counting numbers
  12. Multiple XMLMaps export to single document
  13. Turn off a filter before running a macro
  14. Status bar showing sum and count
  15. Excel template and default save name
  16. constrain the no of sub procedure executions per second
  17. Update - 4 - Re: Parsing, mid, left, trim or right to find specific word in string
  18. Charts -- drawing arrows to points
  19. Application.Inputbox question
  20. What is the difference in declaring a Collection in these Procedur
  21. RE: Save Fail on Excel Close
  22. is it the fault of the macros or what
  23. conditional formatting 1004 errors
  24. file owner properties
  25. Macro to insert data behind a certain date.
  26. feedback on charts advisor in excel 2007
  27. Forms help
  28. Data validation list drop-down values based on prior selections
  29. permission denied error when automating explorer
  30. Trying to insert rows in a Macro
  31. pulling data and autofilling fields
  32. japanises letters
  33. That's it. I've had enough!!!!
  34. combine two formula in one cell
  35. Calculating Age (in days) with multiple date formats (including ti
  36. turn multiple vlookups into one macro
  37. how can i move a scanned document from word to excel
  38. Is there anyway to find out which cell is being calculated?
  39. Add body message to auto-email code in Outlook
  40. Worksheet Activate event not firing
  41. Missing Expand All
  42. auto enable macros
  43. macro to add row in same worksheet based on 2 fields not having a
  44. Now Formula
  45. Excel formula in VBA
  46. Change cell after macro
  47. Check box
  48. Copy Excel chart to PPT that is already open
  49. Excel Table of Contents
  50. Copy and populate a worksheet when a new data line is added on ano
  51. VB code to run a Query in Access and paste results onto an Excelworksheet
  52. Printing Control
  53. general formatting
  54. function to re-calculate when cell format (colour) changes
  55. set toggleButtons to "pressed" by default
  56. Copy conditional format using formula to entire worksheet
  57. Help with Filter and FilterOn
  58. free text in combo box
  59. Macro Protection
  60. changing colours on chart series
  61. Weird Macro Behavior
  62. PasteSpecial fails
  63. Listbox Time Formatting
  64. Need Excel Macro
  65. Setting all the Chart Colours in VBA and also font sizes
  66. Macros...
  67. Hide Rows based on value of a cell
  68. system.Runtime.InteropServices.COMException (0x80020005): Typemism
  69. Trap Mouse Move event for Images inside the shape or Image control
  70. if fuction in data validation
  71. Two dinamic graphs in a worksheet
  72. How can I covert Indian Rupees to Word in excel 2007
  73. Sub to open n close .xls files in folders
  74. Renaming worksheets taking REALLY long... any ideas?
  75. Dialog box for Inserting Rows
  76. Capture an event for hyperlink is Excel
  77. Shapes Fill
  78. Change SourceData with ScrollBar for SheetChart Type xlColumnClust
  79. copy method of range object
  80. Creating a ratings spreadsheet?
  81. Macro to insert row in protected sheet
  82. range referencing
  83. Very Unusual Sort Rows Needed
  84. MACRO - INSERT ROW
  85. recalculating RAND() inside a VBA loop
  86. Macro fails on 1 out of 4 computers
  87. How can I seperate Imported text with delimeter as part of the par
  88. determine current theme in xl2007
  89. Bolding a Cell under certain conditions
  90. Premium Solver Macro Problem
  91. Numbers in combo box
  92. Re: Columnwidth in cm?
  93. filling a table depending on column heading
  94. Fill/Copy Up to fill blank cells.
  95. Is Sumproduct best for me?
  96. index and names of open workbooks
  97. Null value in excel
  98. Cell Reference
  99. More efficient code than this?
  100. How can I get Memory used by Current Excel Application?
  101. Automatically increment cell reference
  102. Get smaller range from within another range using VBA
  103. Excel 2007 Named Range - Naming convention
  104. Changing rows
  105. New to VBA
  106. Working with Excel via Visual Studio 2008
  107. disable macros in a worksheet
  108. Problems with ChangeLink Command in Excel 2003
  109. Excel 2007 - Workbook.Open Question
  110. Working with Excel via Visual Studio 2008
  111. Tick Quandry
  112. Fine Tuning
  113. Copy from Internet Explorer & Paste in Excel
  114. runtime error 13
  115. Export to Excel with different sheet names
  116. problems with calendar control
  117. RE: Excel VBA drawing Arcs programmatically - not lining up!
  118. need mulitple lines in a cell
  119. RE: Columnwidth in cm?
  120. Are links relative?
  121. add 1 to the value in a cell
  122. enter check mark with one click
  123. Up and then down VB code
  124. Object Library References Question
  125. Excel 2007 Add-ins
  126. I need help creating a macro
  127. Program to insert pictures
  128. Need to you quotations ("") in a string.
  129. Method 'Range' fails while using AllowEditRanges
  130. FileSearch on a remote server
  131. Tiny Charts
  132. Event Change code
  133. userform question on UserForm_Click()
  134. Problem copying formulas using VB
  135. Hi, i need help whit macros
  136. Lotus Notes VB code (yes, it works)
  137. Batch Delete VB code
  138. loop though numbers
  139. Problem when copying a range from closed workbooks (ADO)
  140. Calling a function within a macro
  141. Userform is blank
  142. Macro output as Text
  143. Inserting Comments with VBA
  144. error 13 when setting worksheet listbox
  145. Keyboard shortcut values displayed on custom ribbon
  146. data validation (multiple options)
  147. macro needed for saving
  148. excel macro to copy the word document to new excel workbook
  149. How to run Excel Macro on all files in folder
  150. goto next if
  151. .Refresh BackgroundQuery:=False
  152. List Box Select All Values
  153. delete unused rows
  154. Modifying a LARGE text file
  155. Standard numbering
  156. Excel as a data source for Outlook to email Word docs
  157. Why is my UserForm event procedure disapeared?
  158. Knowing what Folder I'm in when I open from a shortcut
  159. Required Columner Data
  160. Date Diff Help
  161. EOF Parse Text file
  162. finding the next empty column
  163. average of column
  164. Count number of like occurences across all worksheet within workbo
  165. VBA Newbie
  166. Workbook closing
  167. Header horizontal margin seems fixed, won't move
  168. Make sure all items in a Collection equal the same thing
  169. images for user form
  170. How can I locate image code in a worksheet object
  171. UDF or SUMPRODUCT with 51 named ranges?
  172. Determine if particular procedure(s) exist in module
  173. CustomProperties
  174. Using VB to change a defined formula within a pivottable
  175. Parsing, mid, left, trim or right to find specific word in string
  176. Exposed Workseet names
  177. Move downloaded bank transaction to a specific worksheet in same workbook
  178. Custom View Macro for Excel 2007
  179. Variable equal to values in a list
  180. Variable Address in Pivot Table VBA code
  181. Disabling Function Results in the Function Arguments Window
  182. Copying an entire sheet from 2007 to 2003
  183. UNABLE TO IMPORT A TEXT FILE HAVING 30 COLUMNS. LOADS ONLY TILL 26column.
  184. Application on my desktop
  185. Excel VB ListBox 'Height' Problem
  186. relative path
  187. Excel import data from old accounting systems
  188. Named Identity
  189. Using Form Buttons / Objects
  190. Link source - Need change?
  191. Record Comparison Between Two Databases
  192. Output file to My Documents
  193. Prevent SaveAs on Protected Sheet
  194. Macro is choosing by tab name?
  195. Macro (Modle) naming insight
  196. Problem with "Call was rejected by callee."
  197. Run-time error '1004', the macro xxx cannot be found.
  198. looping down 1 column then start agian at the top of the next column?
  199. Checking for duplicates
  200. ISERROR
  201. Changing the "From" field in Outlook using Excel macro
  202. Convert Range to Array
  203. Prorgram doesn't work on different computer
  204. End loop
  205. Hiding rows
  206. Window Caption
  207. Cancel Toolbar load
  208. Delete rows based on more than one condition.
  209. FileSearch in Office 2007 generates an error?
  210. Deleting a Worksheet??
  211. Quotation marks in a string
  212. How to copy data from merged cells to their individual cells?
  213. doesn't read all data from cells into xml file
  214. VBA Vlookup
  215. PivotField CurrentPage Change Event
  216. freeze or lock rows when using Auto filters
  217. Userform - placing
  218. Using IF to decide action
  219. Autoname a range
  220. Color sorting
  221. Autofilter-sorting from specified cell
  222. How do I create an organization chart in excel
  223. Common set of macros
  224. How to use SUMPRODUCT or SUMIF with 2 criteria?
  225. Macro to copy active worksheet from multiple Excel files into 1 fi
  226. Relative Path in Excel to a word document
  227. Pulling data from mySQL DB to Excel spreadsheet
  228. User form bug
  229. Search Form
  230. Launching PowerPoint from an Excel application
  231. Write filepath to file
  232. Problem with Naming Cells
  233. Find variable in a sheet
  234. Command Bar Excel 2007
  235. EDATE & #NA Errors
  236. Music files
  237. Tags for worksheets
  238. finding numbers
  239. use only part of window name in a macro
  240. mousepointer
  241. Can you use offset and empty in the same code
  242. Can you hide and unhide rows with a macro based on content of colu
  243. little mistery..
  244. Simplify Code help
  245. Importing to Excel 2003 - Code from Jean-Yves
  246. Add two cells if one cell is greater than 0
  247. Surpressing a Message
  248. Multiple ADO queries at the same time
  249. idiosyncracies of user form
  250. Changing printer defaults in Excel Worksheets
  251. Need code assistance to update pivot table from an ADO recordset
  252. Regional Language
  253. Re: Mail with "Lotus Notes"?
  254. Web Queries : Passing variables via POST method not working
  255. Converting xlsx to xl
  256. How to obscure functionality
  257. Help!!! Database lookup from excel
  258. VBAProjects still open for workbooks closed in Excel 2007
  259. Re: Using Variables in ActiveCell.Formula
  260. Re: Using Variables in ActiveCell.Formula
  261. help required to change format when converted from excel to xml.
  262. RE: Mail with "Lotus Notes"?
  263. Auto Filter
  264. excel macro to copy the outlook mail body to a new excel workbook
  265. Macro to delete on condition
  266. Excel 2007 - Textbox Formatting
  267. Offsetting to identify value in header row
  268. Assigning value to text
  269. User defined range for vlookup w/ loop
  270. Inserting a blank line
  271. Fill series event detection
  272. and + or
  273. XML export form a Excel
  274. Open Workbook Empty?
  275. code instead of functions
  276. For Next If help
  277. howto: disable date recognition?
  278. Image Control Question
  279. Force Save Folder Location on Network
  280. File closes without prompt to save!!!
  281. using an excel database function in Visual Basic
  282. Open a workbook from a written path
  283. Selection
  284. Select locked/unlocked cells
  285. 32000 chart limit warning
  286. Wildcard use in comparason.. Please help
  287. delay in msdos batch file
  288. Using 2 cells in the same row within a form
  289. multi threading
  290. Writing Data to cells
  291. Re Excel 2007 Trend Equations
  292. why do I have to have the table files.xls open in memory to query
  293. putting criteria directly into a database query, dsum, daverage, e
  294. Excel 2007 Shell Command Runtime Error HELP
  295. a way to make this more compact ??
  296. standby for parts of code
  297. Creating an AutoNumber ID as a primary key
  298. Data validation list limit
  299. Search and Replace Problem
  300. Can't Unhide Complete Workbook after adding code to hide it
  301. take fields from form to report
  302. How do I pass a value from an event back to my VBA Programming enviornment.
  303. relative reference between two tabs
  304. Setting Up a Dynamic Print Range
  305. Trying to Mimic an Array Function in VBA
  306. Print selection using check boxes
  307. Macro to create different groups
  308. End without Next Error
  309. use different string variables in FOR loop
  310. Position a user form next to selected cell
  311. Find and Replace Help
  312. Inserting a value based on another value
  313. Find and Replace Question
  314. relatetive reference-to perform a series of cal and return result
  315. keep last row added visible on the screen
  316. find a value in another sheet
  317. Get value from one row to another
  318. Accelerator keys
  319. How Can Make equation With IF X>Y>z
  320. Changing BackColor of ToggleButton produces a muddy grey color
  321. File path extracted to the cell in lowercase and sometimes it does
  322. Convert numbers to HEX
  323. find by font size
  324. Fails then continues without error
  325. Redraw problem
  326. Hide rows of active selection
  327. Macros using drop downs
  328. Plotting a number of single point series on a scatter graph
  329. output unique records to a dynamic range
  330. Format Textbox on an user input form
  331. Re: Looking for Input
  332. Max patient census by day by hr
  333. Adding selected numbers
  334. Select Case
  335. Macro
  336. using vlookup in a loop
  337. Filtering A CSV file during the import
  338. can you specify a worksheet during file open in excel?
  339. WorkSheet Change Event - Need Help With Coding Syntax
  340. simulate pressing CTRL and A
  341. PasteSpecial between workbooks
  342. Listbox with available procedures
  343. Need to Add Text to Control Text Box via Command Button code
  344. Permission denied code 70 on killfile
  345. copy to clipboard
  346. RefEdit
  347. Set print area based on last row with a given value
  348. Find text Sequentially Number
  349. When do AddIns load?
  350. Sum and Rank
  351. Excel macro Cc distribution list control
  352. How do I create a .bat file to create a shortcut on the desktop?
  353. Input on a user form
  354. Macro takes a while to run - should I be concerned?
  355. Final Days 2008 East Coast U S Excel User Conference
  356. Run a Stored Procedure from Excel
  357. Are there any other way to run the vba code than...
  358. Reading Data from an Excel Sheet
  359. Protecting an Excel worksheet from being renamed
  360. Long Shot !!
  361. Re: Delete Workbooks
  362. Get a Date to show as a Date Format in Combo Box
  363. Macro to create charts - Points to wrong sheet
  364. VBA unable to recognize code after reinstallation of MS Office
  365. Pictures.Insert not working in Excel 2007
  366. Clear selection in CSV-file
  367. Software copy Protection
  368. Calling a public function from a worksheet
  369. Setting an array of text boxes equal to individual form text boxes
  370. [Microsoft][ODBC Driver Manager] error
  371. Can I use the address function as an argument in another function?
  372. Complex Count
  373. Cell justifcation
  374. Cell to display certain if an entry is provided
  375. "Move Several Cols Down One Row"
  376. Macro to execute at a set time, pull data off of a web page, and e
  377. Need help with formula to count currency of personnel between 2 da
  378. at excel start need macro to remove autofilter & apply sort mult t
  379. Merge Worksheets w/Comments & Hyperlinks
  380. multi-line controltiptext
  381. first user form.....
  382. Custom Icon
  383. Over-ride protection for one user - doable???
  384. How to make a custom function to work in another workbook
  385. ControlTipText
  386. Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions
  387. Newbie Needs Help.
  388. User Form - use of single form for multiple sheets
  389. Strange problem when running macro from PPT'07 copying ranges from
  390. Autofilter, protected worksheets, Debra Dalgleish's code
  391. Calculations
  392. Conditional format based on adjacent cell value
  393. Retrieving Part of a Cell Contents
  394. auto copying Excel spreadsheets
  395. Compare List A to List B, Return List B Items Not in List A
  396. Array vs. Collection
  397. Find Worksheet code names from PowerPoint 2007
  398. Trying to concatenate based on font color
  399. Linking Cell Data to Text Boxes on a Form
  400. Control scrolling in a TextBox
  401. Single hotkey to do a date time stamp into a cell... and then type
  402. create spreadsheet where all changes can be stored
  403. Cannot pass argument from control to sub and back
  404. Compare columns - weird baffling problem
  405. Print Worksheet by Page Number
  406. xlApp.Quit - Doesn't Close Instance.... Any ideas?
  407. Multiscaling the same graph
  408. Looping through multiple sheets and pasting data in first blank ro
  409. Excel 2007 - Legend.Position
  410. Pick data from web page (no query)
  411. macro to open the mail and copy the data to excel
  412. find text within string and then delete
  413. Link to a sharepoint list
  414. Saving a workbook using VBA
  415. Inserting getpivotdata formula using vba macro
  416. Trapping invalid dates
  417. Macro for Tab Changes
  418. stuck in loop
  419. Conditional Formatting Issue
  420. Hide Rows
  421. Time stamp with undo funktion
  422. ComboBox Queries
  423. Advice Sought
  424. Code to add attachment
  425. Select range
  426. Help with Debug issue
  427. Count number of times macro was executed
  428. test dbl click 'target' is part of named range
  429. some simple (?) simulation
  430. validation
  431. How to creat custom made error message in separate window
  432. lock a cell from users but not macros
  433. Worksheet change time format
  434. VBA code to select a cell so it appears in the top left of the screen
  435. Macro "out of Memory"
  436. RE: Delete Workbooks
  437. Create Multiple Filter and graph data
  438. Unprotect Cells When Radio Button Selected
  439. Filesearch .LookIn fixated on MyDocuments
  440. Excel 2007 File Slow Response
  441. Call a procedure using a variable
  442. Combine 2 Codes into 1 Code to do the lot?
  443. strange formula array issue
  444. I would like to block access to my VBA coding
  445. Excel chart data in Power Point
  446. Clearing contents from a range
  447. worksheet template
  448. drawing text on a worksheet
  449. VSTO 2003 deployment problem
  450. Compare two spreadsheets
  451. Macro Help Please
  452. Index # of selected embedded chart
  453. Macro doesn't work when Sheets are protected UserInterfaceOnly
  454. Setting cell colors using RGB( ) function
  455. using best approach for activecell property
  456. Application.Quit Does not Close the Application
  457. Changing The "Printing Sheets Per Page" In VBA?
  458. How to return query with out headers
  459. Re: Drop down list
  460. use information from an input box in cell reference formula
  461. Scroll bars and how to print
  462. Again, for Excel 2007, Clipboard image saving issues
  463. Using a Range variable to call a procedure with a ByVal statement...
  464. Macro to find and copy to another sheet
  465. using OFFSET to fine DUPLICATES in a list
  466. call Excel subroutine from Sql Server?
  467. Hyperlinks and Comments
  468. Set Priority for Conditional Formatting in Excel 2003
  469. Excel 2007 pivot tables - calculated fields and SSAS cube
  470. Programmatically copying range in design mode
  471. Scrolling
  472. Need to change the following code
  473. Error using Union in a Loop
  474. Worksheet_Change event not running from Form control.
  475. using loop in ontime
  476. PlotArea.Left Question
  477. command button not working
  478. Excel References Not Release When IDTExtensibility2 Used
  479. Macros assigned to Menu Items
  480. RE: Please add a "Paste Value" Command to this macro.
  481. User-defined functions not calculating/recalculating
  482. User-defined functions not calculating/recalculating
  483. User-defined functions not calculating/recalculating
  484. AutoFilter
  485. Use number in text box to look up value in a workbook sheet
  486. Browse for folder - not selecting folder
  487. goto next line
  488. Import data from web page into excel
  489. macro to save the file as per the path selected
  490. How to open correct Module window in VBE by macro
  491. Code to open multiple files from within a folder
  492. copy data to one file from all files
  493. Opening OLEOBJECT
  494. A problem with HPageBreaks
  495. VBA to create directories based on 'date picture taken'
  496. Listboxes Without User Form
  497. Array as defined list in sheet 'Temp'..
  498. Re: Dynamic Array Problem
  499. List all applications running
  500. Excel Programming
  501. Clipboard images to Bitmap files through VBA in Excel
  502. click image in web
  503. Creating a que
  504. Accessing The Value Of A Merged Cell
  505. newbie
  506. Excel 2007 macro problem in editing a cell
  507. Re: Drop down list
  508. creating multiple pivots fails
  509. Script out of range
  510. validate entry via messagebox
  511. Copy as Picture takes up to 5 seconds to copy
  512. Automatic Update links to web query
  513. Code to close many open workbooks
  514. Is it possible with a macro??
  515. VB Code to hide rows
  516. format issues
  517. Combine 2 Ranges as One and copy to another worksheet
  518. Create two pulldowns from another pulldown.
  519. Macro Help....
  520. Insert Macro into Excel Workbook using C# code
  521. Compile Error: Can't Find Project or Library
  522. Loop Macro
  523. how to disable Office alerts...
  524. Time to Unhide an Entire Column
  525. Checking Outlook Email Address
  526. How to catch events from an outlook mailitem object from an Excelmacro
  527. go to child window
  528. Scroll
  529. Classic PivotTable Layout
  530. linking worksheets
  531. Lock
  532. Format Page setup for multiple worksheet in a workbook
  533. vlookup sub procedure help
  534. Lists
  535. Using VBA to Print duplex (two sided)
  536. Basic VBA questions....
  537. code to parse a multi-colum multi-select listbox
  538. Error trying to write array to range
  539. MAXA won't work with VLOOKUP?
  540. Sort Range by Font Color
  541. Excel 2007 VBA speed update
  542. Problems in macros after chaning Operating system to Windows XP
  543. Hiding Tabs
  544. Change VBE Settings
  545. RE: loop whole sub
  546. how to execute a stored procedure in SQL server from Excel 2007?
  547. VBA Converter
  548. can excel simulate three dimensional spreadsheets
  549. Error after code is run
  550. Winzip and email multiple files (RondeBriuins code not working)
  551. Modifying Ron's Sub Copy_To_Workbooks
  552. Change refedit control image
  553. Problem with RefEdit Control in VBA
  554. Re: LoadPicture(FileName) with size?
  555. pivot table
  556. Searching for non null cells
  557. count cells in range
  558. Help with code to run macros from hyperlinks
  559. suppress Workbook_Open event
  560. application-defined or object defined error
  561. Macros and hidden worksheets
  562. Add a Image to sheet attached in Ron Debruin's email attachment code
  563. Extract a single file from a Compressed Folder (Zip file)
  564. Combo Box Data Validation - First Entry Blank
  565. Formula to sum up customers totals from other sheets
  566. VBYesNoCancel Modify the YES and No Text
  567. Last Save date/time and User for a specific sheet in a shared work
  568. Check if text box has more than one entry seperated by a comma
  569. Using Data Validation to Filter Lists
  570. Copy Paste Macro not Pasting Values when Blank
  571. Blank Cells
  572. I want to create lists from web pages
  573. #VALUE
  574. Excel rejects XSD from Visual Studio DataSet Designer.
  575. Read of excel spreadsheet with ADO recordset
  576. Putting a default nam e in a SAVE AS dialog box
  577. VSB more efficient then standard functions?
  578. Re: Edit Comment from UserForm
  579. Copy Paste from Class Sheet to Filtered List on Combined Sheet
  580. How can I make a cell to flash?
  581. click LINK
  582. "Counter" in macro
  583. Programming Invoices for Reports
  584. Can you tell me the Print options for ExecuteExcel4Macro?
  585. Share workbook update changes setting
  586. filter the data and paste in another workbook
  587. RE: Update sheet one if data is not present.
  588. Excel 2007 / application.filesearch no longer works
  589. limiting text entry into columns
  590. Delete rows based on text value in a range
  591. Run Procedure when The Value of A Cell Changes
  592. Excel 2007 losing cell validation
  593. Disable all Control Events on a Userform when it is Intialized
  594. Can I detect if user has Excel 2007 and display different pages?
  595. Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003
  596. controlformat.enabled failed in excel macro
  597. Filename in Macro
  598. pivot table; adding kolomns to the base-table afterwards
  599. Logic
  600. Select Coloumn Range based on cell value
  601. Refering to Codenames in Remote Workbooks
  602. Code in 2003 not working in 2007
  603. Transition Formula Entry and Copy of Values
  604. New Web Query, from very long URL
  605. Multi-column Dropdown combox on a commandbar
  606. How to move AutoCorrect entries between computers in Word 2007
  607. Macro Help
  608. simple vb question
  609. Copy all data into one sheet and insert origin data... code amend...
  610. Suggestion for improving the execution time
  611. Input Box w/Drop Down List
  612. Match Value in Range and Then Paste
  613. Protect / Unprotect Sheet in Share Workbook Excel
  614. How to Zip then emai 4 files please
  615. Count Different Values in a column
  616. Hyperlinks
  617. Removing text before and after word in cell
  618. Determine File Filter Selected
  619. Save As window with vba
  620. Static variable
  621. If/And formula showing true/false instead of cell value
  622. How to avoid arrey formula?
  623. Replace password with *** in input box, xlVeryHidden
  624. Auto_Open and global variable
  625. HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED
  626. Change the background color of cells once it being edited
  627. Forms Buttons on Sheet Frozen
  628. Word to Excel
  629. Prompt to Unprotect Single Worksheet
  630. ftp paths defined in variables are persisting. How to clear?(vba)
  631. Popup Window Containing Image
  632. Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet
  633. Manual Page Breaks in VBA
  634. Creating an automatic log of filenames copied to flashdrive?
  635. Select worksheet using a variable
  636. Find Value and Move Rows to another Sheet
  637. Create a vbCheckbox from code in vb command button
  638. complex column addition
  639. Accessing a Stored Procedure
  640. file size increases drmatically
  641. Subscript out of range
  642. excel instance stays open
  643. Compare several cells in row & output value for match
  644. RE: Multipage Name
  645. VBA dates versus Excel dates
  646. Control Zoom for Print Preview
  647. String variable name is incorrectly used literally
  648. CONSOLIDATION OF TEXT FILES. DATA FROM VARIOUS COLUMNS.
  649. Re: Multipage Name
  650. Loop to insert data from a form - Help
  651. Vba - Access Setup Question
  652. Help with paths
  653. Color gradient
  654. Remove the $ from a cell reference
  655. Help with Array & Split
  656. Making a spreadsheet lock up after a demo period expires
  657. worksheetfunction.match
  658. Merge a range from all workbooks in a folder with AutoFilter(RDB)
  659. Suggestions for creating a demo spreadsheet that locks up after atrial
  660. Mail Merge in Excel
  661. Search Columns and return multiple rows.
  662. Calculating a cell
  663. managing time
  664. Picture property
  665. Solver Error with Function "EXP"
  666. How hold multiple versions of the same range?
  667. (no subject)
  668. Comparing lists in 2 workbooks and copying missing rows into new W
  669. vlookup in vb
  670. Database password
  671. Phantom workbooks in VBE in Excel 2007
  672. identify specific word in a range of words
  673. Create Folder Variable
  674. hyperlink - colors and macro question
  675. Book about using VBA to run SQL queries with results put in Excel
  676. Data Validation error
  677. Getting data from a spreadsheet without opening?
  678. How to zip an active workbook
  679. Find Posts?
  680. HELP PLEASE Any one Know how
  681. help creating a marco please
  682. Mail Merge from Excel
  683. Save worksheet after printed
  684. Help creating a macro please
  685. Macro help (not the sharpest tool in the shed)
  686. UNIVERSAL PROBLEM - Fixing Missing Office References Programatical
  687. Merging two cells within the same table
  688. Clearing Hyperlink formating from undefined # of cells in a column
  689. Add a row with data
  690. Pivot Table
  691. "Most recently used" list missing from File menu and "Recently usedfile list" option unavailable
  692. Data Validation, Drop Down Lists
  693. This sub runs to a function in a Module. Why?
  694. Strange Background
  695. Very Slow reading excel data into an array (while opened in new xl
  696. Annotating charts with text from within VBA
  697. Filtering Data
  698. Macro for recurring formula; max of set of cells
  699. Design Selecting Controls
  700. sorting in a macro and defining last row into varible not working in
  701. how do i export excel data directly to my outlook agenda?
  702. Help adding a label to Total line
  703. Unselect option buttons
  704. Need Code To Run Always
  705. HelpContextID on a single field
  706. creating custom menus
  707. Help with annoying VBA editor behavior
  708. Protecting conditional formats
  709. Excel Instance Hanging Around
  710. Protect VBA Project By Macro
  711. format table
  712. REMOVING DATA BASED ON OTHER CELL INFORMATION
  713. Chart with a defined named range?
  714. REMOVING DATA BASED ON OTHER CELL INFORMATION
  715. Change the value of particular cells in a Named Range
  716. SetFocus in a custom dialog
  717. last date saved in excel
  718. those little "moving lines"
  719. finding control
  720. Prevent users from saving if cells are blank
  721. Event procedure or ............
  722. combo boxes again
  723. How to Determine group of numbers best fit into 1 number
  724. Import XML Problem
  725. Display Excel Data as a Calendar
  726. XML Importing Problem
  727. Update a specific worksheet
  728. Insert a symbol using VBA
  729. Using Form Combobox in VBA Excel
  730. Very basic question, please
  731. Help....
  732. Numeric representation of curve/distribution for resource forecasting
  733. Data Validation Error
  734. Change Cursor Image if Workbook is not the Active Window
  735. If - Then Code Help needed
  736. Sumproduct with A1 notation instead of R1C1
  737. Exiting a workbook
  738. Dynamic list based on sheet names
  739. Help! Cannot calculate 123 * 456
  740. Parse a txt file and save as csv?
  741. Filtering VBA
  742. Help with "floating pop up menus" (if that is correct)
  743. How do I decrease the value of a column by 10%
  744. Re: Limiting number of characters in textbox
  745. Formatted Date in header applied with a macro
  746. Need help with hyperlink character limit
  747. Help with Macro
  748. Calling Excel methods from a different thread (COM add-in)
  749. Scripting Error
  750. **URGENT** Macro to find a Cell