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. Automatically Append New Data in Unknown Addresses into Existing Ranges
  2. Worksheet Change - Help!
  3. RE: Conditional format via VBA
  4. We introduce our new resources
  5. Can I enforce Goal Seek to perform one iteration only?
  6. The Print # command print not all rows from excel sheet to file
  7. Hyperlinks
  8. Excel 2007
  9. Insert picture based on cell value (unlimited)
  10. Run macro by day --- but only once per day
  11. Re: Prompt user to select a printer using a checkbox within a user
  12. Enter data and press enter to move to specific cell
  13. Re: Controlling Visio from within Excel
  14. After entering data, press enter to move to a specific cell
  15. Customise Button on toolbar
  16. vb code help needed
  17. Paste area Error on my macro
  18. Re: temperature reader
  19. Refrencing Diffrent Tab.
  20. Refrencing Diffrent Tab.
  21. Cell variable name
  22. Re: xlPolynomial trendline
  23. Weighting Costs Across Multiple Months
  24. Add a live clock to Excel and change values accordingly
  25. Using Find or search for Cells with <3 Characters?
  26. How do I have Excel Macro write a open ended formula?
  27. xlPolynomial trendline
  28. test
  29. Re: Check to see icon exist in command bar
  30. Compare data from different sheets and total how many times it appears
  31. Bug in a built-in VBA date function?
  32. Re: Can Excel automatically shade a subtotal row?
  33. Excel and Outlook linking
  34. Syntax for Application.Ontime incl Variable Parameter
  35. What is the output of this code (CODE given)
  36. Re: Tiered Pricing
  37. Excel4 PAGE.SETUP?
  38. Re: How Do you Sort Worksheets in a Workbook, Alphabetically
  39. Printer/Driver
  40. Re: Create invoice from excel worksheet data
  41. Re: Formula in a Macro
  42. Arial pt. 8 ONLY
  43. Re: Assigning Macro by using code
  44. Re: Need a code to print and save file as
  45. Re: Macro How To
  46. Re: Importing file envelope infomation
  47. Re: Deleting a range
  48. remove name of addin in Tools menu: "Document Project"
  49. how do i delete a macro
  50. Re: Deleting a range
  51. Re: Removed digit from excel spreed sheet
  52. Re: Removed digit from excel spreed sheet
  53. Saving question
  54. Re: Follow up to unselecting cells question
  55. Functions that return a Range
  56. Replacement for Dsum - calling countif from aVBA
  57. Having different Y-axis
  58. Conditional Formatting using VBA Case...
  59. Macros the same but not acting the same
  60. delete modules and sheets
  61. Re: dynamic worksheet select
  62. help References in a User Function
  63. RE: copying by formula....
  64. Re: copying by formula....
  65. FileDateTime help
  66. What's up with VBA (?)
  67. Dynamic Graph
  68. Change Validation list in the adjecent cell on the Basis of Value in the Current Cell
  69. Re: Varying length records to be sorted
  70. This should be easy
  71. Creating listbox
  72. Deploying templates
  73. Disable the 'Send' button in Excel 2007
  74. Help required with VBA program to automatically enter data from a validation list.
  75. Transfer the colorindex of a cell to another, without using paste or pastespecial
  76. VBA for Excel
  77. Macro Issue with loop
  78. Keep value after deleting original information
  79. Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's)
  80. Getting RSS feed from Excel file
  81. How do I have Excel VB write a open ended formula?
  82. Sum the remaining rows and place the result in the row below the last
  83. how to make macro to combine text from 2 cells?
  84. Re: worksheet change
  85. Moving Complete Folder
  86. VBA code for message box and focus on a sheet
  87. unselecting or uncopying or whatever in VBA
  88. Omit Date from Blank Cell
  89. Why does the date change from "January 07" to a numercial value of "39038 "
  90. help with defining column only from range of cells
  91. Odd date parsing issue
  92. using a variable for MOD Statement
  93. Input Box
  94. Re: Increment number on command
  95. Corey.....certain cell protection.....
  96. Forms Buttons. Can you add a Comment to POPUP if the Mouse floats over it ?
  97. Combobox List to Open when uderform is Activated ?
  98. Help with an Excel Macro
  99. Replace hardcoded cell reference
  100. Show actual name of file path after you have renamed it
  101. Re: delete row if text in cell
  102. Re: Open workbook on close
  103. Re: Increment number on command
  104. Add values from a current cost column to a cost to date column at the push of a button
  105. Copy and Paste cells using VB
  106. Round to Nearest 25 Percent?
  107. Get Month and Year ONLY from cell value
  108. Referring to data series in a chart
  109. Why Spreadsheet worksheet is not a worksheet?
  110. Re: SpecialCells problem
  111. Q: Creating a macro to sort and group columns in a sheet according to another sheet
  112. Pivot Table Loop
  113. Re: "Personal" Sheet
  114. Textbox = Capital letters ?
  115. Re: "Personal" Sheet
  116. Re: "Personal" Sheet
  117. Re: Trying to convert from Early to Late binding
  118. Problem with reloading graphs! (References to Nameranges)
  119. Select the same cell in sheets 2 & sheets 3
  120. Daily "Tabs"
  121. Using a Named Range to create routing slip in Excel
  122. Re: Call one Macro after another
  123. How to use spinbutton to recover data
  124. Copy text with formatting from an Excel cell into an embedded Word object?
  125. Format date macro
  126. Re: Increment number on command
  127. Multiple For Next Statement, Excel 2000 & 2003
  128. move column data based on value of another column
  129. Another head banging problem
  130. convert to values numbers as text
  131. Input Box
  132. Programmatically Access to Symbol Dropdown in Format Cells Dialog
  133. Input Box question
  134. Control size and location of Tables and Charts Linked to PPP from Excel
  135. Help with paramarray
  136. testing if there are named shapes on a sheet
  137. Re: selecting a pivot table through VBA
  138. Re: need help populating a totals sheet
  139. peer review...need to change path where this saves .csv file
  140. stopping userform resize on minimize
  141. Pivot: Refresh Data with new Data - ErrorMessage
  142. File does not close
  143. VBA Causing Excel To Crash
  144. Change found text in special textfiles
  145. Benvenuto ai nostri luoghi circa il tatuaggio
  146. Get Fun With This Click Counter
  147. Visual basic linkup with Excel
  148. if addin loaded on command line, it is not in addins collection
  149. RE: Running a Userform from Excel
  150. Re: Retrieving page number count from Word DOC
  151. How do I have Excel VB write a open ended formula?
  152. Programming a Forms scroll bar on Chart Sheet
  153. Help with deleting all files inside of a folder from Excel?
  154. User form closes after opening another one -- Problem with "Unload Me"?
  155. need to build an Excel VBA database
  156. Need help parsing column data - new to Excel
  157. Need help with Criteria1
  158. Bug ! Textbox on userform will not align text correctly ?
  159. Comparing relative cells and making values dependent
  160. worksheet change
  161. Quick syntax question- bolding userform control text via VBA
  162. Toolbar Help
  163. Move/Scroll Specific Cell(Row) into the centre of the Screen ?
  164. Creating a Profit and Loss Statement from Imported Data
  165. Delete Row
  166. Excel UserForm issues: Textboxes cannot be blank
  167. Show actual font type as in the cell in a Combobox
  168. Looking for value; if not: add value
  169. Correct code to Exit Userform, with out Unloading data
  170. Selecting control on userform with part of control name (set question)
  171. Set new range based on rng.Offset(rng.Rows.Count, 0).Resize(1, 1)
  172. Re: consolidating worksheets
  173. Re: consolidating worksheets
  174. Borders within a With/End With
  175. How to insert a group of columns, each part of different ranges
  176. Creating/Adding Combobox
  177. Restrict from increaing numbers of rows and col in a spreadsheet
  178. vlookup again
  179. loop through tabs
  180. Delete empty rows in list of data
  181. Adding Combobox Values
  182. Hide/unhide specific cells based on the dropdown list value
  183. Add DropDown at Runtime Visual Studio Shared AddIn
  184. Using vbYesNo in conjuction with Userform
  185. Detect Hidden Columns by Formula
  186. question on formula
  187. Re: complex copy and paste
  188. period solver to schedule lifts
  189. Can you use a formula to fill cells with color?
  190. Create a activecell from the listbox?
  191. OutLook Task and Appointment
  192. Run-Time Error '-536608719 (e0040031)': Whats the problem?
  193. VBA reference to 3D range
  194. can concatenated result extract an address ?
  195. Re: Enable Auto Filters in protected sheet
  196. Addin close command not working in new workbook
  197. RE: Enable Auto Filters in protected sheet
  198. Re: range on new sheet between dates
  199. Using VBA to insert dynamic formulas into a worksheet.
  200. Allow a file to open on no more than 3 computers
  201. RE: help from Gary''s Student
  202. Re: AutoFit Columns in a new Worksheet
  203. listbox
  204. Run Time Error 1004
  205. Up Dating Cells From Userform
  206. How does Excel evaluate embedded "IF" statements
  207. Summarizing Large Reports
  208. RE: Lock Cell if another cell contains data
  209. TRACKING DATA
  210. RE: Recording a macro for a Data Analysis add-in
  211. Still stuck on finding the last occurence...thanks...
  212. Re: help from Gary''s Student
  213. Run-Time Error '-536608719 (e0040031)': What the hell?
  214. search and expand feature: programming
  215. Excel 2007 development problem
  216. Heap Error when debbuging my Excel COM Addin
  217. Command button to run a macro
  218. Statistics Problem
  219. How to code, AND where to place it !!
  220. Excel column autofit
  221. RE: Hyperlink help
  222. How Might I "Mail Merge" Data For Multiple .txt File Output?
  223. Re: Writing output to a textbox while VBA macro is running
  224. Re: Cell formatting
  225. Right Click
  226. RE: help from Gary''s Student
  227. Apply Names in Formula
  228. RE: Run-time error '1004'
  229. Macro to hide rows with a certain cell empty then set print area and print
  230. before close runtime error 9
  231. Re: On Error Goto 0
  232. Macros between two seprate windows (excel)
  233. Make only active sheet Volatile? Or other solutions?
  234. mouse pointer in and out from commandbutton's area detection
  235. Any way to compare VBA code in different workbooks?
  236. Re: Copy a named range from an installed add-in while in anothter work
  237. Re: Copy a named range from an installed add-in while in anothter work
  238. Re: Cell formatting
  239. can anyone tell me whats wrong with this line of code?
  240. Re: uncheck checkboxes from a form
  241. Re: Controlling tab order on a sheet to include AX combos
  242. Re: Decimal problems
  243. RE: Inserting Dates
  244. Re: Decimal problems
  245. Still having issues with adding a period to a ActiveCell.Value
  246. VLookup Help
  247. Navigate Sheets using In-Sheet Combo Boxes
  248. Help with Checkboxes
  249. Sort worksheet by the number of occurances
  250. Re: Check for duplicates and move to another worksheet
  251. Re: Conditional Formating on column matches
  252. Re: Dynamically changing a file name
  253. set the bottom propertie of a label
  254. Inserting Dates
  255. Can't edit cell
  256. Re: Dynamically changing a file name
  257. Find and Replace with Changing finds and replacements
  258. Re: Filter only shortcuts and xl files
  259. Re: Filter only shortcuts and xl files
  260. What the heck is wrong here?
  261. Re: Excel 2007 is saying macros are disabled, but they are not.
  262. Removing double lines by macro in excel 97
  263. Macro To Import Text File
  264. Open - Output txt file creation
  265. Re: Undo function after a VB macro in Excel 2003
  266. What event to use?
  267. Selection by color
  268. Use named range to fill Userform combobox XL2003?
  269. Selection by color
  270. Query SQL Server from Excel
  271. Re: copy a result
  272. Re: delete based on date in input box
  273. Need help 'cleaning up' a spreadsheet
  274. Easy Sorting for Senior mgt
  275. Display different charts
  276. How to click and highlight cells and calculate the total amount in MS Excel?
  277. How to Import the path of files (>100) in single folder to excel
  278. Name a dynamic Range
  279. Re: CreateObject - Namespace variable
  280. Re: Check inputbox enter is in correct format
  281. E-Mail from Excel at a Certain Specified Time
  282. Copy Worksheets and create new Individual Excel Sheets
  283. stop a macro
  284. Detecting row delete/insert
  285. prompt user to save file as {desired_name} and save it to a variab
  286. Create Compeition Schedule
  287. Need Help Formulating a spreadsheet
  288. Re: How do I tell if user has closed Excel.
  289. Re: Embedding Excel in a C# WinForm
  290. Re: Code Locks Up Worksheet Briefly
  291. Hmmm. Private Sub ComboBox6_DropButtonClick(). Should i have my code here ?
  292. Modify Font from this code. Possible ?
  293. Several worksheets in 1 file to different new files in one command
  294. Re: Using XML and integrate into MS Access
  295. Combo Box Dropdown Menu
  296. Creating character combinations out of a possible set...
  297. Strikethrough Text to be identified with code
  298. Setting the number of colors in a contour surface chart
  299. How can I save a Range in Excel to a Word File?
  300. trying to use print screen.
  301. Commandbuttons
  302. A tall order
  303. Populating a userform from data in a sheet problem. Is it an Obvious error ??
  304. Re: Decimals problem
  305. Re: CreateObject - Namespace variable
  306. Re: Range.Value fails
  307. Re: Range.Value fails
  308. Pivot "row hide menu" keeps having items I don't have anymore!?!?
  309. Detect Hidden Rows by Formula
  310. Re: On Error Goto 0
  311. Re: On Error Goto 0
  312. Change Combobox list to list more than 1 cell.value
  313. How to use variable in code
  314. using automation in excel to create multiple charts
  315. Automatically entering missing date into a list
  316. Concatenate Macro
  317. formula based on prefix
  318. Emailed Excel file comes across as read-only
  319. Add-in w/toolbar crashes on one of many company machines
  320. setting current directory
  321. Converting col number to alpha letter to use in a range...
  322. Re: entering date dd/mmm/yyyy in VB gives mmm/dd/yyyy
  323. Re: Run-time error '9'
  324. Excel Recalculation problem with VBA function
  325. How to check whether Cell has Validation?
  326. Re: Running a Userform from Excel
  327. Application.ScreenUpdating = False still causing screen to flash...
  328. Re: Pivot Chart Changes Data Labels Formatting
  329. Re: Can we make XY Scatter Chart using Pivot Tables
  330. Re: Save As Code
  331. Un-pivot
  332. Re: Adding Cells in Different Sheets
  333. Re: Fit Selection to Page
  334. Code to include a one-up suffix to a field value
  335. Re: Exporting only the workbook formatting
  336. Re: Cannot sane all data and formats
  337. Using Calculated Item to add dynamic columns in pivot table
  338. find and add values in different worksheets
  339. Re: Adding Cells in Different Sheets
  340. Re: toolbar
  341. Re: Determine which button was clicked on a sheet
  342. Re: Adding Cells in Different Sheets
  343. Re: Data Keeps Dissapearing
  344. How do I display an Excel file?
  345. Re: Excel 2002 SP3 and VBA
  346. Re: is it possible to store formula under a UDF
  347. set certain entire groupings of rows to print together
  348. Re: Cannot sane all data and formats
  349. Re: unhide multiple worksheets in one go
  350. Re: unhide multiple worksheets in one go
  351. Pivot Date criteria
  352. Re: Beginner
  353. Move down 1 cell after going to the end of my data.
  354. Re: 2 Questions about the following code - Please help if you can.
  355. Autofill using variables
  356. Re: Beginner
  357. Copy specific text from notepad into Excel
  358. Excel 2007: How to solve *Cannot run the macro...*
  359. Re: 2 Questions about the following code - Please help if you can.
  360. Code needs your help
  361. RE: Loop & Count
  362. macro that automatically sends a fax from excel
  363. Re: how to save the complete path of the file we open?
  364. Re: how to save the complete path of the file we open?
  365. Help with code please....
  366. Combobox list to leave ONLY related values in list ??
  367. Re: Using Instances of a Class
  368. make signed over-punch conversion work in a macro
  369. make signed over-punch conversion work in a macro
  370. Re: Migration from Excel 2000 to 2003
  371. How to select Acitive and Next Row
  372. Put date stamp on file name using VBA
  373. Need help with code debug please
  374. Hooking up a Cryptographic Hash Function
  375. communicating with another program via a network port
  376. Re: how can I send automatically a fax from excel 2000 using faxtalk?
  377. Re: Closing a Macro Early
  378. Re: How do I use a macro to select a range?
  379. Drop Down Lists
  380. intersect method error
  381. how do I put my unprotected cells in order to answer they're mixed
  382. Re: How to deactivate the external queries that are used to import dat
  383. rng.Offset(-1, 6).value to work with CheckBox value
  384. MS Excel 5.0 Dialog - What is this?
  385. Re: Print to fit one page
  386. Cell Refrences in Addin
  387. Cell Refrences in Addin
  388. xlUnlockedCells ClearContents Possible ?
  389. Using If Then to check for a worksheet
  390. Naming word tables or coding reference library with vba
  391. Setting CONST referencing a cell Value
  392. Re: Istalled Windows Version
  393. VB and check boxes in Excel
  394. Locked hidden cells
  395. Extracting Data from the Web
  396. Re: Use Range Name with 'Find'
  397. Re: What's causing this?
  398. Re: A hard one for manipulating arrays
  399. Re: How do i write an offset code ?
  400. Re: I need help making 'click' buttons for a survey.
  401. Re: go to top of page
  402. Automate an Excel Add-In Install
  403. Consolidating spreadsheets
  404. border non-contiguous rows
  405. Re: Excel 2002 SP3 and VBA
  406. Re: Print to fit one page
  407. Code to Delete Range Names
  408. Re: Create a collection of ranges
  409. Re: Excel 2002 SP3 and VBA
  410. Re: Excel 2002 SP3 and VBA
  411. Display only 1 column in listbox but return another
  412. Re: Create a collection of ranges
  413. If A cell Is null Do Nothing.
  414. Hiding column if cell in previous column is empty-revised
  415. Re: How do I change the shadow using a formula?
  416. Question on determining "ROW" inside of a "For .. RANGE " loop
  417. Detect for empty excel sheet
  418. Insert chart into user form
  419. adding code to command button in word from excel VBA
  420. Tough One To Crack for excel specialists
  421. Paste, clear and ignore contents and... automatically!
  422. Boxes in my addresses
  423. require more than 7 nested IF statments
  424. Re: A hard one for manipulating arrays
  425. Re: Multiple Versions of the same file
  426. Forms / Lookup
  427. Re: Headers
  428. Printer Driver / Video Settings?
  429. Re: Paste
  430. Re: Multiple Versions of the same file
  431. Cut Duplicate Records based on criteria
  432. Re: Worksheet_Calculation Issues
  433. Hard Coding A Button Using "Buttons.Add(x1,x2,x3,x4)"
  434. Re: Automatically Update Currency
  435. Equivalent of Vlookup function programmatically
  436. Re: Macro has stopped working!!!
  437. trying to use xlToRight but having problems
  438. UPPER case in a macro
  439. Display column when previous column contains data
  440. Combobox Help...
  441. ctrl+break when modeless
  442. VIP needed!
  443. Change event
  444. getting paste function to list all addin functions
  445. Problem looping ChartObjects in a Com-dll
  446. Adapting Excel 4 Macro Page Setup for multiple pages
  447. Block keyboard input
  448. How Can I write a function that calculate the time it take to coomplete all the loops
  449. Convert text from clipboard and put in cells...
  450. Cut and paste duplicate data
  451. Auto Fill Color of a particular Cell if conditions are put
  452. Deleting Personal xls
  453. Re: Creating a .csv file that will import to multiple worksheets
  454. How do I get Excel to jump to the next row using VB code?
  455. A continuing search
  456. Macro - Cut and paste a row if duplicate
  457. Re: Downloading Worksheets
  458. If statement question
  459. How do i write an offset code ?
  460. assign excel 2003 macro with parms to shape
  461. RE: Downloading Worksheets
  462. Changing Filename in VBA
  463. InpurBox & Directory
  464. Returning an array from a multi-dimensional array
  465. Strange formatting behavior
  466. Re: Inserting Dates in pre-existing data list
  467. RE: Select All,Copy All and Paste Special Question
  468. RE: Select All,Copy All and Paste Special Question
  469. Slow Running Code to Hide Blank Rows
  470. RE: Select All,Copy All and Paste Special Question
  471. import only files with a certain extension
  472. How do I get Excel to enter a cell and delete the last character typed?
  473. Re: excel formula writing question
  474. Re: Command Button Question
  475. A bit of Syntax help please...
  476. Re: Creating a help file
  477. display multiple lines in pop up when workbook opens
  478. Insert row after pagebreak
  479. Display data in a combo box
  480. Inserting Dates in pre-existing data list
  481. Re: Combining Macros
  482. Using a string to set an object reference?
  483. Re: Combining Macros
  484. Re: Open Workbook with Macros
  485. Re: Need help with codes please
  486. Combining a 3-Step Formula into One Formula
  487. Re: Line Gradient in Excel 2007
  488. Re: Creating a help file
  489. Re: Need help with codes please
  490. Regular Expression for cell address
  491. Perform a task if result is a whole number
  492. Re: userforms & workbooks
  493. Re: userforms & workbooks
  494. Importing External Data using a variable
  495. Error when adding a reference to Analysis Toolpak
  496. Build a userform on excel to copy contacts from outlook 2003
  497. RE: Help with a sort please - Tom it worked like a charm thanks somuch
  498. Problem with nesting an OR in a formula
  499. Re: How to replace a tilde with the corresponding headword
  500. Reset Spin Button
  501. Hide Spin Button
  502. Re: macro is creating a duplicate worksheet
  503. Getting a value from a formatted row
  504. Dynamic user form - VBA and Excel
  505. using now() function not in a cell
  506. Help with a sort please
  507. Help - Using VBA with a validation dropdown list and a table to expand the entries
  508. Re: Allow font colour changes in protected
  509. Re: Cleaning Up
  510. Re: Cleaning Up
  511. Pause a macro for some time
  512. RE: Allow font colour changes in protected
  513. Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ?
  514. Check if a predefined number of workbooks exist in a specific directory
  515. Check if a pre0defined number of workbooks exist in a specific directory
  516. ShellExecute hangs Excel when opening XLS file
  517. Run macro when adding a new line
  518. digital signatures in Excel
  519. Loop & Count
  520. Class Modules
  521. IF FUNCTION
  522. IF FUNCTION
  523. sequencial sort
  524. text to columns trouble with "zeros"
  525. Rename Several Defined Range Names with Macro
  526. Delete the last Range Name
  527. VBA Module Recovery?
  528. front end form
  529. fill cbox unique value
  530. Excel hide caption bar...
  531. PrintArea Query
  532. Combobox value to be set as Target for referencing from. How ?
  533. Possible to call a procedure inside a function?
  534. Remove item from Tools menu
  535. Excel 2007 is saying macros are disabled, but they are not.
  536. Moving data from mutiple workbooks to one
  537. File in Excel 2007 has encrypted macros. How to remove restrictio
  538. Discontiguous Chart Source
  539. RT Error 438
  540. Looking to make simple formulas
  541. Looking to make some simple formulas...
  542. deleting shapes with VBA code
  543. Trying to demo Code, but get error
  544. easy udf by VB
  545. Macro Problem
  546. Easy question - Unselecting cells
  547. Problem with "ThisWorkbook.Saved" property.
  548. Extra Sheet, Workbook, and VBA code protection?
  549. Use Outlook 2003 contacts in excel
  550. Macro for copying data between sheets - Help needed.
  551. Rename Protected Worksheets
  552. two way vlookup
  553. Printing
  554. Insert row at start of each subtotal
  555. Benvenuto!
  556. Excellent sites!
  557. Solver and VBA
  558. Changing focus question
  559. Autoopen of an Excel File at the set time
  560. There must be a way!!!--set cells' values equal to calculated values in another range
  561. Listbox question
  562. Hide row if particular cells are empty
  563. sorting custom
  564. How do you solve this one ?
  565. Code looping through files
  566. Open external data (varying file names) and closing file once data is retrieved
  567. Excel Connect to Accpac Dos
  568. If A>0, I need a message pop-up box to show text in B1
  569. Reference UDF within Worksheet Formula
  570. Sheet Ranges Possible?
  571. Move File to New Directory
  572. Divide Value in Cell by worksheet count
  573. Change colour of multiple shapes in a Chart???????? HELP!
  574. Excel Spreadsheets to Access Database
  575. Creating auto functioning worksheets
  576. Cannot create forms?
  577. Pattern Matching using LIKE ?
  578. Adding a Value from one worksheet to another.
  579. VBA basic question
  580. Write 3d array to range
  581. VBA question
  582. worksheet change
  583. Randomly selecting a cell weighted on percentage
  584. Adding information to a Pivot Table
  585. Create simple line graph in Excel!!!!!
  586. Subs
  587. How can I take away a xldatafield from my Pivot table in VBAexcel
  588. Problem with short-cut key combination
  589. C# Value2 intermittent exception
  590. Request for help with EXCEL 2003
  591. MicroSoft Office Development Tool Kit (SDK)
  592. RE: Removing VBA Password
  593. RE: Removing VBA Password
  594. Re: Removing VBA Password
  595. Re: Removing VBA Password
  596. leave one blank row between data in *visible* rows
  597. Change cell color
  598. RE: Footer Font
  599. VBA Problem Converting Numbers that are brought in as text
  600. Cout CF in range that = blue
  601. Transpose to Non-adjacent Cells
  602. Skip code
  603. If spelling of a word in a DV range changes, can values previously selected be updated?
  604. SendKeys
  605. HOW TO TRACK DATES OF A MONTH EXCEPT SUNDAY
  606. Can't find project or library
  607. Updating value in form text box based on combo box input
  608. select cell with value
  609. Org Chart: Can't add coworker object while recording macro?
  610. Re: System Error &H80004005 (-2147467259). Unspecified error
  611. Newcomers' Newsgroup Etiquette
  612. checking for a numeric value in a textbox
  613. Type of variables and their effect on result...
  614. Re: Syntax to Find User's File in MultiUser App
  615. Create & Name new Sheets without duplicates
  616. DSUM - Modifying the function...
  617. Bubble Charts in C++ Automation
  618. Re: Activating Workbook
  619. Custom Toolbar Below Other TBs
  620. RE: Recognizing cell change in a Sub Worksheet_Change procedure
  621. Re: Recognizing cell change in a Sub Worksheet_Change procedure
  622. RE: Recognizing cell change in a Sub Worksheet_Change procedure
  623. Re: Activating Workbook
  624. Re: Pulling Part of a String
  625. Re: how can I create a save file hyperlink or macro in a workbook?
  626. Prevent Editing of Worksheets w/in SpreadsheetML
  627. Re: Pulling Part of a String
  628. Re: UserForms -- Subscript out of range error
  629. Pivot Table Error
  630. Hiding subtotal groups
  631. Re: excel question?
  632. Re: Pls advice if there is a bug in my vbe ?
  633. Possible to automate conversion of text files to Excel?
  634. Posting text from VBA to spreadsheet Web Browser
  635. Re: wrap text
  636. Re: wrap text
  637. Re: Can we run Windows Script file from Excel/Office Application
  638. VBA compiled - affects conditional compile?
  639. Randomize tab colors when new sheets are added, and link color to formatting
  640. Create an Array to fill a Range
  641. excel question?
  642. FAX with Excel VBA
  643. RE: Multiple Userforms Upon Click
  644. Excel size increase through charts
  645. Problem solver call from vb6
  646. Run a macro when changing the sheet
  647. RE: CommandButton Caption Anomily
  648. RE: Can we run Windows Script file from Excel/Office Application
  649. Function Int
  650. ActiveCell.FormulaR1C1 = "=IF(c4:c4<='Title Page'!$B$19,1,0)" ?? HELP!!!
  651. Code stops for no apparent reason
  652. Controlling Hidden Rows / Columns in Filtered List
  653. Problem with ATPVBAEN.XLA
  654. Copying Cells
  655. Showing rows containing text
  656. Hi ...read text file and copy it in a specific cell
  657. Hi ...read test file and copy it in a cell
  658. Modify code to reference from a Matching value in Combobox1
  659. VBA coding to copy sheets into a new workbook
  660. Combobox Properties (Text Wrap and Center from Top to Bottom) How?
  661. macro help please
  662. Macro Help
  663. Re: can i from excel create mail merge with calendar invitations ?
  664. Totaling (Subtotaling) a Changing Filtered Range
  665. RE: cell.offset when starting cell is merged
  666. Custom face for custom toolbar item
  667. RE: cell.offset when starting cell is merged
  668. Re: Worksheet Change Error
  669. Number of links?
  670. RE: SP UDF for EXCEL
  671. Non Static Variables in a For...Next Loop
  672. Re: Show Milliseconds
  673. combobox on userform not populating ??
  674. Conditional automatic entry from a list using VBA
  675. Re: exit from excel?
  676. macro for pivot table
  677. Re: personal xls for UDF
  678. Re: Need some code for header/ footer, another case of "last saved
  679. Excel Chart displays incorrect X-Axis
  680. Accessing Mapquest info from Excel
  681. Re: Help Rearrange Data
  682. Re: Show Milliseconds
  683. Re: Need Automation Help fast
  684. Re: Need Automation Help fast
  685. Create an attractive "link" button
  686. Userform Suggestion
  687. Re: any more criteria condition for mySP UDF, if possible
  688. How to run an After Save event?
  689. Re: more factors needed for an SP UDF
  690. RE: How do I do this
  691. Re: clearing a user-defined Type variable
  692. protect sheet question
  693. Filling both hidden and visible cells once a filter has been applied
  694. FTP via VBA
  695. Re: excel question?
  696. Data table automation problem
  697. repeat macro for added items
  698. Automatically add/show/hide rows that have (or have no) data?
  699. Help: sort data and move to a new sheet
  700. It takes two clicks to shut down Excel
  701. Hash (#) at start of line in VBA
  702. Stand alone VBA script files
  703. Run macro on refresh data (pivot table)
  704. Merging Spreadsheet and matching data...
  705. Move cells to another column based on value of cell
  706. Importing all files in a folder to excel workbook
  707. pls help ammend progress bar code
  708. Export sheet > store sheet > import sheet.
  709. How to reference to an other excell book to get the value
  710. RE: Check Box Question
  711. Copying rows to another sheet when certain value equals
  712. Re: Check Box Question
  713. Change row height
  714. C# COM Add-In: Form doesn't appear after closing n reoping it 3 times
  715. RE: Problem with too large a range
  716. UDF for Excel in C# paramters not coming through
  717. Re: Lists and Look ups
  718. Formatting numerals and text numbers between Arabic and Hindi (indic) languages
  719. Unexpected CommandButton Caption Display on Exit
  720. Pass the variable into the sub function
  721. How to check drive exist or not using FileSystemObject
  722. e-Mail File out of Excel 2003 Macro
  723. Look up Function
  724. RE: what's the problem with this ?
  725. RE: what's the problem with this ?
  726. RE: what's the problem with this ?
  727. Combobox List to list Numerical Values ONLY in Column A is specific Sheet....
  728. Pivot Cache
  729. "LegalWorkSheetName" Function?
  730. Help with a Dynamic range
  731. Cancel 'Password' prompt during VBA
  732. Formatting Text to Italic AND Underlined to individually listed cells
  733. print PDF file from Excel - NOT print Excel to PDF?
  734. moving between windows
  735. Charts.Add error '1004' Method 'Add' of object 'Sheets' failed
  736. Help writing macro for a lookup table
  737. Excel solver in vb6.3
  738. Re: Highlight Cell
  739. Using VB Code to update one workbook with data from 4 diffferent workbooks.
  740. Re: Activate WorkBook
  741. RE: Highlight Cell
  742. A macro that will show a cell's contents but not allow it to print
  743. Re: Highlight Cell
  744. Combining Files
  745. Find Replace List of Items
  746. Simultaneous rst.AddNew and rst.Delete from 2 Workbooks
  747. Re: Activate WorkBook
  748. Re: Delete workbook..?
  749. Macro Only works Once
  750. Centering a worksheet for viewing