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. simple little loop
  2. select case simplification request
  3. Collect value
  4. ChDrive and ChPath to a network drive
  5. use variable value in a range reference?
  6. RE: Complex If/Or/And formula
  7. Strange behaviour
  8. RE: Complex If/Or/And formula
  9. Need help with simple macros for double checking manual plugs
  10. To,Mr.Jensen Harrisn and Mr.Savraj Dhanjal @MSoft.com
  11. Excel VBA recommendations
  12. help w/deleting rows if 2 conditions & calling macro from other bo
  13. Re: How to skip confirmation for macro and update all links?
  14. Redirecting ALT+1 keystrokes to run routine
  15. How to skip confirmation for macro and update all links?
  16. Loop by Group Within Group
  17. Password entry userform
  18. Reference list
  19. Extracting Data From a Chart
  20. unhiding / hiding sheets
  21. Keep getting "Type mismatch"
  22. Insert, copy, update, delete records through VBA
  23. CommandBar and Controls (how to create separate "Sets" of Controls)
  24. More efficient code wanted
  25. Debugging
  26. Debugging
  27. Debugging
  28. Another Easy Question
  29. Link checker: checking if a URL exists
  30. Sumproduct error
  31. Move lines from one sheet to another
  32. SaveAs in Excel97-2003 format
  33. In what order do installed AddIns open?
  34. Application or object defined error
  35. VBA Calculation with Variables
  36. Picture Form Help
  37. Maximize Excel?
  38. How to run a macro by opening a file?
  39. What IF statement
  40. CDbl and "Type mismatch"
  41. Sort data from every workbook in a folder into sheets in another?
  42. userform control structure strategy help request
  43. VBA Calculation with Variables
  44. Macro Help - Array
  45. A macro to check if a URL exists
  46. formulas containing constants
  47. Locking all text, combo and check boxes
  48. Filter Table based on Cell Value
  49. copy text and logo from protected, hidden sheet
  50. HELP: Email body transcript deleted when receiving response emails
  51. Very Easy...Right?
  52. Macro help needed
  53. add cells
  54. How to group
  55. Problem with workbook on_open event
  56. How do I open a com port using Excel visual basic
  57. Auto_Open Macro
  58. Lookup and Enter Value to Other Tab on Change in Cell
  59. Re: How to reference shdocvw?
  60. How to reference shdocvw?
  61. Saving workbook with a trusted extenstion VBA issue
  62. how to skip open operation
  63. Copy Filtered Data
  64. How to Loop
  65. Syntax to match sheet by codename
  66. Error values generated in functions
  67. Combine two ranges with different numbers of rows and columns
  68. Go to record end, then one across
  69. Re: How can I check a collection (e.g. worksheets) collection to beempty?
  70. Hiding menu options
  71. Re: Trying to read CustomDocumentProperties of an open 2007 AddIn
  72. Importing text file into Excel 2003 - C# - QueryTables.Add throwsSystem.ArgumentException
  73. Programatically format Axis Values
  74. merge all files in sub dirs
  75. Savecopy and saveas locking up excel
  76. Excel 2007 ADO Connection Error
  77. Protecting macros
  78. Exit Sub from Main Sub
  79. UserForm Text Box to display worksheet cell text
  80. Conditionally populate a data table
  81. Code to update links every 30 seconds
  82. Array To View Specific Sheet(s)
  83. Existing File Not Found
  84. CurrentRegion - Usual Behavior?
  85. How do I capture the last character in a string inside a macro?
  86. DATE MODIFIED
  87. Excel hangs crashes when pasting formulas
  88. Max size of user form?
  89. fill several sheets with data from other workbooks matching criter
  90. fill several sheets with data from other workbooks matching criter
  91. run report on web page, import to excel
  92. IS it possible to get the Visual Basic Form to VBA Excel
  93. Date Stamp
  94. Pivot Table and Protection
  95. Reloading and Editing UserForms in Excel - help!
  96. Dynamic radar chart
  97. Identify last row containing data
  98. ListBox / UserForm interaction
  99. Error when no records meet criteria
  100. Copy numbers from an array, each to it’s own sheet
  101. If statement works here, case doesn't
  102. Trying to read CustomDocumentProperties of an open 2007 AddIn
  103. Combobox display 1 value, access another
  104. Add formula to cell to sum range of cells
  105. Concatenate A1, B1, and C1 into D1
  106. Adding a sheet to a workbook
  107. Copy/Paste Import/Export Data VBA Code
  108. Code to look at range and extract data.
  109. Autofill Formula
  110. Conditional Format Syntax Error
  111. Passing info to the Workbook.Open event
  112. Sending Emails
  113. Extract multiple data to other cells with same numbering
  114. Problem Applying Formula to cell
  115. Separate first and last name in two columns
  116. how to check if a number has no more than 2 decimal digits
  117. Which version Excel created file?
  118. Selection based on partial input
  119. Conditional Format
  120. Named Range
  121. This one is For all the accomplished MVPs.
  122. Getting the entry of a Named Range
  123. Code to find all / next in a row of data
  124. Array range error question
  125. SUMIFS BY MONTH
  126. Drawing in VBA - compatibility between Excel 2003 and 2007
  127. microsoft 2008
  128. senin - sabtu
  129. Alternate Shading for non-bold rows
  130. Re: Extracting a number from a multiline-entry
  131. What VBA function returns cell 2 from which cell 1 gets its value?
  132. Lookup value, but between dates
  133. Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1to be repeated at top
  134. random selection of rows
  135. Help with printing rows and/or columns
  136. Help with drop-down box creation
  137. trim a range object
  138. Pivot Items Visible
  139. Making A Particular Wooksheet Active
  140. Turn off all error messages in Excel
  141. Type mismatch error using Sumproduct
  142. Emailing individual worksheets - problems with save as and filename/subject
  143. Columns Grouped
  144. Making a sports league schedule
  145. Prevent user from Inserting new worksheet
  146. Copy Rows Based On Criteria
  147. Setup dropdown list that selection references another dropdown
  148. Using VB to pull formats and data from another workbook
  149. Pivot table and it's macro
  150. Excel Function
  151. How do I programmatically select various ranges in vba?
  152. Populating and Comparing Arrays
  153. In XL VBA, Word Document SaveAs throws error
  154. Where to ask- running Excel from .NET?
  155. Add Page Numbers to PDF
  156. Macro Please
  157. how do i bring a visual basic form to the spread sheet?
  158. Creating a Required Field
  159. Programming question
  160. Do loop or For Next with data from cells
  161. Events copy and paste
  162. Can I do without using VSTO
  163. migrate xls app 2003 to 2007 -- get custom macro button out of des
  164. Macro for blocker from using cell range
  165. Sharing macros
  166. Email Help: Email with voting buttons from excel, Body gets delete
  167. Why Excel process is still there on Task Manager list
  168. E-mail from Excel
  169. Save file to Specific Directory - then EMAIL
  170. Saving a Macro Button on the Quick Access Toolbar in Excel
  171. How to do it in macro?
  172. Saving files to Sharepoint site: error 1004 (can't save file)
  173. cells() property?
  174. create a macro that opens, edits then closes cell
  175. A link to a collection of videos and tutorials on MS excel:Data mining Add-in
  176. how can i search for sheet with any part of sheet name
  177. Type mismatch: array or user-defined type expected
  178. what is the code cann make this pls. help me
  179. how do I find all the rows containing a specific value in excel
  180. Macro slow when copy and pasting
  181. Advanced filter VS formula in cell
  182. find item in coloumn
  183. date format
  184. date format...3.1.2010
  185. date format...
  186. Excel VBA: Reading data from HTML-file
  187. Copy cell values to another sheet
  188. Merge 1000+ cells into one
  189. Organising sales data by month
  190. Macro to copy a VLOOKUP formula - Data with a filter on
  191. Distinct items from recordset
  192. Change color on faceid 3077
  193. How not to display any pop up message for macro?
  194. Protect Worksheet Macro
  195. make it text in vlookup
  196. case is string contains string?
  197. Local cube files
  198. sumif
  199. HELP: how to locate objects on userform from VBA code
  200. show and hide a drop down list
  201. slecting averages from a changing table
  202. application.statusbar updates freeze
  203. Open Referenced Add In Workbook as Read Only
  204. Question on pivot tables
  205. Advantages and Disadvantages of Referencing An Add-In Workbook
  206. How to Update Selections for (Numerous) Validation Lists
  207. between
  208. I need help with this Subroutine!!!!
  209. Lists not working w/ userform
  210. Search for userform or procedure name?
  211. dynamic references to content in closed Excel workbooks
  212. Can anyone help with a macro?
  213. VBA IF THEN with an OR
  214. Complex Excel formula help
  215. How to determine which sheets appear on opening a workbook.
  216. Formula appearing instead of result
  217. Importing number with dash changes to date
  218. How do I create synchronised lists in Excel?
  219. Copy and paste rows from one wksht to another based on cell value
  220. Application.SendKeys & Printing
  221. Extracting a number from a multiline-entry
  222. Organising large amounts of VBA code
  223. Chip Pearson's VB Object references
  224. How to set cell validation in excel using name range?
  225. Why macro cannot refreshall?
  226. dumb question about subtraction
  227. lookup
  228. Date Format returned from Userform to Excel worksheet
  229. Reading from a dat file
  230. what type of code is this?
  231. Dropdown list items and item IDs
  232. Looking for beta testers
  233. move one cell down
  234. User Form Date Field disappeared!
  235. Delete Blank Rows when Pivot Table included on sheet
  236. Problem with exported text
  237. automating data copy from dynamic invoice to single spreadsheet
  238. CopyPicture from Excel Range to Power Point
  239. Extracting data from an excel spreadsheet
  240. date tracking
  241. Pick numbers
  242. String of numbers
  243. Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
  244. Help with DDE - stock feed
  245. Excel VBA Populatig UserFrom Contols as Design Time.
  246. How to retrieve value from specific cell value?
  247. How to set TIME condition for if-statement?
  248. Manipulating Table data
  249. How to code it in macro?
  250. Sort a Column
  251. How to code macro to disconnect internet connection?
  252. Prevent cursor/focus from moving
  253. Ribbon Customisation
  254. Extract last name from Last, First
  255. Build a String Sort Key, sort a 2 dimen array Mar20
  256. odbc connection lost
  257. Combined Cell Value
  258. RE: copy a hyperlink to another cell
  259. Time duration calculation
  260. Letters in the code
  261. How to code it on macro ?
  262. What is the bar and function name for refresh all?
  263. Hiding rows
  264. Calculating Distance in MIles
  265. Choosing a drop-down menu selection returns value to another cell
  266. Acos trig function
  267. Copy Paste with fiter and hide copies filtered and hidden
  268. Making my App only work so many times
  269. Reconstructing a table with Arrays
  270. onGetEnabled
  271. Hide Rows if all values are zero
  272. covert invoice.GIF to excel database
  273. Macro Error that I connot figure out
  274. Excel 2007 export/import datetime
  275. Object variable not set error
  276. How to make weekly totals change as the days in the week change ye
  277. Macro
  278. Macro to extract data from multiple Excel files
  279. HELP: Email body deleted when I receive voting response
  280. VBA: Insert rows
  281. Deconstructing a table
  282. SaveAs FileFormat
  283. e-mail issue
  284. EXACT function - but where does it not match?
  285. Data Entry Form
  286. Deconstructing a table - How to take a table back to the begining
  287. Macro to Delete Duplicate Cells
  288. SQL VBA Excel
  289. Dependant ComboBox on a UserForm
  290. saving And rename source file
  291. Copy question
  292. Advantages and Disadvantages of Referencing An Add-In Workbook
  293. vba format question
  294. Triming trailing spaces before using Match on columns of numbers withleading zeroes formatted as text
  295. prioritized assembly data
  296. XML Suppress Keytip Auto-Assignment in Custom Ribbon Tab
  297. Ribbon Customisation
  298. Select all rows till last row with value in Column A and CopyPaste
  299. Accessing Worksheet stored within Power Point
  300. Unable to change "Enabled" state of an Excel 2007 ribbon gallery b
  301. How to Reregister a given Excel version
  302. Cdate does not help
  303. problem with conditional formatting and VBA (excel 2007)
  304. How can I make this formula work?
  305. Can I freeze columns in a listbox
  306. Making a cell mandatory if another cell has a particular value
  307. create email when the cell value changes
  308. Prevent edit on combo box?
  309. Urgent Help needed!!!!
  310. how pass array to a function?
  311. How to do it in macro?
  312. Help!!
  313. Digital Signature?
  314. lists not populating userform
  315. Is there a way to test if a control exists on a userform?
  316. cell to have comma-delimited values based on text
  317. Excel 2007
  318. presenting a list to the users
  319. Number with dash is importing as date
  320. Closing workbook open as CSV
  321. Object doesn't support this property or metheod ERROR
  322. Macro Please
  323. update links - source file open
  324. show download progress to user
  325. Re Post Please help: Listboxes question
  326. Calcutate SUM of column in first blank row
  327. Bug with the function Round !
  328. need help writing a script Hiding a range when a cell with in is greater than 53..
  329. How to get notified when user inserts cells, rows, or columns in W
  330. Evaluate v. WorksheetFunction: best practice?
  331. Loop through a range Open a file
  332. Close Referenced Workbook if it's No Longer Referenced
  333. Simple IF give me nothing?
  334. Programable Controls on a Chart
  335. Unable to get TextBoxes property of Worksheet Class Error
  336. appXL = CreateObject("Excel.Application")
  337. ActiveWorkbook.PivotCaches.Create in Excel 2007
  338. GetObjects chokes on apostrophe.
  339. Run time error adding controls to form programatically
  340. Listbox scretch
  341. Data Validation circle cell position
  342. Pull data (sumif?) from an external workbook
  343. Copying and pasting values to the last available column
  344. Copy and paste
  345. How to set time within macro?
  346. How to do it in macro?
  347. question using SUMPRODUCT
  348. How to set time for processing the code?
  349. Create Range of Visible Rows only
  350. Create a list of pre-named tabs
  351. Create Hyperlink in VBA
  352. Referencing another field if result is N/A
  353. Auto copy and insert a defined number of rows as defined in a cell
  354. Automatic filling of data
  355. International Range style settings
  356. delete rows that have a duplicate id keeping the upper row
  357. selecting cells to produce a pivot table
  358. Problem copying named range
  359. VBA access to a series, after it was assigned to an empty range
  360. Declaring variables for use in a Module
  361. Automatically start a macro after data refresh
  362. DIR
  363. List of Displayed Pivot Items
  364. Excel Open window customization
  365. How do I code the cloning of an object in vba?
  366. Cloning an object which contains a collection
  367. How to simulate a click into a textbox (shapes)
  368. Filling right header/footer with barcode
  369. List Listbox data in column
  370. How to open a workbook into a new Excel application
  371. format on change event
  372. delete rows which have a one in them
  373. Macro to delete rows
  374. .Text .Formula .Value to replace copy_paste values?
  375. Set certain cells to print and others not to print
  376. Excel automation fails from PowerShell when PIa are installed.
  377. referencing a workbook using string var = error9
  378. Combo Box
  379. .pdf file not working in UserForm
  380. Need Help with a cell?
  381. How can I use a collection inside a class?
  382. Date dependent macro - run once only
  383. Clearing used range?
  384. Determine the Empty row and/or column
  385. List of tables in SQL server database
  386. Looping code
  387. change date in a sql statement from a cell
  388. Getting output from the TREND function using VBA
  389. Matching Data between 2 Tabs on Same Workbook - then calculating
  390. Copy subset of Range
  391. Determine number of rows with data
  392. Self Signed Digital Certificates.
  393. using excel formulas in VB coding
  394. Unload UserForms
  395. format a formula to general (not text)
  396. 2 Dim Array Sort, on any columns, ascend or descend. Guidance des
  397. Convert Pivot Table to Values in Macro
  398. Allow only one value in range.
  399. Password To Open Spreadsheet Used as Variable in VB Code or Macro
  400. What's wrong with this?
  401. Autofill Formulas
  402. Open hyperlink - how can I check the page has finished loading
  403. save as - location or default
  404. VBA Conditional Formating Using Logical Expression
  405. move row to next sheet
  406. Chart Print Footer :: Excel 2007
  407. Remove Focus from Form
  408. Code not working
  409. Change in Cell Value
  410. Return 1 of 3 different values based on multiple cells
  411. Simplifying an If(OR(…)) statement
  412. Stumped - Problem with Macro Security settings?
  413. Auto Populate a Template
  414. Addin instalalltion throught a vbscript
  415. macro pointing to wrong folder
  416. Multiple row insertion on various worksheets
  417. UDF Not working
  418. pdf file in a UserForm
  419. How to write Property Let for the single elements of an array
  420. Recall a file
  421. Code To Insert Blank Rows
  422. API Screen Locking
  423. Open Workbooks
  424. List Listbox items in column by macro
  425. Re posting Please help (Macro for Special Sorting)
  426. Get Range object from Cell Row and Column No.
  427. User Account
  428. Calculating calendar days and completion dates.
  429. Checking specific text string in excel files stored in a folder
  430. How to activate a User Form
  431. Problem using Match on columns of numbers with leading zeroesformatted as text ???
  432. active worksheet
  433. Populate User Form Text Box from Worksheet?
  434. Merging row data in Column A has duplicate.
  435. Select range from ActiveCell do to Lastcell in ColumnA
  436. Select range from ActiveCell do to Lastcell in ColumnA
  437. Using Variables in Two Workbooks
  438. How to use structured reference (ListColumns) in VBA
  439. Printing multi-page and multi-orientation excel tab to PDF
  440. Fill column question
  441. How do you set up backround with multiple pictures?
  442. Checkbox activate Combobox selection
  443. macros disappear in Excel 2003
  444. Copy part of text file
  445. Dynamically Adding Textbox Control To Frame Object in VBA (Workshe
  446. Can someone explian to me what this line of code does?
  447. dynamic reference to data in multiple closed workbooks
  448. Minimum row height
  449. Excel Date format changes
  450. Place a cell value on Charts
  451. Configure macro to run on all sheets Excel 2k7
  452. For Each loop doesn't work on First Pass, only on Second Pass
  453. Picture AlternativeText property Equivalent in Excel 97
  454. Color fill based on multiple conditions
  455. Fill with Gray if Column b is bold
  456. Macro to Check Dates
  457. months to full calender year
  458. Minimum row height
  459. Re: collect data automatically from a folder
  460. Auto row fit height
  461. Wildcards and Looping
  462. paste values without copy-paste values
  463. test for exernal links
  464. Send email from excel to notes - save email in sent folder
  465. Strange error message when loading a collection with an item of userdefined type
  466. Copy row when value NOT found?
  467. TODAY() and NOW() being reflected as zero
  468. Show Activecell Date in MsgBox
  469. How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE?
  470. Macro for Special Sorting
  471. Sorting with VBA (Tough)
  472. LookUp If Greater Than and LessThan
  473. How to handle dynamic Array properties in a class module?
  474. column copy
  475. Best Method
  476. Populate combobox
  477. Bubble Sort failure, Strcomp with binary compare
  478. Need help with chart formatting
  479. Remove characters
  480. Used Range and Source data of a Pivot Table
  481. Selecting from a randomized list
  482. Changing tab color locks the worksheet
  483. Word wrap and height
  484. User Select File on Import External Data
  485. userform in the VB environment
  486. PDF document that has Text Entry fields
  487. activesheet error
  488. Marking found records in Workbook A from Target List in Workbook B
  489. Trying to write a query
  490. Project Window does not refresh?
  491. Make Worksheet Deactivate Event only run once
  492. Problem creatting charts with VBA
  493. Novice question: I cannot get the immediate window to work
  494. Autocomplete
  495. how do i include an excel formula in a vb string?
  496. Convert Date-as-Text
  497. vba excel 2007 data mining
  498. Code to copy worksheet
  499. statistical database attack verses defense for online game
  500. How do I sort worksheet without affecting formula values?
  501. Lost a radio button on a sheet
  502. allow sort and filter on protected ss
  503. VBA Excel Macro worked for 2-years now dosen't??
  504. Auto complete a row
  505. AutoSave
  506. Carriage return character shows in combobox
  507. Is there a work-a-round i can use for making a datagrid....
  508. link in macro
  509. GetOpenFileName
  510. Excel button problem
  511. Save
  512. Choose folder with largest filename number
  513. Re: Dynamic Price Change Calculation
  514. LinkedCell
  515. ADO - Access to Excel
  516. Conditional Formatting of Percentages
  517. FYI: Microsoft admits Office patch gaffes
  518. Can't create recordset to populate userform combobox
  519. Data Validation Lists - Generating a list based on another list'sresult
  520. Open a file in another Workbook
  521. How to get notified when inserting cells, rows, or columns in Exce
  522. Repost - checking date of latest Forefront updates
  523. Re: Dynamic Price Change Calculation
  524. VBA: Paste in a range
  525. mstsc from hyperlink
  526. Excel VBA ?
  527. Re: Stumped on Object Variable not set
  528. Start a macro from a change in a cell value made by a formula?
  529. VBA-recovering a broken link
  530. Notify user macros are disabled.
  531. Excel events appearing unexpectedly
  532. Merge multiple worksheets into one
  533. controlling chart location
  534. Trouble with modifying cell right-mouse-click context menu
  535. Re: Stumped on Object Variable not set
  536. find mac address of my own computer by excell macro
  537. Novice q: allow user to select worksheet in middle of macro
  538. Change Selected cells references
  539. Activate Windows explorer
  540. Re: Stumped on Object Variable not set
  541. #Value! cell
  542. UserForm as Reader
  543. Setting column width on different computers
  544. worksheet_change becoming active just by entering the cell
  545. Change a default Excel warning
  546. Click on a Pie Chart
  547. Editing a Chart on a protected worksheet
  548. Using data from cells in a Query to a MS Access Database
  549. Opening Text Files and Re-Saving Them
  550. wkbModel.wb_Activate
  551. Find last user of computer from ActiveDirectory using Excel/VB
  552. Excel 2007: Formula bar text flicker, can't access other openworkbooks or close Excel.
  553. How to hide macro so as to protect them from editing
  554. Merging all the sheets in the folder
  555. Forgotten password
  556. Re: VBA Passwords - security
  557. Determine when Enter Key is pressed in a sheet??
  558. Buttons re-assigned themselves to the right macro name but in Book
  559. Folder location for Addins
  560. VBA Passwords - security
  561. Paste to next row if cells are not empty
  562. excel 2010 question regarding determining the last row
  563. Formula causing run-time error
  564. Would like a more efficient way to Copy/PasteSpecial
  565. Select contiguous cells by ActiveCell.Interior.ColorIndex and applyborders
  566. Passing Parameters to a Pivot Table
  567. colorscales, icon sets, and databars referring to remote cells
  568. Maintaining variables after program ends
  569. Macro to copy and populate an egsisting ssheet and save it.
  570. Syntax Error Help needed
  571. .StandardHeight property
  572. Convert date (m/dd/yyyy) in text format into an excel recognised date
  573. Referencing Chart Data?
  574. VBE Toolbars and Windows
  575. Clear contents of last two rows of data on sheet
  576. code for Allow Insert Hyperlink
  577. Is there something wrong with the random generator in Excel?
  578. Excel
  579. Connecting to Access database to populate a combobox.
  580. In VBE, how can I set a date format different than the system date
  581. Macro code mod - add tabs/apply to entire workbook
  582. Calculating relationships in table
  583. Compare worksheets
  584. VB to specify criteria then paste to a new worksheet
  585. Freezpanes address - apologies for incorrect post
  586. Referencing other Office programs in a Excel VBA App
  587. Simple shared code library, also how to find spreadsheets with macrosin them
  588. Genrate random numbers using the binomial distribution
  589. Problems in copying a Collection to another and removing elementsfrom two Collections
  590. Programming involving applications other than Excel
  591. MsgBox instead of compile error
  592. Is it necessary to Set a Object to nothing before referencing itagain to some other object?
  593. Delete duplicate rows of data
  594. Saving files automatically
  595. Message box warning of missing data
  596. Replace Worksheetfunction.ln code
  597. Select range from ActiveCell do to Lastcell
  598. Highlight
  599. How to know the correct height of the row
  600. Re: Adding date and time to cell programatically?
  601. Msgbox if cell is not a value
  602. change date format to excel format
  603. Select specific worksheets & copy - code problem
  604. Copy cell range to another sheet
  605. Error Handle problem
  606. touch screen apps
  607. linking cells in a column (result) to cells in a row (source)
  608. Pasting to Cells to the Right.
  609. How do I use Filesearch now that it is hidden in Objects
  610. Suspend Scrolling in a split pane
  611. Odd behavior using CONCATENATE
  612. Control to pick time?
  613. Printing of option buttons
  614. Check if value does not exist in range.
  615. Macros Help Needed, Thanks in Advance
  616. Searching question
  617. Repost - checking Forefront updates
  618. name manager?
  619. Copying Data from a workbook to another workbook
  620. PivotTable: formula for added & removed
  621. Pivot
  622. Lost locals and watch windows
  623. BeforeDoubleClick Event not working
  624. How do I make a Binary Search Algorithm on Excel?
  625. Personal.xlsb problems
  626. Create OptionButton at run time
  627. Delete ' from date
  628. not like syntax in querry not working
  629. GetSaveAsFilename
  630. How to print with a gap in the middle of a sheet
  631. Conditional Formatting VBA Multiple Numeric Ranges
  632. Modeless User Form Is Blank
  633. VBA-Protect Row
  634. How do I add numbers in two column based on the date in another?
  635. Select range from unopened workbook
  636. update in the workbook by different users
  637. Find Value in Workbook
  638. Out of context error in user defined function
  639. WorkBook Custom Properties
  640. Sumproduct formula needed
  641. Dependents problem
  642. How to reset the range name to refer to another cell?
  643. Special problem deleting a folder
  644. Call Stack Available ?
  645. Spliting Names
  646. ShowDetail
  647. Convert decimal digit to integer
  648. Excel Crashes when trying to open a User Form
  649. Need help with VBA help
  650. Unprotect Workbook with Function
  651. Why does column revert to date format after setting to numeric for
  652. ComboBox and rowsource from an external sheet
  653. Structured Table Refs in VBA
  654. if / then structure with macros
  655. Manadatory break after 10 days of work formulae
  656. Manadatory break after 10 days of work formulae
  657. Re: Need a accumulator driven from second cell
  658. Reliable send keys
  659. WorksheetFunction Calculation Error
  660. Error 1004-application or object error
  661. Chart datalabels linked to cells
  662. Command Button in Excel 2007 Chart
  663. Modify code from paste values to change font color / multiple rang
  664. Excel TextBox Control
  665. Launching from IE
  666. API License
  667. Error 2007
  668. Help with Microsoft.Office.Interop and c#..........
  669. vLookup with comma break
  670. If statement in macro to find blank cell/value in another cell
  671. Problem with Worksheet_SelectionChange
  672. Excel 2003 VB referencing #N/A not working but works in Excel 2007
  673. Custom XLAM tab not showing up when excel is opened from word
  674. How to add a worksheet from template without duplicate cell styles
  675. Retrieve part of a calculation
  676. RE: reading data from .xls file
  677. Re: Password for running Macro
  678. update sheet with data at bottom of present data
  679. Freezing Header Row
  680. Userforms with CommandBar Popups
  681. Link Drop Down list with Pivot Table
  682. Inconsistent behaviour of attributes accessed through structured r
  683. UserAccounts.CommonDialog - How it works
  684. Excel instance isolation problem
  685. Manipulate filtered data
  686. SFTP
  687. Timer to detect idle time?
  688. Adding daily updates to other master sheets
  689. Enter event in textbox control?
  690. Situation when file is "read only"
  691. How to code macro to import web link and avoid frame within HTML?
  692. Last used row within filter
  693. VBA code to paste data based on condition
  694. compare value of cell in one sheet to range of another sheet
  695. Calculations not keeping up with macro
  696. Responding to Keypress event on a sheet
  697. using formula =sum('*'!A1) in a macro does not work.
  698. val() is not work in my code
  699. VBA, refrencing a range
  700. Distorted display in spreadsheet apps
  701. conditional formatting of cells based on result in hidden cell
  702. Excel 2003 vs Excel 2007 #N/A in VB
  703. How do I insert a row ...
  704. Copy/Paste charts , ranges in PowerPoint
  705. How do I find text among multiple worksheets and return the cell .
  706. 2007 Excel Issues
  707. 2007 Excel Issues
  708. Problem with pasting special merged cells to merged cells
  709. Select One
  710. Find records that belong to a combo box value
  711. Save As Webpage - include my own HTML??
  712. Re: userform - list of clients without repetitions
  713. HELP: error handling in VBA
  714. Part protection of Excel 2007 tables
  715. what is the mime type for office 2003 xml formats?
  716. Sub or Function not defined
  717. How can I size merged cells to fit the needed rows of text?
  718. Disable functions on command bar
  719. Honoring page setup of each worksheet
  720. return checkbox value
  721. Do Until Macro
  722. Add text per user input
  723. Compare Two Workbooks
  724. Excel 2003 VBA Editor Context Menu won't open on right-click - Hel
  725. Save to SFTP not working.
  726. Search a range of cells for a specific word
  727. formula help
  728. Autofilter for fixed columns
  729. Selecting two different columns in excel using VSTO
  730. Personal.xlsb counts as a workbook, can I "super" hide it?
  731. Spin Button Programming
  732. Pivot Table Show Detail
  733. How to incorporate 2 sets of changing named ranges
  734. Date find Macro
  735. True/False Checkbox
  736. ADO query eating CPU power
  737. signing VBA Macros for Excel
  738. Hiding a userform properly!
  739. How to Loop?
  740. VB Editor Window
  741. Dealing with unknown array sizes
  742. How to reference a cell into a Dialog Box ?
  743. Copy rows with values in sheet 1 to next empty row in sheet2
  744. Drop and Drag Cell Data
  745. Excel 2007 returns data as 2007 table instead of range - how to turn off.
  746. Copy & Paste cells dependent on value
  747. Excel 2007 Object Model Map
  748. Re: Using a macro for a user-entry password - hiding the entry
  749. Re: Using a macro for a user-entry password - hiding the entry
  750. no change pivot item.