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. List Box
  2. Formulas to Values
  3. V or H Lookup
  4. Help with VBA Script
  5. Protection Error
  6. RE: Long with value zero
  7. RE: Long with value zero - IGNORE
  8. Long with value zero
  9. RE: subscript out of range
  10. RE: subscript out of range
  11. XIRR function breaking down (#NUM)
  12. Use Loop to set Picture Property of image on User Form
  13. UpdateLink Problem
  14. Hide QuickAccessToolbarCustomization
  15. Progress Bar
  16. Hide a sheet based on a cell condition
  17. Keep leading zero in number (Column also contains text)
  18. Need your hep: Creating new workbooks and name it based on a list
  19. LoadPicture fails
  20. running macros
  21. HOW DO I EXCLUDE SUNDAYS FROM AN EXCELL SHEET FOR PROJECTING SALE
  22. Need to always go to Sheet1
  23. More VBA Editor weirdness
  24. RE: Using InStr with variables
  25. Using InStr with variables
  26. RE: Has anybody found a solution for enabling macros from Excel 2003 t
  27. Listing BuiltInDocumentProperties without opening workbook
  28. relative reference for LastRow
  29. losing modules, and user forms in VBeditor
  30. using lotus notes
  31. Re: Delete row if cell in column "E" has 1 or more alpha characters
  32. Add the values of TextBoxes
  33. RE: Delete row if cell in column "E" has 1 or more alpha characters
  34. Re: Delete row if cell in column "E" has 1 or more alpha characters
  35. Delete row if cell in column "E" has 1 or more alpha characters
  36. How do I set a default format of the drill down table?
  37. Monthly Report
  38. Eliminate wild characters
  39. Hide a TextBox
  40. Re: Workbook_BeforeClose Event and Cancel Option
  41. The Amazing Growing Check Box
  42. ignoring certain tab names
  43. Workbook_BeforeClose Event and Cancel Option
  44. Activate Sheet but minimize Userform
  45. Serial Port Usage
  46. Improvement to code
  47. Bug in programming - using toggle between read-only and write acce
  48. What is the correct object?
  49. Re: Code for summary report
  50. RE: Help with some VBA code to copy and paste on new worksheets
  51. run macro on all sheets in workbook after specific sheet
  52. RE: Inserting Mulitple Criteria
  53. RE: Inserting Mulitple Criteria
  54. consolidate data from worksheets
  55. Using alphanumeric and numeric criteria in same code
  56. Inserting Mulitple Criteria
  57. Attaching code to ThisWorkbook
  58. Need help with SeriesCollection Object Please !
  59. Copy data from 1 sheet to multiple worksheets
  60. Programming Excel to open a program
  61. Can someone help me get started or point me in the right direction
  62. Extracting sub-strings from a large string
  63. Adding rows in the array
  64. Excel 2007 erases VBA code from Excel 2003
  65. Help with Macro that contains text and not looks at case
  66. Looping help needed
  67. Getting file name from Worksheet or Workbook?
  68. ComboBox doing a double take?
  69. passing cell reference and formatting cell in VBA function
  70. TYPE_E_LIBNOTREGISTERED Exception in MS Excel.
  71. break page based on specific conditions
  72. Result in 3rd function from existing two functions
  73. Open a excel workbook that has a different extension
  74. Class module to access range events
  75. named ranges in building excel formulas from a string
  76. Re: converting ways of referencing cells
  77. excel-vb help
  78. converting ways of referencing cells
  79. Help with .Find
  80. 6 arrays in 6 worksheets compare
  81. Registry Location for ActiveX for Excel 2007
  82. ActiveX controls still show data when empty
  83. automatically rename workbook with cell input
  84. Too many cell formats error
  85. Device I/O error on workbook close
  86. Ribbon Custom Tab Focus
  87. textbox value
  88. autoshapes - identification and property change
  89. loop through worksheets for each sheet after
  90. displaying multiple inputs
  91. Re: indirect formula that will fill down
  92. Can I use customed Addin in french version office excel?
  93. Userform Not working PLEASE HELP
  94. indirect formula that will fill down
  95. Copy Word range to Excel
  96. run macro each sheet after and then copy range
  97. Sort and move macro
  98. Changing Pivot Table Source Data
  99. conditional format macro
  100. looking for an Excel VBA programmer - 2 - 3 hours of work
  101. Before Worksheet Insert Event
  102. Help with Late Binding in Excel
  103. Using cells to specify range
  104. Re: copy cell values only
  105. Date format and Range.Find
  106. Issue Accressing current range of a closed workbook
  107. Scantron -- Fill in bubbles
  108. Monthly sales summary.
  109. Re: Subject: Type 13 Error when defining a Columns variable
  110. Timer w/ Start, Stop, Pause
  111. Subject: Type 13 Error when defining a Columns variable
  112. test post
  113. Excel 2007 Personal.XLSB file
  114. Convert email hyperlink
  115. Force a file to open in a new instance
  116. Delete rows where 1st 3 characters in a cell DO NOT meet criteria
  117. Delete rows where 1st 3 characters in string don't match criteria
  118. Re: Expand/collapse toolbar ribbon
  119. RE: copy cell values only
  120. Expand/collapse toolbar ribbon
  121. automatic data entry
  122. Making a Custom Dialog Box Work (some code included)
  123. RE: If cell is not null, add value to adjecent cell
  124. Create a callout box/Context menu for a cell
  125. If cell is not null, add value to adjecent cell
  126. Getting around a Mixed Variable Type
  127. Dynamic Range broken
  128. Working with colors (default and custom)
  129. Re: Macro for detect palindromes and repeats in letters/numbersstring
  130. Excel 2007 - Moving around in VBE
  131. Macro for detect and list palindromes and repeats in letters/numbersstring
  132. Dynamic userform help - Data Validation
  133. Macro for detect palindromes and repeats in letters/numbers string
  134. Unlock project for viewing within a macro
  135. Is there a better way to get Range of cells for entier worksheet ?
  136. Add Text to Shape
  137. auto-run a script?
  138. excel odbc ms query using cell as criteria value
  139. Curser / Edit problem in VBA editor
  140. Moving shapes around - XL2007 bug?
  141. Password log in from input box
  142. Mod 43 Check Digit calculator
  143. Need help with wayward ActiveCell.EntireRow.Delete
  144. Remove VB code when copying sheet to new workbook
  145. Range method error
  146. Password from cell
  147. RE: Autofilter currently filtering, or just "on"?
  148. Autofilter currently filtering, or just "on"?
  149. Insert formulas by means of a Macro
  150. Encoding query - Ansi
  151. Listview and Imagelist
  152. dates are formatted as custom date but still display as numbers
  153. copying sheet1 from different workbooks contained in a folder to myone and only destination workbook.
  154. RE: Calendar in a cell
  155. Case Specific
  156. Monthly Update
  157. how to input data into textboxes and make it appear on excel cells
  158. Know which cell was just left
  159. Spinbutton
  160. Re: Hexadecimal Numbers
  161. waittime versus Sleep
  162. Determine when Word document opens successfully from Excel VBA
  163. Iteratively delete rows from a spreadsheet
  164. Running Excel
  165. Isert - ("Dash Mark")
  166. MACROS IN MULTIPLE SHEETS
  167. Active Cell in Non-Active Worksheet
  168. Need to fix macro to send workbook via email
  169. Centralize worksheet code in Module code
  170. checkbox code needed
  171. Reading range w/ 255+ characters throws error
  172. How to send a variable from a VB Module to an excel spreadsheet ce
  173. Macro to compare datas
  174. Keep the textboxes the same size?1
  175. RE: Macro to compare datas
  176. Help with renaming in Visual Basic
  177. Can't name new workbook
  178. Copy to next row down....revised.
  179. Deleting rows messes up Named Ranges--How can this be fixed?
  180. Target.Address Question
  181. How to limit "Unhide Rows" Macro?
  182. How do I set the Maximum Property for this Chart in code
  183. VBA: Edit Web Query with Range(B24).Value
  184. Alphabetizing tab names
  185. Copy to next row down
  186. MinimumScale method of Axis Object failed
  187. Re: From a series to a matrix
  188. Macro to Unhide Rows
  189. DDE links
  190. From a series to a matrix
  191. VBA code to ascertain difference between Range1 and Range2
  192. Run Other non microsoft applications
  193. Read only access for hidden sheet
  194. Test if Word is running
  195. Error 424 Object required
  196. SetFocus issue
  197. Overflow error in Progress Bar
  198. Ran last Friday, doesn't this morning!
  199. How to make straight line after edit points
  200. Re: Make a button or menu selection
  201. Re: Make a button or menu selection
  202. VBA code seeing documents in Vista?
  203. Customise Ribbon Excel 2007
  204. macro
  205. Error code 91
  206. Inserting image file through ADO
  207. Re: Displaying Data in a List
  208. Use RibbonX in Off2003
  209. RE: Displaying Data in a List
  210. Copy row to sheet as per dropdown
  211. Login into secure web site and download data into worksheet?
  212. CodeName assignment for the new Worksheet.
  213. Is it possible to assign 'Ctrl + D' to a CommandButton
  214. Validate Cell Character Length with VBA
  215. Cut merged cells
  216. Re: Find number of lines ?
  217. how do I use VBA to set background of a cell
  218. Hyperlink in cell to path/file name
  219. protect sheet in 2003 vs 2007
  220. Worksheet Object
  221. Re: Help Fixing Code - Edit Access table from Excel
  222. Excel using VB - save problem
  223. Re: Constants as arrays?
  224. RE: Constants as arrays?
  225. ComboBox still shows data when linked cell is empty
  226. Re: Extract data from one range and place in the same sheet
  227. How do I run routine for each cell in column and wait for response
  228. Problem getting results of RefEdit into a range
  229. Re: Test post
  230. deleting text
  231. CONCATENATING CELL CONTENTS !
  232. offset merged cell
  233. using alise
  234. Detect Option Group Value in VBA
  235. RE: Help Fixing Code - Edit Access table from Excel
  236. How best to parse string lists of numbers
  237. RE: Getting data from a worksheet
  238. RE: Getting data from a worksheet
  239. Getting data from a worksheet
  240. Phantom sheet protect
  241. Test for empty array is 'UBound(AName) > -1'.
  242. Time Macro
  243. Addin
  244. Problem with ListBox, List Index
  245. Check cell status on Calculate event: resource issues?
  246. What does syntax '_Object' mean?
  247. Programmatic export/import code modules
  248. Formula help pls
  249. Test for membership in sheets collection
  250. Excel 2007 VBA Label Control
  251. Need a control to pick worksheet cell ranges
  252. Switch ribbons programmatically
  253. Problem with creating Worksheets with Macros
  254. using a variable length list to poplate a List Box
  255. help with textbox tabkeybehavior
  256. Expanding =HYPERLINK() functionality in include BODY
  257. Re: Trigger inserting Date (again!)
  258. Convert Worksheet List to Named Array Constant
  259. VBA in Counting Unique Values
  260. Auto numbering
  261. Dictator program question
  262. Variable in call statement
  263. creating a UDF for copy
  264. How do I change the forecolor of a CheckBox when True
  265. Save As Name To Change Cell Value
  266. 0.3395604 Now Look Here ... 0.45301
  267. Duplicates
  268. Called procedure ignoring "With Sheets" command
  269. CountIfs
  270. Macro help
  271. Find Month - Help with VBA
  272. Embedding an Excel sheet into a Website
  273. Dim ChkBoxes() As New Class1
  274. Call module
  275. Normal.dot Error
  276. Find Date and Paste Data
  277. #DIV/0! Error
  278. Help with Delete Macro
  279. RE: How to find the most common numbers?
  280. Combobox rowsource from non-contiguous cells
  281. Check for Compatibility Pack
  282. Convert text to Long
  283. Copy/Paste Template to New Workbook
  284. Date Time Picker
  285. copy rows to new sheet
  286. code for sort until cell equals...
  287. Time Marco issue
  288. Move Worksheet
  289. Utilizng full AutoFilter features while specific cells are protect
  290. Help with Range Probelm PLEASE !
  291. Chose a product and update related product variables
  292. Get External Data From Access
  293. Re: Pivot Table in Protected Worksheet
  294. 'InValidateRect' API not working as expected !
  295. Re: Copy Conditional Formatting w/out the CF Coding
  296. Trying to "clean up" some code...
  297. Edit names
  298. is there a way to use the WorksheetFunction.Min function
  299. Copy Conditional Formatting w/out the CF Coding
  300. RE: If for word in sentence
  301. Re: Activate hyperlink based on cell value
  302. If for word in sentence
  303. RE: Activate hyperlink based on cell value
  304. can VB ignore capitalization
  305. Copy worksheet from one file to another
  306. Activate hyperlink based on cell value
  307. Multi-editor sheets
  308. Does anyone have a League table calculator?
  309. Class Modules and Userforms
  310. Sorting Information in Excel, making collapsable data
  311. Need Help with a Macro
  312. How do I move an ActiveX control (command button) in a worksheet?
  313. password to open a work sheet in a workbook
  314. Headers
  315. using dir to get folder names
  316. Re: Please Help Me Annotate Subroutine
  317. Can Worksheet_Change be placed somewhere "universal"?
  318. RE: Combobox Populating from recordset
  319. Point me in the right direction
  320. Put data by matching cell value with sheet name
  321. Calculate data for previous 7 days
  322. Re: Put the same number in A1 for 160 rows and change..
  323. Re: Copy Worksheet
  324. Excel crashing
  325. Opening workbook in invisible mode?
  326. Clear contents of cells hidden by autofilter
  327. RE: macro needed to fill down base on condition
  328. Compare blank cells in a column
  329. RE: Copy Worksheet
  330. Run macro on exit by red cross
  331. Re: Excel to Access
  332. Working with most recently used colors
  333. WorksheetFunction.Left problem
  334. menu commands of excel disabled
  335. Add a picture to a cell that only appears on click
  336. Is there a way in VBA to check if a particular Sub exits inThisWorkbook?
  337. Hide a textbox on open of Excel
  338. Pulling a currency variable through my arrays drops 3rd decimal?
  339. Looping within a loop
  340. Save
  341. Pivot Table Programming
  342. Instead of Range please.
  343. Converting Indents to Outline
  344. Select Case Failing on Array Variable
  345. Writing a challenging macro
  346. Activate workbook using partial name
  347. "File cannot be accessed" when trying to click macro button
  348. How to calculate Min,Median,Max values in non consecutive rows via
  349. Dividelink
  350. Running a macro when a cell in a range has changed
  351. ODBC MS Query - comparing dates
  352. Help with listbox from pivot table with dynamic data
  353. Textbox Validation and Associated Checkbox
  354. Mercy - Need help with Copy/Paste VBA
  355. How to modify the Query Tables attached to a sheet in a excelworkbook
  356. setlinkondata code error causes multiple event firing and locking upcode.
  357. Print function parsing help
  358. Bypass Workbook_Open event when opening Another WB
  359. Change font size based on value of a cell
  360. VB - Macro to list all controls in the Commandbar.
  361. Charting error message
  362. auto save when form is closed
  363. Row Increment
  364. Plotting duration of activity on a graph
  365. Excel 2003 Pivot table: creating Fields from Consolidated muti ran
  366. "Out of Memory" Excel 2007 Vista 64
  367. EDITTING QUERIES RELATED TO QUERY TABLE
  368. macro to find the closest value
  369. Need to use excel from a web page and return the result to that pa
  370. Copy Down
  371. Index - Match - Vlookup Error
  372. Excel Command line
  373. dynamically naming ranges
  374. Delete all non-numerics
  375. data entry validation
  376. Copying Filtered Data from multiple worksheets
  377. troubleshoot column formula
  378. How are cube and queries related to excel templates coding
  379. Help on macro error when arranging pivot rows
  380. SQL Server
  381. while my c# code running ,clicks on excel document interrupts code
  382. Relative range syntax
  383. PivotItems for a Specific Filter
  384. Simple workbook Protect
  385. Macro Runs Twice
  386. validation rule
  387. Public function returns error intermitently
  388. Disable copy and print command
  389. Help repeating formulas with skips
  390. Re: Trigger inserting date
  391. Worksheet Chnage....still need help please
  392. what is the best way to loop through a 2-column range argument ofnumbers in a UDF?
  393. RE: Trigger inserting date
  394. RE: Trigger inserting date
  395. RE: prompt a msg in loop code
  396. RE: prompt a msg in loop code
  397. RE: prompt a msg in loop code
  398. inserting page numbers into a column heading cell
  399. Store data in array
  400. Worksheet Change events not working properly
  401. Need help converting number string to number
  402. UDF returns #NUM! with F9 or Application.CalculateFull if sheet notactive
  403. Test for value and hide or unhide based on result
  404. macro to stop numbering when a letter is found in cell
  405. macros in ribbon no longer work
  406. Unable to get the Add propert of the addin class
  407. Return Font Property
  408. Control User Form object properties from VBA code
  409. Macro Help!
  410. Refined Sort - Sort within a Sort
  411. One more time (I hope)
  412. Dynamic Data Exchange (DDE) getting rewritten on save.
  413. Is there an easy way to tell if array.column(x) has any contents?
  414. Select Case Type Mismatch
  415. Formula concatenating date & text converts date to number
  416. Turn off all code (VBA, VSTO)
  417. Hide and unhide row when asking a question
  418. WSS and Dashboard Creation
  419. change a tool tip
  420. Programmatically hide an object - Excel 2003 or 2007
  421. Bombing on final sort command . . .
  422. Subscript out of range error?
  423. Highlight a row using conditionalcformatting
  424. Error in row -2147467259 calling sql stored proc from excel 2003
  425. Access mysql longtext field from excel
  426. Looping through a range..
  427. Using Debug.Print with Range Variable with more than one cell
  428. Notification
  429. get rid of single quote in field from Access export
  430. View by User
  431. using variable in setting and ActiveCell
  432. Add-ins in Microsoft excel
  433. trick validation to take values from vba formula
  434. unprotect worksheet error
  435. Can program go back to userform to give user another go at it?
  436. tool tip
  437. Excel 2003 crash
  438. tool tips & custom buttons
  439. Need to return to display
  440. Create workbook based on cell value change in column
  441. copy rows
  442. select from list
  443. Indenting and sorting
  444. Code for Selective Printing
  445. VBA - Corrupt Excel Load
  446. Trigger macro when range entry complete
  447. Populating a multi column listbox with ADO Recordset
  448. Pyramid
  449. Err number 6 in my first macro written! Drop down box not working
  450. RE: vba for Today()
  451. RE: vba for Today()
  452. RE: vba for Today()
  453. an addin installation problem on test machine
  454. Copy and Paste web page using Vba
  455. Copy and Paste an HTM file with Vba
  456. Column Heading Loop
  457. Cell Population
  458. Hide Menus
  459. macro to unlock worksheet
  460. RE: RmDir
  461. Capitalise
  462. Workday Function in VBA
  463. Problem with Populating Data Validation
  464. Need code to loop through columns and enter formulas
  465. Entering date and time on VBA Form
  466. excel formatting for .net
  467. Paste With A Custom Format
  468. File in Use Error Message
  469. Re: Condintional Format Entire Row based on Value in Cell
  470. Re: Condintional Format Entire Row based on Value in Cell
  471. String as date
  472. Get macro to run on all sheets not just the active sheet
  473. Enable Copy Paste in automatically selected cells
  474. CONTROL SHAPE COLOR
  475. Relative Copy Range setting
  476. Intellisense, Object Browser, Code Issue
  477. Customizing a message with msoFileDialogOpen ?
  478. Checking for Errors
  479. Creating a range name from Selection.CurrentRegion.Select
  480. transfer data from one workbook to another.
  481. UserForm Option Button
  482. It seems so simple...
  483. Track Events in Worbook in VBA .XLA Add-in
  484. Macro Command Button to Sum specific cells in a range
  485. How to Hilight Chart's Source Data?
  486. Trigger Macro with keystroke
  487. Find > in a string
  488. Creating Match-up formula to return value
  489. Find Contents
  490. Convert RGB to Red/Green/Blue component
  491. Macro to search through macros (?)
  492. Marco code needed to find contents of cell a1 in entire workbook
  493. Confused with If s and And s
  494. Re: Docmd.Transferdatabase error
  495. FUCNTION THAT SOUND AUDIO ALARM WHEN SPECIFIC VALUE FOUND
  496. RE: Docmd.Transferdatabase error
  497. Create active timeline graph
  498. Drag and drop
  499. xl constants
  500. Re: Want to modify this VBA code snippet
  501. Re: Automatically close personal.xlsb
  502. Modification to SUMIF code request
  503. XML - reload source data from a file
  504. Worksheet Change event not running a macro
  505. Automatically saving to someone's 'My Documents' directory
  506. rank scores show ties and add top four scores
  507. Copy Range to Another Workbook
  508. RE: Automatically close personal.xlsb
  509. Trouble Setting Range
  510. public variable declaration, memory efficient?
  511. fill a shape with pictures based on the shapes boundries
  512. Another Question about Date Formatting
  513. creating a excel sheet and have it print out and also load theinformation into another workbook
  514. Can't see Modules and Worksheets in VBE
  515. Protect multiple selected sheets?
  516. error in loading dll/missing Ref Edit Control
  517. look back period
  518. toolbar macro on template
  519. excel, dataset and .net access problem
  520. Group Name from a macro
  521. .find query
  522. Help with VBA & Macro - Trying to auto-create a "form"
  523. Joel - Importing multiple text files to 1 spreadsheet, now importing from excel files
  524. Where (in which folder) are macros saved? And how to change location?
  525. Getting Creative
  526. Format a textbox
  527. Selecting Certain Userform Controls
  528. Want to modify this VBA code snippet
  529. are there skins available for excel?
  530. Multiple maximums in column
  531. Setting the last row in a sheet
  532. FIND FIRST AND LAST
  533. Copying Conditional Formatting With Icon Sets
  534. Relative and absolute references in Macros
  535. Formatting numbers
  536. Automating Pivot
  537. security constraints when you a excel scripting macro?
  538. Excel working with recording macro in excel
  539. Creating Code??
  540. Make sheet change stick after Application.Inputbox
  541. How to remove the spaces in currency format?
  542. UserForm ListBox
  543. Is it possible to ask an autofilter what is current filtered criteriais?
  544. Macro for splitting lines
  545. Looping until blank
  546. How to show all formulas of cells in cells (and not the calculated result) ?
  547. Need Help in numbering
  548. Insert row
  549. 0.8945782 Now Look Here To See ... 0.2297446
  550. .NET dll Usage in Excel
  551. Command Button color
  552. Conditional Formatting in Excel 2003
  553. how to program excel formatting options
  554. how do i rename an autoshape object so i can use it in vb program
  555. Run Time Error 91 in Thisworkbook
  556. cell-based conditional formatting on the whole row (Excel 2007)
  557. How to launch Macro/Code form command line
  558. Problem with Set stmt in Workbook_SheetSelectionChange event
  559. Re: Excel automation: how to open a blank sheet?
  560. Re: REPLACE in SQL function against text files
  561. REPLACE in SQL function against text files
  562. Excel automation: how to open a blank sheet?
  563. Checking and Unchecking CheckBoxes using code
  564. Reference Cell in VLOOKUP
  565. global shortcut definitions?
  566. Load Data into Userform ListBox
  567. Re: Trapping events within a Workbook_SheetSelectionChange event
  568. Resizing a Form in VBA
  569. Re: Creating Messages
  570. Creating Messages
  571. highlight different ranges in pivot tables
  572. Trapping events within a Workbook_SheetSelectionChange event
  573. code to make a comment macro uneditable
  574. OLEObjects - Paste combobox contents to a sheet
  575. Re: Userform Listbox selection change
  576. Data Source Name
  577. Userform Listbox selection change
  578. positioning in a specific cell using a macro
  579. How to count the number of worksheets selected?
  580. Query the Sort Key(s)
  581. Re: New to VBA, code works but need it to offset diffrently
  582. Excel 2007 ThisWorkbook code is slow
  583. Adding Sub code in Function module
  584. data type mismatch in criteria expression
  585. exporting data from My Excel to my Web
  586. How to make it work for "WHOLE" workbook
  587. International date format and user form
  588. RE: select a range based on a name
  589. Automating a process that uses an add-in
  590. Error
  591. select a range based on a name
  592. Useform displaying all columns with data.
  593. Useful code: find all the occurrences of a search string in a column
  594. VBA Conditional Formatting A GROUP of Cells
  595. File not found -- how to suppress
  596. Complicated code
  597. .Net application refreing to different version of Excel Object Lib
  598. RE: Formula question
  599. Formula question
  600. Range Help
  601. remove zero
  602. Find value in crosstab list
  603. RE: How do I use what is typed in a cell in programming
  604. How do I use what is typed in a cell in programming
  605. Identify the numbers that make up the average
  606. Sorting and filtering with more than one line of data in a cell
  607. Accept credit cards on your Website - Free Setup
  608. How do I timestamp a cell in excel (I don't know VBA)
  609. Dim ChkBoxes() As New Class1 Dilemma
  610. Carriage Return
  611. why does code stop execution at row 32768?
  612. "Name" Keyword ?
  613. Set value of all Userform textboxes to ""
  614. Missing Microsoft XML, v6.0
  615. Macro to move item to a folder
  616. Selecting data in ListBox
  617. Lost callbacks(?) and now custom ribbon doesn't work
  618. Disabling drag and drop - paste problems
  619. Copy non blank rows only
  620. Launch IE and scrap data from the web site
  621. How to handle user input error
  622. Autorun a macro on save
  623. Coding Question
  624. overflow error
  625. Analysis Toolpak Problem
  626. Index-Match Formula Promblem
  627. apps pros
  628. Show full Combo List at once
  629. Help on Worksheet_change (I think!)
  630. MC3
  631. Immediate window can't be found
  632. Target
  633. Problem with .Update
  634. how do i get a column format to follow me from one cell to another
  635. Range problem
  636. Vlookup with mouse over definitions
  637. Runtime-error 1004 (excel 2007) when selecting validation list optiontriggering worksheet_change property
  638. Target Macro
  639. Move and Link3
  640. Increase
  641. Double Delete
  642. ConsolidationReference pointing to current file in xml
  643. Target Macro
  644. UsedRange?
  645. Protect worksheet cells but still allow macro to edit chartproperties
  646. Autofilter on hidden sheet
  647. number format?
  648. ElseIf question
  649. 2007: Disable printing but still able to view Print Preview
  650. HOW CAN I USE VLOOKUP
  651. Macro Modification
  652. Run-time error '-2147221080 (800401a8)': Automation error
  653. Filter and unfilter
  654. date stamp to keep date
  655. SQL ODBC MSQuery in EXCEL
  656. 2007: How to disable printing when a specific cell is blank
  657. dsofile.dll and Excel 2007 file format
  658. On an invoice - with sums equations - don't want zero values to sh
  659. Validate Textbox/Userform Number Range
  660. Validate Textbox/Userform Number Range
  661. Name all Sheets except first one from a list
  662. variable not set
  663. #IF Statement in Excel
  664. Creating an Excel macro library
  665. Workdheet.BeforeChange
  666. Re: Find empty cell
  667. RE: Find empty cell
  668. Unwanted Querytable Autofilter on ODBC Import
  669. Privacy warning in Excel 2007
  670. Search up from last row
  671. Table Style dialog
  672. Formula function for ignoring cells/results equal to 0 (zero) ?
  673. DYNAMIC LISTBOX
  674. RE: Loop syntax help
  675. .net data being formatted in excel
  676. VBA storing and accessing larger texts within spread sheet
  677. MCount2
  678. Combine workstheets of multipel workbooks into one workbook using a macro
  679. Help with ComboBox in VBA
  680. How do a logical test on times in two different formats?
  681. Changing Font Color to White if Background is Black
  682. Array Dimensioning
  683. Read Order When Using Tags on UserForm; Typename
  684. How can I prompt user to select item and use as a variable
  685. Automatically execute Excel Solver to on a change of input
  686. Text Export macro modification?
  687. Unzip all encrypted files in a folder with known passwords
  688. Saving userform code
  689. Save As HTM with "align=Left" in HTM file code
  690. Want a leading zero on a number
  691. Goto Reference:="abc" where abc is formula result
  692. How to Copy formats and formulas in vba?
  693. autoresize of cells (height)
  694. Showing all info under subtotals with large listings
  695. I need a variable name to contain the values of several cells
  696. Macros and user-defined functions used in several workbooks
  697. Worksheets events
  698. Can the last two if statements be combined together?
  699. Change default number to default text?
  700. Force display to round down
  701. Help on animation
  702. How to check if cell has conditional formatting
  703. Button Programming
  704. error; " 'Range' of object '_Worksheet' failed"?
  705. excel macro stops
  706. How do I relate column data?
  707. FileFormat List
  708. What is the wild card for an Access query (MS query) parameter?
  709. Creating a loop in a Macro to do through data
  710. April Fools Programming, anyone?
  711. Variable types
  712. Check if a file is already open
  713. How to set a gradient stop position
  714. IF NOT between
  715. Insert multi spreadsheet
  716. Re: user form with conditions
  717. time format
  718. "Cannot shift objects off sheet"
  719. If Worksheet Active, Go To Cell A1
  720. Major help needed - Iterative Functions
  721. Adding 2 arrays, then use in worksheet function
  722. Validation Dropdown Font Size Change
  723. Help with Loop Please
  724. Time calculations
  725. Paste data of a cell to another cell by just selecting the source
  726. RE: Return unique values from 2 different ranges
  727. Carriage Return and Line Feed
  728. How do I insert a Filter range result into a ListBox
  729. userform code for timestamp on w/sheet
  730. Macrocount
  731. How to Find the Column address from a Range Dimensioned Variable
  732. Combine files as tabs in a single Workbook
  733. How can I make this macro works
  734. How find elements NOT common to two ranges?
  735. Pause for thought!
  736. avoid recalculating user-defined function when file opened
  737. Tricky Formula
  738. VBA to copy an htm file into excel
  739. Pull Recipient from Outlook Address book
  740. conditional format column
  741. Macro to Unhide MulipleRows if Cell B10 has a "X" otherwise hide c
  742. X values on a chart
  743. I'm looking for an operational ROI to use in the tourism industry
  744. Help using ListBox in VBA
  745. Macro: Code for skip a row
  746. Code window changes case and throws error
  747. vbscript to open worksheet, insert data on first opencell....HELP.....
  748. Find and FindNext...from Excel VBA Help generates 91 error.
  749. complex numbers with excel
  750. Adding cells from different sheets of same workbook