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. Is it Possible to have a dynamic function in an array written in visual basic?
  2. ParamArray values not being passed, Feb08
  3. Looping through columns(a:k), with rows(5-7) only
  4. Open "A.txt" For Output As #1 - How to make Output a Sub argument?
  5. run sub routine with multiple conditions
  6. Use data from another workbook
  7. VBA - Freeze data in external data range
  8. access object in non-referenced add-in
  9. Extending the time-out duration for loading URLs in Excel?
  10. How to report on WHAT range names are used
  11. Add date picker calendar to a user form
  12. pulling properties
  13. How do I move bars in a chart?
  14. Copy entire row to diff worksheet based on value
  15. I Have Some Sort of Macro/Worksheet Corruption Problem ?
  16. System Error
  17. I have Some Sort of Macro/Worksheet Corruption Problem :-(
  18. Hide
  19. Application.FileDialog(msoFileDialogSaveAs)
  20. Delete Rows with Loop Statement
  21. consolidating sub-totals
  22. No VBA when I record a macro (Excel 2007)
  23. Command Button Drop Downs
  24. Copying out corresonding values
  25. Setting row height to 0 in the visible celss of a range
  26. how to use MZTools to get a calltree?
  27. Why does this Worksheet Calculate Event run so slow?
  28. how to sum values of an unkown number of cells
  29. Creating a Project Schedule, displaying the hours per day.
  30. Case Select
  31. VLOOKUP Help
  32. trying to write a tab-delimited file
  33. Sort and Renumber
  34. Speed
  35. Regex syntax request for help
  36. Insertion of Excel plots in a userform using VBA
  37. cell already referenced
  38. Path Issue
  39. Matching a date or value
  40. Remember Last Cell
  41. Userform
  42. get other workbook objects values
  43. RegExp information
  44. scheduled tasks
  45. Macro for PPT changes the object number when looping over 42 times.
  46. xlsm
  47. change cpu used
  48. "Web Services References" add-in
  49. Copying text within text box and having scroll bar appear
  50. What determines the language of MSGBOX's Yes , No ?
  51. Process monitor macro needed
  52. Having trouble formatting paragraph in text box of form
  53. why,,,, dificult??
  54. Extract strings intelligently from single cell
  55. get value of a known cell
  56. Help Using Excel 2003 to send emails
  57. Accessing groups of option buttons
  58. Invoke hyperlink
  59. Create a chart from a "txt" or a "csv" file
  60. Keep track of OnTime macros
  61. How to activate a worksheet at a set time
  62. Export Multiple worksheets to text files
  63. Type Mismatch Error in Excel VB on RowIndex
  64. How can I change the case of letters without using function ?
  65. Cell to indicate protected sheet
  66. countif from whole row as range
  67. How to use MS assistant instead of drop down list in excel
  68. populate text boxes from data in worksheet
  69. Generating password-protected PDF using Excel VBA
  70. 1.04 Mb with nothing in file ???
  71. help with a worksheet needed
  72. If then else assistance - conditional "deletion"
  73. Run-time error 1004
  74. excell error on close with commandbutton
  75. Compare and Count data in worksheet rows.
  76. check that active cell is within a range
  77. error 1004
  78. Setting Pivottable RowField Width
  79. Counting based on characters.
  80. Text box
  81. Custom zoom
  82. VBA enhancements
  83. using rons email but need just printrange to mail
  84. Application.Sheet1.PrintOut = property not suported
  85. checkbox & controlsource
  86. ListBox Value
  87. "Run-time error 429: ActiveX comonent can't create object" MSComm
  88. Why doesn't this simple macro work
  89. Excel 2007
  90. Accent / Diacritic word search
  91. EXCEL 2007 / RS 232
  92. Defined named range (Array list)
  93. VBA help: need folder names
  94. Data from SQL to Excel in a formated manner..
  95. Error when trying to remove Validation from cells
  96. ActiveSheet.Pictures.Insert problem in excel 2007
  97. Match 2 cells and total another
  98. Match 2 cells and total another
  99. Run Code on Cell Select
  100. find cells that match in column
  101. I have 4 columns, I need to match col. a & c, then sub b from d
  102. Excel 2000 clocks -- Excel 2003 works fine.
  103. needing help with replace(c.value
  104. WAV Files
  105. Help, please. Anybody?
  106. Type mismatch error
  107. Type mismatch error
  108. Unique Values
  109. Re: copy worksheet tab data into one sheet
  110. Custom Sort a Pivot Table (possibly w/ VBA?)
  111. how to generate date error message
  112. Using a text cell reference as a variable in a macro...
  113. Insert Row after Specific Value in Previous Row
  114. Goto last cell
  115. find
  116. Using VBA to send a javascript:opendocument command, then grab information from the active IE6 window
  117. Workbook Open
  118. msgbox
  119. highest used area of an array ("uBound" of used area)?
  120. Info on UserForms and command buttons
  121. sort within a sort
  122. Looping or Repeating on all worksheets
  123. Add-in macro button assignment spontaneous change
  124. Combine column data into one
  125. Active Cell
  126. RefEdit error
  127. Cell Value
  128. MERGE ROW CELLS BY MACRO
  129. referencing a Drop Down Menu
  130. combo box value
  131. Worksheet_Change not repetitive
  132. Macro Question revisited
  133. Application.Wait information request
  134. Problem with that PPT changes an objects number during macro in aloop
  135. SaveAs dialog box
  136. How to save data back to databak
  137. ListBox Execution
  138. Slow Macro Issue
  139. Copying the last used cell only
  140. Call Macro If x 2 Q
  141. Closing an Excel Spreadsheet via command button
  142. Re: Copy worksheet tab data into one sheet
  143. VBA Code for pop confirmation box
  144. help modify code
  145. MERGE CELL BY MACRO
  146. VBA Lookup with Find method
  147. Prevent selecting filtered rows in AutoFiltered Range
  148. Items received vba
  149. stop formula recalculation when formula contains UDF
  150. Stripping Formating from Header/Footers
  151. Get cell reference as parameter in function
  152. Linked File and Range
  153. Sorting file names
  154. Strings
  155. Select Case Not Returning Correct String
  156. Retrieving OptionButton Control Value
  157. Copy data in multiple worksheet tabs into one worksheet
  158. IF Cell contents = "a" then hide row
  159. after click a button(commandbutton), getting the button name
  160. variable names stop to adapt to changes
  161. Find Worksheet
  162. MACRO TO INSERT ROWS
  163. Calendar
  164. Uncheck every Check Box Q
  165. select range...
  166. Columns to rows
  167. My file is 28 MB w/ code & forms; ~40MB with data - is this too bi
  168. intersection point
  169. How to have multiple values in a single cell?
  170. Fun with GetOpenFilename
  171. BDP/BDH/BDS functions in Bloomberg
  172. Issue with workbook not being selected when form button is clicked
  173. Macro to create a varying named range
  174. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  175. How to traverse cell.Dependents
  176. Page Header: Setting using InputBox for LeftHeader
  177. SetFocus not working
  178. Correct structure
  179. Formatting the Formula Bar
  180. Single quotation mark prefix
  181. macro OK in Excel 2003 but NOT in Excel 2000
  182. compile error with FaceId
  183. PivotTable filter ordering
  184. using the WorkDay function in VBA
  185. Calling function from non-referenced add-in
  186. Delete entire row if column B shows -
  187. Macro to update data
  188. copying macro to multiple excel files
  189. Range properties from Array variables
  190. Add Tab names to Userform
  191. Recursively scraping web pages for embedded links and files
  192. find values and add them
  193. Create Multiple Dynamic Ranges in a single column
  194. print to pdf with vba
  195. Complex Graph
  196. XL2003: VBE Project Explorer not showing folders
  197. Formula in a Text Box
  198. Using "Undo" with bound ListObject
  199. FIND function i VB
  200. Improve speed of data transfer loop
  201. alphabetize within a cell
  202. Copy/Paste Multiple cells from Excel to Word
  203. Combinations
  204. Using Excel for statistical analysis - a question for problem-solvers
  205. Excel crashes when using F2 to edit a cell
  206. Assigning cell values with VB
  207. VBA or Function Required . . .
  208. problem with background query
  209. Kill a Macro?
  210. Matching user input to number in range
  211. Create list of different columns
  212. Delete the active wb
  213. Detect Excel service pack
  214. make hotkey in commandbutton1 on userform
  215. Programing - TEXT - EXCEL
  216. if value begins with "" then
  217. Pearson and Peterson are Genuises!...er...Genii!
  218. subtract date and time between columns
  219. Excel Cell Display window blanked out
  220. SLA - Downtime calculation
  221. How to protect worksheet?
  222. How to stop a VBA Module from opening
  223. Chart Question
  224. Send email in a different way
  225. Adding Time to a Date
  226. Callling Word fronm Excel
  227. OLE Object on Sheet updates Value in Code but not its Display
  228. Setting up Classes
  229. How to detect cell content modifications?
  230. Spread Revenue Over Time - Excel Help
  231. Web site plus excell
  232. runtime error 9 in my macro
  233. How to set Cell Format using VB.NET
  234. Search and change text color or style only
  235. Copying Data between worksheets
  236. Filter Pivot Table
  237. sort (ascending) data while worksheet is protected
  238. activate
  239. How to create Loop
  240. How to create Checkboxex on the fly
  241. PLEASE HELP
  242. Date Serial Problem
  243. delete row on basic of cell
  244. Deleting a row in a message (opposite to VbCrLf)
  245. Macro to do numerous tasks
  246. Loop
  247. Autofilter over 255 characters in a cell?
  248. copy range to Text (Tab delimited) (*.txt) file
  249. Help creating a custom function in VBA
  250. Retrieving a value at some cell from another Workbook
  251. XL2007 - Known problem? - Driving me crazy.
  252. Form Actions
  253. Worksheet_change event assistance
  254. Data comparison
  255. WORD ART WITH EXCEL 2007
  256. Clear Method not working for a ListBox clear
  257. A formula for birthdays
  258. Run-time error '1004'
  259. Unwanted "Flashing" of screen
  260. enable and repurpose the Spelling control?
  261. Macro launched from another file only partially works
  262. How to change debug.print font?
  263. Listbox Output to Individual Listboxes
  264. Formatting cells with VB
  265. Exporting Values into Microsoft Word Form Fields
  266. Specifying cell in Worksheet_Change even
  267. Dates
  268. Excel 2003: VBA - Hide Rows process now too slow
  269. find
  270. Textboxes remembering previous entries
  271. excel crash on workbook_open userform.show
  272. countifs
  273. Declaring arrays
  274. Private sub Worksheet change question
  275. delete empty space after certain characters
  276. If texbox value begins with "E" then send to another sheet.
  277. Macro gets lost
  278. Sending email routine, tweks needed
  279. Multipage control
  280. How do I protect my code?
  281. Insert a number rows according to a cell value
  282. Scraping/listing document URLs on a server that don't have web pages/existing links?
  283. application.EnableEvents = false not disabling events
  284. VBA syntax to check between two time frames i.e. 2 PM thru 5 AM?
  285. Find using a variable value
  286. How to obtain superscript and mixed font info when read from Excel?
  287. include date and time in email subject line
  288. Grouping related ribbon tabs
  289. How do I plot two curves on a single XY scatter chart?
  290. Textboxes Not Calculating Properly
  291. Macro to delete with filters
  292. Find something
  293. What are the options in the print macro?
  294. Halting Execution -- A Newbie Question (possible repeat, sorry)
  295. Cell Error Markers
  296. Macro to mark a column where text in row (or cell) is as specified
  297. Can I switch to my custom Function category ?
  298. Stopping Code Execution -- Newbie
  299. hide formula bar (and menu bar etc)
  300. Copy File from Website (Sharepoint)
  301. If find function to not find anything
  302. if multiple conditions are true, then copy the row to a new sheet
  303. How do I track down 'invalid references'
  304. opening workbooks in subfolders
  305. Shadow Menu
  306. Programming Shapes
  307. Clearing formulas
  308. Compare Columns, Find Matches
  309. MegBox @ Opening
  310. MultiPage Page Order
  311. Add custom icon using VBA
  312. Reading Directories
  313. Extract data from seperate files-macro
  314. ADODB Connection in Same Excel File
  315. Identify defined name range by another cell value
  316. How to create pivot table from web query
  317. Formula for list summary
  318. MACRO TO BRING WORDART ON CELL VALUE
  319. Invalid Precision: cbColDef value out of range
  320. find
  321. Selecting dates from current week with Macro
  322. try to email with vba, but more than one sheet and convert to pdf
  323. Problems with an if (using rng Nothing) - only to produce sheet giventhat it doesn't already exist
  324. Make excel Worksheet as data base
  325. How do you programatically format embedded charts
  326. Restoring the Macro Recorder to Default w/ relative references sho
  327. Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range)
  328. Last cell with constant in a sheet
  329. how do I disable spell check in email sent from Excel macro
  330. Auto Number Excel Forms During Save As
  331. Synchronize Combo Boxes?
  332. Listing installed COM add-ins
  333. Deleting Duplicate Rows In a Selection with a True Statement
  334. Making changes on "grouped" sheets via code
  335. SQL with Excel ranges
  336. Inconsistent behavior using VLOOKUP
  337. vba editor comes up everytime this specific macro is run
  338. Determine if a shared workbook is open
  339. vba editor comes up whenever macro is run.
  340. VBA and Excel 2007
  341. Plot Area Changes Automatically When Updated
  342. Sum / countif data range
  343. pulling apart a field
  344. pivot table order
  345. return to first column of next row
  346. Invalid Precision: cbColDef value out of range
  347. Limit Dates in Pivot Table
  348. Numbers Not Calculating Correct on Userform
  349. Formula to add a date to a cell that is 6 months from today
  350. Maximum number of named ranges?
  351. Adding validation fails with automation error
  352. Goal Seek with dynamic Goal Seek
  353. ExportAsFixedFormat for Multiple Sheets in a Single Excel File
  354. Configure Built-in Font Color Command Button?
  355. align and resize controls
  356. Conditional Formatting and Text Alignment
  357. If column = value sum another column and place result in cell
  358. From VB6 how to determine if an Excel cell string containssuperscript?
  359. Pivot table from xml data
  360. No... while trying to update to Excel file
  361. COPY FORMULA TO THE LAST CELL
  362. Code for file download
  363. Code for file download
  364. Save As PDF / XPS
  365. Range is nothing
  366. Replace last three characters
  367. Zip and mail more than one sheet from the ActiveWorkbook
  368. Display formula result in a popup.
  369. disable clear all using VBA
  370. Time conversions from data dump
  371. Integartion of BDC into Excel services
  372. Help passing Range to Class Module method
  373. identifying the end of a data column
  374. Vlookup and #N/A
  375. Text Box
  376. VBA block cell copying.
  377. Multiple Windows in Single file
  378. DATE IN COMPUTATION
  379. most efficient way to filter out and iterate through XLS databases
  380. Loops stop working and presents "1004':
  381. SumIF
  382. EVALUATE method returns zero
  383. Custom menus don't appear under custom ribbon tab
  384. Adding AUTOSUM to Cell menu in Excel 2007
  385. Loops stop working and presents "Run time error '91':
  386. Variables in Variables
  387. Conditional Format
  388. Filtering one or more items in 2 columns
  389. Need help to enter text in Polish language
  390. Re: How to see cell value exactly as Excel displays it?
  391. How to see cell value exactly as Excel displays it?
  392. Workbook Open bypasses Query Refresh
  393. coding for variable rows
  394. Why is my vbasum(F1:F45) called 46 times?
  395. outlook express 6 glitch
  396. Message Box Help
  397. return row header as answer
  398. .Formula vs .Value?
  399. Check cells in row for last cell with data to use as multiplier?
  400. Set Formatting Menu Font Color with VBA
  401. UserForm and user input
  402. For Each ws autofill
  403. Create worksheets based on value
  404. How to refresh a pivot table that uses changing source data
  405. Bloomberg API: Preserving Values?
  406. Sending Email to non-standard address using CDO?
  407. return chart's source data location/range
  408. Random phantom breakpoints and random bogus compile errors
  409. Record Not in Access DB
  410. Importing Specific Data From Multiple Pages From The Web
  411. PLEASE HELP!!
  412. Change background color based on cell value in vb?? Current code notworking...
  413. How can I hide contents of a cell and password protect to reveal
  414. VBA 6.5 on older systems
  415. GetPivotData - Why does the reference not change when I drag theformula?
  416. format in VBA
  417. Subscript out of Range
  418. Obj Variable or withblock variable not set?
  419. Save Copy or Cut Reference
  420. Use criteria in an Advanced Autofilter's single column
  421. Transpose 3 columns into Single column
  422. Return the first 2 letters of a Cell Value
  423. Vlookup across workbooks
  424. Inserting rows if a particular item is chosen from a list
  425. copy formulas on a weekly basis to next available
  426. having trouble with a chart range
  427. Excel runs much slower in console app
  428. Zip and mail more than one sheet from the ActiveWorkbook
  429. How to run a process in the background?
  430. Multi-level User Definet Types
  431. respostX2 - deleting blank rows after macro-generated pivot table
  432. respostX2 - deleting blank rows after macro-generated pivot table
  433. VBA Error
  434. Passwords on files used in calculation
  435. Macro to Transpose All Items in a Vertical List, and Add a Comma
  436. Downloading into a column
  437. Which cell is calling a user-defined function?
  438. Getting/using the File path of a spreadsheet
  439. Help needed with macro
  440. Excel program
  441. Look up data.. help please :-)
  442. Referring to merged columns in range object
  443. count column c with condition in column A
  444. Using the result of an input box
  445. Creating a line break (newline) in a cell with SpreadsheetML
  446. Reset of radio button values without calling _Click() function
  447. Custom Context menu (Right click menu) not working in sheet changeevent.
  448. Copy worsheet from different files in to one file
  449. Crash on ActiveWindow.Close
  450. Variable not seen
  451. Simple question
  452. exclude holidays on UserForm Calendar control
  453. application.filesearch error in excel 2007
  454. Sheet Select
  455. Look Up sheets
  456. Unable to view search results
  457. HELP Debug
  458. Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names)
  459. application.goto reference using references in the worksheet
  460. Converting a number todate
  461. Macro not running when Image/Button Object is pressed
  462. delete all rows where cell is not date format
  463. if cell is not date format delete row
  464. if cell is not date format delete row
  465. if cell is not date format delete row
  466. Scrambleing data when refresh
  467. Combobox that populates text boxes on userform
  468. help with "Goto" command
  469. Reactivating file based on text value producees subscript error
  470. Combo Box Wont Show Values
  471. Help with autofiltering a list based on criteria
  472. How can I tell the shape of a Variant containing an Array?
  473. Calendar using TODAY function
  474. Insert "/" into cells that contain data, using a macro
  475. app.quit
  476. why would a large addin save in 2 seconds or 18 seconds
  477. run code *after* drop down list choice
  478. page header multiple rows
  479. wait function
  480. if - then actions
  481. Changing a horizontal axis crosses value using VBA
  482. circular argument
  483. check column -A- and fill out column -B- by vba
  484. Ranges in VBA
  485. Writing text at end of spreadsheet
  486. Conditional Formating
  487. transpose loop
  488. CC Field Q
  489. Automate Monthly Task
  490. user form tabs
  491. Filtering Data Based On Different Criteria
  492. Programmatically adding code to worksheet
  493. Pivot Tables
  494. Concatenate Rows depending on cell value in rows
  495. What does it take to get class functions to execute?
  496. html help and custom msgbox
  497. Page Fields Converting to Text
  498. Using calculated fields to count unique items in a pivot table
  499. getting data from website's url and webpage
  500. Rename worksheet tabs
  501. Copy a Range that matches Todays date Q
  502. v lookup problem
  503. cell top of screen
  504. How can I sort contents of one column based on the contents ofanother column?
  505. Dialogs(xlDialog...).Show arguments usage
  506. getformat
  507. Pivot Table Macro - How to describe the Active range (so that themacro can be used on new sets of data)
  508. Why doesnt this work?
  509. AutoShape Macro Help
  510. comparing values that don't equal but do equal?
  511. Filter Data based on criteria
  512. Seperate letters and numbers in a cell
  513. Protect workbook when saving
  514. Excel Automation
  515. Adding Cells and Indexing
  516. ScreenUpdating Not Working
  517. delete rows where value in Column B=0
  518. Need loop guidance
  519. Using Cell Numbers in a range
  520. Row number of filtered row
  521. Variable value
  522. R1:C1 format
  523. Function
  524. Using ADO from Excel form to relational Access Db
  525. Referencing two versions Object models
  526. Copy/Paste data based on a criteria
  527. Locking worksheet based on the cell value
  528. array formula to extract members of list A that are not in list B
  529. How to include field name in CopyFromRecordset
  530. Filesearch error in Excel 2007
  531. Find first empty cell in range and paste formula??
  532. Control don't refresh
  533. How to add a text box with scroll bars in excel 2007?
  534. Minimum references required
  535. Count items in a column
  536. Excel Functionality
  537. Code Help
  538. Code Crashing
  539. use option button background color to format cells
  540. Value cells
  541. Skip part of macro on re-run?
  542. msgbox
  543. worksheet as data entry for Access database?
  544. Increasing and decreasing cell values
  545. Copy and pasting based on criteria
  546. Coded to delete extra rows after pivot table
  547. Open And Close Form
  548. Find cell
  549. Adding a second line in a header or footer through VBA
  550. How can I change the caller cell's format into "mm/dd/yyyy"?
  551. Paste not working again
  552. Macro to split data
  553. Passing Parameters to an ODBC
  554. Opening files from Excel
  555. Accessibility of a server
  556. What programming to use in VBA to convert in to number?
  557. lost reference to activesheet when opening workbook inside IE
  558. OUT OF OFFICE IN OUTLOOK 2007
  559. read Matrix
  560. Copy to
  561. Query refreshing inside a loop - out of memory
  562. Getting error using Month()
  563. Asian file names
  564. Macro freeze up
  565. Totally Lost
  566. convert xml to table with VBA
  567. blank display while macro runs
  568. Excel 2007 filesearch
  569. Instr
  570. Excel 2007 ambiguous name detected:Worksheet_Change
  571. links
  572. Need help with a macro that takes information from another workboo
  573. Can Not Complete This Task with Available Resources
  574. Import text files to cells
  575. Copying a chart included in a range
  576. Counting Octals.
  577. Userform
  578. How to put a button on a cell and assign macro to it?
  579. Delete row Based on First column value
  580. Looping through columns
  581. Deploying Excel 2007 VBA Project in an Office 2007 Standard enviro
  582. AMENDMENT IN MACRO
  583. extract certain values from multiple workbooks into a new file
  584. calling .net exe file from within SSIS script task
  585. highlighting rows
  586. Summary page
  587. Getting #VALUE! while entering UDF as an array function
  588. Activating a workbook
  589. Custom Toolbar question - newbie
  590. userform closing after input
  591. Code that searches a column, then copies and pastes any matches intoa new Spreadsheet
  592. Setting a variable = ActiveWorkbook
  593. code to delete all rows beneath and columns right of pivot table
  594. peraphs impossible... order line base color...
  595. Copy data from worksheet to another automatically
  596. Closing VBE systematically
  597. Remove/Inactivate "X" in UserForm
  598. Pivot Tables: Hide detail for a RowField via code: Get an Error?
  599. Exclude rows with result 1
  600. Calling a user Function in Worksheet
  601. If cell value = x or y then perform formula set else skip
  602. How to read in cell border?
  603. Copy Error
  604. Average - without zero?
  605. Best Substitute for Range(cells(),cells()) in worksheet
  606. Windows API - File Menu Processing...
  607. Easy Question: Cell Value
  608. Bloomberg download
  609. Image in Userform looses quality
  610. Excel 2007 VBA - Can't type in VBA editor
  611. Automatically populating new rows with formuals above
  612. Forcing cell value update/refresh
  613. Add Column at the end with concatenate formula
  614. Count CheckBoxes in a Frame that are True
  615. How to set Range variable to point to End(xlDown) cell?
  616. Conditional Formatting
  617. Rename Worksheet Based on Cell value
  618. Advanced tool uses TrueType fonts to represent tiny charts
  619. Filter out Non-Number (i.e. Text) Cells
  620. Combobox
  621. VBA, copy lines with specific value
  622. Save Changes to Add-In
  623. VBA Project Passwords
  624. save and add to CSV file
  625. save workbook without code
  626. How to get the last valid (non blank) cell index?
  627. how to detect if macros been disabled
  628. Copy & Paste...if
  629. Import from Excel to an access database using Jet in vb.net
  630. hide name box
  631. convert xml to table use VBA
  632. IF statement for lookup matchup
  633. Excel Error
  634. UDF Function or Macro Needed
  635. Updating Listbox in Excel Form
  636. Updating Listbox in Excel Form
  637. Updating Listbox in Excel Form
  638. Public oMyClass As New MyProject.MyClass
  639. best way to get an updatable SQL Server 2000 recordset into Excel?
  640. Not ScreenUpdating with PrintOut Property
  641. Enter Key Press Event
  642. Inserting a picture into a Userform from a stored location
  643. Using VBA to change the color of the active cell if the value in thatcell is less than 15%
  644. How to automate Print Zoom to fill page
  645. An old macro needs updating
  646. Macro's
  647. drop down change event
  648. isblank macro
  649. DELETE ROWS ACCORDING TO FIGURES
  650. Run time error 2147319765(8002802b)
  651. Setting cells to change colors as a date approaches
  652. Shopping Cart application
  653. protect my sql query
  654. range with variable row
  655. Checking Data, Help Please
  656. Information dependent on other information
  657. Block games in Excel
  658. Deleting Worksheets
  659. Questions on Ron de Bruin's Excel Email Macro
  660. hyperlink follow through and save file
  661. If Then else
  662. Circular reference, Maximum number of formulas
  663. 0E560 = 0?
  664. Withdrawing a template from "Data tracking"
  665. Change the date when there is a change in another cell
  666. Hyperlinks with Cells(r,c).Value reference
  667. Need help with MAcro for Multi-value cell and row processing
  668. Excel 2003 and 2000 and VBA Macro
  669. XL2002 - Worksheet_Activate Question...
  670. OLAP cube DateTime dimension
  671. import multiple text files into single sheet separate column
  672. Custom menu groups don't appear on ribbonX when no workbook is ope
  673. Re-Arrange Tabs
  674. Big excel file
  675. Subtotals
  676. Looking Up Text entries
  677. SQL and Excel
  678. Ribbon stopps working after Save
  679. GETPIVOTDATA help
  680. Pass criteria in Microsoft Query
  681. Subscript out of range
  682. depedent drop down lists
  683. Run time error?
  684. Programatically filter a protected shared workbook
  685. checkbox value unavailable?
  686. Putting zero value within a specified range, help please...
  687. Buttons
  688. 3 dimension array using Excel names
  689. Replace Dialog Box Keeps Moving To Bottom After Replacing Text
  690. User Forms & Checking Inputs
  691. Excel Combobox keystrike
  692. break into an invisible instance of Excel
  693. How can I set a text box or label to show the vaule of a spinner?
  694. How can I set a text box or label to show the vaule of a spinner?
  695. Macro to give different outputs dependent on result
  696. Excel 2007
  697. Hide a cell so that users can't see the contents
  698. Loop to tidy up my code?
  699. Doing a LOOP for multiple columns, help please...
  700. if then multiple sheets and values
  701. Unhide rows error
  702. Column value
  703. Listbox Properties
  704. Adding current date and contents of a cell in the footer
  705. Sendkeys to paste excel worksheet object to powerpoint
  706. Fixing Rows...Help please..
  707. Paste from Word to Excel
  708. suspend processing for TextBox_Change events when initializing a f
  709. SaveCopyAs changes SheetName
  710. Excel formula that adjusts to new columns as entries made in cells
  711. Combo Boxes
  712. Filter and Delete all rows with a date greater than or = today
  713. Reference value plus 7
  714. intersect
  715. adding code lines with vba code
  716. How to get the last row in a column without selecting
  717. Mulitplication within an "IF" statement.
  718. Creating a procedure using VBA Code
  719. Auto Update files for just this run of code
  720. Accessing External Module
  721. Wizard pages not hiding when go to next page
  722. Passing criteria from one Excel Query to another
  723. Shorting the Code
  724. PICTURE TROUBLES
  725. Copying sheets without copying named ranges
  726. Save As File Format
  727. Specify chart template size
  728. Rename a worksheet to use with a pivot table
  729. Paste object from excel to powerpoint
  730. formula with percentages
  731. Calculate text strings
  732. Merge several fixed width text files into one
  733. Is Excel compatible With VB 2008 Express Edition
  734. Cells.Find
  735. Conditionally Disabling Optionbuttons
  736. Calculate total days
  737. IgnoreRemoteRequests & multiple Instances
  738. VBA Code to Insert Borders Along Automatic Page Breaks
  739. Removing duplicates
  740. Chart 2ndary axis issue
  741. items in pivot's page section
  742. Resolving "File Now Available" Read-Write dialog at end of code
  743. MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS
  744. change email page color
  745. Advanced Filter is unstable HELP
  746. Form Control Drop Down Lists
  747. Copy from an application
  748. Disable Paste in Excel 2007
  749. SetFocus method
  750. Using "Custom XML" as a datasource