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

  1. setting a range using a named list in vba
  2. Retrieving Current Excel Instance from Automation Add-IN
  3. Setting a range that varies
  4. What is the purpose of a Macro Sheet ?
  5. programmatically create a macro
  6. How do I enter research data in an excel worksheet?
  7. Customizing popup menus
  8. could someone help me witht his macro please.
  9. VBA- Contains any element
  10. Re: Help on reply to...building a list in a col...based on another col
  11. macro to extract info and paste to a new sheet
  12. Locking Inserting of Rows at certain rows?
  13. Calculating days between dates and leap years
  14. Calculating days between dates and leap years
  15. debug error: object variable not set
  16. How to set up an phone dialer with Excel?
  17. please explain this syntax
  18. Select Range - Fill Down
  19. FileDialog - Not available in 2k?
  20. sumproduct in code
  21. comparing text with macro
  22. vlookup and sum of multiple lines
  23. User Form Text Box
  24. How do I?
  25. im so close, someone please help
  26. How to get the DDL statement from SQL server through Excel VB.
  27. Hot to get the create DDL statement from SQL Server through excel.
  28. need help. page breaks
  29. Arrow key operation among multiple TextBoxes in a UserForm
  30. How to get the Create DDL statement from SQL server through excel.
  31. How to get the Create DDL statement from SQL server through excel.
  32. Max Question
  33. datediff in excel 2003.. Agecalculation
  34. use macro on a protected sheet
  35. Determining if values in a column range are of same value.
  36. vb combo box
  37. Display multicolumn box
  38. Help with Conditional Formatting Please
  39. SUMIF in VBA on VBA variables?
  40. How to column length into a formula
  41. Dock a custom toolbar
  42. Copy, calc and repeat
  43. Dock a custom toolbar
  44. Printing
  45. Ranges and Arrays
  46. Simple form question
  47. Macro attaching itself to spreadsheet
  48. vlookup to return the cell positioning where the criteria is found
  49. vlookup to return cell position as to where result was found
  50. Further simple Form questions
  51. Excel Range Variables
  52. Simple Programming Function??
  53. IF
  54. Filter
  55. count 1 cell in column based on value in another cell
  56. Can't change name of querytable.
  57. Using Excel Macros & Outlook Web Access
  58. function explanation
  59. formatting text
  60. disappearing controls
  61. Detect corrupt database
  62. inserting sheets in excel
  63. Problems with Google
  64. how do we achive the default view settings?
  65. Event procedures for controls added with CreateEventProc
  66. calculating roots greater than 2
  67. macro to remove spaces at the end of a cell
  68. how can I import Fortran output to Excel?
  69. lower and upper case equal on spreadsheet but not equal in VB
  70. Help with changing code
  71. go to cell
  72. ActiveCell.Top question
  73. dave or someone, quick question
  74. sumproduct problem
  75. Heartbeat code
  76. Printing Userforms
  77. have macros complete and enter passwords for sheet protection.
  78. Need to convert temperature from Farenheit to Celsius
  79. Deleting an element in the middle of an array
  80. Complex programming task
  81. Userform - Printing
  82. why doesn't macro work?
  83. Strange offset fault
  84. Help ID's
  85. Identify selected chart
  86. data linked to files in shared computer
  87. Protecting a cell based on another cell
  88. Disable Label in a Form
  89. Combo Box loaded with Excel Number Formats
  90. Macro to delete Macro
  91. help with mail
  92. one for the guru's
  93. sorry...I'm a terrible idiot and still can't do anything...:-(((
  94. Option Buttons separate from each other
  95. Total a Variable
  96. Excel 2000 vs 2003
  97. Info button
  98. deactivate fullscreen
  99. Finding NExt Blank Cell in Range
  100. ADD SPACES
  101. Classes Excel and Access - off topic
  102. Search for #'s in range
  103. complex functions with scenarios and relative addresses
  104. Where do you put the 'Else'?
  105. How To Link To An ACCESS Table
  106. How to publish VBA and UserForms on the web?
  107. how to position a listbox???
  108. How do I reference "DataObject"?
  109. Scan range of rows and export to 2nd worksheet
  110. how to disable automatic query refresh in excel?
  111. How do I make my other Microsoft Applications like Outlook access.
  112. How open excel file with microsoft spreadsheet control in ASP.Net
  113. How to run the SQL statement in Excel VBA
  114. Automate compacting database
  115. Declaring Objects
  116. i want excel to read the amount (no. format-20,000.00) and print .
  117. Urgent - Macro Programming Help Need
  118. Loading Number Formats into Combo Box
  119. Error Generated from Array formula
  120. Copy sheets.
  121. Find a cell with a special value and activate it
  122. How can I "Select a range"
  123. How do I send single worksheets in a workbook to different recipi.
  124. Enabled Property of Shapes?
  125. pdf hyperlinks
  126. Userform options and macro
  127. number of non-empty rows on a worksheet
  128. Pivot Chart Value Axis Scaling Question
  129. copy sheet with buttons
  130. Passing array from 2nd sub back to first sub
  131. Add space.
  132. type mismatch here!
  133. Entering military time into a userform
  134. Copy data from textfile, paste and transpose to sheet2
  135. Change Whole Column Cell Color
  136. Same Name Range for different spreadhseets in a workbook
  137. Common Dialog Box
  138. Cell reference from previous index function
  139. Code to create a right click short cut menu
  140. Excel Icon
  141. Urgent,! Need help with this Macro
  142. multiple queries in Excel
  143. Further Form Questions
  144. How can I get the value of a cell in a un-opened workbook ?
  145. TXT format
  146. Average Question
  147. range variable across sheets
  148. script converting list data to summary table
  149. Can anyone help with a sorting solution?
  150. Boolean to advance loop
  151. Delete Every Column After
  152. RE: Auto duplicating a sheet
  153. Go to cell 65000
  154. re: Object libraries and different ones with different versions
  155. is there a way I can modify the save as dialong box?
  156. RE: Auto duplicating a sheet
  157. Auto duplicating a sheet
  158. Automating the XML Data Mapping in Excel 2003 using C#
  159. Insert Function wizard for User Defined Functions
  160. File Search
  161. Number of rows used
  162. static var/function question
  163. Help w/ macro to zero hard keyed numbers
  164. Command buttons moving in Excel
  165. need help for several issues
  166. Workbook container - can't get it to work
  167. querytables.add ! Unwanted rows are inserted !
  168. No Visible Workbook
  169. Hyperlink i listebox?
  170. Altering code to reference the worksheet before the active worksheet
  171. Late Binding examples of binding excel application
  172. late binding examples of excel
  173. How do I set up a cell in Excel to choose a date from a pop-up ca.
  174. Protect a column by disabling mouse pointer
  175. ShowPivotTableFieldList Property - Version issue/ How to replicate?
  176. Insert Spaces
  177. Check last digit in cell
  178. Bit manipulation
  179. error handling not working
  180. Deactivate a cell
  181. How can I programatically change the language in the language bar?
  182. multiple worksheets in a workbook, each saved on its own.
  183. Float a window over sheet
  184. Populating a listbox will a certain cell on multiple worksheets in the activeworkbook
  185. Isblank Function not working in VBA
  186. Macro
  187. Excel to Access using ASP
  188. Pasting formula as text
  189. select all cells in sheet
  190. Testing for a cell being dependat on others?
  191. load several ASCII files in different worksheets
  192. Macro to step to next open workbook
  193. Disable Addin Menu when file not open
  194. Named Ranges
  195. Macro that prints after recalc is finished
  196. How to format a cell with VBA to return a value from a database?
  197. Border Mystery?
  198. Insert Blank Column every 9 Columns
  199. Standard Modules in VBA
  200. Pivot Table Select Range of Value
  201. Difference of Control toolbox / Forms ?
  202. ActiveWorkbook.SendMail
  203. find text in a sheet
  204. Trigger a Macro in MS Access from an Excel Macro?
  205. Excel file will NOT save
  206. RE: Excel's main windows does not redraw
  207. PointsToScreenPixels for Excel97
  208. ADO programming and Excel
  209. Barcode fonts
  210. End(xlUp)
  211. How to fill range with formula using VBA?
  212. Copy range from closed file
  213. VBE, change default path for file import
  214. Setting page breaks (another)
  215. call a function from VBA
  216. Userform Shown while macro runs
  217. Default Value formatting... UK Postcodes
  218. Userform.Hide not working
  219. Sheet turns into a "ThisWorkbook" module
  220. Unloading Cell Value in Textbox...?
  221. Another problem with export to TXT
  222. posting archives
  223. Copy & Paste
  224. Counting Strings in an Array
  225. rollover
  226. Zero Length Dynamic Range
  227. Applying a macro to all Excel-files in a folder
  228. How to force a paste of values only?
  229. Open Files via InputBox
  230. Conditional Formatting Bug w/ relative formula?
  231. Excel trucates contents of cell
  232. CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS!
  233. "Querytables.add" in a loop; result is insert in a new row each t
  234. Looping through controls on form
  235. Workbooks.Add and SaveAs don't occur
  236. Opening Files from a folder in sorted order.
  237. Move to end of textfile
  238. Error handling with a handling routine
  239. Thorough deletion of cell contents
  240. Error Trap
  241. Strange error if another Excel book is opened
  242. Get / extract a button name
  243. Excel document building
  244. Rename Module
  245. Change Cell Color dependent on Cell Contents
  246. Japanese Excel 2002 crashes because of CoTaskMemFree, why?
  247. Programmatically Controlling Excel Viewer
  248. Looking Up Numbers in a Table Using VBA
  249. Convert XLS to TIF
  250. Determine procedure name at cursor?
  251. Insert a blank Column Every 9 Columns
  252. OLEObject question
  253. sharing an add-in function for multiple users
  254. Need a bit of help on comparing cells
  255. Is it possible to make a cell flash in a normal excel document?
  256. Message box before save
  257. Counting Formulas in Spreadsheet
  258. Convert cell data into a worksheet name via a formula
  259. Can't get ActiveWorkbook.Container to work
  260. VB code changed Excel settings for all worksheets
  261. change lots of formulae all at once - how?
  262. Formatting Comments
  263. How to read part of a text string only?
  264. calculate Min and Max Values of selection
  265. add footer page name in word using excel
  266. ON Error goto fails on 2nd error
  267. Find a part of a string
  268. VBE Windows
  269. Colum heads in multcolumn listbox
  270. Strange Character
  271. Add a Button with code
  272. Passing a named range into a user defined function
  273. Fast Find possibly replacing .xls files
  274. Trace Dependents
  275. range names
  276. How to populate a combobox with the name of all the sheets in work
  277. Automate Run Rate Formula
  278. Add a New Worksheet
  279. Can't get out of my loop
  280. Column of a defined name (office 2000 vs XP)?
  281. Workbook Collection
  282. Case Select
  283. Macro getting stuck
  284. copying and pasting Cell reference names
  285. Counting numbers in a table
  286. Setting up 30, 60, and 90 days delinquency
  287. Showing activecell in view
  288. Help with Access Database Query!!
  289. Insert A blank Row
  290. Passing new .CommandText to SQL QueryTable in Excel
  291. formating
  292. Pasting to Excel sheet (getting desperate!)
  293. Formatting a Blank Row
  294. Enable Macros
  295. disable close if conditions are not met
  296. Memory problem or Excel limitation
  297. Limit find range
  298. applying standard formatting to a worksheet
  299. What's the easiest way to set up a client pipline w COE dates and.
  300. Default SaveAs type...
  301. Modify to delete row
  302. Change even rows to a predefined colour
  303. Date Formatting
  304. Loop through PivotItems of PageField - including "(All)"
  305. Matching values & returning on the same row
  306. Deleting Blank Rows
  307. Hi
  308. Programmatically finding out if Excel macros are enabled.
  309. Create a menu of sheets in a shared workbook
  310. VBA Editor Disappearing
  311. Why is Excel appending numbers to querytables.
  312. I want to create a "Insert Row" button to insert a new row at the.
  313. Can't see error
  314. Execute problems
  315. Copy Worksheet plus ranges
  316. WHy does it only work on Menu SHeet
  317. Insert a blank row (2)
  318. Scroll thru multiple spreadsheets
  319. ASP.NET Vb calling webservice
  320. macro that promt user for input
  321. Copy/Paste using hyperlinks
  322. workbook dont run macro under a lower version
  323. Compiling error! VBA Help needed
  324. print two sheets
  325. Named ranges
  326. formatting a worksheet
  327. See digital signature timestamp for workbook with trusted cert
  328. Number zero and the Letter O formatting
  329. PB import with MSQUERY from Access ton Excel
  330. Sum cells until a value X is reaced and then start again
  331. Parameters for Office COM Add-Ins
  332. IDTExtensibility2.OnConnection Event
  333. Workbook_Open Problem ... Worksheets not loaded yet!?
  334. Still need help with Access DB Query!!
  335. Circular Cell Find
  336. Skipping sections of code
  337. How do I determine when a cell's formatting changes?
  338. Re: Formating Text in a combobox
  339. Reading a text file line by line
  340. Userform height not consistent?
  341. VBA IF statements
  342. ConvertFormula Problem
  343. User Defined Functions - Help Text - Make it Easy for the User
  344. Passing Cell Address (String or Range)
  345. Using Find Function with Macros
  346. MS Query
  347. Cancelling a macro
  348. Paste data with a macro?
  349. Setting Sheet Display Zoom Magnification in VBA
  350. Positioning of figures
  351. Opening and Saving Groups of Files
  352. Change font if item above is not hidden
  353. how to dragDrop objects from other applications in 1 cell in excel
  354. how to dragDrop objects from other applications in 1 cell in excel
  355. How do I write a macro in XL that will delete 1st row and save th.
  356. how do i release an access database after importing into excell w.
  357. Issue with line wrap in source txt file when importing- please help
  358. How do I just update values on several cells (not the entire works
  359. Kill Excel Process
  360. macro associated with shape object, useful approach if can be solv
  361. Cant Select temp Sheet
  362. Hyperlinks Inserted in Design Mode inactive once Exited Design Mod
  363. Data validation code not replicated in rows by macro;can this be d
  364. How to distribute a workbook as a stand-alone application?
  365. How to restrict scroll area
  366. LOOP BETWEEN "FRONT" AND "END" SHEETS?
  367. Select a Range and Format
  368. SpinButton control loops infinitly when calling a ATL COM server
  369. Event procedures for controls added with CreateEventProc
  370. SpinButton control spins forever when calling COM function from Excel
  371. VBE bookmark
  372. What happened to "favorites"?
  373. Help with Code..or Solution
  374. Extracting 'exact' local references from formula
  375. using the if statement with data validation
  376. Data from excel to MS Access
  377. Catch _AfterSave Event & Saved Property Problem ...
  378. F5 to solve freezing
  379. Clear Cell
  380. ADO cloned recordset doesn't return field names
  381. on error goto
  382. How to zero out cells with formulas in them but no precedents?
  383. reset Workbook_SheetChange event?
  384. automatically insert each image to its own sheet
  385. How can I convert Text into Date? (See inside)
  386. Sorting in VBA
  387. Dsiabling All Keys
  388. Form questions
  389. If not found get a message
  390. How can I hide-Unhide pivotfield using VBA?
  391. Saving 2 windows
  392. Finding Duplicate values within a single column
  393. If resulting in False when it is actually true
  394. Next not incrementing
  395. performing least squares
  396. Capital Letters
  397. Forcing Excel to update, or recalculate.
  398. Worksheet Change "code"
  399. Userform Textboxes and Looping
  400. Chnaging Case
  401. String manipulation
  402. Identifiying a Worksheets VBComponent
  403. I have an issue during retrieving data from DB
  404. sorting an array
  405. Instantiate a Class via Automation
  406. Valeria, Did you find your answer?
  407. Two beginner's question (:)
  408. Insert Rows (3) VBA help soght
  409. activate/deactivate button with macro at given condition
  410. Excel Macros do not work with Outlook Web Access
  411. Derivation of min and max values
  412. loading txt files with more than 256 columns
  413. VBA help sought
  414. Hiding a range of cells
  415. Get / Extract Data from an Excel Field
  416. Explanation of SUMPRODUCT
  417. Multiple Control Event Classes
  418. change macro
  419. How to set ActiveCell to a new column?
  420. Planning future programming environment: office.net problems?
  421. How to get Excell to jump to Date?
  422. Conditional Formatting work automatically
  423. Formatting data
  424. How do I show Row and Column where I want them
  425. Delete with command button?
  426. Before close and workbook open!
  427. Web query results in a recordset?
  428. excel net worth file
  429. excel net worth file
  430. Monthly average calculations
  431. Event triggered by cell data change/entry
  432. Workbook not recognising named ranges
  433. Automatically EMailing a Spreadhsheet Upon Opening
  434. Can I import raw HTML source code into Excel?
  435. Covert Column Numbers to Column Letters in Excel VB
  436. Non -Modal form disappears
  437. VBA: Find and adress cell
  438. Asking for the connectivity of excel
  439. Event Management
  440. VB code to generate an e-mail with an EXCEL attachment, but not se
  441. Double Click for all Sheets
  442. How do I get to cell to insert a tab (worksheet) name on the same.
  443. Saving XL ranges as Fixed Field Length Text - Leading spaces
  444. Unable to Insert new Worksheet
  445. How to write a macro in Excel which can .....?
  446. Selecting answers from a list and displaying them
  447. Won't insert value
  448. Interrupting an endless loop
  449. How to zip a file before sending it out by macro?
  450. Re: XL5 Macro function - getting worksheet status
  451. Displaying the filename in a cell
  452. Hlep with code referencing an addin file.
  453. Activate an activex control on a sheet in excel 97?
  454. embedding links in cells
  455. Determing first row in VBA when subtotaling
  456. Offset problem
  457. ADO connection problem when using server
  458. Inhibiting Moving Cells without loosing Autofill
  459. Handle password for open workbook?
  460. CAN ANYONE SOVLE THIS PROBLEM!!!
  461. Unique entries in textbox
  462. MEDICAL/HOSPITAL
  463. Private Sub CommandButton1_Click()
  464. GetSaveAsFileName questions
  465. Format textbox on exit
  466. Populating a ComboBox
  467. Ho do I determine the Active Cell location of the data being sele.
  468. trying to create a blow-up sheet by writing a VBA macro
  469. VB Code
  470. How can we classify referring to grades?
  471. Search An Array in VBA
  472. Store the Spreadsheets filename in a variable?
  473. Excel 2003 Programming - Outlook.Application and Char(10)
  474. Incrementing Variable shortcut
  475. Excel schedule chart - 'reverse' conditional formatting
  476. Exporting data
  477. Comparitor
  478. XMLHTTP.OPEN + PASSWORD + USERNAME
  479. Max Length
  480. concatenating line decided not to work
  481. Need help with my looping macro
  482. Delete Rows in VB
  483. turn off green triangles in Excel 2002?
  484. Is Excel the right choice for project
  485. Set a 30 day limit for Excel worksheet formulas?
  486. NEED FORMULA HELP
  487. Compare 3 columns
  488. Excel 2003: Can the same range be used for a querytable and a list
  489. convert a number to text
  490. How to change this into array ?
  491. How to change this into array ?
  492. Need Excel to read a text field(part#) and assign a number(commiss
  493. Can I reset Client cache size in excel 2003?
  494. Can I use array to simplify this code.
  495. opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY
  496. Can I include noncontiguous worksheet in array of worksheets?
  497. Problem saving with VBA project protected.
  498. help creating labour program
  499. can I pull only data from a sheet greater then 0
  500. Referring to file no's from within an add-in gives problems
  501. Can't write to Tag property on Tabstrip
  502. So many greater than and less than values to calculate
  503. Formatting Postcodes in VBA (Bob Philips, Myrna Larson + Jamie Collins?)
  504. Popup input-form on focus
  505. Date manipulation within text entries
  506. Transaction on Budget Planner
  507. calculating transactions per second and per hour
  508. Run Macro When Select Cell
  509. Alphanumeric formula
  510. Sharing with Newsgroup
  511. ColorIndex property XL2000 vs 2003
  512. Blocking VBA Project
  513. Formula for neg and pos values
  514. MATCH, INDEX and VLOOKUP with Arrays
  515. Loading / Unloading Add-ins mystery
  516. Tough one, for me anyway....
  517. ado vba help
  518. Spanish/English Formulas
  519. Msg Box Timer
  520. Export DataSet to Excel
  521. Before Close workbook?
  522. Number of different items in an entire column without knowing if some of the cells are blank
  523. protected spell check for Excel 97
  524. Find Method
  525. loop non adjacent cells
  526. PageSetup.PaperSize
  527. Display Msg box on open "before" MS Macro Security warning display
  528. Want to launch Excel from C# app
  529. How to Find(...) in different worksheets with VBA?
  530. Array Problem
  531. Looping worksheets in workbook
  532. Can I do this?
  533. declaring public variables
  534. Frustrated with VBA so-called help
  535. Generic sheet selection in a macro
  536. Pivot Table Dynamically Creating on Query
  537. Loop help
  538. Help on error...
  539. Add a Chart as the last sheet
  540. Help Printing
  541. Deleting Unwanted Files
  542. identify green triangle in cell programatically?
  543. Date grouping in Pivot Table
  544. VBA code to define nbr of text character a a cell/column
  545. Capturing the column number and # of columns in a selection
  546. March 2005 Actual Info vs March 2006 Plan Info
  547. OpenText failed in Internet Explorer
  548. Run macro in another file
  549. userform
  550. CheckSpelling a Textbox
  551. DDE help
  552. Writing to Columns from VBA
  553. Word "Image" into Excel
  554. Alphabetizing array items
  555. Remove 255 character limit from OLE DB .NET and Fix Data Corruptio
  556. Paste Event
  557. Changing the columns from letters to numbers
  558. Calculate workbook in VBA
  559. cell formula manipulation
  560. dynamic range defined in VBA for use in formulas
  561. modifying code using addfromfile method
  562. Count A's
  563. How to clock a procedure
  564. Range Question
  565. excel macro to copy data to second sheet
  566. Don't run if entire column is selected
  567. Dynamically insert a picture.
  568. Automatic Refresh in Addin
  569. linking to multiple password protected workbooks
  570. macros - navigating
  571. Objects in cells
  572. Focus
  573. Text box formatting
  574. Move msgbox out of loop
  575. How do I get the name of a Cell
  576. How to take over the value of a userform-controle to a cell
  577. MICROSOFT AND PETITIONS
  578. Keeping a Variables value alive.
  579. Poking data from Excel into Access
  580. Defining Categories for Custom Functions
  581. Vlookup help
  582. html
  583. Help - Type mismatch when running loop with strings from arrays
  584. Calculations in Excel
  585. Cell Reference Question
  586. Counting rows and naming columns
  587. Unprotect worksheet method in VBA
  588. SendKeys and Application.ScreenUpdating
  589. copy, find next blank row, paste special location
  590. sort macro
  591. Re: Counting Values in a different column
  592. programatically creating dialog box
  593. Macro Copying To Another Workbook??
  594. Making an open workbook active
  595. MultiColumn ListBox, linked to a range - select cells
  596. Open a specific Word document from an Excel Macro
  597. SLOW Code...
  598. FFT usage in Macro
  599. Assign Value to Module Level Variable
  600. change the 8th column in a not contiguous array
  601. copying pasting
  602. auslesen aus eines dsf Datei
  603. Table to sort via VBA but row&column size variable!
  604. find missing dates
  605. Easy one... If and or
  606. Issues with ThisWorkbook.Name
  607. retrieve the last value in a column - JulieD
  608. worksheet change event doesn't work
  609. Just a code check please...
  610. Moving Cell up, down, left or right thru Macros
  611. Just A Suggestion
  612. Auto update Invoice
  613. For Each
  614. John Walkenbach Colour Palette
  615. open word doc from within excel with VBA
  616. Digital Certificate
  617. Getting data to Microsoft Word
  618. Testing a string array for any values
  619. Object required error
  620. Password protection custom tool bar
  621. Colors in cells depending on a value?
  622. line chart? add a series?
  623. Copy and paste spread sheet
  624. Auto open and add spreadsheet
  625. Code to show blank instead of 0 when there is no value in linked cell?
  626. Re: Running a macro by changing a cell value
  627. ActiveX need help
  628. How to unload Excel Addin Application?
  629. Mimic Undo actions
  630. Textbox format
  631. Limit access to certain worksheets (tabs)
  632. Progressive search
  633. check the cell format by function or vba code
  634. UDF that can populate the sheet with data?
  635. Access VBA: Problem at saving an Excel file
  636. DDE real time and time dispay conflict
  637. excel functions in macros
  638. Button colour
  639. Calling EXE After Calculation Complete
  640. Prevent loading Add-in ...
  641. Change Macro?
  642. hiding worksheets
  643. To Tom Ogilvy
  644. Find
  645. Worksheet_Change on Excel 97
  646. Open HTML as Text
  647. Suspend macro while others are running
  648. Working with Hidden worksheets
  649. Find Protected Cells
  650. vb help
  651. Copy, Paste then delete
  652. Font/CellInteriorColour
  653. UserDefined Functions
  654. enable macros accross the network
  655. Sheets - Limited acces
  656. Remove the last letter from a string!
  657. its coach again......
  658. Button on Userform calling GetOpenFilename
  659. Remove/disable event macros in SavedAs wkbk?
  660. Sum IF
  661. Call Names
  662. Automate Finding Values/Copy to Different Sheet
  663. VBA Excel - Power Point
  664. Copy an array into an ADO recordset?
  665. macro with a macro
  666. New record in table in Access from VBA in Excel
  667. Turn off printing status dialog with Excel automation
  668. Error opening file
  669. How do I sort numbers based on last two digits?
  670. permissions needed for excel programming on asp web page
  671. Subracting times and dates
  672. range and sum?
  673. customizing chart column color formats in code
  674. customizing chart column color formats in code
  675. user input and concatenate
  676. VBA equivalent of VLookup on an array
  677. single button on a custom toolbar
  678. button display
  679. I think I'm missing something very simple
  680. Function Delcarations
  681. Need exit Sub modification
  682. Data Validation - Dynamic
  683. How to sort a worksheet programmatically
  684. Get path of open workbook
  685. Excel97 VBA controls don't load in Excel2003
  686. How to use Macro throughout Department
  687. help writing a special 'COUNTIF'
  688. Is it a way to schedule an excel spreadsheet to update automatical
  689. Macro to insert extra rows in a table
  690. Need help matching Numbers
  691. What is the fastest way to bulk load data into Excel?
  692. delay msgbox?
  693. Alternate syntax...
  694. Moving in the worksheet during an evaluating function
  695. Activate Excel after opening PowerPoint from VBA Excel
  696. Select All Sheets and clear Interior Cell colours
  697. Dynamic folder??
  698. Range and Array question
  699. Inconsistent formula problem Excel 2002?
  700. Clearing Conditional Formatting
  701. dynamic named range
  702. If Then statement in a userform sub
  703. Finding Cell Interior Colour of First Cell in Column
  704. unable to set hidden property
  705. compare values in 2 ranges
  706. screen flicker
  707. Re: change folder
  708. break links
  709. Object required?
  710. worksheet referencing
  711. allow user to change workbook while in Msgbox or InputBox
  712. capture WEEKNUM & place in page setup
  713. Userform Question
  714. time till finished
  715. Excel Macro's use on several tabs?
  716. using worksheet name to find cell in table of contents.
  717. auto fit row heigth
  718. Macro to change Macro code?
  719. Trouble increasing the array number and capacity?
  720. can i reverse the data of cells?
  721. Array & variable
  722. Append a column with the text "Remarks"
  723. adding a module to several different workbooks
  724. How can i change the text color in a cell automaticly if i write.
  725. Range and SUM of 3 cells
  726. MACROS
  727. compare data evolution
  728. Help with Count Please
  729. How do I select a range to print if I have different numbers of ro
  730. Prioritising on dates
  731. Conditional formatting and weekdays
  732. Autonumber Newbie Assistance... Please
  733. Create a macro to launch notepad while in Excel.
  734. Excel8.h
  735. Macro
  736. Version difference when opening text files?
  737. QueryInterface for interface Excel._Application failed.
  738. getpath in a template
  739. Disable warning on macros
  740. Addins from Excel 95 won't work with Excel 2003
  741. Use of Format function in Excel marco
  742. Need help on an issue related with code management & data dimension
  743. Like Command Question
  744. Linking cells to several other workbooks and worksheets
  745. Linking cells to several other workbooks and worksheets
  746. Clearing Interior Colours or all sheets
  747. Send SQL to Access from Excel using ADO
  748. Linking Excel to PowerPoint
  749. Import a printable gantt chart from MsProject to Excel
  750. Linking a several workbooks and worksheets
224