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: Pound NA problem
  2. Progress from Stored proc in Excel
  3. getting value of named range
  4. Fill in zeros within a specified range
  5. Hide Column based on Cell Value
  6. Merged Cells Causing Problem in Macro
  7. Combining Data from Multiple Worksheets into 1
  8. Array Variable for Month Names
  9. GetSaveAsFilename - file name is blank
  10. How to proceed
  11. Conditional text boxes on Form
  12. Userform appears behind other application
  13. Re: Pound NA problem
  14. CutCopy mode goes to False
  15. Excel PivotChart Field Buttons
  16. VB6 COM Add-In Ribbons defined in customUI XML not appearing
  17. Save as from right click menu (a bit off topic)
  18. Print Page Set up
  19. Timesheet Date Populating Problem
  20. Excel Automation
  21. Sumif Range to new Worksheet
  22. Dynamically Changing Pivot Data Fields with a Macro
  23. Workbooks.Close
  24. Matching Ranges
  25. Disable or hide Cancel button on Save dialog box
  26. A formula that's different on every row
  27. Como se realiza isso?
  28. Loop through image controls on worksheet
  29. Transpose paste with space
  30. Changes to Excel 2007 VBA
  31. "Condition" format based on Font color
  32. RE: Find Value of cell in another sheet
  33. CommandbarButton.Execute method not working for drawing shapes
  34. Cancel save dialog box
  35. More about trying to automation multiple Excel instances
  36. EXCEL PROGRMMING OR MICROSOFT PROGRAMMING QUESTION
  37. WorksheetFunction.Xirr problem
  38. Saving file overwrites AddIn
  39. Copy Patse Macro
  40. Click the Step Into button via code
  41. IF AND THEN Statement problem
  42. Posting in each row of a Summary sheet the sum of corresponding itemson another sheet
  43. In VBA, bump to next row each iteration
  44. Arrays
  45. insert cell value into string
  46. Application.FileSearch 2003 vs 2007
  47. Adding date to a column in Excel
  48. Re: Need help w using custom image for custom toolbar in Excel 2007
  49. Clear a sheet.
  50. Managed UDF Cannot Call WCF service?
  51. Hooking the FileOpen Event from the OfficeMenu in Excel 2007
  52. CommandBars in 2007?
  53. TreeView - How to add + and -
  54. Close a form when you click outside of the form
  55. Code to list concurrently open workbooks
  56. Duplicate Rows Based On Cell Value?
  57. How to click a cell with mouse and have a different tab appear
  58. Data validation on combo boxes
  59. Chart Macro Problems
  60. Undo a Worksheet_Change Event Causes run-time error '10'
  61. Creation of a form in Word and save the data to excel.
  62. Textbox Formatting Trouble
  63. Conditional Formatting Code
  64. create loop in macro for a list
  65. When I rename a module the keyboard shortcut stops working
  66. Accurate vertical scrollling?
  67. How to traverse subdirectories
  68. transfer the name of combobox to module
  69. dates to text
  70. save as error with no click
  71. SELECT * INTO[Text;DATABASE...
  72. modification of auto-multiple workbook macro, Ron DeBruin (Copy4)
  73. Code takes a long time to process
  74. Macro that needs user input to import excel files
  75. QueryDef; Error 1004
  76. Making a Summary from multiple worksheets
  77. Using Add-ins
  78. Table range coordinates?
  79. Hyperlink All Column Values
  80. Macro in excel
  81. Pushing/Writing data from one cell to another
  82. How to Dim Hummingbird HostExplorer
  83. Insert Column to the left in a list
  84. Range("A1:A10").Interior.ColorIndex = Xlnone
  85. SUMPRODUCT in macro
  86. How can I use "VLOOKUP" with different Table Arrays
  87. Dynamic Visibility of Charts Through Checkbox Selection
  88. Simple Excel 2003 macro not working in Excel 2007
  89. Delete Row if date is greater than or equal to 6/6/2008
  90. ThisWorkbook.FollowHyperlink....
  91. Macro for duplicating rows based on cell value?
  92. Make Enable Property = OptionButton.Value for all Controls in Fram
  93. OptionButtons with same GroupName not working properly
  94. list the pivot items into column a:a
  95. How to get the folder name of thisworkbook
  96. Worksheet arrays VBA
  97. rng.Count ====>results wrong value?
  98. TABLE filter net zero amounts
  99. Productivity tool for managing numbers in Excel
  100. Excel 2007 error after close down
  101. Dates and Times
  102. GetActiveObject("Excel.Application") for multiple instances of Exc
  103. Combo Box
  104. Cond format if Len() is greater or equal to 255 in a code.
  105. Insert Text to the cursor position of a Text box from another cont
  106. .Font.ColorIndex Delay Question
  107. If statement to add picture based on cell value
  108. How to keep Excel from formatting columns?
  109. Re: Settin up the default application to open hyperlinks in cells
  110. Creating a new worksheet and naming it according to a specific cel
  111. Macro to update hyperlinks?
  112. Enabled property failing when code tries to set it
  113. XL2007 Save Thumbnail
  114. Could this issue be specific to Excel 2003 ???
  115. Auto save at specific times with changing saveas name
  116. Refresh a cell that contains a formula
  117. Select Variable Range paste last row + 1
  118. How do I set up a weighted percentage formula in Excel?
  119. Compare value in column AP with value entered into one of COLs D-
  120. Status Bar more complex
  121. Find a cell value then read the next row as a record of columns
  122. PivotTable & PivotFields/VBA
  123. Combo Box value is null
  124. RE: Define a Variable
  125. Find previous active cell
  126. Adding page breaks conditionally
  127. TrimAll ; $nbsp; alt+0160; Cell View Add-In
  128. Stopping Find from wrapping around in code?
  129. Ignoring errors?
  130. VBA Combo Box for Excel
  131. Insert picture using Macro..
  132. Staus Bar
  133. Non-Sequential Count
  134. Number of colons
  135. A macro that counts cells when the conditional formatting formula =True. i.e. the cell is colored other than white.
  136. Pivot tables map to network drive?
  137. Data Type Declaration
  138. push recordset from excel to SQL server
  139. Data Validation
  140. Access Query from Excel VBA
  141. Fastest way to reference a particular cell?
  142. Print macro Excel 2003 used to work, now crashes
  143. write data to a closed file on network drive
  144. How to apply vlookup formula dynamically to a worksheet
  145. Text alignment in User Forms
  146. How to make a macro run every fifth minute
  147. Re: Strange behavior in Excel 2003
  148. VB Query
  149. Hide All Excel Toolbars, Menubars etc when UserForm Loads
  150. Prevent worksheet Rows to Delete.
  151. Call sub from Personal.xls
  152. Need to clear a fielf in Excel 2k7
  153. select case multiple conditions
  154. Splash Screen Timing
  155. Find, select, cut and paste
  156. Multi Select List Box - Checkbox
  157. RE: Looking for documentation/tutorial on Excel C API
  158. Marking a cell on click
  159. Update workbooks in folder, new name and save in new folder
  160. Data update
  161. Creating a new chart with code
  162. Controlling Entire Worksheet with VBA Function
  163. Problem with Range("a65536").End(xlUp).Offset(1, 0).Value
  164. Test creation Software
  165. How can i get xCellRef.val.sref.ref.rwFirst?
  166. Adding Rows on multiple sheets
  167. Going to sheet specified in a cell
  168. Interrupts
  169. Date formated as text
  170. Followup To Jim Thomlinson macro
  171. Data based on another tab
  172. Don't update
  173. Concatenate the lookup values from all occurences
  174. Save to CSV macro crashes Excel 2003
  175. Programmatically determining if a sheet is empty
  176. ftp
  177. controlSource ques
  178. Deleting rows
  179. Convert List - Hyperlink - Template - Auto Email
  180. run macro sequentially, across multiple workbooks
  181. Move a file
  182. Coding UDF's with VSTO
  183. vb Code
  184. Protected Formula Error
  185. Timer on Userform
  186. Processing Time Varies
  187. Merging user forms with spreadsheet
  188. Advanced Filter works in recorder but not while running macro
  189. HOW TO CHANGE RESULT WITH SAME MACRO CODE
  190. Irregular Shape - Follow up
  191. Convert xls to pdf
  192. EXCEL MACRO HELP
  193. Problem with RegEx and matches
  194. Who opened the file
  195. Save to pdf and make filename
  196. type mismatch error
  197. Clear pivot fields - please help
  198. ListView Control
  199. hide columns automatically
  200. Entering value into cell in macro
  201. VBA Debug Mode : How to I enter it after executing the nth data row.
  202. Help files
  203. Combobox
  204. Start up security
  205. HELP radio button not functioning in Excel 2007
  206. How do I use WinHttp within Excel 2003 Macro?
  207. Running balance table, monthly/year grid
  208. Header & Footer text
  209. Run Time Error 9
  210. Problem with password security
  211. Looping Text Import problem
  212. ListBox Conundrum
  213. MACRO ACTIVATED AUTOMATICALLY
  214. Saving as PDF and printing in a macro
  215. Sorting issue
  216. Export Excel Data to Xml Output
  217. Automatically change the line thickness of a row
  218. VLookUp
  219. InputBox
  220. General VBA Question Help.
  221. excel 2003 very unstable after copying a worksheet
  222. Can't manually open file after coding.
  223. Vanilla Ice vs. MC Hammer
  224. need help; unprotect + unhide + save with certain name
  225. Mouse Coordinates
  226. Date Validation
  227. Break Links But Keep Formulas
  228. test for number
  229. Problems using FormatConditions.Add with an Expression
  230. Selection.Sort problem with formulas
  231. How to programmatically set ControlSource?
  232. save existing file name, different format.
  233. Open All Files that Meet Condition and Save Renaming
  234. How do I retrieve data for the last 90 days?
  235. Macro to group data in pivot charts
  236. Sub to clear pivot filters
  237. solely search certain cells
  238. Macro which inserts new sheet name
  239. Hide row from Autofilter
  240. assign formula to variant range of cells
  241. Trouble positioning an autoshape object using .Top in Excel 2007
  242. I need help with sumproduct,
  243. 2007 PivotTable Type Mismatch for records more than 65536
  244. Calling a function from a Sub
  245. Using Regex to Physicaly Highlight Non-match with Font Color
  246. Break links VBA
  247. Need sample for reading value from and writing value to cell E53 from outside Excel
  248. Same Contents, Regardless of Order
  249. State Validation
  250. what is sumproducts cell limit?
  251. Embedding an OLE Object from DAO Recordset
  252. target cells in solver
  253. Send email from excel with image
  254. Missing objects in worksheet (e.g. command button)
  255. General questions about VB6/2005 and Excel 2007 compatibility
  256. Reconciling Lists
  257. Select all Matching cells
  258. Variable Declaration
  259. SIMPLE way to call code in one XLA from another?
  260. command button can't be clicked
  261. VBA empties clipboard
  262. Formula Problem
  263. SAME MACRO DON’T WORK ON (ActiveX Control) BUTTON BUT WORKS ON (From Control) BUTTON
  264. ado copyfromrecordset and nextrecordset
  265. Printing-don't need half this code but which half?:-)
  266. Open workbook and pass info
  267. help! macro textbox
  268. operate macro across multiple sheets, error, cannot locate solutio
  269. Getting text to overlap into other cells
  270. Help with a Macro
  271. Writing Macro in Excel 2002
  272. Complex Summation
  273. Stop Macro if file is already open
  274. transfer a macro to the personal macro worksheet
  275. Frame
  276. ShellAndWait Query
  277. Variable Row Numbers
  278. Send Values from TextBoxes to Specific Sheet on Network?
  279. If active sheet and cell reference
  280. Returning result as 0 from #N/A
  281. 2008 East Coast US Excel User Conference
  282. Jet 4.0 ISAM Error
  283. Reminder or Buzz in excel sheets
  284. Excel crash while expanding object in watch window
  285. Vlookup - error handling with VBA
  286. Code to close and reopen file
  287. SpecialCells method of Range class failed
  288. OLEObjects
  289. RE: VBScript to set conditional formatting for cells
  290. Want to Copy and paste to new sheet range except hidden rows.
  291. Little help with filter Please please!
  292. Excel 2007: Error 400, Excel 2002: OK...
  293. Prompt for password
  294. Getting Unique Data Only!
  295. Format date in Multi-column listbox
  296. Can I add an item to a PivotCache with VBA?
  297. Open a UserForm when a Tab is selected
  298. Custom Function displays as #NAME
  299. Excel document (with VBA and Macros) TO standalone app or Web
  300. Excel Add-In Using ADO to retrieve database records
  301. Excel hangs when switching focus
  302. Pivot table grouping
  303. changing formulas across worksheets
  304. working with format 01-01-08
  305. Test for color of sheet tab?
  306. GET PAID FOR INCOMMING!!!!-FREE VIRGIN CONNECTION!!!
  307. GET PAID FOR INCOMMING!!!!-FREE VIRGIN CONNECTION!!!
  308. Can you use UsedRange.SpeciaCells() to loop through all Cells?
  309. Macro Problem
  310. Insert Pictures using Macros
  311. Re: multi text boxes validation
  312. Data delete and mass copy/paste with macro questions
  313. Setting the view area
  314. Sum an R1C1 Range
  315. Re: textbox validation for date and condition
  316. HOW TO PROMPT MSGBOX JUST ONCE
  317. Detecting which Windows is running
  318. Auto-Numbering fails
  319. grouping in Excel
  320. Convert Number To Word ?
  321. Creating User Forms
  322. Keeping a log of activity in a worksheet in a second worksheet in same workbook. Phew.
  323. HOW TO PROTECT SAVEAS FILE
  324. countif / sumproduct or something else?
  325. Overwriting data
  326. find row number of next empty cell in range
  327. calculate direction
  328. VB code to move text cell
  329. combining integer and decimals
  330. Nested IF functions
  331. Use UserForm to Access Spreadsheet on Corporate Intranet?
  332. How to set a tab stop for a command button
  333. How to translate Excel formula function name to another language?
  334. How to set the range?
  335. Zoom event in VSTO 3.0?
  336. move and then unprotect
  337. Protect all cells but allow data validation dropdown change
  338. value is changing at the end of Call Sub
  339. Need help with data validation
  340. Excel to Auto Recieve an Email
  341. Adding todays date to new records in Excel
  342. Textbox date "oddity"
  343. Sending Excel Workbooks to Outlook people automatically
  344. Textbox date "oddity"
  345. VBA - Active Printer Port Problem
  346. column count
  347. Starting Word from Excel
  348. How to Auto populate dates from a given start date
  349. Excel 2007 macro gets workbook name and path from temp file
  350. ADSysteminfo
  351. How to refer cell E53 from the previous (=next left) worksheet?
  352. Clarify this post
  353. macro to unmerge cells
  354. Auto Cell Color using VB
  355. Delete Rows
  356. Cleaning up code
  357. Why does this work now?
  358. Easier Way to Macro Total
  359. Prevent Right Click Menu
  360. Error 0:
  361. Formatting/Merging Cells from XML Publisher
  362. taking "strip html" to the next level
  363. Clearing the interior color properly?
  364. Looping a Macro
  365. Help to the first sheet
  366. Cursor information from a graph on a sheet
  367. Importing text from clipboard into a sheet
  368. Re: excel 2002 and windows vista
  369. Adding formulas to cells dependant on data in another cell.
  370. Printing macro i network
  371. for small project management which is the most suitable software
  372. Change view without activating sheet? - Repost
  373. Hide blank rows - what is wrong with this code ???
  374. need to get several formulas to change chronologically across shee
  375. Using Solver in VBA for excel without cell references
  376. Makroprogramering
  377. Change view without activating sheet?
  378. Excel VBA 2003 Addin trying to map Context id to .chm file
  379. Re: excel 2002 and windows vista
  380. Trouble Sending emails
  381. Remove Alpha Characters
  382. problem running macros on a file from server
  383. is current cell within a named range
  384. use data in cell as a formula for another cell
  385. Web page will not reveal its secrets
  386. Values for charts
  387. In an Excel formula can the clock be used to measure time?
  388. Acronym Macro 2
  389. Using code to edit macros
  390. Assign Macro to a Menu Item using code
  391. Assigning to an array
  392. Problem with if statement
  393. Spreadsheet Component not setting focus
  394. Macro on a Pivot Table run on changing data
  395. Excel Add-in causing problems with objects embedded in Word
  396. Lock Date Format
  397. Using Solver with Linear Constraint(s)
  398. SHow Hide COlumns based on cell value
  399. Automatically insert code into worksheet via macro
  400. autofiltering question and possible logic question
  401. Macro to Create a new row if a column contains text
  402. Copy data question
  403. msgBox problem
  404. Upgrading to excel 2007
  405. Need to modify code
  406. Excel Macro Prompting
  407. Good references for programming with Excel/VBA
  408. If Sheet Name, No Action
  409. Help Writing A Macro in Excel
  410. Help with text function
  411. Tools - References
  412. Macro Script
  413. PLEASE CAN ANY BODY HELP
  414. Suggetion for funtionality of this site
  415. Removing named cells
  416. Can Excel 2007 Templates Project run in Excel 2003
  417. Workbook.activate acts dif when activewindow.caption changed
  418. Check box driven order form
  419. How do I update a template wizard form to Excel 2007?
  420. Stock prices into excel
  421. Populate multi-column list in worksheet not in a UserForm
  422. Worbook.Activate Activates sht 1 even though this was'nt active sh
  423. Excel list box or combo box - filled with data from SQL query
  424. Lookup Macro
  425. Sr Software Engineer/OLAP Product Architect
  426. How do I concantenate two columns for the length of a table?
  427. Looping Macro
  428. Advice & Error Trapping
  429. Export a menu
  430. Controlling Excel From Access
  431. RE: Please help...
  432. VB - With protected sheet
  433. How to Remove Macro from SaveAs file
  434. what's there in blank cell when data is exported to excel frm db
  435. Help with simple 1-D motion simulation
  436. Using Foxpro from within Excel
  437. annoying subscript out of range error
  438. Run a subroutine from a worksheet without button, menu, or shortcut key…
  439. outlook from excel
  440. Excel crashes when I open the file, except.....
  441. Sort an access database, remove duplicates
  442. if more than 2 decimal places
  443. Re: Work sheet hangs - help appreciated
  444. Work sheet hangs - help appreciated
  445. Remove a row if data is bold
  446. Remove last character from all data
  447. Re: Pop up in excel
  448. conditional formatting a row
  449. code to replace advanced auto filter
  450. Branching in IE via XL Macro: pt I
  451. Excel Crash in procedure.
  452. macro for closing all Excel processes visible in TaskManager
  453. Can excel service be used to show and save data in Database like SQLserver?
  454. Distinguishing what is causing close
  455. How to read data from a spreadshet without opening it?
  456. Auto import of data into excel
  457. Simple looping question
  458. Selecting header rows with macro.
  459. Re: Code very slow
  460. Adam.. Where are you? You need to get back to the institution.
  461. Loop Macro
  462. Customizing the Ribbon UI with Office Open XML Formats Files
  463. if iserror then value = zero problem
  464. Range.Formula breaks Worksheetfunction.CountA
  465. Copying a Row in a sheet based on criteria in another
  466. What is the Correct Data Type?
  467. Please help - Spin Button
  468. Count Visible Cells when using Filters
  469. Select File to Open
  470. HOW TO EMAIL HYPERLINK OF ACTIVEWORKBOOK
  471. I dont know whats wrong with this....
  472. Assign shortcut key to existing Excel Macro
  473. macro - small change
  474. how do you skip empty cells or zeros when calculating the average
  475. list box
  476. how to hide "title-bar" in Excel?
  477. Can this code be speeded up?
  478. Sort Selected Cell References
  479. Signing a Code that uses a Custom XLA file (Location problem)
  480. Copy Non-Colored Cells to a New Sheet
  481. Macros
  482. HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY
  483. define a range that equals the first row of another range
  484. is there a maximum amount of data that can be in a list?
  485. .cells question
  486. HOW TO CHECK FILE IS SAVED
  487. QueryTable Supress Headers?
  488. String to Rounded Integer
  489. Copy/Paste Using 2000
  490. How to clean a worksheet
  491. Excel 2007 Crashes a LOT
  492. VBProj.VBComponents
  493. need advice on whether or not to use macro
  494. What is compiling and should I do it?
  495. Problems with Macros created in PC run in Mac
  496. Getting around 255 Column limit
  497. Opening file in VBA with Questions
  498. Excel 2007 - Can Macros be added to the Quick Access Toolbar
  499. application.volatile
  500. Macro to find last row with Data, avg last 30, show result on row
  501. If file exists then
  502. Can you store a value in different levels of a multi array?
  503. Warning Message
  504. Create a help file into VBA
  505. Selecting Till last row
  506. borders in VBScript
  507. Import Web Tables
  508. Macro to control two workbook
  509. unmerge with macro
  510. Formatting autoshapes using built in excel formats
  511. Lost Enable Automatic Refresh in Excel 2007
  512. Last Row…./ last cell
  513. workbook open - microsoft solution - current user vs other users
  514. Saving to a USB drive
  515. Source Formatting
  516. Extracting chart title from Embedded Excel Chart in PowerPoint
  517. Extracting Excel.Chart title from Embedded Excel Chart in PowerPoi
  518. Store code outside the workbook, is it possible?
  519. How to size rows and columns in pixels rather than units
  520. unprotect 1st sheet in every workbook in a folder and change month inS1 & year in T1 & rename all workbooks
  521. HOW TO EMAIL FILE LINK BY MACRO
  522. Module / Sub as string
  523. workbook error - please help
  524. filter criteria
  525. Prevent saving on specified location
  526. automatic close of pages
  527. Web Query
  528. Variables to be use by different Sub
  529. Little help please please!!!
  530. automatically creating new xls pages
  531. setting cell values in another worksheet?
  532. Modeless form keeps taking 'focus'
  533. Select a column from a matrix
  534. query
  535. Help with Resize
  536. Picture Insert Security
  537. subtotal worksheet based on criteria
  538. macro to select match results
  539. Macro Problem
  540. Vlookup code problem
  541. Special Char in footer ?
  542. SUMPRODUCT question
  543. Call Excel in VBA
  544. Sendmail works one computer, not another
  545. Error 28 out of stack space
  546. Chart - Variable Series Collection
  547. print preview do not update (?)
  548. Check if cell value is between two numbers
  549. excel not finding spaces in email addresses when searching
  550. Removing border around Check box
  551. simple yet complex scenario - goal seek problem
  552. Prevent Errors When Using Links
  553. Check if workbook is open...
  554. Commandbutton captions
  555. returning an array from a function
  556. Moving within a form
  557. Working with protected files...
  558. Message when opening a sheet
  559. Error - Need assistance Please - Object doesn't support thisproperty...
  560. Excel 2003 Finding External Workbook links using VBA
  561. Trying to search an Array of Strings
  562. Cell and Worksheet Location
  563. Open Word Document using VBA in Excel
  564. Programmatically adding checkbox and attaching event handlers
  565. CUMULATIVE leaving 0
  566. Excel VB - copying formatted dates programatically
  567. Mail Merge
  568. Copying worksheets between workbooks - The object invoked hasdisconnected from its client
  569. Text To Row Function
  570. Vlookup help, please
  571. Saving Changes to a Command Bar.
  572. autoshape protection
  573. fill a web form from excel vba
  574. What is a 400 error? Why would I suddenly start getting it?
  575. Inserting rows incrementally using a macros button
  576. Is it possible to link the cell in excel to the size of the shape
  577. Formula Required -
  578. i've seen this before here yet the macro is hard to search
  579. Clear Excel Clipboard with VBA
  580. GetOpenFileName
  581. copy cells
  582. Size of filtered list
  583. Code Fails Intermittently
  584. Simple Question
  585. active cell - get me back there
  586. Colour functions on Chip's page
  587. Changing default response of an alert through vba
  588. Calculating number of days off
  589. Accessing Embedded OLE chart information
  590. Stack overflow exception, when chart is selected
  591. Change UserName & Password from Worksheet,
  592. Dynamic variable in formula ?
  593. Open File *approved.xls
  594. how to group time field in pivot table
  595. CommandButton Enable not working in Excel 2007
  596. ignore this post
  597. 3D Screen Saver causes error 380 with userform text box ControSour
  598. UDF Naming
  599. Does CDO mail require a reference?
  600. How to add a combo box in a cell using the office web component 11
  601. Excel Programming, Office 2007, Windows Vista
  602. randomization in excel
  603. help needed
  604. Using GetOpenFilename from a cell
  605. How to reference a constant?
  606. Efficient Nested Loop Solution
  607. Efficient Nested Loop Solution
  608. Msgbox in WorkBook_Open event
  609. Write a Macro to retain rows based on certain criteria
  610. chart cell references do not change when worksheet is copied
  611. How to track object index in object collection
  612. Isolating a row/column in a range
  613. Copy worksheet without triggering events
  614. multiple user-defined functions in add-in (2007)
  615. Is there away to do this....?
  616. How can I use a variable in a cell reference? Ex: $A$1:$F$"X"
  617. Pivot macro problem
  618. I need help sorting a table
  619. Range Find
  620. Array of Range Objects
  621. Conditional Formating
  622. Range, select, and printing arrays
  623. Excel - Access Integration
  624. Linking Files - copy a worksheet to a new workbook
  625. linking files-update a cell in several workbooks
  626. Clear borders macro not working in Excel 2007 but works fine in 20
  627. Missing my macro book
  628. Check whether a sheet is present in a workbook
  629. Speeding up updating records using ADO
  630. I'm getting crazy
  631. close a file ater opening with GetOpenFileName
  632. Use of Proper Case
  633. Save records from one file into seperate other files.
  634. VBA Converter for Excel 2007
  635. Sending mail CDO from Excel 2007 on Vista
  636. SUMPRODUCT with filter
  637. Auto_Open, Expiry Date of VBA application.
  638. zoom in on range
  639. Turn off "Printing.." message
  640. Frame
  641. onCHange event
  642. Change date formula to Value
  643. sumif vs dsum
  644. Can I save detail reports in different sort sequences?
  645. SaveAs Copying Macro to New File
  646. Sheet protected - user cannot interact
  647. counting spercific charaters in selected cells
  648. COUNTIFS function ?
  649. Search Columns for Most Recent Date
  650. Using Speach
  651. Making two pie charts look alike
  652. Do Event to stop concatenate Next statement running
  653. how not to go on Loop
  654. vba project properties via code
  655. Network share problem
  656. Re: conditional validation
  657. Divide Use column headings - Indirect?
  658. Wscript and stored procedure
  659. COUNTIFS function not supported in Excel 2003
  660. Excel2000: Is it possible to run a pass-through query from Excel
  661. Problems with Hlookup
  662. Stripping characters from strings and writing contents to another
  663. Question about Comments
  664. Login
  665. Cancel = True
  666. number format change
  667. VBA in Excel
  668. Data entry help
  669. Summary Page code help
  670. Save worksheets to files automatically
  671. getting error with empty listbox
  672. popup userform for b/days
  673. create a global digital signature for free?
  674. digital signature
  675. print preview in loop
  676. Data not populating
  677. Trying to get My Computer / Search results into a worksheet
  678. Re: date entry in userform textbox
  679. Pivot Table, Subtotal, CalculatedItem
  680. How do I do an Analysis of Means computation using Excel?
  681. Position of Comment
  682. RE: date entry in userform textbox
  683. RE: date entry in userform textbox
  684. Conditional Formatting
  685. Create a animated logo
  686. copy and paste
  687. Format Conditions Formula1
  688. Help with formula
  689. Trouble cutting a range of cells
  690. RE: Programming a chart object
  691. Parameter Pasing ?
  692. GetSaveAsFilename Troubles
  693. Stop Search ----> Ron de Bruin RDB_Filter_Data
  694. Saving worksheets
  695. failure in sheet with macro
  696. After Save
  697. Ultimate Control
  698. Populate combo box, then hide rows that don't match chosen value
  699. Data Validation and VBA
  700. opening text file as a .xls file and not a .xlsx
  701. How to perform SQL INSERT from vbs script
  702. How to use ADOX on Excel? How to automate Excel invocation on existing xls file from vbs?
  703. Formatting values in a form control. Is it possible?
  704. Copy non blank cells from 1 sheet to multuiple sheets
  705. Trapping blanks
  706. How do I display all the filename in a folder in excel ?
  707. File is corrupted after applying conditional formatting
  708. hyperlink image for email
  709. digital signature
  710. userform popup with birthdays
  711. empty listbox giving error
  712. Pivot Table, Calculated Field
  713. Get value of Option Button in Excel 2008 for Mac
  714. Sum by month running balance
  715. Add cc option to Send Mail + attachment
  716. Data Validation - Propercase
  717. Re: textbox validation with 3 conditions
  718. Detecting an endless loop in the VB Editor
  719. move cursor to empty row ?
  720. External Link to workbook
  721. how to reference a changing 'last row' cell in a formula
  722. How do I write a macro to increase the value of any cell by 1?
  723. VBA SQL Statement not working
  724. Find The Last Used Row
  725. Ending a dll program
  726. Find and FindNext
  727. Create objet for InternetExplorer application
  728. hi5
  729. Format colum for number and next colum age
  730. Hyperlink to show a userform
  731. format colum for identity number and next colum age
  732. mail merge
  733. Cell Status Activates Macro
  734. Pass Arguments to CDO_Mail_Auto
  735. Goal Seek
  736. Hiding macro-enabled password
  737. BeforeClose event won't run when closing using macro
  738. Extracting Web Data
  739. code copy
  740. Controlling Microsoft Project from Excel
  741. Moving data from an array to a range when range consists of areas?
  742. Expandable Rows
  743. Print from PrintPreview macro method
  744. Make Sheets VeryHidden With Code?
  745. Combining two line of code
  746. UDF: Roots of 1D Polynomials of Degree N and Real or Complex Coeff
  747. display a calender that automatically shows today date
  748. Macro to go to last row with values and average previous 30 values
  749. How do I force a pivot column if there is no data?
  750. Dropdown Lists and Funtions/Formulas