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. Video tutorial for programming Excel macros or such
  2. HELP! Writing Text file from Excel Spreadsheet.
  3. Copy data into blank cells
  4. Protected cells in Protected sheet
  5. Remove Duplicates
  6. Name of the current pivottable from active cell
  7. Changing Category (x) axis labels for radar charts
  8. Reference Sub from another workbook
  9. Variable variables and sub routines
  10. Problem with Error handling in loop (with find)
  11. Trying to copy data from one workbook to another
  12. Creating a macro to paste in a specific cell
  13. counting filtered items in PivotTable
  14. VLOOKUP works but gets #REF when macro changes formulas to values
  15. Excel Publish Event
  16. IFERROR(Vlookup) question
  17. macro queries
  18. MACRO TO DELETE ROWS
  19. Will accounts 2008 export data to excell as well as import
  20. Recording a Macro
  21. Changing Toolbar Image
  22. IF(NOW()
  23. Excel automation using VB Express
  24. subtotal bold
  25. Easy work from your home :
  26. Whats wrong with my code? This is a real challenge...
  27. Setting a Control Variable for a listbox
  28. Calling a macro in excel
  29. IF statements
  30. Download a spreadsheet with VBA
  31. Run Time Error, FormulaR1C1
  32. CopyPicture method (# 1004) failed
  33. Protection Macro
  34. Retrieving Pipe (|) delimited text file into ADO Recordset
  35. Dbl-Clicking anyfile.xls = excel basic grey screen
  36. Saving a worksheet to a new workbook
  37. Macro to display pictures
  38. checkbox1 value = true if range got data
  39. Excel to Access
  40. Delete Duplicate Rows, by Date field
  41. Error in loading DLL
  42. Re-entrant call to VBA
  43. put textbox data in sheet (sheet name selected in a listbox)
  44. label caption
  45. Macro writing formulas
  46. Use workbook name in Connection
  47. Search multiple strings in one text file
  48. UsedRange and LastCell feb08
  49. Can UDF modify worksheet(s)?
  50. list sheet tab names in listbox
  51. link textbox to cell
  52. Macro to Convert Data to Different Format
  53. Excel Autofill Showing Mondays ONLY in a calendar year
  54. Has Microsoft fixed Excel's Dependents bugs?
  55. Paste Macro
  56. VBA Click a link
  57. Triple Filter
  58. Formula Madness
  59. Automatically starting macros
  60. Oracle ODBC driver password
  61. 2007 Status Bar in Excel 2003
  62. FORMULA TO MINUS TEXT CHARACTERS
  63. reference to another sheet not in wkbk brings up dialog box
  64. cell range
  65. Calculating column 'J' and offsetting result in column 'L' on nextblank row (continue to end of sheet)
  66. macro question
  67. Stop VB from deleting modules from wrong file
  68. Selecting current range for pivot macro
  69. Why does a find wrongly return true when I search a variable?
  70. Code execution error
  71. im sorry to even go as far as asking
  72. worksheet cells displayed on a user form
  73. Export/Import custom toolbar
  74. Links to Update every 10 seconds...
  75. Changing of Sheet Codes for the worksheets...
  76. transpose cols to rows excel 2003 looping macro help please
  77. View a non-Excel file whose name is in a cell
  78. WAV files
  79. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  80. Select all rows in a date range
  81. Active Workbook
  82. excel help with min() fn reference
  83. Pages
  84. Convert GEDCOM file to excel lists
  85. Data form errror
  86. Identify a change in computers
  87. Average row of Data using VBA
  88. to print or not to print...
  89. unlock cells if value is...
  90. Macro runs in another workbook if you open simultaneously
  91. How do I get Excel to stop publishing?
  92. Casing of built-in property Font.Bold
  93. is it possible to have a common macro for Multiple workbook
  94. Multiple results from a table
  95. Form in excel
  96. Macro to delete 2 rows every 500 rows
  97. How to return the color of a cell
  98. Insert value in text box based on previous tselected value.
  99. Help with code
  100. Prevent Worksheet from being deleted
  101. how do I reference a cell in a previous sheet not by name, by orde
  102. Using VB instead of function for INDEX
  103. Is this macro scenario possible using VBA?
  104. my first macro - super simple for any veteran... help appreciated!
  105. Cancel Key Press Event
  106. Adding a Name range with vba
  107. give value of next column
  108. DirectDependents not working properly.
  109. Worksheet add
  110. Restrict access to only one sheet
  111. Set up shared bililng spread sheet
  112. What's the difference between .Dependents and .DirectDependents?
  113. Creating a truncated range- Speed issue
  114. Animated Gif89
  115. Control desktop Icon
  116. vba problem when grouping sheets
  117. Count mails in Excel
  118. How to Create an array
  119. Chart VB Code Syntax
  120. Printing x amount of pages if cell is greater than 0
  121. How to save existing Workbook with a new new name, without changingthe open Workbook name?
  122. Looking for answers
  123. Looking for answers
  124. RangeName Define Limitations
  125. Find and Replace
  126. How to undo ClearContents?
  127. dll File
  128. NumberFormat
  129. Worksheets("Sheetname").Select refuses to kick in from User Defined function
  130. Loop to Filter, Name Sheets. If Blank, Exit Loop
  131. close pdf file before closing excel
  132. Loading a formula from VB
  133. Paste a function using a Macro
  134. Code failure with different partitions
  135. Copy pasted name range
  136. Set Visible Cells To TRUE
  137. Application.AutomationSecurity stops calling macro
  138. Creating a button to execute a macro
  139. Type MisMatch with Set Statement
  140. Quick sort problem
  141. Looping thru sub-level of controls on userform
  142. find combination of cells that equals a sum
  143. Macro on Hidden spreadsheet
  144. Calculating Column and off setting calculated value to another column
  145. Error when opening up file in Excel 2007, but not when opened withExcel 2002
  146. Range help
  147. Include Blank Value In Validation List
  148. a slight syntax error...
  149. Help with Calling a subroutine in the ThisWorkbook Class
  150. Macros acting on a filtered list
  151. cond. formatting - border thickness
  152. How to "Scrape" currency conversions off web... Maybe using Google
  153. VBA Help
  154. forms toolbar greyed out
  155. Debugging managed COM objects being called from VBA
  156. Coverting strings to numbers and trimming trailing zeros
  157. IF formula?
  158. Get text from clipboard to string?
  159. Export to CSV via macro does not use local regional settings
  160. Macro Doesn't Run With Command Button, But Does Run With F8 Key
  161. Help to align FORMAT
  162. auto inserting thumbnails into an office program for web use
  163. Determine drive
  164. reference for OpenFileDialog
  165. Hyperlinking cells and macros
  166. How to feed a userform a variable to display in a textbox?
  167. Copy an entire row based on value in one cell
  168. Command Buttons
  169. Opening a csv file stops macro
  170. Compute length of a string in points depending on current font
  171. Protecting VBA (Excel) code
  172. How to interrupt code
  173. Need event for selecting a series on a chart
  174. Emailing a userform with its values
  175. Concatenating and Copying columns from 30 sheets
  176. Changing Excel charts pasted into PPT 2007
  177. Re: Chart Text Box
  178. Two macros at startup excel?
  179. Adding Column A for All sheets : Please HELP
  180. HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007
  181. 'INDIRECT'ly referred cell's own simple formula fails....
  182. What is VBA equivalent to Tools/Auditing/Trace Dependents?
  183. Add new record to Access using VBA in excel
  184. find location
  185. Relative cell value in function
  186. trading system and filter test
  187. Excel 2007 Print Preview button disabled
  188. Re: Quicker Counting
  189. calling VBA from EXCEL
  190. Vlookup that checks against two values
  191. Trying to Send a Keystroke to a specific Window
  192. tuncating a table in sql from excel
  193. Restoring Attached Toolbar
  194. Copying headers and footers between sheets
  195. Data to be transferred to new workbooks
  196. How do I create mathematical links from workbook to workbook?
  197. vba password protection
  198. Populating Values In One Table With Values From Another Using VBA
  199. import .pdf file to .xls
  200. uncheck a checkbox with a macro
  201. Excel 2003 Add-in with C# and VSTO 2005 doesn't show custom menu
  202. Stop the macro at the end of a certain column #2
  203. Saving Add-in in Excel 2007 (Global Macros)
  204. Calculating Age In VBA (Chip Pearson)
  205. Value in column
  206. find / findnext question
  207. Copy selected sheets to new book
  208. If a cell in a worksheet is less than Q...
  209. creating number sequence
  210. NEED MACRO TO GET BALANCE
  211. Autofilter - delete filtered selection
  212. How to paste clipboard into textbox sheet?
  213. Loop Help
  214. Faster way to read data from old file to new
  215. Help with passing data
  216. Trim Workbook Path?
  217. Find Executable Path with Excel
  218. Find specific values in three columns of a ws
  219. Copy logo from sheet1 to new sheet3-10
  220. Open PDF located in excel with macro
  221. Update Link Continue prompt
  222. Need help with IF
  223. Date in formula
  224. Printing last entered values
  225. VBA code with and / or statement
  226. Converting Excel to TIFF
  227. Excel 2007 Range.ServerActions Property displays read-only data
  228. Protect sheet and still copy
  229. Range Name
  230. Copy values only
  231. Image Loading
  232. DisplayFullScreen=False not working
  233. Code to find specific number and calculate
  234. Min If function by Part number
  235. find max value in one field, return values in other fields in same row
  236. Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)
  237. DataBase worksheet function
  238. The find function
  239. WorksheetFunction.Match applied on an Array
  240. Freezepane in new excel application
  241. Difference Between Range("SelectedRange").Value and ActiveCell.Val
  242. Please Help for Macro or Formula
  243. Can I create a file to send to other's that updates module 1?
  244. Hiding "modules"
  245. Struggling with List Box
  246. NEED MACRO OR FORMULA
  247. timing sensetive code?
  248. Passing ParamArray to another function converts it to TWO dimensions.
  249. AVERAGE FORMULA PROBLEM
  250. return the number of rows
  251. excel to sql server (frequently)
  252. Run-Time Error (8000500d) - The directory property cannot be found
  253. Using parts of a defined range for UDF
  254. How to "Quit"....Input Box
  255. Add sheet
  256. hide worksheet tabs
  257. OnKey when closing Workbook
  258. Macro to select files and then run different macro on selected file
  259. Select Method of Range Class Failed
  260. MACRO OR FORMULA NEEDED FOR CALCULATION
  261. Mouse Wheel Control with Combo Box
  262. Calling Excel using DCOM
  263. Quicker Counting
  264. Can't Display Userform
  265. Need help with handling localized currency formatting.
  266. How to keep a formula from being over written?
  267. Why does this macro fail (1004)
  268. Change a field and delete row
  269. Gauge/Dashboard Charts
  270. Macros deleted from an Excel,but I keep getting security warning
  271. Code for Error handling using F5 from debug mode
  272. Is it possible to send a "variable" to a userform text box?
  273. please help! Replacing blank cells from a userform textbox
  274. Pole value of Option buttons
  275. Template Question
  276. Combo Box
  277. find and replace name of links
  278. Macro or Formula for Calulation
  279. Click to show value in active cell
  280. Show which entries in Search Table duplicates or triplicets
  281. cell update includes original text
  282. Update excel
  283. excel update graph
  284. User form programming help needed?
  285. How to write data in array to range on worksheet
  286. Bypassing Excel's FTP login/password dialog
  287. Sharing/Exporting a custom tool bar
  288. Programming the Command button
  289. Fixed or floating command buttons
  290. Hide sheet
  291. hide sheet
  292. Custom CommandBar visible dependent on active sheet
  293. cell value from different worksheet
  294. ComparingColumns
  295. "can't enter break mode at this time" message when adding a projectreference
  296. Copy & paste...if
  297. Need assistance with simple Excel macro or code
  298. c.column returns a number - I need an "A" or "B" or...
  299. Probably too easy...change range to be one row down.
  300. Incentive Spreadsheet Problem
  301. Insert Autoshapes in excel
  302. Validation list functionality disappered
  303. Macro to export data to fixed width not saving right justifcation
  304. Select sheet based on cell value
  305. no empty values in inputbox
  306. Deleting a textbox
  307. Formatting a textbox
  308. Code not working correctly
  309. Request for Responders to Posts
  310. Dynamically load data into a pivot table
  311. VBE question
  312. LOCK THE CELLS
  313. copy cells contents to access form
  314. Reference to free-form textboxes
  315. Looking for Help in modifying a code
  316. Importing from Excel sheet with unknown name
  317. Calling an external sub dynamically.
  318. Adding a macro to copy worksheets
  319. Execute a Macro from one excel Application to another Application
  320. Copying of consecutive Rows, one at a time and pasting it in onelocation
  321. How to count number of different cell formats
  322. TIP # 17 Convert rows to columns & vice versa
  323. count of dishes that contain specific ingredients
  324. Ribbon UI onAction causes macro to run twice, with warning
  325. Hide Column without data
  326. Looping question
  327. tabs
  328. custom error messages
  329. what is wrong with my fun ,thanks
  330. Help needed with Error Handling
  331. Macro links to other workbooks
  332. Msgbox freezing in beforeprint module
  333. Essbase Add-in
  334. Issues with Combo Box change event
  335. SheetChangeEventHandler Problem
  336. scroll records with distinct value in column
  337. Inser row with the format from the row above.
  338. Please need your help
  339. Macro help needed
  340. Excel sheet protection
  341. limit on the delimited list for Data Validation.
  342. VBA Coding Question
  343. Copy Sheet into another workbook
  344. Sheets.Add Function
  345. cut and paste into cisco device (equivalent to pasting into notepa
  346. Create a report page???
  347. PivotTable: Need to detect when user selects new value for dropdow
  348. Excel spreadsheet to talk to mainframe
  349. Cost Sheet
  350. Excel and Visual Basic
  351. disable "unprotect sheet" in tools menu bar with VB
  352. issue when opening a workbook through a macro shortcut
  353. Macro to delete rows with matching Credits and Debits
  354. VBA Mod, Excel Floor, etc.
  355. Macro work - but don't think it is very efficient
  356. A Two-Level SOLVER ??
  357. Determining the number of open workbooks
  358. Accessing Outlooks address book via VBA embedded in Excel
  359. Options for replacing toolbars in XL 2007
  360. editing data in a database from a Userform Textbox.
  361. Calendar on userform is blank
  362. .IQY loop in VBA?
  363. udvidelse tabelmatrix
  364. vlookup or index match
  365. VBCompononts.Name...
  366. Stop baby eating in CHINA
  367. Cell Auto Fill from Range of Cells
  368. Error, Excel 2000 & 2003
  369. csv file convert to excel file
  370. Trouble opening file
  371. formula for vlookup 2 cells
  372. BeforeRightClick
  373. Check last two characters of a string.
  374. Color rows by "group"
  375. Macro ends early without error message
  376. Trying to delete existing unwanted horizontal page breaks
  377. need Macro
  378. Macro appears 5 times
  379. using named ranges in vba
  380. cells not registering as blank
  381. Specific use of INDIRECT inside VLOOKUP...
  382. Min IF Function Needed
  383. Need some help with this code:
  384. Excel Productivity & Charting Add-Ins: Suggestions? Recommendations?
  385. Hide all Sheets in Workbook then Close Workbook
  386. creating a macro to print PDF
  387. excel2k FormatConditions question
  388. Problem with code - Help
  389. How to clear Immediate Window programmatically within a procedure?
  390. Macro Properties Password Popup.
  391. How to see value of UDT variable while single-stepping?
  392. RE: macro does not work inside Excel 2007 #2
  393. COM Addin function
  394. Migration Project
  395. Help with Error
  396. "Object required" error
  397. Rosh Hashanah and Yom Kippur Holiday Dates Revisited
  398. sorting in multiple sheets
  399. Listbox finding the adress of the item
  400. convert hyperlink to email address
  401. Txtbox set focus
  402. creating a macro to add text to existing data already in cell
  403. Value not shown on selected ActiveCell
  404. Iterate over a Range of data - create arrays or ranges
  405. How to prevent Excel to paste data in separate cells
  406. substring check
  407. Using range names in SQL query
  408. Easy question
  409. protection not working
  410. Info onto Web page
  411. MACRO
  412. Looping Paste Special Value Transpose
  413. Receiving 'Error 1004' with VBA program
  414. Block Of Numbers Repeating in a Formula
  415. Status & Formula Bar Disabling Prevention Among Other Opened Workb
  416. don't allow excel event kill
  417. Hyperlink to TIF File - Not Trusted
  418. 2003 vs 2007
  419. Alternative to ShellExecute
  420. Creating task in outlook from a particular row in excel
  421. Range Selection help (Formatting)
  422. Sorting Question
  423. Use Code for Demo
  424. Protecting worksheet
  425. UDF returns #VALUE! when regional language setting not English!?
  426. Input Box Default Value
  427. Dimming Toggle Button
  428. Code To Send Mass Email
  429. Multiple Goal Seek
  430. Setting up a per unit bonus formula
  431. MIN IF Function
  432. Tools Menu disappeared??
  433. Autofiltering and copying selection to anotherworkbook
  434. command button invisible upon opening file
  435. Re: Updating Properties of a Control on a Worksheet - THANK YOU DAVEPETERSON!
  436. Prevent "Add-Ins" from appearing in Ribbon
  437. LookUp?
  438. Cell name
  439. Saving a single worksheet
  440. Creating multiple emails from one Excel file.
  441. Do Until "" Loop
  442. How to make this fire at every page break??
  443. Stop the macro at the end of a certain column
  444. How to create a list of dates (not including weekends)?
  445. Userform TabStrip questions
  446. is it possible to pass a reference to a function as an argument
  447. checkbox property
  448. indirect address offset in array formula
  449. IS there a way???
  450. find a value in a column, if it matched, highlight that column
  451. Cursor Position After Sort Operation
  452. XLL programming for Mac.
  453. Exists similar function to the PROC but that it returns the super
  454. Write text data to text file without quotes
  455. Existe uma função parecida Ã* PROC mas que devolva o valor superior
  456. Command button "selected"
  457. Drawing a Circle
  458. User selection from a chart
  459. Copying from one cell to another cell
  460. Copy + paste macro
  461. Updating Properties of a Control on a Worksheet
  462. Excel 2007 - Drill-through action called via VBA locks the workshe
  463. Min If
  464. Need help in Excel Programming
  465. MS Query and Integer fields
  466. Update links & calculations upon command
  467. Problem copying between worksheets
  468. Create muliple event procedures via VBA
  469. want help
  470. How to copy this to another cell exactly?
  471. Find a textstring in a "Range" - and then return a value iftextstring is found.
  472. Auto complete cell from a list of choices
  473. How can I send file by different email address (to; cc and bcc)
  474. What is planned to replace VBA?
  475. Insert Row without affecting page breaks
  476. How do I create an alert in excel programme
  477. Searching and adding in a closed file
  478. Naming modules
  479. Macro for copying and pasting values based on criteria
  480. Make global Macro/Add-in for all active Workbooks/Sheets
  481. checkbox1 linked to sheet1 a1
  482. time elapse on userform label caption
  483. Find number - where did I go wrong?
  484. Macro If Then Question
  485. converting dates to iranian and islamic calendar
  486. Losing Module Level ENums in Excel 2003
  487. FileSearch to locate the latest (last saved) file
  488. capturing current range of cells
  489. Special effect on User form
  490. Custom Worksheet Collection
  491. For What kind of computer was Excel created?
  492. Drag picture
  493. Anyone know how to program transfer of CSV data to web page form fields?
  494. Displaying published htm file from remote share
  495. Sum after every blank cell
  496. Pivot Table Refresh Updating all to same data
  497. Case Statment in Err trapping
  498. display userform4 for 30sec's
  499. Macro
  500. Displaying question
  501. Range VBA: double entry table
  502. Range vba: double entry table
  503. Function to find last value in a column
  504. function to find last value in a column
  505. GetValue from closed workbook
  506. tutorial needed
  507. Two short questions
  508. Type Mismatch
  509. link checkbox to cell
  510. Renaming individual columns
  511. Please HELP me!!
  512. Zoom in/Zoom out picture
  513. if internet on then ... else ...
  514. stop command does not trigger
  515. Workbooks.Open oddity
  516. Print user form and add menu bar to the form
  517. UserForm ComboBox
  518. Range as Variable
  519. Excel data types
  520. addition to a remote cell
  521. Make PivotCaches.Add(SourceType:=xlExternal) from VBScript code
  522. Autofilter Check
  523. Format a number field as text
  524. Turn of Autofilter Arrows?
  525. PivotTable with all row label visible
  526. problem with Excel file created programmatically
  527. Stop Recording Macro
  528. Summary based on field indentifier?
  529. Update check box from cell
  530. Tip #16 Double-click your way to fast formatting
  531. range and variant
  532. Prevent Copy action Q
  533. Allowing xlBook.SaveAs in Access code to overwrite existing workbook?
  534. named cells
  535. VB code is not shown when recording drawing objects
  536. Update from Excel 97 to 2007
  537. Type mismatch error only on the first run
  538. calculating working hours between 2 dates
  539. How to suppress XML import error message
  540. Image (Picture) from Excel Cell Data?
  541. Define Print Area using Variables
  542. security Level settings in Excel
  543. Placing a formula in a cell of an unconstant row location
  544. Context sensitive hekp
  545. can't undo Full View with macro
  546. Performing a Macro within a range
  547. Before Print Problem
  548. Discontiguous Chart Source
  549. SQL.REQUEST in Excel 2002 not supported in 2007. What is new func
  550. making listbox without horizontal scrollbar
  551. Process a range from bottom to top
  552. launch excel, auto-open second excel file
  553. Different Macro behavior when called from Immediate Window vs. She
  554. retrieve data from web
  555. Another Excel Problem
  556. Feed Multiple Comb Boxe with same list
  557. Ready Calculate
  558. Hiding a PivotField
  559. Hide or delete "Add-Ins" in ribbon
  560. Call to Sub Routine which exists in seperate workbook
  561. Code Help Needed
  562. how to test if range object target deleted
  563. Macro Enable after Disabled
  564. Force cell to have Accounting Formate
  565. Keeping whole formula constant to new workbook
  566. Progress Bar
  567. replace string
  568. Problem with locked file
  569. confine cells to two digits
  570. vacation.pto calendar
  571. Excel 2007 VBA - Run-time error 1004
  572. I get error on adUseClient why?
  573. still having trouble
  574. Odd Save As behavior
  575. Row number of cell containing specific text
  576. Need to move last number in a column
  577. vba Cancel Save As
  578. VBA Sum returns Wrong Format
  579. Select a Range By color
  580. The name ... either conflicts with a valid range reference or isinvalid for Excel.
  581. Multi Dimensional Array
  582. Excel 2003 Dates - Strange behaviour
  583. Excel 2003 Dates - Strange behaviour
  584. Alphanumeric Recognition
  585. Find Text, Add Border 6 Columns to Right
  586. Add Item to Recenly-Open Files
  587. Locked for editing problem
  588. Build a Worksheet that pulls info from other Worksheets
  589. Excel to Schedule Task in Outlook
  590. Closing temp worksheet without saving
  591. Shell Out Failing
  592. Need Class Module examples...
  593. Persistent Storage for Add-Ins ?
  594. Starting Excel and doing "stuff"...
  595. Power API
  596. Variable File Name Activation
  597. XL2002 - trigger sheet event BEFORE deactivating
  598. saving open workbook to text string in cell
  599. Excel 2007; OutlineLevel-Problem
  600. Option Buttons
  601. Run macro in background
  602. Remove a line from a text file
  603. Delete defined text in a column
  604. Chart sizing
  605. Master's please help me with my code; Doing a loop to copy valuesfrom a series Sheets of another workbook..
  606. Avoid displayalert message while opening file
  607. No double space
  608. "End" Button for Error Messages
  609. combobox change fires on workbook close when textcol <>1 or -1
  610. Teaching Excel
  611. Add Userform Image from Cell Picture Address
  612. Find a string within a string
  613. Set EnableAutoRecover to False
  614. Display alert if data exists
  615. totaling criteria
  616. Re: How to make a selected row visible in the Window?
  617. offsets - using ranges
  618. Selecting range of cells to copy using a variable
  619. IsEmpty - what's the opposite?
  620. Lookup in VBA
  621. Last Used Cell
  622. Rosh Hashanah and Yom Kippur
  623. Variable causing subscript out of range error
  624. Delete Sheet without Warning
  625. SP3 and RefEdit Control
  626. Create header/footer txt file and link to Excel worksheets
  627. Macro copy of variable ranges in one sheet to table in another she
  628. defining a variable containing quotation marks
  629. formula
  630. Adding a WHERE statement
  631. Named ranges and links
  632. Selection.Copy used in a variable.
  633. Function used in conditionnal formating not using good language...
  634. Dba query filter taken from Excel
  635. userform
  636. Custom Save As
  637. group (add) numbers without exceeding 168
  638. SaveAs produces subscript error
  639. Hide Buttons When a Cell is False
  640. Delete Last 10 Rows in Worksheet
  641. Check if workbook open (Not working)
  642. Excel Problem
  643. Selecting a dynamic name
  644. Isolate group of names from Drop down list
  645. Custom Save As
  646. Using Variables in R1C1 formulas
  647. VBA solution required?
  648. Capture Excel close
  649. Sheet Tab Color, Excel 2000 & 2003
  650. vlookup in VBA - 30 sheet lookup
  651. using a formula in a program
  652. How to update Shape pictures
  653. List objects and Buttons
  654. date function
  655. Type mismatch passing arrays via COM
  656. Excel Shapes selection problem
  657. Before Close Event Hide all Worksheets then Close Application
  658. The Great Gatsby- Importing multiple external data files
  659. force a selection from a list of words
  660. SQL Problem
  661. vbMsgBoxSetForeground
  662. Unable to loop on Excel collections. Error 451.
  663. AxInterop.OWC11.dll license question
  664. 2007 cannot enable macros?
  665. manipulating arrows
  666. Re: How to make a selected row visible in the Window?
  667. sheet selection via user click (yez)
  668. Double Click Event Error on Worksheet
  669. Selecting only some characters, using "characters property"
  670. Excel Add in - VSTO on Pocket PC/Windows CE
  671. security warning
  672. Opening/Closing Large Files
  673. Lock a named range
  674. INSERT ROWS
  675. Help Fixing a Macro
  676. Combine several macros
  677. GetOpenFilename and filter "*."
  678. How to make a selected row visible in the Window?
  679. Export comments to document
  680. How do I link Excel to a dynamically column named access table?
  681. Macro does not work inside Excel 2007
  682. Cannot Edit Active-X Control
  683. Code to check errors in excel 2002
  684. Calculation/Number Bug in .xls? Any ideas?
  685. Re: Seeking advice for complex charting algorithm (16K attachment)
  686. Opening Word Docs from Excel VBA With full path and name > 255 chars
  687. Handling Errors When Opening Word Docs From Excel VBA
  688. Code seems to have not copied fully
  689. Importing data seems to interfere with auto-scheduled macro
  690. Issue removing leading and lagging spaces
  691. Sort by changing number
  692. Set CommandBars Dropdown value
  693. duel criteria seach
  694. 2 parrameters to filter
  695. Create named ranges in Column on worksheet
  696. Excel ScrollBar - Don't Move or Size with Cells ...
  697. Can't create workbook with VS.NET 2005
  698. How to add the same cell in multiple worksheets (with VBA)?
  699. checking a range for at least one
  700. Can you copy a worksheet from a workbook wothout opening it?
  701. CutCopyMode -- What workbook was copied?
  702. Passing Null Value to Range Property
  703. Can't get the macro to continue through a range
  704. Vba Vbe export
  705. Help with macro comparing data in worksheets
  706. Determine if Carriage Return or Tab key is used
  707. editing data in database from Userform textbox
  708. active workbook/sheet
  709. Custom Header
  710. Copy/paste new worksheet to master worksheet
  711. mail sheet as body from userform
  712. Math headache
  713. RANGE MACRO
  714. New funny recruitment video for Microsoft..
  715. Schedule downloads in VBA
  716. InputBox buttons
  717. Find checkboxes and then check them
  718. workbook_open() sub does not work
  719. Connecting to Access
  720. Macro Fault on Custom Ribbon
  721. Error Msg when opening Excel 2007
  722. Selecting a range after activating a worksheet
  723. Code loops to death every time I attempt to add a string to a cell
  724. Create a user-defined function
  725. xlDialogImportTextFile txt file name
  726. Macro to format text
  727. having trouble disabling "save", "save as" (2003)
  728. add names
  729. Formula to VBA function (if and lookup)
  730. Taking info from all sheets and compiling it without spaces
  731. Copy/Paste Charts; Define Destination of Charts in PowerPoint
  732. Groups in Option buttons
  733. Next Worksheet in code
  734. Determining if Button on worksheet is hidden
  735. macro comparing values from 2 worksheets
  736. E-mailing from Excel Q
  737. disable shortcut key from menu control
  738. Date Format
  739. Solution: MSXML2.XMLHTTP with a TimeOut Value
  740. Beginner stuff - Adding look-up box to spreadsheet
  741. PC and Mac
  742. loading automation add-in for an instance of Excel
  743. Count and list items that are due
  744. error
  745. Networkdays function
  746. autofilter
  747. Form not found
  748. Using autofit on cells which include ASCII 10 (LF) character
  749. Examples of "Front Office" usage of Excel
  750. Activating an open work book from text in a cell