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. Cell value while typing
  2. cant find project or library
  3. Excel upgrade to 2002
  4. Making a PDF-file
  5. Extracting the column letter and row number
  6. Subtotal & #n/a problem
  7. Printing a .pdf file
  8. Sumproduct Question
  9. Date Formatting Woes
  10. XL RTD server
  11. Decimal separators in formulas
  12. Selecting Cells using dialog box
  13. Debug.Print in a WITH procedure?
  14. Change value of each cell in selected range by percentage
  15. Macro - Insert&Label Column, if the labeled column doesn't exist
  16. null value cell
  17. VBA for XL OSX
  18. HELP PLEASE
  19. Function returns Range --> error 91
  20. Re: Dynamic Named Range repeat on different worksheet
  21. Range use on page
  22. Re: Active Printer Application
  23. Run-time error 429 after installing Office XP SP-3
  24. Re: Radio Buttons
  25. "Unable to set the ..." in Excel 97
  26. Generating HTML from Excel 2002...tabs broken?
  27. Re: Block REMarks in VBA?
  28. Re: SendMail only one sheet, not entire workbook
  29. Re: SendMail only one sheet, not entire workbook
  30. Colour number...
  31. Detect Workbook Name when using GetOpenFileName
  32. Open a Word document problem
  33. Define Range based on cell color
  34. Opening/Closing a lot of groupings via VBA
  35. VBA.NET
  36. Database Question
  37. validating 4 values programatically
  38. Transfering Declared value through procedures
  39. Extracting the Month from the Date in other cell
  40. Special Character
  41. PivotTable-Fields Page
  42. hide negative values from a formula
  43. Range as variable No.2
  44. Excel marco upgrade
  45. Links
  46. Formatting Issue - Zero's not being displayed
  47. it's going to blow!
  48. Format date in footer to propercase?
  49. HOw to create Excel user
  50. Auto Filter
  51. setfocus
  52. Application Events / App_WorkbookOpen
  53. Detecting active customview
  54. Faster AutoFilter?
  55. Referencing Shapes
  56. variable row count 2
  57. Move up text
  58. 7 Digits Only
  59. Sheet naming
  60. Re: Grouping and outline
  61. Data validation: using Custom, NOT List, to get non-blank cells
  62. Need Macro to Find Column Heading -- if none, then insert new column
  63. Keeping text together
  64. saving a macro
  65. Cell not refresh probably.....
  66. ? To Tom Ogilvy or others on VBA Listbox
  67. importing a tab delimited file
  68. How do i assure a pull down list begins at the top of the range?
  69. Copying rows of data based on a value in a cell.
  70. FileDialog problem
  71. EXCEL textbook for self study
  72. Props to Tom O.
  73. %SYSTEMROOT%/Temp variable
  74. Problem with VBA "Find" operation
  75. How to track two values and work with the data in between?
  76. Creating an Object on a Multipage
  77. How to Find MAX value with depedency
  78. olap cube (pivot table)
  79. Type mismatch
  80. Loop Through Highlighted Range
  81. "Subscript out of range Runtime Error 9"
  82. How does one get the PivotTable report info that feeds another PivotTable report?
  83. Hide Cells
  84. Headings in a Listbox
  85. Code Does Not Work
  86. Sheet Protect
  87. Subscript out of range
  88. dynamically create userform
  89. set last used for getting directory
  90. Automatically lock cells and hide formulas
  91. Max Value within filtered range
  92. selecting current row information and transfering it.
  93. tick boxes on userforms
  94. problems with XML XSL and Excel 2003
  95. sumproduct problem
  96. Tom Ogilvy or somebody else, please help
  97. Create a search Field within a worksheet to search command buttons
  98. protection
  99. CONDITIONAL FORMULA
  100. Inserting items into the Paste Special Dialog box
  101. What does the "Paste Special Dropdown" popup menu do?
  102. I need a macro that will delete every other row in excel.
  103. Macro Delays
  104. Re: Links using XLODBC.XLA not working after upgrade to 2003
  105. Find two values and select data in between
  106. window size
  107. Question for T.Ogilvy
  108. How to bypass "Enter Parameter Value" via macros
  109. How to use FileConverters?
  110. .filesearch trouble
  111. Borders/Inserting Line
  112. For..Next loop error
  113. Web query - when does error occur so I can trap it?
  114. restriction
  115. Excel 97 to Latest Excel. Repair ?
  116. csv for filetype property of filesearch object
  117. How do I use a for/next loop to preform the same actions to every.
  118. Cannot use .IsBroken property of a Reference object - error 48
  119. Create Database
  120. How select/define cells with FIND method (maybe together with SpecialCells)
  121. Print selective pages - only if the pages's Rows.Hidden = False"
  122. Borders/Inserting Lines
  123. How to setup a program to print on lower bin tray
  124. Help with Loop / Array / Ranges
  125. How to play a MIDI
  126. Hiding Cells
  127. List box Setup from Varying 1d Array
  128. macro to add additional lines
  129. Printing worksheet excluding rows with formulas
  130. Changes btw worksheets
  131. Running of a Macro when Workbook is opened
  132. How do I open Access database from Excel
  133. Dynamic Named Range count
  134. avoiding VBEopen when using CreateEventProc
  135. How to avoid re-initialisation when Unloading form
  136. Add and rename a worksheet
  137. Listing of Face Id's...
  138. Error after last object in the array when looping For...each
  139. using default excel screens
  140. How to build dialogue boxes into macros
  141. Programmatically switch off "Variable declaration reqiured" in VBE?
  142. Macro: If
  143. Excel and VB6
  144. Range object
  145. Speed up performance for very big array
  146. Random number generation from a set of non-sequencial values
  147. CurDir
  148. Ensuring a cell is copied in text format
  149. Problem
  150. newbie questions
  151. how can one obtain the current selected cell value
  152. Code Still Does Not Work
  153. combobox events
  154. General question about using "worksheet" when select from the VBA Editor?
  155. usings contains in var check
  156. How to create a dropdown list of dates with validation?
  157. Saving to the desktop w/ VBA
  158. How do I save to the desktop across OS's?
  159. ActiveWorkbook.SendMail Security Warning
  160. please help with FORMULAS
  161. link from one workbook to another workbook
  162. Print Orientation Toggle
  163. Run-time error 1004
  164. Double prompting of an over-write confirmation when saving a fileof the same name
  165. Default Page Breaks
  166. Will their be a fix for KB 818808 ?
  167. Using Multiple User Forms to pass info from one to the other
  168. Cell Reference to a location
  169. re-organising a table of data
  170. Copying over Rows Once
  171. please need help : collecting data from different places.
  172. Subscript out of Range Q
  173. Closing Other Workbooks
  174. Returning checked Nodes from Treeview form control
  175. Exiting Design Mode
  176. Intersection?
  177. Open event to call procedure ONLY on Monday
  178. macro attached to workbook: to be sent to other users
  179. Multiple Users
  180. Looking for eloquent solution: Determine of any control on a page of multipage has been altered (userform)
  181. Sum active range
  182. How to ungroup a set of controls?
  183. Listbox column headings
  184. Populate and refresh
  185. Not equal to?
  186. Command button on a protected worksheet
  187. how to lmport a text file and save it as an excel file using vb s.
  188. Web Queries - bypassing "no connection / data available" messages.
  189. How do I log everytime an excel workbook is opened?
  190. How to "bypass" run-time error '91'????
  191. finding the first blank cell and then executing rest of macro
  192. controling Internet Explorer from Excel...
  193. need help controlling IE from Excel...
  194. disable listitem
  195. Macros not running
  196. this is about excel programing
  197. Date in an excel form
  198. How to clear a form from the screen
  199. Values from another workbook
  200. Excel closing event of a specific file
  201. Populate selected Cell with variable
  202. Database ready
  203. complie error
  204. Put a button in a cell
  205. Sheet Code Module: copying code to
  206. ?thisworkbook.VBComponents(5).Type returns 2
  207. FIFO: Share calculation in VBA?
  208. access from vba
  209. User Form
  210. Replacing Named Range Names By Cell References in Formulas
  211. Add Macros to Someone Else's Personal.xls
  212. Storing text in an array
  213. External Links Problem
  214. MSComm locking up Excel
  215. splitting worksheet into multiple workbooks
  216. Floating Toolbars
  217. Custom button, code placement
  218. Scripting Excel - EXCEL.EXE refuses to leave task manager after .Quit and =Nothing?
  219. Drop Down boxes
  220. Read image from excel file
  221. Return an array of values from a function
  222. Excel instance not shutting down
  223. Monitoring Changes
  224. Formula Help Again
  225. populating data from excel into access
  226. Formulas
  227. Command Bar with Number in Name
  228. Custom Toolbar
  229. Move an object not using increment property
  230. Excel object - save as csv from Word?
  231. Creating & Naming a New Worksheet
  232. Inserting Cell Contents into a header
  233. Determine application language in Excel 97
  234. how to stop program in a big loop?
  235. Selecting AutoFilter Rows
  236. Picture
  237. need help controlling IE from Excel...
  238. Autofilter Properties
  239. How to Kill Excel application process
  240. Excel 2003 bug? VBA custom menu disappearing
  241. Get a workbook to import data when openeing and export when closi.
  242. getting back to excel
  243. Find Excel path
  244. Extra projects in VBA editor?
  245. Code Wont Work
  246. Read about excel - word integration?
  247. Problem caused by Googels personal index software!
  248. Strange window behavior
  249. capture data from multiple sheets and add to the bottom of existin
  250. how to run other program's macro in excel?
  251. Please help me on this....
  252. Activate Menu Items
  253. Widening the Name Box
  254. Invalid qualifier
  255. Turn Off Pivot Table Autosort
  256. Clear comments in a selection
  257. Macro & Passing a range
  258. weird saving of a document with macros resulting with macros being transfered to the copy
  259. Menu updates, Administrator VS limited account
  260. Saving the activecell range for later use
  261. OPening worksheet
  262. Locating Latest Workbook
  263. Last Workbook in A Folder
  264. Web query for pictures and maps
  265. Changing Workbook Property
  266. Calculate Individual Sheets
  267. Unable to Run Code on Specific workbook
  268. Code line not calculating correctly
  269. Late Binding to Outlook from Excel: Outlook modifies email body
  270. Problem with code
  271. setting an excel file to read-only
  272. Forgotten Password
  273. Changing color in palette
  274. Workbooks within a Folder - B-Lists
  275. VBA auto filter question
  276. Transform xsl file to xml file programmatically
  277. CXomparing Job Numbers
  278. Need assist with setting cell values from an addin subroutine
  279. Teaching VBA programming
  280. Line numbers
  281. Sum of value in cell range between 500,000 to 1,000,000
  282. wildcards in tab. names
  283. QueryTable OLE DB with Parameter
  284. Activating Custom Menu
  285. MACRO TO SELECT A PARTICULAR SHEET!
  286. Clearing Form
  287. VBA array - find largest element
  288. Run-Time Error
  289. Capturing deletion of a row
  290. Re: Searching an Entire Workbook
  291. Set Print Area
  292. How to convert SumProduct function in VBA code ?
  293. run time error 1004 naming a sheet
  294. Problem with Dynamically Writing Event Procedure
  295. Looping
  296. Help with if statement
  297. Move cursor down, skipping hidden rows
  298. recording macro to paste a copied ws formula
  299. how to use the divisibility condition in excel with 'if' statemen.
  300. Button doesn't work
  301. Whorksheet Calculate Event Q
  302. Does Workbook need to be open to copy to..from vba
  303. Type mismatch?
  304. Summarising data
  305. Error Handling with Web Queries
  306. Declaring variables (Long, String, Integer) and interpretation spe
  307. Between dates table lookup.
  308. Check Boxes?
  309. How can I default to Paste Special?
  310. How do I make toggling shortcut keys for superscript and subscript?
  311. PageBreak Problems
  312. Excel XP: How to make a reference to a library persistent
  313. Web Query to database
  314. Points measurement problem
  315. Running excel as an application
  316. refresh application.caption
  317. No zero in a cell
  318. getting the sheet names present in a work book????
  319. Can someone give me a simple macro to sort a column?
  320. Make this paste_into_word code flexible to unknown office/word version >97?
  321. VBA WorksheetFunction problem
  322. Prevent Column adjustments?
  323. Option buttons in Excel to perform formulas in a several Absolute.
  324. Macro Secret Key Code/
  325. Macro to generate new graph with variable range
  326. How to use Subtotal in VBA
  327. S Curves
  328. How do I add a reference to an object library using VBA?
  329. ADODB Recordset Function
  330. HOW TO send data to another program and get back results in Excel?
  331. How do i wrap text in a merged cell in excell?
  332. Background task
  333. Two Questions?
  334. Filters on Data Validation
  335. SaveAs and Hidden Workbooks
  336. Checkbox - Center Horizontally and Vertically
  337. I cannot use Assign macro in Excel. Could before but not now. A.
  338. VB Code Remains In Memory
  339. return used letters in a range function - an example
  340. Web Query running in backg. -how to know when data retrieval compl
  341. Opening 4 files with 1 button?
  342. Simple Thing
  343. How do I turn off macros when programmatically opening a workbook.
  344. Access 2000: Print Database name in Report footer
  345. analyzing poll data
  346. public sub
  347. VBA simple one..
  348. Characters bad when exporting asp.net datagrid to excel
  349. Debugging Aid
  350. ActiveSheet.Paste error in XP
  351. Code Repeats Itself And Goes To Wrong Focus
  352. Solver
  353. password userform
  354. common functions:where to put them?
  355. Dynamically Assign Objects to Form Objects.
  356. VBA excel programming
  357. Highlighting the active row
  358. Count function for two specific items in vba
  359. WorkSheet Present
  360. SaveAs Concatenation
  361. Validation List Box Locked
  362. Compare Size of 2 files
  363. Populate combobox
  364. update independent column on pivot table
  365. Getting data from sheet stored on LAN
  366. Auto update function in VBA?
  367. Need help similar to a histogram
  368. Macro to combine cells
  369. Newbie at mixing ADO and Excel
  370. Can this be done
  371. IF Functions for Text in Excel 2000
  372. Re: Determining Language Version of Excel
  373. Eliminate Case-Sensitivity in Search
  374. Sort More than 3 criteria
  375. Listboxes on worksheets
  376. Excel Problem
  377. Bulk-Delete All Custom Commandbars
  378. Re: Excel Problem
  379. Returning true if a number fits between a range
  380. Inconsistent error
  381. Excel page breaks
  382. automatic copy and paste from sheet to sheet in a workbook
  383. Dynamic naming of worksheets
  384. Use a variabel
  385. "If Not.." crashes
  386. Re: Hide a sequence of rows
  387. When to use screenupdating?
  388. Solver32.dll missing
  389. Find first cell in column's used range
  390. Copying ThisWorkBook Events
  391. fatal error
  392. Application.Match Type mismatch error
  393. How to select range of cells
  394. Trap a find error
  395. get cell.address question
  396. Cursor Movement vs. Range Reference
  397. Delete "Cut" row on move...?
  398. printing pictures in excel with VB
  399. Calendar
  400. Searching for text or numbers in textbox
  401. Error Setting Excel's Application.Left Property
  402. Are Excel Macros Adversely Affected by inserting an Object in a ce
  403. Excel query object
  404. protect embeded object
  405. Writing a conditional formula to Search with number ranges
  406. Listbox Selection
  407. Wrong reference showing up as missing
  408. Is it possible to validate date in Visual Basic Editor? If so how.
  409. ComboBox properties---need to recognize comma's in numgers
  410. How can I prevent users from deleting an Excel toolbar from a work
  411. Need help with Treeview control ??
  412. merging worksheets onto one
  413. percent increase
  414. Listing Sheets
  415. date
  416. MkDir and Save As
  417. lock cells
  418. How do I set up a macro using relative cell reference?
  419. userform
  420. Compile error?
  421. Compile error?
  422. Odd problem with charts... narrow!
  423. Data Validation Range Question
  424. Change Cell automaticaly
  425. Collection methods
  426. Programmatic addition of form elements relative to a cell
  427. Personal XLA not appearing on Worksheet Menu bar after Excel Start
  428. Update Links Popup
  429. Check if form is open
  430. Compiler Error
  431. Importing to Excel from an Outlook Form
  432. VLookup Recalculating Every Time - Help
  433. Format
  434. Error Invalid Qualifier
  435. Protect certain cells
  436. "Pick from list"
  437. Excel 97 shared file
  438. Switch() causes strange ADO result
  439. trying to populate a variable from a combo box
  440. Excel Export Script
  441. how can i turn functions written in VBA into an addin?
  442. XBRL in Excel 2003
  443. Personal Macro Workbook
  444. stuck on division
  445. Bring forward conditional formatted characteristics
  446. Copy worksheets without any code
  447. How do I print hyperlinked files when selected from a check box?
  448. Selecting Multiple Cells
  449. User input formula variable
  450. Debug VBA
  451. Add Checkbox programatically to form
  452. Copy data from excel into a web page.
  453. List Formula Macro Needs Enhancement
  454. macro ...if command, I suppose...
  455. Get the properties from a closed file
  456. Creating a recordset over a range
  457. Unique lists
  458. Excel Calculation Issue
  459. Find the occurrences of the particular word and appear one time
  460. Storing various data in .ID property
  461. No duplicates
  462. Stop on variable
  463. A problem when use create excel file using Microsoft excel ODBC dr
  464. How do i find the last entry in a column where every cell is not .
  465. Excel taskbar
  466. Formula
  467. Delete row depending on size of Characters in cell
  468. Business Budget - screen Printing
  469. Filter between dates
  470. budget template, screen printer
  471. Code Module to Add In
  472. Multiple firing of macro from ListBox
  473. Combo Box
  474. Please help
  475. How to source data from multiple worksheets in a PivotTable?
  476. VLOOKUP cannot find numeric values
  477. Worksheets, Ranges & Unknowns
  478. Delete LOCAL named ranges
  479. Turning a Macro into an add-in for Excel?
  480. running-total formulas written from one spreadsheet to another
  481. excel macro inconsistency
  482. printing selected sheets
  483. Using Solver with VB6 Excel Object
  484. How do I register Grid32.ocx
  485. TODAY'S DATE PLUS "BUSINESS" DAYS
  486. Re: Get VSTO code to run on every launch of Excel
  487. Running a macro on mulitple files
  488. Subroutine works but can it be improved?
  489. Save sht as text file - problem
  490. Workbook_Open() will not run
  491. Links using XLODBC.XLA not working after upgrade to 2003
  492. using RANGE object in multiple-area range
  493. Contents of an array
  494. verifying data type
  495. Error when running macro
  496. How do I total data in a single column and then chart off of that
  497. Can't assign a textbox to object
  498. Can't assign a textbox to object
  499. FINDING LAST CELL IN A CALCUALTION
  500. Found Files
  501. VBA Code for essbase Zoom-In
  502. how can I open a password protected document through vb?
  503. If Then Statement
  504. Variable Manipulation
  505. Adding tool tip to worksheet button
  506. Advances one Record when I tab...
  507. how do I subtract 2 date fields to get number of days elapsed?
  508. Cell Hyperlink - text, screen tip & link from other cells
  509. [Newbie question] Returning an array from a function
  510. Syntax for Range Reference
  511. Linking workbooks
  512. password protect vba code
  513. Calling a Private Sub
  514. Form development question
  515. Problem exporting as csv file
  516. Querytable refreshing on a protected spreadsheet
  517. Excel/Lotus Notes
  518. Recorded Macro to Set page breaks generates error.
  519. Macro
  520. Pivot table with form elements
  521. Mail Rounting, Need help quick!! I'm under the gun on this.
  522. Code to Save HTML table as xls file on click
  523. UserForm Value
  524. Userform for data pull
  525. Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend?
  526. Summing
  527. Excel Macro to edit and delete one character in a cell
  528. #Name
  529. UserInterfaceOnly on startup
  530. How to create Excel, Access and dbf output files from DataSet usin
  531. Inserting a function
  532. Move text after delete
  533. help on deleting several rows at once
  534. Compile error: Can't find project or library
  535. Setting chart series XValues in foreign language
  536. sum by currency
  537. DisplayAlerts = False fails
  538. How can read object order by useing writing?
  539. Array problem
  540. Closing excel with a macro
  541. "Clone" cell formats between sheets?
  542. How to action on Open Sheet
  543. Delaying until Recalcu code is done.
  544. How do I export excel data to an html file?
  545. Directory listing manipulation
  546. Want Excel Hyperlinks to reuse browser window
  547. Dynamic Arrays
  548. Identifying the Active Fill Color
  549. Re: Not filtering by date
  550. Re: Excel Version in which file was created
  551. Re: Help to adapt AutoFitMergedCellRowHeight routine to Target with 2 ormore rows
  552. Problem copying a range to a different workbook
  553. Re: How do i save as a textfile in a macro?
  554. autofill same number to end of file
  555. Populate 2-column ListBox with 2 non-contiguous columns
  556. Copying a cell one at a time
  557. Copy cells with certain info
  558. Recognizing a whole number instead of a decimal
  559. open password protected Excel doc
  560. Selecting rows
  561. help need on VBA code
  562. User Tools in Excel 2002 vs Excel 2000
  563. the sum of cells of many sheets
  564. E-Mailing Execl via Outlook Express
  565. VB code to make Excel open in a specific worksheet
  566. Switch from Office 2000 to Office 2003 error
  567. Importing from Outlook
  568. Importing from Outlook
  569. Updating records by status based on a formula.
  570. Using one subform to control another subform
  571. Unable to set the active cell from within a VBA procedure
  572. Macro to append onto and then sort a pre-existing list
  573. multipage tabs off?
  574. reformat contact data
  575. How do I hide a shell command called from VBA in Excel
  576. Can't resolve external reference on Excel 2000
  577. linking 3 rows into one
  578. setting up multiple timekeepers with multiple rates by period?
  579. find (exact match) ?
  580. Create a Named Range in Excel with VBA
  581. cell addresses selection for chart source
  582. Dynamic ComboBox
  583. Driving me nuts! Row Height, Cell Width
  584. HELP - Have two lists and #1 needs #2's contents subtracted from it
  585. Re: Array element
  586. Excel Code
  587. Mail merge does not show leading zero in Zip Code
  588. message property
  589. Write the result of a formula only once then lock it
  590. Reference to IE - but none found?
  591. End Of File - For use in Formulas
  592. Force standard chart size
  593. worksheet function?
  594. Re: Array element
  595. How can I compare a list of strings, allowing positive matching b.
  596. Log File CleanUp
  597. clearing memory /clipboard
  598. set variable once
  599. Help with Find
  600. Auotomating "Sort" in Excel
  601. Change Caption of Forms Command Button
  602. RE: Activecell Offset
  603. LOOKING AT THE FIRST PART OF A CELL
  604. numeric value
  605. RE: hide columns based on header macro
  606. Re: Works if I single step
  607. Re: how to average this?
  608. How To Pull Access Query into Excel (2003): Reposting
  609. extracting certain text
  610. Can I set up a worksheet as read only for one user
  611. find last row of data
  612. Re: Determining Language Version of Excel
  613. Sorting Excel object?
  614. Convert Excel into a CSV file automatically
  615. Instance of Wizard excel add-in
  616. Re: Test if application running?
  617. VB code in excell
  618. RE: How do i save as a textfile in a macro?
  619. Re: How to store additional attributes for a cell
  620. Re: Path/File Access error: "VB3B.tmp
  621. Selection vs Objects
  622. Re: Macro Needed To Find Product Cost In Another Sheet
  623. Re: Macro Needed To Find Product Cost In Another Sheet
  624. Re: Add Check Boxes to Many Cells
  625. Re: How to store additional attributes for a cell
  626. Re: Excel Version in which file was created
  627. SIMULTANEOUSLY adding rows in two sheets
  628. Cannot set HorizontalAlignment Property of the Range Class
  629. Can't find Macro code
  630. How do I switch focus from a modeless user form back to the excel.
  631. How do I insert a page break before each change in the cell conten
  632. PivotTable Object - Unable to get the name property
  633. Cell formatting question
  634. VB code to open Print window
  635. Can I run an external program?
  636. Help Needed - VBA If statement!
  637. Determining and presenting unique entries?
  638. Need to save/write ranges to a workbook
  639. Help Authoring and Excel Conversion
  640. indirect addressing? a range of cells
  641. Help Needed - VBA If statement!
  642. looping through selected sheet tabs
  643. Clearing ClipBoard in EXCEL
  644. Help Needed - VBA If statement!
  645. HELP WITH CHART - COMPLEX ONE
  646. Delete Digital Certificates
  647. Help Needed - VBA If statement!
  648. Help Needed - VBA If statement!
  649. Help Needed - VBA If statement!
  650. Common Data in Add_In
  651. can take a look at my code?
  652. builtin dialog box and arguments
  653. row height
  654. Problem Dropping data in first Empty Cell and across the row
  655. can a userform pass an argument?
  656. Identify product not found
  657. changing the currenc setting of a cell or range
  658. make severaly workbooks 1
  659. make severaly workbooks 1
  660. Excel, VB.Net and shutdown
  661. cannot find code
  662. xlDialogs(xlDialogSaveAs)
  663. Macro Help
  664. I cant use englisch function names in a swedich version of excel
  665. how to simplify this process?
  666. Clearing Memory
  667. all caps to lower case
  668. Combine records from 2 tables whenever there are matching values .
  669. How can I create a spreadsheet...
  670. Unable to set NumberFormat property of the PivotField class
  671. Unable to set NumberFormat property of the PivotField class
  672. populating one list/combobox based on the results of another
  673. Order Form Template
  674. change tab color base on cell value
  675. how to do the conditional formatting for this?
  676. Open workbook object
  677. Use VBA to copy a chart from the internet?
  678. Going down until the data stops....
  679. What's the Difference Q
  680. Opening Excel from Access
  681. Re: Processing non-contiguous row selections
  682. Named Range to Array Oddity
  683. RUN a macro based on a value selected in a drop down box in a shee
  684. How to Rename a Blank Sheet that a macro Creates
  685. Excluding cells in custom TREND function
  686. Mirror a workbook
  687. Combination of data out to two worksheets
  688. I need to find a macro to find data cut and paste to another colu.
  689. can anyone help me with this?? Thanks!
  690. Books on "how to" program macros in Excel using VBA
  691. Re: Find text numbers
  692. Project two - Diffrence Sheet
  693. Find text numbers
  694. Help with code
  695. probing the serial port for data
  696. Fomat change
  697. Problems with ADO from Excel
  698. SaveAs Question
  699. Save Workbook (Blist) as today's date
  700. Multi-Column Listbox properties
  701. Launch a VBA macro with opening a file
  702. Using multiple worksheets to keep track of changed values?
  703. Insert lines when x<> y
  704. Module update
  705. Wht is this Code not Working ?
  706. Wildcard for numeric characters in filename?
  707. fphover.class not displaying in Explorer 6.0 when XP SP2 is instal
  708. How does one return a specific cell in a web query?
  709. how to sort data this way??
  710. How do I set up a Conditional Alarm to ring a bell when a conditi.
  711. Copying Range from 1 sheet to next
  712. convert dates stored as text to dates
  713. How can I find the last time a custom function is called ?
  714. Can Paste-Special-Values be VBA programmed?
  715. Can "Home" key be VBA programmed?
  716. Automatic Lookup/Fill-in
  717. Macro to Copy Cells
  718. UserForm with ListBox
  719. How can I change size of the picture without changing chartobject?
  720. How do I Format a cell to make 1=$3.00 per cell then total?
  721. Insert word from dictionary
  722. How to check if an object has a certain property?
  723. Disable Save and Save As
  724. Selecting Menu Item by VBA Code
  725. How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation
  726. #NUM checking
  727. How can I involve in Rotary member of International?
  728. Can't find "stop recording" toolbar to use relative references
  729. Re: Change datalabel font size for all chartobjects in a row
  730. Name Check Box in code
  731. Add-ins and Reference library
  732. Perplexed
  733. Excel Copy and Paste into Outlook e-mail
  734. Tell OS to refresh?
  735. Userform Code
  736. Importing text file
  737. How to specify a range in VBA based on values in cells
  738. How to increment number using vb script
  739. Re: Select Case syntax
  740. VBA VLOOKUP Question
  741. Function to return a previous cell value
  742. Excel crashes when using CreateEventProc towards CodeModule
  743. how do you insert a drop down calendar in excel
  744. Check Box
  745. combo box
  746. VBA Code issue
  747. VBA Project Explorer
  748. drop down menus and repeting
  749. ThisWorkbook.Protect
  750. Dynamic Ranges Q