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. Re: C#NET2008 Excel Merge Cell Problem
  2. Re: C#NET2008 Excel Merge Cell Problem
  3. Declaring variables programmatically
  4. Conditional copy and row insert based on criteria
  5. Excel, Python, Linux
  6. Compating all rows in two sheets
  7. Get results from Access Database.
  8. inserting trademark in excel 2003
  9. Select Previously Selected worksheet (and/or select previouslyselected workbook)
  10. What If a Table has a Million Rows?!
  11. How to group my students using Excel
  12. Range reference in array formula
  13. Silverlight
  14. running macro from keystrokes versus from ribbon
  15. Excel hangs
  16. Excel VBA Training Courses
  17. Re: Times before noon show different
  18. Re: Times before noon show different
  19. linking data
  20. Looping through Non contiguous cells in a row
  21. Re: Change Cell Background
  22. Change Cell Background
  23. Re: Change Cell Background
  24. Run a recorde macro in multiple excel workbook at a time
  25. Problem with file path to sharepoint
  26. Insert Excel Data in Oracle
  27. Excel Database Readability in Linux?
  28. Conditional borders
  29. Microsoft Internet Controls
  30. trend data, with twist
  31. Updateing file links
  32. What does " " turn the cell?
  33. Help with text file
  34. Does M.S. Project have to be installed in order to use the ProjectObject Reference within Excel to grab read-only data from .mpp file?
  35. Conflicting functions
  36. VBA to write Excel data to Oracle table
  37. Average/Sum formula with offset
  38. issue embedding 2003 xls vba objects with powerpoint 2010
  39. Capitalise on Input Q
  40. Anyone speak Japanese excel?
  41. MS Excel VBA Interview Questions & Answers
  42. From 2 predefined test data ranges, how do I detect which one has a anon linear trend through Excel VBA ?
  43. Do Until - If-then problem
  44. Problem using Range objects
  45. Can't create a new instance of the Range class
  46. Sum Dynamic Range
  47. Recognize currency in a cell
  48. Find item in column Copy to new location
  49. macro listing subfolders from selection of mainfolders
  50. Trying to print specific worksheet from outlook attachment
  51. variants and freeing bstr memory (C++)
  52. Excel 2010 crashes on Workbooks.Open for csv file -- sometimes
  53. DLL not available in system32 folder - vista/excel 2007
  54. Web Automation, Form Filling, Web Scraping with Excel
  55. VBA Save As problem with file that already exist
  56. Pasting to a new page on existing sheet if not enough rows on the page
  57. Attach to RTD communication (.NET)
  58. Manipulating embedded excel charts in Word
  59. Frames Scroll event causing cursor to move to first textbox
  60. Populate list or combo box from closed workbook
  61. Simple userform tutorial
  62. Creating UserControl with VB6 for excel
  63. Existing sheet formatting removed when changing active cell border color
  64. custom function - finding cell address
  65. ListBox Remove Certain Text
  66. how to store a macro to be available to all workbooks
  67. block of quoted lines
  68. How to change active cell border color in Excel 2007
  69. Remove Blank values
  70. SHRINK/REDUCE EXCEL FILE SIZE
  71. Multiply Corresponding Values in Range
  72. Convert Excel IF ISERROR formula to VBA
  73. Save dialog box
  74. Differences among VBA in Excel 2007 and 2010
  75. Subtotal by VBA
  76. Finding the maximum in an array of strings (Excel VBA)
  77. combo box - last value
  78. Using Collection to also capture range adjacent
  79. Formula problem
  80. Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails?
  81. Excel 2010 Component Id
  82. Excel 2010 Component Id
  83. Excel 2010 Component Id
  84. Delete Entire Column
  85. Summing Criteria with Index - Match
  86. PasteExcelTable does not work in OS X
  87. Drop down list - link to another worksheet
  88. Filter with an IF, AND, NOT formula
  89. Emulating Ref Edit in VB6
  90. referring to texbox
  91. VBA date conversion
  92. Solution for Application.FileSearch Excel 2007-2010
  93. VBA form imported into VB6 project
  94. INDIRECT Syntax
  95. Merging Multiple Named Ranges
  96. Macro errors when upgrading to windows 7
  97. Macro question: Using named ranges
  98. SofTeC 2010: Calling all Testing Professionals, Managers, Leaders[Nov 20th, Pune]
  99. Beforeprint not executing
  100. Save dialog box
  101. Run-time error '381'; on Listbox remove item - (Please Help)
  102. How to Schedule a VBA Macro?
  103. Save box / file name
  104. Prevent Coping/Transffering item twice from Listbox1 to Listbox2
  105. CheckIBAN
  106. HELP - Radio buttons and other controls suddenly moving in Excel 2010 only
  107. SofTeC 2010: Calling all Testing Professionals, Managers, Leaders[Nov 20th, Pune]
  108. Listbox
  109. special characters, other multi-language gotchas?
  110. Save data to closed workbook
  111. workbook open password protected
  112. Password protected sheet
  113. Calling subroutine defined in another workbook (autostart workbook)
  114. controls and dynamic events
  115. controls and dynamic events
  116. CSV decoding line-by-line
  117. How can I transfer information from Excel to Outlook?
  118. Subscript out of range
  119. SUMIF with the criteria range
  120. Data Table
  121. noob problem - Conditional hiding.
  122. Inserting 2 columns when cells don't match
  123. make a named range with an array not using a workseet cell range
  124. make a named range with an array not using a workseet cell range
  125. make a named range with an array not using a workseet cell range
  126. make a named range with an array not using a workseet cell range
  127. make a named range with an array not using a workseet cell range
  128. make a named range with an array not using a workseet cell range
  129. make a named range with an array not using a workseet cell range
  130. make a named range with an array not using a workseet cell range
  131. make a named range with an array not using a workseet cell range
  132. make a named range with an array not using a workseet cell range
  133. make a named range with an array not using a workseet cell range
  134. make a named range with an array not using a workseet cell range
  135. .find does not find if .NumberFormat = "#,##0.00"
  136. Move Column Values to Rows - THANKS in Advance
  137. Cleanup this macro please
  138. Lookup?
  139. Make this into a toggle command? [XL2003]
  140. Howto populate a column with values coming from another sheet
  141. Combining Procedures into Loop
  142. closing a vba project - dumb question
  143. Export to txt file using VBA
  144. Using VBA to move system files
  145. Set macro security level to 'low level' on opening a certain workbook.
  146. Automatically select entire rows on pressing down and up-arrow key
  147. Code Snippet - Activate VBE window
  148. Problems automating Word from Excel
  149. Chartspace & Excel2003
  150. Protect each worksheet individually
  151. membercode check
  152. Re: Pivot Table problem
  153. Save All Worksheets as CSV
  154. Association between cells
  155. Delete duplicate rows
  156. loop using double
  157. Why you should change your vehicle to flex fuel
  158. How to embed INDIRECT.EXT into workbook Excel 2007
  159. On Error Resume Next not working (2010)
  160. Delete duplicates based on time
  161. How to separate on very long line of code in VBA
  162. User input into cell formula?
  163. Which zones are touch given this range
  164. Help with pseudocode translated into VBA Code
  165. Excel VBA Multipage
  166. Option buttons not responding
  167. ProgressBar control in 64-bit Excel
  168. How to use MS Flex Grid in Excel vba form
  169. ResetAllPageBreaks
  170. issues with getting .pdfs to be created
  171. Ensuring Macros Are Enabled
  172. Is there a better way?
  173. How do I view/edit code on Excel 2003 Worksheet Command Button
  174. conditional sum
  175. Why would End(XLup) stop working??
  176. OPEN EXCEL - Needs your support and enthusiasm...
  177. Timing Macros
  178. paste value column based on first cell command button
  179. How to Reference a VSTO AddIn
  180. Intersect and Union
  181. Multiple Conditions - VBA
  182. Read smarttag value
  183. Comment Box Placement
  184. How to copy one worksheet vith command button???
  185. macro using forms button
  186. Non Uniform Random Number Generator
  187. Re: Application.dialogs and PDF - again
  188. VB coding for complete cell copy rather than what ^C does?
  189. non-repeating Comboboxes values
  190. class module and encapsulation
  191. Re: Application.dialogs and PDF - again
  192. Re: Application.dialogs and PDF - again
  193. Can you change the font and font size for a forms control ?
  194. Can you change the font and font size for a forms control ?
  195. selecting a range
  196. copy and paste 3 rows run macro and continue to end of columns
  197. Test if a user defined chart name is valid
  198. Import CSV Data from Outlook Public Folder
  199. End(xlDown) giving me blanks
  200. End(xlDown) giving me blanks
  201. Re: Formatting currency with the cents but without the decimal point
  202. What is the difference between 'Select' a sheet and 'Activate' a sheet
  203. Wanted: Business end of Excel
  204. Populating 2-D array w/ Application.[Function] results
  205. VBA vs C#: filling a spreadsheet with random numbers - C# 4x slower...
  206. Placing picture with code
  207. Delete Rows as per Text, Font Color, Font Type, Time Format
  208. RDBMerge ADD-IN
  209. Setting a cell's color based upon RGB values
  210. Text box value to userform
  211. loop
  212. Seconds missing from time/date properties
  213. Userform Save data To Worksheet & File
  214. Events
  215. What happened here...?
  216. Filter, Delete and Error handling - need help
  217. Pick from drop-down list gives empty or erroneous result
  218. Sort current range by column j
  219. Change DeleteValue1 to named range
  220. Help with DoEvents to show progress form, please?
  221. How can I sum two arrays together?
  222. VBScript help
  223. Remove cell from range
  224. Go to next row depending every nth iteration
  225. Run-time-error 1004 "ListIndex method of listbox class failed"
  226. What is the new object name after copying & inserting line?
  227. Conditional Formatting
  228. Macro to modify property of an object
  229. Match and Range Reference Syntax
  230. Re: In Excel 2007 where is the Personal workbook saved?
  231. Hierarchy of Codename and error catching if no worksheet.
  232. .Lookin through Outlook
  233. Mistery Link
  234. Pickup Data from a Worksheet
  235. VBA editor doesn't prompt to save changes, doesn't save
  236. Why is my .Findnext not working?
  237. Best way to run Find or Vlookup down specific column in range
  238. Kind of a "reverse" Vlookup; or please help me use Find instead
  239. Kind of a "reverse" Vlookup; or please help me use Find instead
  240. Index and Match - Errors
  241. help with sumif formula
  242. interior colored cells counting
  243. VBA handle on a C# ribbon
  244. Format Telephone Numbers
  245. Re: Automation and XLL add-ins
  246. Re: Automation and XLL add-ins
  247. Re: Automation and XLL add-ins
  248. Re: Automation and XLL add-ins
  249. Add a sub folder
  250. increase / decrease font size based on value in cell having a formula
  251. Even procedure in xla
  252. save worksheet data to alternate closed workbook - next row
  253. Referring to ranges as Cell, Range, and variables
  254. Using a function to return a populated array
  255. Define a Range based on a Range object
  256. copy/paste records into different sheets by status
  257. Search Target <= in Col. "B" to return Date in Col. "A"
  258. Search Target <= in Col. "B" to return Date in Col. "A"
  259. Referring to Range addresses when in variables
  260. Worksheet_SelectionChange Not Firing
  261. Populating one sheet with specific data from another sheet (I'm dumb)
  262. Excel prompts for VBApassword after saving workbook under new name and exiting excel
  263. CommandButtons moves to another place in office 2010
  264. Loop don't work
  265. Change definite value to string reference for criteria
  266. compare named ranges and list duplicates
  267. Date format.
  268. Insert rows in grouped sheets
  269. activesheet.name ending in "-" &Style1
  270. Counting and deleting duplicate rows
  271. Strange pasting array to cells behavior
  272. Quarterly Analysis in Excel
  273. Highlight row and insert text on click
  274. How to build a bulletproof application Using excel
  275. Open File in Skydrive through VBA
  276. VBA to Extract time that user logged onto Windows
  277. Semi Autofilter code
  278. Convert Conditional Formatting to Conventional Formatting
  279. Set range, perform operation, set new range, repeat
  280. Code help
  281. How to get the available languages (MUI) of Excel using VBA?
  282. Using VBA to close a running application
  283. Excel 2003 autofiltering options from a userform
  284. How to structure specific macro task, oop or procedural approach?(Excel 2003)
  285. Limit range of values for integer
  286. How to deploy my new addin
  287. Personal Macro Book
  288. Working with moving dynamic ranges
  289. parse csv file contents into powerpoint textbox Autoshapes
  290. scrolling 2 frames simultaneously
  291. cell comments, hiding columns, "Cannot shift objects off sheet"
  292. Code deletes first row/headers.
  293. Create new worksheet and use a number as its name..
  294. Re: Totals rows shouldn't become invisible when filtering
  295. Dynamic Names
  296. Re: Totals rows shouldn't become invisible when filtering
  297. Payment Coupons
  298. Personal Macro Book
  299. Total by Invoice Number
  300. Vlookup using array ?
  301. Dynamic Names
  302. Re: Totals rows shouldn't become invisible when filtering
  303. 2007 Table
  304. Use VBA to Populate Listbox from Open Spreadsheet
  305. On-screen buttons turn to white
  306. loop through class module
  307. Import Excel to Access (used range only)
  308. Apply Alternate Shading to selected rows
  309. Excel model - Very fast first time - Very slow second time
  310. Find a date in list less or equal than target date
  311. Duplicate Entries
  312. Find Running Total Value or % at a given Target Date or vice versa
  313. Range object causing Sort to fail
  314. Re: How to change a device name into a resource name and v.v.
  315. using two cell references to make up the save as file name
  316. Stopping a macro to edit the template then re-saving the macro for use
  317. Stopping a macro to edit the template then re-saving the macro for use
  318. password protection
  319. Picture on comment
  320. Generate Subtotal Summary from Sheet1 into Sheet2
  321. Saving templete / workbook to a specific drive / file...trying again
  322. Change file name when saved to C drive
  323. save as cell A1 to to a specific drive
  324. Conditional formating question
  325. Can I do automation on Access if the database is open?
  326. UTF-8 File Opened in Excel from Firefox Browser
  327. Sorting columns horizontally
  328. Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ?
  329. Re: Help with Excel VBA code
  330. Copying used range from other sheets ignoring row 1
  331. Automatically copy files into folders
  332. Re: Help with Excel VBA code
  333. Re: Help with VBA code
  334. count dates
  335. PERSONAL.XLSB will not load
  336. Mail Multiple Sheets via PDF Q
  337. Running a Macro periodically between Time A and Time B
  338. Referring to control value on form using variable name for control
  339. Saving templete / workbook to a specific drive / file
  340. Sorting problem : "The sort reference is not valid..........."
  341. #VALUE
  342. Re: ADO question
  343. Auto select worksheets - and goto a specific cell afterwards
  344. Charts.add or ActiveSheet.ChartObjects.Add doesn't work
  345. Group rows based on indention of string in a column
  346. MS Excel/VBA Macros Training for professionals in Chennai
  347. Convert dates
  348. Comparing dates
  349. VBA Public Function - Excel to PPT Stacked Chart, How to Remove Legends
  350. Add-in question: can I store default values for a form in the Add-in?
  351. Remove a criteria from countif based on user selection
  352. Re: ADO connection to a protected workbook?
  353. How to "freeze" all cells in Excel sheets?
  354. counting a specific "text" occurance in a selection of sheets withina workbook
  355. Re: Restore a range of cells to "empty"?
  356. MACRO to paste row into next empty row
  357. Macros I want dont appear in the customise box to drag to a toolbar
  358. group of worksheets in a workbook
  359. group of worksheets in a workbook
  360. countif - in an entire workbook
  361. Re: ADO connection to Excel 2007 *.xlsx files?
  362. Re: Using an ADODB.Recordset in Excel 2007
  363. find
  364. MS Excel VBA Copy and Paste from external workbook data to central worksheet
  365. Re: IBAN Number
  366. converting excel VBA macros to VB
  367. Excel 2007 Ribbon Will Not Re-Validate Unless Excel Window Has Focus
  368. Can I import 2003 .xlb definitions into 2010?
  369. Re: Searching a group of Excel workbooks.....
  370. How to import events VBA code in Excel?
  371. EXCEL 2003 file doesn't update certain cells
  372. Re: Searching a group of Excel workbooks.....
  373. Transpose & reorg data from 2 WS to new WB
  374. Re: Any way to know when my worksheets get opened at remote location?
  375. Change Pivot Table Filter Based on Cell Value
  376. How to program with this problem
  377. How to compare two spreadsheets
  378. How to get a MsgBox to pop up if I have VBA write a wrong link
  379. ThisWorkbook.Close crashing Excel (2010)
  380. writing macro to match the group and age
  381. Good way to open a .txt file, copy/paste all text into Excel?
  382. Excel reporting
  383. Expose Function Fieldnames to VBA
  384. chart objects top
  385. countif and vlookup
  386. Help with code restricting TextBox entry
  387. Filter between Dates
  388. Resetting autofilters
  389. Programatic access to VB-editor not trusted
  390. Substituting zero values in blank cells
  391. ActiveX Properties missing from menu
  392. Excel 2003 VBA In directory Open Spreadsheets Extract data
  393. Re: Strange CopyRange behaviour
  394. Spreadsheet object in VBE appears with the ThisWorkbook icon
  395. Re: Strange CopyRange behaviour
  396. sheet cycle macro
  397. Conditional Formatting Weirdness
  398. Require user to enter numeric value in TextBox
  399. MsgBox problem
  400. Retrieve Excel Colors
  401. DropDown List (Validation) from other worksheet
  402. Start Time to End Time... Minutes On Each Hour... How to distribute proportionately?
  403. Allow text in locked cells on a worksheet from a userform
  404. Option button enabled when tabbed to - how?
  405. SUMIF and SUMIFS Error
  406. Excel 97 Mouse scroll-wheel stops working after run macro- edited
  407. Adding a row with the previous one if....
  408. Macro to line up rows
  409. Mouse scroll-wheel stops working after run macro
  410. Pass xlworksheetId to VBA
  411. *Click And Fill Form Instant Get $3000
  412. Properly Saving a .CSV File With an 11 Digit Numeric Field
  413. How to extract & save an image from an object?
  414. From WebPageA to WebPageB: Error . . . windows opener document isnull or is not an object
  415. Why Insulation is a Good Investment
  416. copy text from textbox to another application
  417. Data Validation issue with two date entries Options
  418. ++outlook automation
  419. +++Outlook Automation
  420. PageSetup - Speeding up - Code snippet Requested
  421. Randomizer Modification Help.......
  422. Re: Copying a UDF from an Add-In module to a workbook.
  423. Calling Button click event from Form initialise event?
  424. Code to 'unbundle' and array
  425. QueryClose event of a form triggering Exit event of a textbox on that form
  426. Save with ref. to cell A1
  427. Using the Find method of a Range object
  428. sort duplicates in string
  429. Re: Excel range read/write
  430. Date and Timer Picker question
  431. quicker way to execute?
  432. Saving file with ref. to one cell
  433. Dynamic Nammed Range
  434. Saving a .xla File
  435. Signatures in Excel
  436. Runaway Macros!
  437. Filter on Day
  438. Text to columns and comma delimited text
  439. Re: Worksheet or Me. Why the difference?
  440. Mac Excel compile error method or data member not found
  441. Accessing VBA Group via NewsReader
  442. 3 csv file to one & linking to find unique rows
  443. x=inputbox
  444. User inserted value
  445. Select Named range
  446. Re: Better Understanding of XIRR
  447. fill range with formula
  448. Launching macros from the right mouse button
  449. VBA re Graphs required plaeas
  450. Running a Telnet session within Excel VBA
  451. Graph - Runtime Error 1004
  452. check if a cell contains a number, not text
  453. Re: Better Understanding of XIRR
  454. Re: How to choose Random rows??
  455. keyboard up/down arrows to select items in this list box
  456. Application.OperatingSystem returns what?
  457. Re: How to choose Random rows??
  458. AutoFilter Criteria using named range
  459. Re: Is cell outside printable area?
  460. Re: Is cell outside printable area?
  461. Changing File Name
  462. sending an array to Excel
  463. dropdown menu ? other ideas?
  464. Excel process still shows in TaskManager
  465. Autofilter Get selected cells value
  466. Adding string to PrintOut?
  467. Add value to the content of a cell with Vlookup
  468. User Defined Function - reformulated repost of an earlier question
  469. Exporting Worksheets from a workbook and saving them as a .prn file
  470. Exporting Worksheets from a workbook and saving them as a .prn file
  471. Macro speed decreesing after each run
  472. Template opens instead of copy
  473. .INI versus Registry
  474. Useform won't Show with dynamically added controls
  475. / key not displaying in cell
  476. Re: Check if UserForm is loaded?
  477. Better error message when a user enters a value in a form comboboxthat is not valid
  478. Using functions
  479. Energy Saving Tips
  480. Need vba code to Update Data in Powerpoint 2007 charts
  481. custom error message
  482. Project Code Communication
  483. If named sheet exists then delete it
  484. macro question
  485. adding verbiage to the end of a cell
  486. Re: Check if UserForm is loaded?
  487. Back up files? in excel 2007
  488. Clear contents of a 3-d (three-dimensional) range
  489. vlookup in VBA
  490. vba macro help!
  491. Code to display a true or false value in the cell containing a check box
  492. HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL
  493. Copying diagonally opposite value from the known cell/range.
  494. Converting European number formats
  495. VSTO Paste
  496. To Determine the 2D array
  497. Re: how to compare formula's values?
  498. Different uses of AND function
  499. Formula,Function, or VBA
  500. Print variable number of rows of spreadsheet
  501. Dropdown list from all worksheets name in a workbook
  502. Formatting macro runs real slow due to network printer - best workaround?
  503. Rank Data using VBA - having trouble with R1C1 notation
  504. Macro to retrieve values corresponding to the value selected in Dropdown box
  505. Re: Easy way to merge 5-6 columns
  506. Form, Dual Monitors
  507. Re: Easy way to merge 5-6 columns
  508. count duplicats, display incremental count, restart count at changein value
  509. Modify Ron de Bruin Code; Save Specific Files to Specific Folders
  510. Re: Synthetic Speech in Excel?
  511. Employee Schedule with multiple options.
  512. Square brackets to specify a range
  513. Excel File; CanCheckOut <> True in SharePoint
  514. CDO.Send failed to connect to the server
  515. Neat code for pasting filtered data to a separate worksheet
  516. macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activity log" .
  517. macro to fill cells
  518. Find a Pattern and Parse Text
  519. Opening PPT deck in background
  520. Re: Windows Query working on some computer, and not working on others?!?
  521. Re: Delete all user numberformat?
  522. Re: Delete all user numberformat?
  523. read the Windows version
  524. ead the Windows version
  525. How do I get something like IE > View > Source . . . Navigate therewith VBA
  526. Macros Disabled by 2010 Shared Workbook
  527. "Set" statement with variables?
  528. UCASE... with Office 2010
  529. Date Variable in Macros
  530. Save Preview Picture
  531. Compare Userform inputs
  532. Help with Cell Formula
  533. Excel sort ranks text above numbers
  534. Generating XML files vs. code page.
  535. Column is overwritten
  536. My excel Generated .tmp file
  537. Use "Tab" within a cell comment
  538. Post disappeared from this forum?
  539. Re: Running Batch File from within Excel
  540. RoundDown function not working in code
  541. VBA to read HTML; Search for TDelement
  542. Get filtered range into array
  543. trying to email workbook from VB6, getting error 1004
  544. Custom Form
  545. Successional Plus Signs - What's going on?!
  546. Reducing "Set" statements
  547. Macro to send Workbook as Email to Users thru MS Outlook 2003
  548. How to write a VBA function which returns an integer
  549. Dynamic chart problem
  550. How to use a subset of a range?
  551. All Workbook Saved except This Workbook - Part2
  552. Macro Help - Looping & Deleting
  553. Function Help
  554. help with highlight code
  555. UDF Not Recognized
  556. Convert a range of numbers to strings
  557. Can I use variables in the text portion of a message box?
  558. UDF function with Optional Paramters Problem
  559. Help with macro to populate blank values
  560. saving to WK4 registry error
  561. Workbook_BeforePrint Stopped Working
  562. Doube click cell to run macro
  563. Re: Import from a HTML file
  564. Dominate Mafia Wars
  565. Macro delete columns satring row 23
  566. Excel is Running Too Slow. Can I run a Diagnostic?
  567. Easiest way...use shortcuts and internet explorer
  568. All Workbook Saved except This Workbook
  569. Always on top and Deactivate event
  570. how to cread invoice tracker
  571. I am getting the following error message "Microsoft Office Excel hasstopped working", when I try to run a macro to load my Userform.
  572. Dynamic add formula
  573. Delete Method Of Range Class Failed Error
  574. Need macro to play sound in Excel 2007
  575. Limited Edition ghd IV Dark Black Styler
  576. Highlighting (formatting) 4 lowest cells in a named range to differntcolor
  577. trigger formula execution based on user entry
  578. Macro specifying file name when printing to PDF?
  579. Retrieving data from online excel spreadsheet.
  580. InputBox to resize all charts of active worksheet
  581. unhide Rows when question is answered via a drop down box.
  582. Re: Check if an Excel or Word file is "read only"????
  583. error 9 - related to an array - adding delimiters back to a cellvalue
  584. Re: Check if an Excel or Word file is "read only"????
  585. Not able to initiate printer from checkbox
  586. Worksheet_change or Worksheet_calculate
  587. VBA Validation between two Times
  588. IE
  589. Compare two worksheets in the same workbook and highlight difference
  590. Macro works but also runs original spreadsheet
  591. Create several charts in one go using VBA
  592. How to format cells to General via vba
  593. Excel open from VBScript does not display Windows pop-up when file inuse
  594. Workbook Page Numbers
  595. Cells(row, j).Interior.colorindex
  596. Force Recalc
  597. Exporting multiple tabs as .CSV files with the tab name being the folder and filename
  598. VBA equivalent for XLL?
  599. delete last-line help.
  600. Copy/Paste from Sheet to Browser; Then Copy/Paste from Browser toSheet
  601. continue processing a link has opened another IE
  602. consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet
  603. Automatically changing default formatting upon opening new workbook
  604. Import Word Table Macro running very slow
  605. slover for a 5x5 logic puzzle.
  606. Sum Columns with Specific Headings
  607. To color string of variable size
  608. VBA Code to run when any cell is updated
  609. AutoFit not working properly
  610. Macro to update on web refresh
  611. How to read the contents of an OLEObject (dropdown list) in excel
  612. Start value of dropdown
  613. Excel Recalc All except one sheet
  614. Building a formula from another cell
  615. Macro warning with no macros
  616. Grey Fill for all cells that contain a certain string in hyperlinkaddress
  617. from pivot table to vb array copy to new table
  618. Excel Macro delete certail column's
  619. WebBrowser
  620. I want to loop this macro
  621. How to properly read Value2 Range ?
  622. Programmatically identify a particular formula (VLOOKUP) in a cell
  623. Adapt this Directory Listing working code to insert a file namepattern prompt.
  624. Re: Transpose
  625. Saving a String as an html File
  626. VBA Excal start powerpoint on mix system of 2003 or 2007
  627. Excel Macro error
  628. Combine/Merge Rows, Multiple Worksheets
  629. message
  630. How to reference a file in a different instance of Excel?
  631. Printing page 1 from each sheet in workbook
  632. Getting Run-time error '445'
  633. Open CSV File
  634. Open a New Instance of Excel
  635. Getting to the bottom of it
  636. just trying to copy 6 rows to the right
  637. summing through end of row
  638. Lookup a value within a range
  639. To disable Right Click Q
  640. Re: Font selection dialog box?
  641. Delete all Excel workbooks from a list on worksheet on condition.
  642. Advance Filter data to store array
  643. Re: Autofilter with criteria from userform
  644. Cell to macro
  645. Adding multiple combo boxes to excel cells
  646. parse a string and do a simple comparison
  647. Convert A Formula to Value Until A Value is Met
  648. Insert rows by group and copy value
  649. how to avoid user to save in .xlsx
  650. if I create a BSTR in C++, do I need to release it ?
  651. Need macro code to pick data according to year selected
  652. Use concatenated String as input to Data Validation List
  653. excel ADODB.connection to itself ? how?
  654. Remove digits after colon
  655. Set a reference to a Workbook w/out opening the Workbook?
  656. I have created a vba script for a document registers
  657. IE automation
  658. Save a file to SharePoint
  659. List of objects with properties & metods
  660. For Dave Peterson
  661. Saving a CSV file
  662. Check an a file; SharePoint
  663. Copy with a macro
  664. PERL script for xlsx
  665. IE Automation
  666. compare column color row
  667. Macro to copy
  668. Open a file from share
  669. Problems copy data when using filter in place
  670. Multi Select List Box based on Advanced Filter
  671. Check a file into SharePoint
  672. How can I force a workbook to close?
  673. Trouble using VLookup in VBA
  674. Continue macro from current workbook
  675. Re: How to save a WorkBook to SharePoint?
  676. Re: How to save a WorkBook to SharePoint?
  677. How to save a WorkBook to SharePoint?
  678. Delete all Links via VBA
  679. Advance Filter with Multi Criteria
  680. Re: Next Without For
  681. Trying to recover deleted macros
  682. Populate Listbox on Userform with file names
  683. Macro Help : copy + selct
  684. Input Data to Webpage
  685. Shortening code
  686. Problem with date formatting
  687. Array by getrows to listbox - date format problem
  688. How to replace numbers in sequence without sorting?
  689. Count Number of CF Q
  690. Count Duplicates
  691. Re: Deleting blank columns
  692. Re: Deleting blank columns
  693. How to run macro from an exe?
  694. Free microsoft excel templates and macros
  695. Issue with Multiple Graph Creation in VB
  696. Control program flow
  697. Issue with Solver in Macro
  698. Automatically create names from values in cell
  699. Re: Copying 1 worksheet to new workbook with data and formats only
  700. Stop Auto Calculation Q
  701. Number of months
  702. Code for auto fill (\-) stopped working
  703. Help- Simple function fails working with pasted values
  704. Making Functions in a DLL visible to the outside world
  705. Progress Bar won't work in Excel 2007
  706. Split a text file with more than 65536 lines over many worksheets
  707. Loop within worksheet array
  708. Weird screen refresh problem in Excel 2003 - bits of differentworksheets display.
  709. keep duplicated numbers, eliminate single occurances
  710. download info from a web site to Excel
  711. All Combinations of cell values in a single Column
  712. counting CF cells
  713. Adding New Sheets
  714. Macro for Multiple Worksheets
  715. Macro for dialog box from pivot table
  716. Using a Table in my VBA User Defined Function
  717. Delete all Conditional Formatting Q
  718. Removing duplicates but leaving data on following rows
  719. Turning into normal proportions
  720. Lookup formula for retuning multiple values
  721. Group By Calculations and Labeling
  722. Can a Sub/Function print the names of its callers?
  723. Function created in VBA not listed in worksheet existing functions.Pleae Help
  724. Userforms & Excel 2002 Crashes
  725. Using XLM Macro Sheet in Excel 2010
  726. .FindNext problem
  727. Disable the cancel option while saving the excel sheet-Excel 2007
  728. Speed of Macro on 2 PC
  729. Best Excel Development Architecture? VSTO vs. VBA vs. VB.Net/C#.Netvs. ???
  730. Populating a form from a spreadsheet
  731. Combing Student list and Classes they took to one sheet
  732. ControlTipText
  733. VBA Macro in Excel 2010 - Curve lookup
  734. Calculating the current time in Excel 2007
  735. Select value on a cell by matching value of two cells
  736. need a macro to set the print range only for visible rows
  737. Re using same macro accross other spreadsheets
  738. Converting an Excel file to PDF Q
  739. Code to Remove Form Control buttons Q
  740. Transfer data from Excel Spreadsheet to Outlook
  741. Help with UDFs in Excel 2010
  742. Can you use ADO from Excel to run an Append Query in Access
  743. Combining formulas
  744. Macro to Call A Subroutine on a Sheet Sometimes stops?
  745. How to use Excel VBA Help
  746. Addin - Invalidate Error
  747. Mark if checkin date is within 30 days of checkout date where name isthe same.
  748. Return to Excel after Automatic Email
  749. Function to Sum colored cells values not working
  750. formatting problem