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. Convert numbers to HEX
  2. find by font size
  3. Fails then continues without error
  4. Redraw problem
  5. Hide rows of active selection
  6. Macros using drop downs
  7. Plotting a number of single point series on a scatter graph
  8. output unique records to a dynamic range
  9. Format Textbox on an user input form
  10. Re: Looking for Input
  11. Max patient census by day by hr
  12. Adding selected numbers
  13. Select Case
  14. Macro
  15. using vlookup in a loop
  16. Filtering A CSV file during the import
  17. can you specify a worksheet during file open in excel?
  18. WorkSheet Change Event - Need Help With Coding Syntax
  19. simulate pressing CTRL and A
  20. PasteSpecial between workbooks
  21. Listbox with available procedures
  22. Need to Add Text to Control Text Box via Command Button code
  23. Permission denied code 70 on killfile
  24. copy to clipboard
  25. RefEdit
  26. Set print area based on last row with a given value
  27. Find text Sequentially Number
  28. When do AddIns load?
  29. Sum and Rank
  30. Excel macro Cc distribution list control
  31. How do I create a .bat file to create a shortcut on the desktop?
  32. Input on a user form
  33. Macro takes a while to run - should I be concerned?
  34. Final Days 2008 East Coast U S Excel User Conference
  35. Run a Stored Procedure from Excel
  36. Are there any other way to run the vba code than...
  37. Reading Data from an Excel Sheet
  38. Protecting an Excel worksheet from being renamed
  39. Long Shot !!
  40. Re: Delete Workbooks
  41. Get a Date to show as a Date Format in Combo Box
  42. Macro to create charts - Points to wrong sheet
  43. VBA unable to recognize code after reinstallation of MS Office
  44. Pictures.Insert not working in Excel 2007
  45. Clear selection in CSV-file
  46. Software copy Protection
  47. Calling a public function from a worksheet
  48. Setting an array of text boxes equal to individual form text boxes
  49. [Microsoft][ODBC Driver Manager] error
  50. Can I use the address function as an argument in another function?
  51. Complex Count
  52. Cell justifcation
  53. Cell to display certain if an entry is provided
  54. "Move Several Cols Down One Row"
  55. Macro to execute at a set time, pull data off of a web page, and e
  56. Need help with formula to count currency of personnel between 2 da
  57. at excel start need macro to remove autofilter & apply sort mult t
  58. Merge Worksheets w/Comments & Hyperlinks
  59. multi-line controltiptext
  60. first user form.....
  61. Custom Icon
  62. Over-ride protection for one user - doable???
  63. How to make a custom function to work in another workbook
  64. ControlTipText
  65. Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions
  66. Newbie Needs Help.
  67. User Form - use of single form for multiple sheets
  68. Strange problem when running macro from PPT'07 copying ranges from
  69. Autofilter, protected worksheets, Debra Dalgleish's code
  70. Calculations
  71. Conditional format based on adjacent cell value
  72. Retrieving Part of a Cell Contents
  73. auto copying Excel spreadsheets
  74. Compare List A to List B, Return List B Items Not in List A
  75. Array vs. Collection
  76. Find Worksheet code names from PowerPoint 2007
  77. Trying to concatenate based on font color
  78. Linking Cell Data to Text Boxes on a Form
  79. Control scrolling in a TextBox
  80. Single hotkey to do a date time stamp into a cell... and then type
  81. create spreadsheet where all changes can be stored
  82. Cannot pass argument from control to sub and back
  83. Compare columns - weird baffling problem
  84. Print Worksheet by Page Number
  85. xlApp.Quit - Doesn't Close Instance.... Any ideas?
  86. Multiscaling the same graph
  87. Looping through multiple sheets and pasting data in first blank ro
  88. Excel 2007 - Legend.Position
  89. Pick data from web page (no query)
  90. macro to open the mail and copy the data to excel
  91. find text within string and then delete
  92. Link to a sharepoint list
  93. Saving a workbook using VBA
  94. Inserting getpivotdata formula using vba macro
  95. Trapping invalid dates
  96. Macro for Tab Changes
  97. stuck in loop
  98. Conditional Formatting Issue
  99. Hide Rows
  100. Time stamp with undo funktion
  101. ComboBox Queries
  102. Advice Sought
  103. Code to add attachment
  104. Select range
  105. Help with Debug issue
  106. Count number of times macro was executed
  107. test dbl click 'target' is part of named range
  108. some simple (?) simulation
  109. validation
  110. How to creat custom made error message in separate window
  111. lock a cell from users but not macros
  112. Worksheet change time format
  113. VBA code to select a cell so it appears in the top left of the screen
  114. Macro "out of Memory"
  115. RE: Delete Workbooks
  116. Create Multiple Filter and graph data
  117. Unprotect Cells When Radio Button Selected
  118. Filesearch .LookIn fixated on MyDocuments
  119. Excel 2007 File Slow Response
  120. Call a procedure using a variable
  121. Combine 2 Codes into 1 Code to do the lot?
  122. strange formula array issue
  123. I would like to block access to my VBA coding
  124. Excel chart data in Power Point
  125. Clearing contents from a range
  126. worksheet template
  127. drawing text on a worksheet
  128. VSTO 2003 deployment problem
  129. Compare two spreadsheets
  130. Macro Help Please
  131. Index # of selected embedded chart
  132. Macro doesn't work when Sheets are protected UserInterfaceOnly
  133. Setting cell colors using RGB( ) function
  134. using best approach for activecell property
  135. Application.Quit Does not Close the Application
  136. Changing The "Printing Sheets Per Page" In VBA?
  137. How to return query with out headers
  138. Re: Drop down list
  139. use information from an input box in cell reference formula
  140. Scroll bars and how to print
  141. Again, for Excel 2007, Clipboard image saving issues
  142. Using a Range variable to call a procedure with a ByVal statement...
  143. Macro to find and copy to another sheet
  144. using OFFSET to fine DUPLICATES in a list
  145. call Excel subroutine from Sql Server?
  146. Hyperlinks and Comments
  147. Set Priority for Conditional Formatting in Excel 2003
  148. Excel 2007 pivot tables - calculated fields and SSAS cube
  149. Programmatically copying range in design mode
  150. Scrolling
  151. Need to change the following code
  152. Error using Union in a Loop
  153. Worksheet_Change event not running from Form control.
  154. using loop in ontime
  155. PlotArea.Left Question
  156. command button not working
  157. Excel References Not Release When IDTExtensibility2 Used
  158. Macros assigned to Menu Items
  159. RE: Please add a "Paste Value" Command to this macro.
  160. User-defined functions not calculating/recalculating
  161. User-defined functions not calculating/recalculating
  162. User-defined functions not calculating/recalculating
  163. AutoFilter
  164. Use number in text box to look up value in a workbook sheet
  165. Browse for folder - not selecting folder
  166. goto next line
  167. Import data from web page into excel
  168. macro to save the file as per the path selected
  169. How to open correct Module window in VBE by macro
  170. Code to open multiple files from within a folder
  171. copy data to one file from all files
  172. Opening OLEOBJECT
  173. A problem with HPageBreaks
  174. VBA to create directories based on 'date picture taken'
  175. Listboxes Without User Form
  176. Array as defined list in sheet 'Temp'..
  177. Re: Dynamic Array Problem
  178. List all applications running
  179. Excel Programming
  180. Clipboard images to Bitmap files through VBA in Excel
  181. click image in web
  182. Creating a que
  183. Accessing The Value Of A Merged Cell
  184. newbie
  185. Excel 2007 macro problem in editing a cell
  186. Re: Drop down list
  187. creating multiple pivots fails
  188. Script out of range
  189. validate entry via messagebox
  190. Copy as Picture takes up to 5 seconds to copy
  191. Automatic Update links to web query
  192. Code to close many open workbooks
  193. Is it possible with a macro??
  194. VB Code to hide rows
  195. format issues
  196. Combine 2 Ranges as One and copy to another worksheet
  197. Create two pulldowns from another pulldown.
  198. Macro Help....
  199. Insert Macro into Excel Workbook using C# code
  200. Compile Error: Can't Find Project or Library
  201. Loop Macro
  202. how to disable Office alerts...
  203. Time to Unhide an Entire Column
  204. Checking Outlook Email Address
  205. How to catch events from an outlook mailitem object from an Excelmacro
  206. go to child window
  207. Scroll
  208. Classic PivotTable Layout
  209. linking worksheets
  210. Lock
  211. Format Page setup for multiple worksheet in a workbook
  212. vlookup sub procedure help
  213. Lists
  214. Using VBA to Print duplex (two sided)
  215. Basic VBA questions....
  216. code to parse a multi-colum multi-select listbox
  217. Error trying to write array to range
  218. MAXA won't work with VLOOKUP?
  219. Sort Range by Font Color
  220. Excel 2007 VBA speed update
  221. Problems in macros after chaning Operating system to Windows XP
  222. Hiding Tabs
  223. Change VBE Settings
  224. RE: loop whole sub
  225. how to execute a stored procedure in SQL server from Excel 2007?
  226. VBA Converter
  227. can excel simulate three dimensional spreadsheets
  228. Error after code is run
  229. Winzip and email multiple files (RondeBriuins code not working)
  230. Modifying Ron's Sub Copy_To_Workbooks
  231. Change refedit control image
  232. Problem with RefEdit Control in VBA
  233. Re: LoadPicture(FileName) with size?
  234. pivot table
  235. Searching for non null cells
  236. count cells in range
  237. Help with code to run macros from hyperlinks
  238. suppress Workbook_Open event
  239. application-defined or object defined error
  240. Macros and hidden worksheets
  241. Add a Image to sheet attached in Ron Debruin's email attachment code
  242. Extract a single file from a Compressed Folder (Zip file)
  243. Combo Box Data Validation - First Entry Blank
  244. Formula to sum up customers totals from other sheets
  245. VBYesNoCancel Modify the YES and No Text
  246. Last Save date/time and User for a specific sheet in a shared work
  247. Check if text box has more than one entry seperated by a comma
  248. Using Data Validation to Filter Lists
  249. Copy Paste Macro not Pasting Values when Blank
  250. Blank Cells
  251. I want to create lists from web pages
  252. #VALUE
  253. Excel rejects XSD from Visual Studio DataSet Designer.
  254. Read of excel spreadsheet with ADO recordset
  255. Putting a default nam e in a SAVE AS dialog box
  256. VSB more efficient then standard functions?
  257. Re: Edit Comment from UserForm
  258. Copy Paste from Class Sheet to Filtered List on Combined Sheet
  259. How can I make a cell to flash?
  260. click LINK
  261. "Counter" in macro
  262. Programming Invoices for Reports
  263. Can you tell me the Print options for ExecuteExcel4Macro?
  264. Share workbook update changes setting
  265. filter the data and paste in another workbook
  266. RE: Update sheet one if data is not present.
  267. Excel 2007 / application.filesearch no longer works
  268. limiting text entry into columns
  269. Delete rows based on text value in a range
  270. Run Procedure when The Value of A Cell Changes
  271. Excel 2007 losing cell validation
  272. Disable all Control Events on a Userform when it is Intialized
  273. Can I detect if user has Excel 2007 and display different pages?
  274. Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003
  275. controlformat.enabled failed in excel macro
  276. Filename in Macro
  277. pivot table; adding kolomns to the base-table afterwards
  278. Logic
  279. Select Coloumn Range based on cell value
  280. Refering to Codenames in Remote Workbooks
  281. Code in 2003 not working in 2007
  282. Transition Formula Entry and Copy of Values
  283. New Web Query, from very long URL
  284. Multi-column Dropdown combox on a commandbar
  285. How to move AutoCorrect entries between computers in Word 2007
  286. Macro Help
  287. simple vb question
  288. Copy all data into one sheet and insert origin data... code amend...
  289. Suggestion for improving the execution time
  290. Input Box w/Drop Down List
  291. Match Value in Range and Then Paste
  292. Protect / Unprotect Sheet in Share Workbook Excel
  293. How to Zip then emai 4 files please
  294. Count Different Values in a column
  295. Hyperlinks
  296. Removing text before and after word in cell
  297. Determine File Filter Selected
  298. Save As window with vba
  299. Static variable
  300. If/And formula showing true/false instead of cell value
  301. How to avoid arrey formula?
  302. Replace password with *** in input box, xlVeryHidden
  303. Auto_Open and global variable
  304. HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED
  305. Change the background color of cells once it being edited
  306. Forms Buttons on Sheet Frozen
  307. Word to Excel
  308. Prompt to Unprotect Single Worksheet
  309. ftp paths defined in variables are persisting. How to clear?(vba)
  310. Popup Window Containing Image
  311. Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet
  312. Manual Page Breaks in VBA
  313. Creating an automatic log of filenames copied to flashdrive?
  314. Select worksheet using a variable
  315. Find Value and Move Rows to another Sheet
  316. Create a vbCheckbox from code in vb command button
  317. complex column addition
  318. Accessing a Stored Procedure
  319. file size increases drmatically
  320. Subscript out of range
  321. excel instance stays open
  322. Compare several cells in row & output value for match
  323. RE: Multipage Name
  324. VBA dates versus Excel dates
  325. Control Zoom for Print Preview
  326. String variable name is incorrectly used literally
  327. CONSOLIDATION OF TEXT FILES. DATA FROM VARIOUS COLUMNS.
  328. Re: Multipage Name
  329. Loop to insert data from a form - Help
  330. Vba - Access Setup Question
  331. Help with paths
  332. Color gradient
  333. Remove the $ from a cell reference
  334. Help with Array & Split
  335. Making a spreadsheet lock up after a demo period expires
  336. worksheetfunction.match
  337. Merge a range from all workbooks in a folder with AutoFilter(RDB)
  338. Suggestions for creating a demo spreadsheet that locks up after atrial
  339. Mail Merge in Excel
  340. Search Columns and return multiple rows.
  341. Calculating a cell
  342. managing time
  343. Picture property
  344. Solver Error with Function "EXP"
  345. How hold multiple versions of the same range?
  346. (no subject)
  347. Comparing lists in 2 workbooks and copying missing rows into new W
  348. vlookup in vb
  349. Database password
  350. Phantom workbooks in VBE in Excel 2007
  351. identify specific word in a range of words
  352. Create Folder Variable
  353. hyperlink - colors and macro question
  354. Book about using VBA to run SQL queries with results put in Excel
  355. Data Validation error
  356. Getting data from a spreadsheet without opening?
  357. How to zip an active workbook
  358. Find Posts?
  359. HELP PLEASE Any one Know how
  360. help creating a marco please
  361. Mail Merge from Excel
  362. Save worksheet after printed
  363. Help creating a macro please
  364. Macro help (not the sharpest tool in the shed)
  365. UNIVERSAL PROBLEM - Fixing Missing Office References Programatical
  366. Merging two cells within the same table
  367. Clearing Hyperlink formating from undefined # of cells in a column
  368. Add a row with data
  369. Pivot Table
  370. "Most recently used" list missing from File menu and "Recently usedfile list" option unavailable
  371. Data Validation, Drop Down Lists
  372. This sub runs to a function in a Module. Why?
  373. Strange Background
  374. Very Slow reading excel data into an array (while opened in new xl
  375. Annotating charts with text from within VBA
  376. Filtering Data
  377. Macro for recurring formula; max of set of cells
  378. Design Selecting Controls
  379. sorting in a macro and defining last row into varible not working in
  380. how do i export excel data directly to my outlook agenda?
  381. Help adding a label to Total line
  382. Unselect option buttons
  383. Need Code To Run Always
  384. HelpContextID on a single field
  385. creating custom menus
  386. Help with annoying VBA editor behavior
  387. Protecting conditional formats
  388. Excel Instance Hanging Around
  389. Protect VBA Project By Macro
  390. format table
  391. REMOVING DATA BASED ON OTHER CELL INFORMATION
  392. Chart with a defined named range?
  393. REMOVING DATA BASED ON OTHER CELL INFORMATION
  394. Change the value of particular cells in a Named Range
  395. SetFocus in a custom dialog
  396. last date saved in excel
  397. those little "moving lines"
  398. finding control
  399. Prevent users from saving if cells are blank
  400. Event procedure or ............
  401. combo boxes again
  402. How to Determine group of numbers best fit into 1 number
  403. Import XML Problem
  404. Display Excel Data as a Calendar
  405. XML Importing Problem
  406. Update a specific worksheet
  407. Insert a symbol using VBA
  408. Using Form Combobox in VBA Excel
  409. Very basic question, please
  410. Help....
  411. Numeric representation of curve/distribution for resource forecasting
  412. Data Validation Error
  413. Change Cursor Image if Workbook is not the Active Window
  414. If - Then Code Help needed
  415. Sumproduct with A1 notation instead of R1C1
  416. Exiting a workbook
  417. Dynamic list based on sheet names
  418. Help! Cannot calculate 123 * 456
  419. Parse a txt file and save as csv?
  420. Filtering VBA
  421. Help with "floating pop up menus" (if that is correct)
  422. How do I decrease the value of a column by 10%
  423. Re: Limiting number of characters in textbox
  424. Formatted Date in header applied with a macro
  425. Need help with hyperlink character limit
  426. Help with Macro
  427. Calling Excel methods from a different thread (COM add-in)
  428. Scripting Error
  429. **URGENT** Macro to find a Cell
  430. Re: Name of Sub/Procedure?
  431. Userform causing a slip for Worksheet activate?
  432. What is proper way to Open Close Release xls files in VBA?
  433. Text and Pic pop-up box
  434. Format RowHeight question
  435. Script Error?
  436. Formating question
  437. need SUM code help
  438. Loop Through UserForm For Multiple Different Outputs
  439. automatic charactor replacement
  440. Order in a array / ListBox
  441. SpecialCells
  442. Need Help programming treasure hunt sheet!!
  443. Accessing the Bessel Function within VBA in Excel 2007
  444. Move one record to another sheet when I type in a cell
  445. Referencing data validation list in IF Statement
  446. Get address from iFrame reference in page source
  447. Manage and run a WMP Playlist in Excel
  448. Multiple wrksheets same columns globally change order of columns?
  449. Macro in UserForm
  450. Application.Quit Run-Time Error 1004
  451. Split address in 1 cell into 4
  452. Disable AddIn via automation
  453. how do i run an external file
  454. Function Trouble: Not sure how to correctly reference my variable
  455. Input box
  456. match up columns and move data
  457. creating a pulldown based on the value of another pulldown menu
  458. Task Tracker
  459. Dynanic Print Range
  460. removing data based on other cell information
  461. Copy two summary ranges to master summary sheet
  462. Re: Name of Sub/Procedure?
  463. Re: Name/Description of error?
  464. Re: Name/Description of error?
  465. Remember FLIGHT 93
  466. VB Command Button
  467. RE: Name of Sub/Procedure?
  468. Execute an external file in Active X control Button
  469. Adding a selection of values and storing result in a variable
  470. Re: Import "ThisWorkbook"?
  471. Re: Import "ThisWorkbook"?
  472. Remove buttons from worksheet programmatically
  473. Kill Function by author
  474. Search data w. use of msg box and copy results to new blanc worksh
  475. Put data from various cells to one cell
  476. "object variable or with bock variable not set" - quick reply greatly appreciated!
  477. How to access cell properties in arrays for automation?
  478. Clearing a listbox
  479. Time Format
  480. Hide/Show rows based on Conditions
  481. Problem in opening Excel which is already opened by VB code
  482. Error handling
  483. Strange validation list problem.
  484. Need to find macro
  485. Evaluate duplicate rows and delete information in specified columns
  486. Password Protection "Sheet 2" ???
  487. Search multiple worksheets and return value to main worksheet
  488. Activecell Count
  489. Pass Workbook Name Into Another Workbook As A Variable
  490. Line Charts - Is this possible?
  491. Creating a DLL for Excel
  492. Automatic Chart update Excel File 2003
  493. Compare Ranges
  494. Clearing data in a row when rows start to duplicate
  495. Placing cursor in message box
  496. Clearing data in a row when rows start to duplicate
  497. Populate combo box with external data
  498. Folder Passwords?
  499. Hiding Pictures "Run-time error '1004'"
  500. A&A - In Any Place - VBA Developing and solution - MS Excel and Ac
  501. How to copy a part of a cell coming from a Web Query?
  502. Change Mouse Pointer Image in Workbook
  503. Condtional Formatting or VBA Code
  504. Blinking Scroll bar
  505. CONCATENATE
  506. Looping clmns, Copying worksheets, and Projections
  507. How to set a value in a list?
  508. Can sales register be linked to custom forms?
  509. Scroll bar
  510. Prompt for Save Path - Use Cell Content for File Name
  511. Start UserForm From Different Workbook
  512. Excel Sort
  513. Userform Commandbutton mousedragover event
  514. Convert decimal Englishpoint (.) to Swedish (,) (texts to digits)
  515. Nasty intermittent
  516. Image Property
  517. Need to send keystrokes to Internet Explorer?
  518. Macro to set print area
  519. XLDialog for setting the Print Area of a worksheet
  520. dyamic printing
  521. Excel2007 crashes while setting chart formatting
  522. Faster Pagesetup in Excel VBA using xlDialogPageSetup
  523. Formatting text that appears in messages
  524. Complex copy and paste looping VBA help
  525. Permanently remove rows
  526. error question
  527. Excel Expiration
  528. Display rows if conditions met
  529. Need Help with If,Then
  530. Excel 2007 Programming Error - 0x80010105
  531. how to copy matching data in next sheet
  532. How to get current information regarding a fresh query refresh?
  533. "collapsing" data--but only for certain rows
  534. Excel - PowerPoint VBA
  535. Copy/Paste in VBA fails?
  536. Sorting CSV Data By Date
  537. file resizing
  538. Last ActiveCell
  539. Value LIKE
  540. create text file
  541. How to enable / disable ControlButton added to Cell CommandBar
  542. 2008 East Coast U S Excel User Conference
  543. Determining if ChartObject is in PrintArea on Worksheet
  544. Problem with new programme
  545. Unable to set ColumnWidth property
  546. Reference
  547. Macro Sensitivity analysis Update table
  548. Colors on a pie chart
  549. macro delete rows <>1
  550. RE: Name of VBAProject ???
  551. Re: Name of VBAProject ???
  552. Using a Macro to Hyperlink to another Excel Workbook.
  553. Re: Place formatted Text in Shape(textbox)
  554. Run-time error '1004' . Please help. Request for immediate attent
  555. number format
  556. Identifying duplicate entries
  557. Control Row Height
  558. Each cell in selected cells test
  559. Accounting Format Text in a Textbox
  560. Add Two Columns of Data into a ComboBox in Userform Initialize Eve
  561. Identify Smart Tag
  562. Find All Replace All
  563. Date & Time Picker Control 6.0
  564. Unlock Protected VBAProject via code
  565. Set DTPicker Date Value if it is not Visible on Userform
  566. string width
  567. list permutations
  568. Cube functions won't refresh when Printing
  569. WTF?? Stange happings with a VB code
  570. Automated Macro
  571. quickest way to find last "used" row in a 2D array? (repost)
  572. set command button on a worksheet
  573. Input Box Question
  574. Fill cells
  575. Icon Size in Ribbon
  576. Append Unique Records to Master Worksheet
  577. Stepping through v. running code
  578. xlDialogPrint
  579. Adding text to the start of a formula
  580. Copy/paste rows to new sheet based on cell value
  581. Re: Data validation list box
  582. Cross Function when array crosses above another
  583. RE: Pivot table sorting - can I do this?
  584. Referencing a cell as a row number
  585. How to change the font used by dropdown list box?
  586. list of folders and subfolder.; quit simple ..but.;
  587. Can't figure out how to do this loop
  588. I'm stuck
  589. Reset ScrollArea
  590. Time Format on Worksheet Change
  591. Excel API or documentation for ActiveX?
  592. Getting Underlying Data from a Pivot Table Cell
  593. Scrolloing
  594. Copy Contents from Cell
  595. Copy Autofilter Source Workbook A result in Destination Workbook BSheet1
  596. Bypas Nil Values
  597. in a columnGet to first positive value
  598. How can I time the speed of a macro?
  599. Creating a formula in Macro
  600. Entering two functions in code
  601. Cannot get accurate results from Hittest
  602. Sub Workbook_Open not called when opening spreadsheet
  603. Output sql query results to text file
  604. Why do I still need to cast "Range selected = (Range) app.Selection;" ???
  605. Limit Characters Shown in a text box
  606. Embed Command Button in Cell
  607. Cycle through Variables
  608. Embedded Combo box changes size
  609. Date Entry
  610. Copy History (recently opened) to Cells
  611. A macro solution - replace text given the values
  612. Create two combo box in a single worksheet
  613. Looping rather than code for each row
  614. Can I put a Formula into an Excel User Form?
  615. Start a macro when cell >=0
  616. Digital signature
  617. Time format via Worksheet Change
  618. Divide rows equally & extract first & last of each block... Possible?
  619. Copying data from different sheets to one mastersheet
  620. RE: MultiSelect Listbox
  621. Modify to do to each required cell
  622. Time sheet in calculate per 15 minutes.
  623. Userform question
  624. Macro to show which cells have validation
  625. "deselect"
  626. Making sure the user is able to run macros
  627. Macro within a macro
  628. Allowing Hyperlink to Work on Protected Worksheet
  629. After Insert
  630. Sover -- how do you stop "The maximum time limit was reached..." b
  631. cannot see text box
  632. opposite of Union
  633. Passing Control Names in an Array to another Procedure
  634. Deleting characters after 3rd occurence of a string
  635. Create an Outlook Task
  636. ExecWB
  637. Re: UDF evaluate string output
  638. Can Excel capture a screenshot?
  639. Autofill down over blank cells until new data, and repeat.
  640. IRibbonUI error
  641. Pivot table filter - Selected Item Event
  642. AutoComplete Entry in Text Box or Drop Down List
  643. Excel Sort
  644. Exporting Data with Line Break
  645. formula to define the number of gallons used
  646. code signing - avoiding "enable macros" once digital signature expires
  647. VLookup in a Macro
  648. Non-exclusive file access via QueryTable
  649. New Loop, 2 workbooks
  650. set range to bottom of sheet
  651. formula to blank cells
  652. Using variables within countif
  653. Skipping the "Overwrite" warning within a Macro
  654. MouseDown with an AutoShape?
  655. Find value copy and delete
  656. Freezepanes
  657. Re: Status Bar Message
  658. Cant set the date into a Date & Time Picker from Cell value
  659. Send Network Message
  660. add vbyesno to existing macro
  661. Macro Help
  662. I am trying to create a formula
  663. iterating through a Dictionary object
  664. Linking worksheets for updates
  665. Lock Position of Controls on a UserForm
  666. Last Row
  667. How to determine which columns are used in formulas?
  668. macro is slow when I minimize spreadsheets
  669. Logical statement: equivalent of an IN function?
  670. Formula not consistent
  671. Selection in a range.
  672. Change Mouse Pointer on protected sheet.
  673. Re: Detect copy and paste action
  674. Macro to select A1 in all sheets so that users always at top of sh
  675. Basic help with sheet
  676. Encrypt 2007 xlsx file using VBA
  677. Empty selection with vba
  678. Commanndbar and tooltip display
  679. Cell formats change while opening the file via VB
  680. Multipage control
  681. For Don Guiilet,please help, 1004 error,1003 (type mismatch etc et
  682. Open workbooks in one click
  683. Is there public domain code to calculation cointegration coeffici.
  684. RE: ListBox Condition Not working for 1st Entry
  685. Re : Excel AutoFilter Detectable via the Most-Recent Activation of aFilter
  686. Anyone had this problem
  687. Appending sheet
  688. Modules
  689. Displaing result in Entire worksheet
  690. Good reference books for Office programming?
  691. Copy, modify and save a spreadsheet a from web application
  692. Delete Sheets to the left
  693. Help with Instr function
  694. Form - Get Selected (true) value of Option Button
  695. Excel and Active Directory
  696. Global Variables
  697. Trouble referencing the correct cell. Function will not work.
  698. Re : Excel To Call Sub and Assign Arguments
  699. In Excel:How do I ? =N14 BUT IT MUST SHOW O14 IN D18
  700. color cells of period
  701. check digit scheme: mod 10 or what?
  702. Send network message
  703. Tools / Options
  704. Colors programatically
  705. Copy Rows based on column value
  706. Getting stock market prices
  707. Displaying the infinity symbol in an excel spreadsheet
  708. Print Preview Office 2007?
  709. Sorting a named range using first three columns
  710. Taking data from other workbook ina macro
  711. RE: Opening a Word Doc
  712. Unable to run macros...
  713. Controlling Change event when loading a form
  714. Re: Next Line in Auto Filter Macro
  715. Run-time error '1004' . Please help. Urgent
  716. Change Font Color for Dupes on Selection Change
  717. RE: Next Line in Auto Filter Macro
  718. Paste non-adjacent cell content from Excel to open Word document
  719. input box searching and adding values
  720. combobox
  721. Color List
  722. Find if between dates
  723. Copy 3 columns become one column with macro
  724. dropdown menu accross row data as list fill range
  725. runtime error 9 -- subscript out of range
  726. One Variable Available In Three Workbooks
  727. InputBox Date Value
  728. UDF shows #NAME? when moved from XLA to XLL
  729. Dont know cellformat in vba
  730. batch file call from a macro - how ? and required batch format
  731. Cells.Find and PivotTables
  732. Open Webpage and Extrat data based on list in excel
  733. Autofil syntax to auto-complete the range
  734. Change all files format in folder
  735. Deleting number strings
  736. New Loop, 2 workbooks
  737. Links cannot be updated related bug - DA
  738. Sum based on mulitple criteria and show indicator
  739. Code to automatically close an Excel spreadsheet
  740. Creating a macro to sort a complex dynamic named reference
  741. Error handler not handling
  742. How to consolidate multi-row data into a single row?
  743. Percentage Formula Issue
  744. Creating new worksheets using data from a single worksheet
  745. Calendar Control (Embeded) - Populate thru a command button
  746. Combo Box Selection Changes w/o Input
  747. Reassigning a macro to an ActiveX button
  748. Simple GetData Question
  749. VBA help needed
  750. Graphing the sum of an autofilter result