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. Help! - Need help with combo box list
  2. numbers change to text
  3. Object doesn't support this property or method (Error 438)
  4. Macro and Today's Date
  5. VB Code generates error on another machine?
  6. Delete a cell when found
  7. VB6 faster than VBA in Excel?
  8. Find All Instances of a Value
  9. Cancel Print
  10. Inconsitent Formula Error
  11. Range column and row using variables
  12. Save file with different names
  13. VBA Excel.WorkBooks.Open can't open an XML format xls file
  14. comparing data
  15. Select Case with Nothing
  16. Compile Error: Proceedure too large
  17. Barra de rolagem
  18. Removing Everything behing 3 Spaces
  19. help collecting data!
  20. Transposing data as it is being returned from an query
  21. Value ( Excel 2007 Version )
  22. MS Windows Common Controls-2 6.0 (SP4) using VBA in Excel
  23. How to speed up sheet copy?
  24. Select Window Containing specific text
  25. Copying hyperlinks with VBA in Excel 2003
  26. Pivot Table
  27. Problem with Excel ActiveWorkbook.SaveAs
  28. Macro to Delete rows on a criteria
  29. Tab through & hit enter through a message box with a macro
  30. drill through to SSAS CUBE
  31. Screenupdating=false not working
  32. Macro for workbook
  33. Data Validation dropdown shows blank choices
  34. Suspend program for data retrieval
  35. how to skip to next instance?
  36. Have the width/height of a autoshape placed in a cell
  37. Add Scroll Bar to CommandBar
  38. Updating pivot items in three pivot tables on one sheet via VBA
  39. how to make merged cells on a new sheet
  40. Filling a Multi-Column Listbox
  41. Align the form to the top left
  42. Programming Comments in Excel 2003
  43. bLANK cELL
  44. Some basic excel skills...
  45. Greg Wilson - XY coordinates of a worksheet
  46. Column headers in CSV file for excel
  47. SUMPRODUCT
  48. Calculation on/off in excel
  49. Looping thru open word documents to find a specific one
  50. Simple i think.... breaking SQL
  51. Create a Macro to Insert a number into a column based on criteria
  52. Excel Problem
  53. Excel Problem
  54. message scroll like stock index screen
  55. Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
  56. VB Question - AutoFilter related - 'Criteria1:' secion of my code
  57. Access variable from form and module?
  58. Auto adjust Y-axis for chart with 2
  59. Cannot open Excel
  60. ChartObjects.Count is incorrect
  61. VBA to sort automatically in a custom order
  62. Excel Hacks - 2nd edition
  63. Progress Bar Query
  64. problem with find and replacing
  65. easy e-mail one
  66. scheduling macros to run automatically
  67. Can this be done?
  68. SUM IF AND
  69. Help with programming Excel User Forms
  70. converting a simple formula into VBA code
  71. creative solutions wanted! No coding involved (yet) ....
  72. Start on select cell
  73. Rename an Pivot Item
  74. passing Nulls to SQL Server 2005
  75. Copying from internet explorer
  76. Select a variable range
  77. Pop up Message box
  78. Macro creating chart gallery giving problem
  79. Divided by zero
  80. OpenXML Excel query
  81. openoffice xlsm query
  82. User Defined Function to run procedure
  83. Change tab colour for active sheet
  84. UPPERCASE, lowercase issue
  85. Getting fields from DAO database and placing them in variables
  86. Loan Amortization in a cell
  87. Toggle common tasks
  88. inserting new row in datatable
  89. optimizer
  90. label_to_number
  91. google newsgroup
  92. Increment Columns by 1
  93. skip to next from if
  94. I've a problem~
  95. Macro Problem TextToColumns
  96. xl2000 vs. xl2003 RangeFromPoint and Grouped Shape
  97. Calendar Control
  98. ComboBox .List problem
  99. Macro
  100. Sorting Items in a ComboBox (ActiveX Control) in Excel 2003
  101. Add Ins basics
  102. deleting rows in large database (+20k rows)
  103. Macro that names a sheet
  104. C# adding textbox to excel sheet
  105. Multiple vlookup and a little extra.
  106. Compound Sumif
  107. Closing without saving and without asking the user to save...or no
  108. web query as background activity
  109. Dynamically populate spreadsheets in a workbook
  110. Logical Formula
  111. Distance Calculation
  112. Need to create cascading dropdowns in Excel
  113. How to generate code from VBA and... run it !
  114. Moving Cell Values Instead of Formulas to Another Sheet
  115. ADODB.Connection Error
  116. macro dont continue after save as
  117. Syntax for looping through rows and columns in Excel
  118. Toggle buttons
  119. Simple For-Each question ... but not for me ...
  120. Range.select error
  121. Adding a scroll bar to a cell to scroll its contents.
  122. macro dont continue after save as
  123. Advice on Using "xlDialogPatterns"
  124. Hide another Office app from xl vba (PowerPoint)
  125. Access to web tables
  126. For/Next Loop through worksheets
  127. AutoFilter results plus show next row
  128. Auto send spreadsheets as email attachments
  129. Finding named range references in formulae
  130. Is there an "On Break" similar to "On Error"?
  131. deleting a cell based on character length?
  132. copy an offset value when select
  133. Update links without opening other files
  134. Updating numerous Pivot Tables in a Workbook
  135. Need Save As Dialog Box
  136. Merging Question
  137. hide menu bar
  138. Sum new Column Added
  139. Vlookup in VBA
  140. need a complete list of Precedents and Dependents
  141. Call Event as Sub
  142. Return all matching cell values
  143. I need to stop this Loop
  144. Excel macro - truncate cell at X characters (left to right)
  145. Validate an account number
  146. Help with Rounding total off but leaving .00
  147. Excel VBA Wookbook Routines
  148. Bloomberg print
  149. Application.quit
  150. 2003-->2007 Mid function
  151. Runnig a macro relative from a form control
  152. Automatic Timeout & exit workbook
  153. column heading
  154. How to prevent a VB dialogue box appear
  155. Worksheets(i).Select - driving me crazy!
  156. UserForm Error 459
  157. data in different work book
  158. Superscript/subscript selected text within a cell
  159. Need to support mutiple Excel versions from C#
  160. Call Search Application
  161. 'OR' Condition
  162. Cell formatting not applied
  163. 2003-->2007 require variable declaration
  164. Logging to a network folder with username/password
  165. Grouping and summing values based on a condition?
  166. Worksheet change event - Spinner button
  167. texttocolumn, limit the number of used columns to 1
  168. Formula
  169. Input Mask - Credit Cards
  170. Conditional Sum Wizard - 2007
  171. Naming multiple parameters/worksheets
  172. Cells orphaned from update precedence tree - test condition?
  173. Sorting
  174. printing formula to a particular Count
  175. Splitting Cells
  176. Excel 2007 - Error inserting column
  177. Sort by find
  178. If Then
  179. Excel drop down lists
  180. How do i hide rows if a condition is met
  181. first and last cells of manually selected regions
  182. Insert rows/copy formulas fro above
  183. Check Boxes
  184. Userform Initialize
  185. Sum using r1c1 style
  186. How to trap auto filter?
  187. insert checkbox to modify cell value
  188. getting System.Runtime.InteropServices.COMException
  189. How to avoid getting the IDE window visible?
  190. Find a Specific Column
  191. AutoText for VBE?
  192. Display caption on Mouse Over
  193. Change Interior Cell Color
  194. Paste Special (Values)
  195. Creating a chart that has a variable data ranges?
  196. Activate code by clicking in cell
  197. Starting New Group in Custom CommandBar
  198. Must reduce file size
  199. green arrow for error
  200. How can Relative Cells/Ranges be Cleared when Rows are Inserted?
  201. web query as background activity
  202. Last Row
  203. drop-down populated from external data
  204. Determine Column Number in a function
  205. c# programmatically grouping a range of cells
  206. Query Parameters
  207. Excel 2003 to Excel 97 macros
  208. Change events
  209. Displaying the results of a Search
  210. Can't find String functions.... Missing library
  211. ActiveWorkbook.SaveAs
  212. VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007
  213. Consider Posting Replies to the TOP!
  214. Not showing Comments,when using arrow keys.
  215. Vlookup, GetDirectories Question
  216. CommandButton still visible until enter and then exit design mode
  217. Closing a Workbook if Macros aren't enabled.
  218. Text to multiple worksheets?
  219. mscal issue
  220. PickList
  221. calculating weighted average cost of capital in a macro
  222. Setting Last Row
  223. VBA Find function does not work for merged cells. Potential BUG
  224. Check if a column is hidden or visible in VBA
  225. Access picture data
  226. How to Create Main Macro File
  227. Custom button-lock
  228. How to interpret my code
  229. vba code...... on update...........
  230. Security
  231. Clear UsedRange except specific cells?
  232. ComboList Source
  233. Loop back to Case vbNo '#2
  234. Autonew
  235. Preserving date format in VB
  236. Convert Named Ranges to Addresses
  237. NumberFormat not working
  238. Refering to the current workbook in a macro
  239. If-Then, with an OR --- not working!
  240. Obtain Value in sheet from C#
  241. Copy hidden sheet and then make copy visible HELP?
  242. run macro on data validation cell change...
  243. Insert and replace row
  244. Send mail using default client
  245. Maximum amount of usercontrols on excelsheet in Excel XP
  246. Still having Filter/Copy problems
  247. copying named ranges to other sheets
  248. How to Export Excel Data for use in a Database Table
  249. Link a column to another sheeet
  250. summarise multiple worksheets
  251. Inhibit 'Save Changes'
  252. Userform questions -- code included!
  253. 2003- to 2007 menu
  254. VBA to make e-mail address in a cell to a hyperlink
  255. Using a macro to protect a sheet after the information update.
  256. adding data to a list
  257. Mulitcolumn listbox - Add Item
  258. noobie question
  259. hyperlink to sheet name where sheet names=cell content
  260. Exporting data to Excel from VB6/VBA
  261. How do you select images progammically
  262. email conditions
  263. Find Last Cell in Range
  264. Goto
  265. Adding custom list and text boxes to the custom tool bar from Excel C API
  266. How can I enable my macro to only open for one particular workbook
  267. Can only open Read-Only Word documents from Excel using VBA
  268. New computer and VBA errors
  269. How to refresh sheet while UserForm is open
  270. Zipping files and using them in a program... Is it possible?
  271. A check box to open and close Columns
  272. Copy Worksheet, Excel 2000 & 2003
  273. Email Upgraded from Office 2000 to Office 2007
  274. Cannot .select
  275. UDF not recognized after conversion to 2007
  276. Not Select locked cells
  277. Copy to Worksheet question
  278. VBA:programmatically invoking menu items from Excel Worksheet menu
  279. Automatically protect cells after updating information
  280. Custom Menu Checkbox
  281. Combo boxes
  282. Do loop
  283. Creating a path to save a file
  284. Using Instr to produce table contents
  285. reading xls file, speed problems
  286. Update Links, Scheduled Tasks and UDFs
  287. Why doesn't this work
  288. Customise Graph Data labels
  289. select case question
  290. Conditional formating for a range of cells
  291. Help - Apply Formatting To Current Row
  292. Copying rows or cells using Java
  293. how to design a form in Excel like this?
  294. Importing Web Page with Hyperlinks into Excel
  295. Random
  296. Sorting a Column of Formulas
  297. Graph Macro range question
  298. Old/New Mp3 Free Albums
  299. Function to Sum A Cell Containing Numbers and Text Abbriviations
  300. Humaneyes sucks!
  301. Humaneyes sucks!
  302. Web query: Want to pause macro while Web query completes refreshin
  303. Conditional Formatting if a certain condition is met
  304. Prevent Saving command if data is not validad
  305. Mail Body
  306. TextBox validation before moving to next
  307. How to Protect MACRO with Password
  308. Question about named area
  309. FillColBlanks - two columns?
  310. problem with find in merged cells
  311. "cell selector" control?
  312. Get count of active (non-empty) rows and columns
  313. Coding the Spinner
  314. Query not returning all the rows
  315. Selection_Change?
  316. Worksheet_Change event
  317. Open tab text file method
  318. Excel VBA Window - Problems with the display
  319. People favourite sites
  320. deleteing peoblem
  321. set olap pivot table selection
  322. How many rows?
  323. PasteSpecial question
  324. PivotTable Custom Field - formula for no value, with blank cell displayed?
  325. convert formula to text
  326. Remote Data Validation
  327. Sheets(2) = 2nd tab? = Sheet2 (Sheet2)?
  328. Comparing data, need help.
  329. Memory jam after too many worksheet copy steps?
  330. path syntax
  331. Find and Replace - delete the remainder of the text in the cell after my Find
  332. have a macro recognize added rows
  333. Macro to split and wrap text
  334. Select File names and select a location of file
  335. how make a random draw of teams of 4 golfers from a list of 40
  336. Pause VB Code to Allow User Input on Worksheet
  337. Help with boolean statment for active row
  338. Menus not working in embedded Excel
  339. Autosort multiple columns, Keep records intact.
  340. SQL query across computer domains
  341. over my head- need function help
  342. worksheet_change can reference excel range on other worksheet
  343. Select any row, copy data from specific columns
  344. 105,000 line XML to Excel
  345. Loop help
  346. User defined Type
  347. #N/A search across multiple worksheets.
  348. Excel datamap question
  349. Autosort but leave header alone
  350. sum only if all are numbers, return 'NA' if non-numbers exist. How?
  351. Save options
  352. replace formula with actual value
  353. Unprotect on open
  354. Use filters from a different sheet
  355. loop to add data in array
  356. How to save clipboard into emf or wmf file using Excel VBA
  357. Check data item is date not text format
  358. Days of the week's special format (i.e., Mon = Mn, Tue = Tu ... Sat = Sa, Sun = Sn)?
  359. Filter and Copy?
  360. IRTDUpdateEvent - Events
  361. Initializing Option Buttons in Excel 2007
  362. Need to Modify Existing Code
  363. Hide rows via Pulldown
  364. Worksheet_Change not changing
  365. Fast Fourier Transform help..
  366. Pivot table using Cube object - data overflow error
  367. Macro Needed
  368. please help me w/ changing my formula
  369. Custum Menu won't dropdown
  370. Excel 2007 used with Oracle ADI
  371. Can Text be Treated as Values for use in Calculations with Numbers?
  372. Open XLT for edit and set Addin to False
  373. Dante's Inferno: Compile Error: Loop without Do
  374. Search Value If Found transfer Data in same row to specified locat
  375. Conditional DeleteRow, if portion of string found
  376. Macro to hide column based on value on another sheet
  377. Use of 'Text to Columns' within VBA
  378. copy paste flexible with vba
  379. Printing solution
  380. Save workbook not macro
  381. Help With Macro
  382. Format TextBox on UserForm
  383. Join Sheets after Running Macro
  384. Which Shape Ran The Macro?
  385. Moving through worksheets and enacting formatting macro
  386. Do Loop
  387. Userform as mini-worksheet? XL2002 on XP
  388. Copy Hyperlinks to other cells
  389. Truncating trailing Chr(10) in Cell w/ Len() > 256 w/o losing Format ...
  390. Complex Formatting of cell
  391. Count If Range?
  392. Code Problems
  393. Update file
  394. StatPro in Excel
  395. Validation List arrow visibility
  396. Late Binding Help please
  397. Run-time error '1004': Methor 'Range' of object '_Global' failed
  398. Run-time error '1004':
  399. Workbook_Open not working?
  400. Copy Paste a sheet to new workbook
  401. Eliminating bland from Data Validation list?
  402. Export cell data to a template in Word
  403. "Enter" event for text box control?
  404. Selecting columns with column numbers not letters
  405. Preserve the formatting of a cell when pasting into it
  406. Is there any way to search image of my local drive with Image name or Image Title, Description
  407. Exception from HRESULT: 0x800A03EC
  408. Excel height and width of a pictures
  409. Noob Question Probably! :S
  410. Disable close button on all froms & MsgBoxes
  411. Help required on creating names using VBA code
  412. MsgBox Label...
  413. Is CopyFromRecordset a bug of Excel?
  414. Please Help--How can I get a Flag, if I try to schedule someone too many times
  415. Conditional formating wiht complex formula
  416. Determining build date of an Add-in
  417. How to reference a named area
  418. asp.net html export to excel - error
  419. Cell Reference for Minimum Axis Pivot Chart
  420. Copy Variable Range to New Worksheet
  421. How to add a macro when Excel window is Restored
  422. Wild Card Search Excel 2003
  423. finding largest value
  424. Search value, if found transfer select data to specific locations.
  425. Sensitivity Table for Financial Model
  426. Dueling events
  427. Install package - registration
  428. taking a .txt email list that are separated with spaces and sort them in to excel cells
  429. HOW TO TURN DEBUGGER OFF
  430. "Live" Advanced Filter (for unique records)
  431. defining range is my plot problem
  432. VBA how to copy a cell value and not the formula
  433. excel save as csv quotation mark
  434. Useful code
  435. Call Workbook_BeforeClose
  436. How do I get this Macro to apply to ALL sheets in workbook?
  437. Pop screen to appear when selecting a specific tab in excel works
  438. Populate Userform from Sheet range (XP - XL2002)
  439. (Complex) Creating hyperlinks to sheets
  440. Sub Directories
  441. Building a FormulaArray using VBA - Size Limit?
  442. Calling macro from a different addin
  443. Maintain integrity of Excel instances
  444. how to paste with value and format
  445. ComboBox listwidth to match text in list
  446. how do i get the "RefreshAll" method to work in a macro
  447. Programmatically Generating Excel Line Charts using C#
  448. Excel text box VBA
  449. Method Range of Object Failed, Excel 2000 & 2003
  450. numbering records on multiple sheets.
  451. Re: Concatenation prob
  452. Copy formula
  453. Array +fonction+vba
  454. Macro, auto refresh data
  455. ColumnWidths, Characters & Pixels
  456. "Workbook_AfterSave" not letting me saveas
  457. issue with ODBC connection to DB2
  458. selecting a named range based on a cell value
  459. Changing Values
  460. Stopping a Macro If a cell is left blank
  461. Need to find the value within a matrix / table based on two other values
  462. Help! Easy Macro - Find and Print
  463. Run-Time Error 1004 When Running Pivot Table Code
  464. Tricky Macro Coding Question
  465. Regression/Forecasting question?
  466. Loop Without Do
  467. Is it possible...lookup macro
  468. Code needed to open files one at a time
  469. DOM Error in internet explorer
  470. max query result size
  471. Excel & Web Browser Embedding
  472. Add columns of data from SQL
  473. Object Error
  474. Delete empty rows with macro by John Walkenbach
  475. strange text format from query
  476. Can xy graph origin be control from a cell?
  477. imbedded picture
  478. Sub to extract uniques from 200k data in xl03
  479. Print Preview and Print
  480. Programmatically open XLT for edit and stop macros
  481. Linking question
  482. Worksheet_Change
  483. Help with Auto Fill Date
  484. Compress picture - VBA
  485. Making a macro loop
  486. Which form control do i need to do this?
  487. Total Common Numbers
  488. Learn Excel Programming
  489. Do References GUID's differ between versions?
  490. Save/exit macro
  491. e-mail subject name changing
  492. Calculating an average using VBA
  493. Named Range in Other workbook - not working in SUMPRODUCT formula?
  494. UDF (user defined functions) how do you get tooltip to work?
  495. AutoFilter Row Count
  496. Point to the content of cell +
  497. Creating a macro that writes to all worksheets
  498. Question on SQL from XL to Access
  499. Userform Textbox Format to fraction
  500. Find and Replace Addin
  501. Calendar queries
  502. Does 2007 Office VBE Editor CommandBarButton .OnAction Property wo
  503. Color Coding Cells that are listed as Dates
  504. Unable to run macro in Excel 2007
  505. How to keep sheet modules collapsed?
  506. Help to modify code
  507. very slow code
  508. Can Formulas use a certain Digit, like the 1st or 2nd Digit, in all Cells in a Range?
  509. Copy cells based on conditions to another workbook
  510. Screen Trails Left Behind Form with Combo Box
  511. How to determine color "name" when mouse is over color selection m
  512. Program for creating buttons?
  513. Multiple Regression Analysis
  514. Code Modification
  515. Help with - Get to last columns - Start next row
  516. dialogs
  517. seperate print and printview
  518. Excel: Tahoma Font on UserForm
  519. filename
  520. How do I remove excel 2003 keyboard shortcuts?
  521. Array Question
  522. if cell colored in red and not between two numbers then highlight the row......
  523. Simple VBA Code written in Excel 2003 not working in Excel 2000
  524. Use of VLOOKUP function in an array formula
  525. Change every 3 columns width with code
  526. Renaming Workbooks
  527. activex controls out of control
  528. Next without For? can't find the problem
  529. Excel's XY Plotting Question?
  530. XL97 - Log use of paste function in workbook
  531. macro to take worksheet names and create dynamic list/range
  532. FORMAT PAINTER KEY REQUIRED
  533. VALUE PASTING MACRO REQUIRED
  534. A Tale of Two Cities- Find and add
  535. Hyperlink and/or Macro
  536. Hide/Show range based
  537. Copy cells based on conditions in one workbook to another workbook
  538. Referring to all pivot tables in a workbook
  539. Reporting add-in build data
  540. Text is contained
  541. (repostX4) Adding hyperlink to macro-generated pivot tables
  542. what loop structure???
  543. An error in some code I did not write
  544. ID multiple column headings
  545. Open Text based on creation date
  546. Date error message (VBA)
  547. permission
  548. Format Cell as Time
  549. Exporting file names to excel
  550. find corresponding OnAction
  551. Reset Find/Replace settings?
  552. save as
  553. named argument not found
  554. excel 2007
  555. Macro syntax: SaveAs Filename=ActiveCell.Text . BUT to a specified folder
  556. How to create a selection list then display the selection in a cell
  557. Add date to cell with open macro
  558. Using Excel to Predict Value?
  559. ComboBox.Clear method calling ComboBox_Change event?
  560. R/T 438 on .HPageBreaks.Add line
  561. Check if ADO connection open
  562. Initialize an excel datasheet
  563. checking the content of a cell if it starts with certain character
  564. Counting visible rows
  565. Adding an Auto Exec macro?
  566. REQ Help with simple Excel macro
  567. Rename all named ranges?
  568. Another 'Sheet Exists' Question...
  569. Can't Paste after Changing Cell Properties
  570. runtime error '1004' application or object defined error. Please help
  571. How to return the cursor back to original cell
  572. Wsh to import Csv and create a second sheet with sql
  573. Total up values for one month
  574. Automate Open an XLS without running macro
  575. VB Window
  576. Unable to open worksheet when called through a function
  577. query tables
  578. If then else in excel
  579. word mail merge from excel
  580. Calendar Autoupdate
  581. More than 3 conditional formats or a macro?
  582. from 2003 to 2007
  583. Programming the Find Dialog Box
  584. How to Set Rows with Merged Cells so They Adjust Automatically
  585. available printers in a listbox
  586. SUMPRODUCT Error
  587. Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows
  588. Dynamically copying data
  589. Fill down - adjust code
  590. Using split function for a csv file with blank line in between
  591. Excel 2007 - Ribbons - Splitbuttons
  592. Scroll home after Autofilter select
  593. Syntax Fpr Range Command
  594. AUTOMATIC TRANSFER OF DATA
  595. Functions included in add-in
  596. Named range by VBA to another workbook
  597. Cycle through all Checkboxes on a worksheet
  598. How to get the name from a range object variable?
  599. Basic Search with Wildcharacters
  600. Using For...Each...Next with a selection of rows
  601. inserting colon into a value at a specific interval
  602. Save Large Scenarios
  603. formatting
  604. QueryTables.Add - Destination problem
  605. IF statement
  606. Macro "Time formatting" help
  607. Refreshing all pivot tables in workbook
  608. references
  609. Delete Query
  610. Change cell range to Uppercase
  611. Linear Programming
  612. Excel Process Not Closed (C++) only after complete Application Shutdown
  613. VB6 and the Excel.Application Object
  614. Run code from separate workbook
  615. How to automatically show list in a validation list?
  616. Renaming Worksheet Command Buttons
  617. Program a combination chart using VBA
  618. Command Button Image Not Displaying
  619. Catcher in the Rye
  620. Separate data align on same cell
  621. Command Buttons
  622. Help with Macro copy/past sheet to sheet
  623. I need to avaoid an Excel prompt.
  624. More Multi-Dimensional Arrays
  625. More Multi-Dimensional Arrays
  626. find last row in one column and copy + paste data to same row in a
  627. ListWidth and ColumnWidths
  628. Private Declare Function
  629. Sending Updates
  630. COUNTA
  631. VBA N/A error
  632. Conditional Initialization
  633. SAVE OR SAVE-AS with a file name derived from a cell on the spreadsheet...
  634. vba - printing code
  635. formula for adding quotes to pre-existing data
  636. Passing arguments to Class Initializer
  637. A complex VBA question
  638. copy files (column A) to a certain dir
  639. Excel command bar list
  640. Application.InputBox screen position doesn't work.
  641. Copy Sheet In Same Workbook But Do Not Know how to Change Cell Ref
  642. Sheet tabs - suddenly have navigation buttons...
  643. Unlocked Region within Worksheet
  644. How Do I Sort search results?
  645. Print data based upon date entry
  646. Problems with Excel and Lotus Notes interactivity
  647. Hiding/Showing OptionButtons on a UserForm
  648. Listbox to select cells
  649. Closing workbook without saving changes
  650. Enter values in a column with combo box selections
  651. Can Excel2003 Read An Outlook Express6.0 Email?
  652. TIME
  653. Text box to determine internal format color
  654. How to send variables to textboxes in a web site
  655. Why does my code randomly ignore variable initialisation?
  656. change event doesnt work
  657. Adding cells in data range at random to determine a given number
  658. Visual Basic - Tuesday
  659. data from the spreadsheet into a form
  660. subtotal on page break
  661. Tuesday and filedate
  662. Updating Charts by a VBA code
  663. problem with shared workbook
  664. number format when returning value from odbc connection
  665. look in second worksheet if value not found
  666. selected range has different cell formatting
  667. disable 2003 shortcutkeys
  668. How to set GetOpenFilename to a specific Folder
  669. SQL
  670. Number Cells skip blank cells, Excel 2000 & 2003
  671. Code Execution Interrupted ??
  672. Treeview
  673. What is better Variables or TextBox ?
  674. Add complicated cell formula within a macro
  675. Formatting withing formula?
  676. Freight Calculation
  677. Linking Scrollbar Min and Max values to worksheet cells
  678. unable to read first cell from 2nd row
  679. Save as new file ONLY and do not save changes to existing xls
  680. Get Active Sheet
  681. How to get the path from where an Excel Worksheet has been opened
  682. Copy / Paste macro
  683. How do I add a simple calculator ( Like the one found in accessori
  684. Chart Error when using Chart Line - Column on 2 Axes in vba code
  685. reading data from columns that span rows
  686. using object range to call up worksheets
  687. Vista/Excel 2007 VBA Determine if the Ribbon is minimized?
  688. With Activesheet.PageSetup how to set 1st two visible rows as repeat (in VBA)
  689. ComboBox won't display more than 1000 items in Excel 2007
  690. A basic VB script--help the newbie?
  691. Indirect eq'n to link info from vba-generated worksheet to summary
  692. Automatically add/ delete data from range
  693. (repostX3) Adding hyperlink to macro-generated pivot table
  694. Auto Disable Macros on new sheet
  695. Macro to update all queries
  696. Can I tell what cell I was in last?
  697. Auto Run a Macro
  698. Running Macro Across More Than One Sheet
  699. create a break in the run of code
  700. Joining rows with different data
  701. How to substitute value of stringvariable to ActiveCell.FormulaR1C
  702. close msgbox
  703. Compare text string of a cell in Column A VS another cell in Colum
  704. Auto Skip
  705. loop and fine & replace
  706. Hyperlink coding in VBA
  707. using a variable as cell reference?
  708. dates
  709. Code to determine if data is filtered
  710. Challenging issue on Pivot table
  711. excel - save file - specify path and name
  712. highlight row
  713. Using range to fill in cell values
  714. Interacting with Internet Explorer Problem
  715. Defining location of sheet relative to the screen.
  716. avoiding doubles in a combobox
  717. Inventory compare and copy Script
  718. Change Directory
  719. auto open macro when opening from template
  720. Email Duplicates
  721. -- operator
  722. List of open workbooks
  723. VB Window
  724. Macro syntax "Save As" with filename from cell ref.
  725. Add Cell range based on color of cell to existing formula
  726. "Can't enter break mode at this time" error coming up
  727. Assign Bold Feature to one of the Word in a Cell
  728. VBA to hide headers
  729. autoshape with macro changes colour when clicked
  730. PROGRAMME HELP
  731. Multipage forms
  732. conditional formatting for ratios between rows?
  733. TreeView Drag & Drop
  734. Help required
  735. VBA duplication
  736. SheetActivate/DeActivate events in a common module
  737. Import Worksheet from One Excel to Another
  738. Finding worksheets with Broken Links to other workbooks
  739. Update Data On Sheet From UserForm TextBoxes
  740. Delete Unlocked Pictures from Sheet1 with Code
  741. copy & paste the column found by Selection.Find
  742. Summing a cell containing numbers and text
  743. Search Active Worksheet
  744. Run a macro from an If statement
  745. Multiple Formats In The Same Cell
  746. Axcessing worksheets in an add-in
  747. Object Lifetime
  748. Bound Test in Variant Array
  749. Copy cell of one excel sheet to other
  750. Excel help