PDA

View Full Version : Microsoft Excel Programming


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 [52] 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. Help Reviewing My Loop
  2. How to use substitute function in macro?
  3. Reportable Error in xla - Desperate
  4. HOW TO OPEN APROTECT EXCEL FILE.
  5. highlight duplicate rows comparing two cells
  6. Display CountA Formula and Text String in a cell
  7. Problem with Macro
  8. Copying a cell value to a specific cells
  9. Code runs to slow
  10. problem moving columns around
  11. Combining Fors and Ifs
  12. Deleting a row that has a zero in column A
  13. Updating from one list to anoter
  14. IF sum help
  15. If condition
  16. Syntax problem with code
  17. Does the folder exist?
  18. Programatically click CommandButton
  19. Excel Custom Box
  20. COPY ROW
  21. Macro to create new workbook
  22. Manipulating Time
  23. Screen Flashing
  24. Curious about macro possibility
  25. Pivot table
  26. Selection based on partial input
  27. What wrong with defined variable?
  28. find name of a chart
  29. Help on macro coding fo URL
  30. Reference cells in a Hidden Worksheet for display in a UserForm
  31. Merge Data From one Workbook to another
  32. Range Objects + Names + Error 1004
  33. Convert Time Column to Text
  34. Limit open dialog to certain directory
  35. Pass a variable to a different sub
  36. Check Data Validation status via a macro
  37. Is the array empty?
  38. Copy from on eworkbook to another
  39. Workbooks property
  40. array dimensioning
  41. Detecting a change in a cell
  42. Do while loop
  43. How to know if cell has name
  44. Return cell(s) Conditional Formatting Status via a macro
  45. Excel Macro Help
  46. Pass a Variable from one sub to another sub
  47. Drop Down Menu Options? Need a PRO
  48. Close X button on Usser Form
  49. Select First Row of Active Column
  50. Sumif with multiple columns in sum_range
  51. File URL Path
  52. Filename macro and a little more?
  53. If statement formulas
  54. function for looking up text
  55. Programmatically Halt Macro and Open VB Editor
  56. I am new to VBE. How can I create a for loop without typing it intothe code.
  57. AutoFit Row Size with Merged Cells
  58. creating a macro to find a cell value and return a statement in a
  59. VBA Code needed to AUTOMATE VALIDATION selections and then PRINT EACHNAME dynamically
  60. Userforms fill screen whatever resolution
  61. Text with link
  62. Include hyperlink in email message
  63. Loop and append to different worksheets
  64. charts source data series copying
  65. Excel Macro works in 2000 but not in 2003 - HELP!
  66. VBA Grouping Rectangle/Text Boxes
  67. Offshore Data Entry Is The Only Way To Increase Your Business
  68. How can I do this..
  69. error in exel
  70. EXCEL Statement help
  71. Excel macros
  72. #NAME? on correct formula
  73. one combobox affecting another
  74. Test a cell for a comment presence from within a macro form 2007
  75. Does VBA shortcut "or" statements?
  76. OUT OF STACK SPACE ERROR
  77. Need formula to calculate the average number of consecutive cells
  78. Loop to copy rows down
  79. Splitting decimals
  80. convert second word in range to Proper when first variable length -urgent please
  81. select the range with the cell's position is a variable.
  82. DECLARE VARIABLES PROBLEM
  83. F11 Crashes Excel
  84. Two Open Workbooks
  85. Linked Cells and Sort Issues
  86. RunTime error 462: Remote Server not avaliable???
  87. Copy & Paste "Equal" Function: Adding Distance
  88. Query SQL Server On Entry
  89. Excel macro to open Notepad and save with Date/Time in filename
  90. AutoFilter... not quite right
  91. Sort blocks of data as if each block was a single record
  92. comment or input message
  93. Avoid saving file with code in
  94. Printer
  95. Seaching a Word Document from Excel Part ii
  96. copy data from a list
  97. how can a macro be paused for input and then resume executio
  98. InputBox Help
  99. Creating separate spreadsheets from a master spreadsheet
  100. how do i set number in cell to add 1 upon opening sheet
  101. Use count data in formula
  102. Area Chart not refreshing/updating properly
  103. Listbox Max Columns
  104. Excel 2007 Oracle DB Help
  105. Getting Picture Into Image In UserForm
  106. Permanently enabling macros...
  107. MACRO
  108. sum cluster of cells based on values
  109. Clickbox control help needed
  110. Solver VBA - Defining Solver Options
  111. Close Excel server after activating OLE object
  112. insert, name and format new worksheet
  113. Hide a Spreadsheet in an Add-in
  114. Calender matrix in Excel
  115. Microsoft Office 2003 Web Services Toolkit
  116. using Excel's regression analysis to compare correlation of FX rat
  117. receiving drag-n-drop from PivotTable field list
  118. VLOOKUP or MATCH >=255
  119. Border Problem
  120. Textbox value copy from one worksheet to another worksheet
  121. UserForm Labels not Showing Properly
  122. sort and copy selection to other worksheet
  123. deleting record with a range
  124. Save as
  125. Code to insert check mark
  126. Hidden Cells
  127. Works in 2000 not in 2003?
  128. How to disable and hide ALL menu in Excel 2007?
  129. Data checking- a better way!
  130. Excel connectivity issue from .net application
  131. Combox In Form
  132. Macro Update Macro
  133. how to allow insert hyperlink and grouping together under protecti
  134. Application Crash Whie adding Code lines using VBA
  135. Hiding rows only when a condition has been met
  136. How do I invoke the "Reset" button in the VB Editior via code?
  137. Copy from one workbook to another
  138. Exclude Leading Blank Rows From Selection
  139. ADO sql server password
  140. how do i protect one cell for write but not for select?
  141. Workbook_SheetChange event
  142. How to Execute macro after importing external data ranges
  143. Pivot Tables and Macros
  144. Worksheet Tabs
  145. Can I programmatically access the MS Office Clipboard?
  146. How to enforce input and delete order of cells?
  147. Dropdown list to populate sheet
  148. Vlookup then subtotal
  149. Delete rows if value matches
  150. Array of Charts in Excel
  151. Find Command
  152. protect formulas only
  153. Lotus Notes get all the recipients
  154. to Ron de Bruin Please
  155. Nested Search and Replace
  156. combobox fraction
  157. This is killing me
  158. Need help adding If/Then/Else Statement
  159. is there a "workbook.calculation" command ??
  160. Model User Forms
  161. Generate list of number
  162. How to remove carriage return symbol before importing into excel
  163. remove vba code before emailing as attachment
  164. Textbox value - rename worksheet with
  165. hiding pivot tables
  166. updating macros
  167. How to change process bar % when macro is running
  168. Returning the IP results from a ping?
  169. Converting pdf tables into Excel files
  170. How to stop macro with cancel button
  171. RemoveDuplicates not removing all duplicate entries
  172. How do I disable "save as the new xml format for additional securi
  173. Activate the cursor in a cell
  174. Looping Listbox in Userform
  175. return ADO record set from Add-In?
  176. How do I direct a macro to a newly opened workbook
  177. looping struggle with index/match
  178. Print Selection
  179. ActiveWorkbook.SendMail and IE - odd problem
  180. Adding button to worksheet
  181. Status Bar Freezing 2nd Try
  182. Links broken when spreadsheet emailed
  183. XML schema validation fails
  184. Screen Updating For Status Bar
  185. How to "step into" in the middle of a long piece of code
  186. Macro additional information
  187. search button on sheet (ctrl+f)
  188. Buttons don't show
  189. Changing a variable which is to be specified through a loop
  190. Text Orientation in Published Worksheet
  191. Listbox to Array
  192. excel 2000 help
  193. Open / Close Grouping through VBA
  194. Loop to move #'s from one column to next
  195. Macro - Search one book, replace with data from another
  196. same sheet copy/paste special
  197. Initiating Excel VBA Code From Access
  198. use part of date in cell for save as name
  199. help with part of my macro
  200. Maintaining a list of unique entries in a list
  201. Uppercase Check
  202. replace . to / in dates
  203. How to Pass a date from a calendar control to a field on a form
  204. Most non built-in command bars invisible in Excel 2007...
  205. Combo control to execute code BEFORE change - please help
  206. Protect/hide VB code?
  207. How to give combo box the focus
  208. can I force formula to be applied automatically?
  209. Excel Cell Comments
  210. What keystrokes indents/outdents a block of code?
  211. copy paste code not working(troubleshoot pls)
  212. copy data in turqouise colour cells from n to a
  213. Please Help! Need to add a Variable Range in my Excel Macro withPivot Tables
  214. Including ActiveX Controls in Names Range Selection
  215. Can't perform requested operation in excel macro
  216. Excel Footer
  217. importing data from closed Excel workbook
  218. Using ADO to query CSV with no unpredictable headings
  219. Shname = Array("Sick Graph","Accident Graph")
  220. Complicated replacement values in list issue
  221. Please help on coding
  222. Message box
  223. Assigning array values to seriescollection
  224. Custom AutoFilter to Compare Due Dates to Current Date
  225. highlight duplicate rows comparing two cells
  226. Extend a Range
  227. importing data from closed workbook
  228. How do I goto column B in the current row using VBA?
  229. #VALUE! from Function()...Posted in Excel General Questions by mis
  230. Issue with File Name changing in cell
  231. How to read xml file using VBA macro
  232. copy/paste special
  233. vlookup STRANGE
  234. Macro File path problem
  235. Problem with ranges
  236. Pause to select cell
  237. Text Import Wizard
  238. Adding sum to varying columns lengths
  239. how to save *.xls in a DB in Acces
  240. USEING IF FUNCTION TO COPY IN ANOTHER WORKBOOK
  241. vba code on seperate excel file
  242. Zero Division
  243. macro to open an existing email message
  244. Macro
  245. Match , copy paste (using find?)
  246. Enter NA() into All Blank Cells in Range
  247. Range as a variable
  248. How do I prevent an error from crashing my macro?
  249. Printing Consecutive Number (One spreadsheet) on Each Sheet
  250. One macro two versions
  251. Dynamically select range
  252. multiple worksheet copy and paste formatting question
  253. Force a File to Open in a New Excel Instance
  254. Using ADO to insert values into CSV file
  255. Loop thru folders
  256. Combining sheets with variable layout
  257. Mouse rollover pop-up message
  258. convert multiple sheets into PDF
  259. Execute VB code against certain open workbooks
  260. keeping an object in view
  261. Boolean Declaration
  262. Copy a Cell with a macro
  263. Tab Function for textboxes on Worksheet not UserForm
  264. Rename Tab with Textbox on Worksheet
  265. .find not finding formula result
  266. Adding an alarm
  267. Convert Input String Formula to Number
  268. Dynamic Workbook in VBA
  269. Identity Specification
  270. Find empty cell and input data for other cells
  271. Code to Follow Hyperlink to media player without a new window opening
  272. Format particular words in a string
  273. Macro to copy a certain a cell to a dynamic range
  274. Automatic Sheet Naming
  275. Automatic Sheet Naming
  276. Saving Excel Workbook to a stream using Excel 2007 Plug-in
  277. it training institutes details ............
  278. select, copy and past all cells with specific colour
  279. Error: Type mismatch
  280. .Value 9999 not recognised
  281. ADO Syntax proble
  282. Excel Data to Powerpoint
  283. Enhance sub to paste charts as well
  284. Pivot Table from external CSV file using VBA
  285. Help on coding?
  286. Insert column and hide columns
  287. Using Caller with sub-menu selection in 2007
  288. Userform close
  289. Excel addin - how to deploy?
  290. VBA Continuation Lines, Best Practices Mar08
  291. IMPORTANT!Conditionally formatting just 2 of many characters in a
  292. Passing ranges to a subroutine
  293. Using ADO to Excel with this Query will not work?
  294. Rename first X number of worksheets predefined names
  295. Stuck and need help
  296. Opening a Workbook within VB
  297. Error saying Control object does not have Enable property.
  298. Macro to convert mmddyyyy format into mm/dd/yyyy format
  299. ActiveSheet.QueryTables.Add
  300. Disappearing Images
  301. Display Math Equation in Userform
  302. Help modify macro
  303. 'Composing' numbers
  304. Paste special validation
  305. Public Sub ProcessData()
  306. FILE 2 SLOW
  307. checkbox centered in cell
  308. How to permanently activate Macros?
  309. Copying Worksheets from one workbook to another
  310. pick from list and automatically enter corresponding cell
  311. extract data from Outlook
  312. Hyperlink Underline
  313. Named Constant
  314. assign Drop Down selections with values
  315. Multiple questions
  316. Error Trapping on Data Entry
  317. Worksheet_Change - initiate macro on another worksheet
  318. select cells with this/that colour with macro
  319. web query for driving directions
  320. if cell text repeats, move the adjacent column to the same row
  321. Macro to put records of same person on same row and delete duplica
  322. Passing reference to a checkbox to a subroutine.
  323. Delete rows based on an array
  324. Conditional formats
  325. Help wCombo Box Setup
  326. RTD issue with Excel 2007
  327. Referencing an Excel Name from a different Workbook in VBA
  328. Finding and copying from 1 worksheet to another.
  329. Error 800a01a8
  330. Shared Workbook - "1/0/1900" displays for some users
  331. .Refresh BackgroundQuery:=False
  332. dim problem when using cell() reference
  333. Column Combinatorics
  334. Help with external drop down lists
  335. Getting around Protected Worksheet (number format)
  336. Undo problems... again *sigh*
  337. Variable headers
  338. How to return mulitple values based on the contents of another cel
  339. Email Formatting
  340. Urgent Help
  341. Export range to XML?
  342. reorganising data
  343. Image Enhancement Software... 3D... Cool Freeware
  344. GetOpenFileName + Type Mismatch error
  345. Please help me edit this code..Thanks in advance :-)
  346. Excel email attachment from outlookexpress
  347. Conditional formatting - based on indentation
  348. How do I add the sum of a multiplication formula to another cell
  349. Excel queries
  350. Excel application logs
  351. Copy data to next empty row in a range
  352. Delete specific menu item from custom menu
  353. Can Excel pull live information from the Web???
  354. copying data in a sheet to a new Word document problem
  355. Your favorite Excel Add-ins
  356. Error handler question in Worksheet_Change event
  357. Excel registry key
  358. parameter
  359. Parse email text
  360. VB code for copying entire rows from mulitple worksheets into a worksheet
  361. Disable Shortcuts
  362. Modeless Userform
  363. name the sheet the same as the file name
  364. Custome Format Alpha
  365. Quick Access Toolbar
  366. A better way to get Min and Max date
  367. Minimise/Restore
  368. Changing case in a cell
  369. weekly totals
  370. Refer to combox from activecontrol name
  371. formula that once it is true info stays in new cell?
  372. Counting Colored Cells
  373. how to save in the excel some additional invisible information
  374. SORTING MACRO TO CLEANUP MESSY SHEET
  375. macro/vba
  376. Disappearing Personalised settings
  377. Create New Sheets from Filtered List - help on macro
  378. Rich Text Box
  379. Searching a Word Document from Excel
  380. Startup
  381. Free Tutorial website And Ebooks programing tutorials
  382. how secure is projectProperty Protection?
  383. Colouring cells based on day of week?
  384. how to have checkBox in ToolBar (Icon) ?
  385. Variables & strings
  386. Can you write the contents of an Excel Named Range to Word?
  387. range and visibility
  388. How to paste a image into a VB UserFrame in Excel?
  389. Help with code please !!!
  390. multiply text and number
  391. Userform driving me insane
  392. RE: Hide Zero Rows - But Not Blank Rows
  393. Vertical Line in an XY Chart at Today's Date
  394. MenuBar/CommandBar(s) reappearing after being disabled??
  395. Macro to understand how wide or long the data range is
  396. If source cell is bolded then destination cell becomes bolded too.
  397. RE: Hide Zero Rows - But Not Blank Rows
  398. need macro to repeat two rows at top of each page
  399. check if any cell in column A has text
  400. nothing selected in listbox, but listindex <> -1
  401. macro to repeat non contiguous rows at top of ea page
  402. How do I make a copy of a macro?
  403. Behavior - Option Buttons
  404. Code for Copying and Pasting data to a separate Workbook
  405. Lop to delete rows
  406. Batch file rename macro
  407. VBA How to
  408. Windows API Functions
  409. Boost up Your Business through Data Entry Outsourcing By saving timeand money
  410. random number generator for scientific simulation purposes
  411. Cheat
  412. Enable/Disable Macro
  413. Excel Chart
  414. Copy Values based on a Match Q
  415. Conditional Formatting based on multiple criteria
  416. why do hyperlinks on userforms in excel work but not word
  417. Recommend: object intermediate between Application and Project
  418. Excel 2003 - Writing a Macro - How Do I...?
  419. how to insert a row at regular intervals of row
  420. split in vba
  421. Help with Design
  422. Question about the Queue of Commands in Undo
  423. Need VBA/Macro help in Excel (I think)
  424. Creating new worksheets and appending data from multiple worksheets.
  425. Days360 Formula in VBA error
  426. Automated e-mail from Excel
  427. loop through matches
  428. TreeView Control V - 6.0 - Drag-Drop Nodes
  429. Formulas
  430. Macros?
  431. macro to add leading zeroes to number and loop
  432. Weird Happenings
  433. formuls
  434. If row 2
  435. Carts and Acticesheet.Range
  436. All for insert of picture on Protected Sheet
  437. COPY...........(need a little change in a macro)
  438. Freeze Panes- Windows Split
  439. User Defined not defind
  440. VBA code disables Undo command
  441. How to enter a constant sum formula using values from 2 different
  442. Outlook
  443. Plot grand totals on secondary axis in PivotCable
  444. how to find whether linked data exists
  445. Formatting based on a condition
  446. VB Scrpit to input search results in Excel work book
  447. Excel VBA - Graph/Chart on Userform
  448. VBA help. Select dynamic workbooks.
  449. Refedit problems after installing SP3 to Office 2003
  450. Excel Sorting In VB
  451. Debugging
  452. Create Worksheets based on column data
  453. Excel Sorting in VB
  454. Date Formatting
  455. Screen Updating
  456. Programmatically creating hyperlinks
  457. toolbars
  458. Find the next Cell with interior color using Do Until...Loop
  459. Macro That Tests
  460. Create folders from excel
  461. UserForm to delete unwated items off sheet?
  462. Storing result of function directly in a variable instead of cell.
  463. How to Query the Database
  464. Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem
  465. Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem
  466. Problem with second count routine from userform
  467. Autoclose excel file after x minutes of inactivity
  468. Need window handle for a userform
  469. Saving date as part of filename
  470. Dave - Trouble finding posts
  471. Number of files in a folder including sub-folders
  472. Lookup first/last column of record
  473. SheetChange for formulas
  474. SplitRange
  475. Opening Excel File from value in active cell
  476. How to disconnect the line for Internet?
  477. Menu item
  478. Private Sub Worksheet_Change doesn't work?
  479. Avoiding IF limits with VBA
  480. On Error Resume Next not stopping pop up message
  481. Question with Solver code using "Application.Run"
  482. Need a 'Refresh' button
  483. Dropdown Box Conversion
  484. Hide Autofilter Button but keep the filter on
  485. Open Workbook Read Only and hide select worksheets
  486. Combobox list appears on far left side of screen
  487. VBAProject Password message appears when exiting Excel
  488. Macro or VBA to Bold first 3 characters of a cell in the entirecolumn
  489. Indirect in VBA code
  490. VB Function exported in XLL file
  491. Developing a macro that will help with mass address cleansing
  492. Formulas mysteriously break
  493. Organizing list of contacts in .xlsx
  494. Run-time error 1004 with Range
  495. slow scrolling
  496. Printing help
  497. Add-in security
  498. converting date to a monday date
  499. Array formulas cannot return strings longer than 255
  500. Import multiply csv files
  501. How deactivate the keyboard and mouse
  502. Workbook Open Procedure in Custom Template File
  503. pick from list and automatically enter corresponding cell
  504. Inputing Data
  505. Useing IF to Paste a Range
  506. Simple seach and copy help needed
  507. Go to Last Active Window
  508. Protect several objects
  509. Check for worksheet in closed book - Help
  510. Slow Office Automation
  511. non-functioning keystrokes
  512. Custom toolbar color
  513. Calling a Webservice from Excel.
  514. ADDRESS MACRO
  515. Problems with saving an Excel document and Macros in Excel which aredisabled with no reason
  516. Mulit-column number formatting
  517. Multi-Dimensional Array Procedures
  518. Compare Problem
  519. Bookmarks in Excel???
  520. function double output
  521. Prevent saving in Excel 2007
  522. Close workbook without saving file
  523. Excel DB Query Parameter for all values
  524. How do I use MS products to set up a linked product order form?
  525. hide check box
  526. Add-In UDF returning #NAME error
  527. move item from one listbox to another listbox
  528. Function - array with 2 variants
  529. Protect a Worksheet
  530. Accessing ranges within sheets
  531. Change Upper Case to Proper Case
  532. IRR Calculation question
  533. check boxes
  534. Macro for expanding a range
  535. Combo boxes in userform auto drop down problem
  536. executions per second
  537. Colorindex 2 not formatting
  538. split the contents of a cell
  539. entering a validated value into a cell
  540. Name Sheet with Input Box and text
  541. Duplicating changes from master file from all sheets within a file.
  542. macro for appointment
  543. Check If Form Open or Not
  544. simple IF statement
  545. Issue with listbox not showing the last value in the range
  546. Microsoft Office Document Imaging - Automation
  547. Cell Address References won't update when Sorting
  548. VBA freezes after opening file
  549. Add-in is visible
  550. Embed VBA in worksheet
  551. Excel VB
  552. performance
  553. Sheet Selection
  554. Clearing a Cell Value
  555. Access from Excel
  556. WebData Substitute
  557. Template Wizard w/Data Tracking
  558. Extending a range
  559. Chart expertise help
  560. Between dates question
  561. Multipage Control in a Userform
  562. Multiple Count Condition
  563. SaveWorkbookAsToday()
  564. Using VBA to change Pivot Table data source
  565. Different approach? Re: Fill color based on RGB (PeterT?)
  566. Evalulate previous cell
  567. Are there any events for outlines functionalities?
  568. Bolding using VBA
  569. Combo Box Row source problem
  570. Are the "page setup" layout settings overwritten by page preview adjustments ?
  571. How to delete all stuff outside marked cells ?
  572. Do Until?
  573. Research Analysis (3rd time)
  574. Extract embedded objects in worksheet to HD
  575. Conditional Formatting vb code
  576. Test for Decimal
  577. Displaying Members in Visual Basic
  578. .NET Win Forms Application to Excel 2002, Excel 2003, and Excel 20
  579. .Find cell within rng when font color=3
  580. For Each code
  581. Excel 2002 and 2000 crash with Combobox on worksheet
  582. Excel 2007 - Macro Shortcut Key Doesn't Work
  583. Delete temp file
  584. using BrowseForFolder shell application
  585. msoControlButtonDropdown
  586. Trouble populating ComboBox from a range
  587. Delete hyperlink from textbox
  588. User Provided Path - Compare 2 Books
  589. SQL Select string
  590. How to programmatically digitally sign code
  591. Sheets and Worksheets
  592. Determine whether the user has saved the file?
  593. How to get the correct active Cell position in Worksheet_Change
  594. Conditional Formating
  595. Copying tabs from one spreadsheet to an other
  596. Microsoft Calendar Control 11.0
  597. read and grab data from database
  598. conditional formatting on click
  599. switching window stops running macros
  600. "run-time error '1004' - select method of range failed"
  601. COMException raised on opening excel file in thread
  602. address of activecell in another sheet
  603. Hide Command button - still use it
  604. Pop-Up Calendar
  605. WTC Towers: The Case For Controlled Demolition
  606. formula behind field on user form
  607. How do I create buttons to link worksheets within a workbook?
  608. Fill down formula if other column contains data
  609. populate output form programmatically
  610. If Sheet Exists Q
  611. linkedcell with togglebuttons problem
  612. Fix my program
  613. Extracting text before ~ sign
  614. Compilation error in hidden module
  615. How can I set focus back or remained on Textbox?
  616. set variable while looping question
  617. Macro to build code
  618. Research analysis.
  619. Hockey Statistics
  620. Populate Sheet based on ComboBox selection
  621. Useing If to Delete a Range
  622. Suppress Mouse Hourglass
  623. Troube defining variable
  624. Referencing a Sheet based on the Month
  625. Do Until empty loop
  626. Error on Set Rng statement?
  627. Using Array's
  628. Combobox
  629. Macro for Pivot Table
  630. Paste To Visible Cells Macro
  631. Select Case
  632. Find value in a 2nd workbook
  633. Importing CSV Finding Min/Max
  634. IF, Case, or something else
  635. Populate List or Combo box based on User ID
  636. Populate List or Combo box based on User ID
  637. rename a copied sheet
  638. Grab Open Outlook Username from Excel
  639. Tweak to code that checks colors of fonts and moves to proper shee
  640. VBA in Excel
  641. "Help Checking Out Macro"
  642. Need to find all 9-digit numbers
  643. Automate IE Web Query
  644. Array Formulas
  645. Need help with a randomization problem in Excel using PopTools
  646. Transfer Data from Input Form - Offset to different worksheet
  647. Fill color based on RGB
  648. excel sheet to outlook
  649. My buttons shrink!
  650. Custom Sort Order
  651. Reading office properties - dsofile.dll
  652. PLEASE HELP: Enable Automatic Refresh
  653. Select rows in a date range
  654. Copy links from one spreadsheet to the other
  655. What does the WebPublishItem ID Value Represent in a Sheet's XML F
  656. Submenus on Shortcut Menus
  657. Macro to check for file update
  658. Email downloads into a single Excel cell - data separation reqd.
  659. Compile error in hidden module: "Module Name"
  660. Conditional Selection VBA code
  661. Macro Hidden - Cannot "Edit" to see code
  662. Populating a userform with a Word document (read only)
  663. combobox
  664. Copy Named Range from one sheet to another with formatting
  665. coding for macro
  666. Sort cell values of different columns
  667. 2003 -> 2000 incompatability
  668. extracting data from sharepoint
  669. adding date from user form with calendar to next row
  670. Advice for generating excel spreadsheet through asp.net preferablywith excel 2007
  671. Input box with a loop
  672. Renaming sheets
  673. Evaluate a Name in Non-active WB
  674. sorting problems for DA
  675. list of used shortcut keys
  676. Listbox problem
  677. Buttons appear to stay "pressed"
  678. interaction with excel and ms SQL (retrieval of records from sql intoa sheet)
  679. handle error in cell values
  680. Code exected at "Workbook Open" slowing/stopping file from opening
  681. Returning Cell Reference/link
  682. sumproduct
  683. Unexplained read-only from a batch file
  684. SORTING BETWEEN WORKSHEETS
  685. Change Row Color using VBA
  686. Numbers stored as text
  687. Loop macro error
  688. Can a custom Search function return a cell reference?
  689. Looping through list of workbooks to open & sheets to move
  690. Outlook and excel
  691. Comparing cells, coloring differences
  692. runtime error 13 - type mismatch error in Excel 97 on Citrix
  693. How to grab a reference into VB
  694. Worksheet Labels as Combo Box Selections
  695. chart from pivot data, and sheet data?
  696. Time Difference in VBA Macro
  697. Search column for string and write to cell
  698. .NET Win Forms Application to Excel 2002, Excel 2003, and Excel 20
  699. Why my procedure will re execute at a certain point in the procedu
  700. VLookup & SUMIf
  701. Use AutoFilter
  702. Return Max Value of given Variables
  703. Setting up capitalization after hyphens
  704. Predefined Print area based on variable
  705. Word doc in listbox
  706. Dropdown list
  707. saving a worksheet as a .txt file with filename of specified cell
  708. Need to lock data based on '=today()' value
  709. Return Filename
  710. Timestamping
  711. VBA or Validation?
  712. Error: Exception from HRESULT: 0x800A03EC
  713. I want Excel to determine the correct directory.
  714. Indirect Lists and Dynamic Ranges
  715. Automating "paste Link" fuction using VBA
  716. Analysis Toolpak VBA module documentation?
  717. Read directory code which needs to include file size
  718. Creating a custom function to interpret another custom engine func
  719. keep cell reference
  720. Copying the first row of wbooks with ADO
  721. Re: How to read workbook (not worksheet) properties with OLEDB
  722. Accessing New Menu code
  723. Download Automation
  724. Making a Macro that will run a script at the end
  725. Conflicting VBA's
  726. A good use for an Object Stack?
  727. Writing cells using Range() slows down with successive writes
  728. Quotes around text in Msgbox
  729. Macros
  730. How to sort a column based on two other columns which are differentplaces?
  731. If statement / Command Button / Message Box
  732. SUMIF in VBA
  733. Last Save Time, Function not updating in cell
  734. copy data input to archive
  735. Does custom document property exist
  736. Sheets.Select
  737. Inserting Control Toolbox text field in Print function
  738. .Delete speed
  739. Looping through columns
  740. .NET in Excel 2003
  741. Using Conditional Formatting with Drop Down Menus
  742. I need some calculations done in a message text string ...
  743. Pivot table Field Setting Number Format
  744. Formatting cells from a value in a Listbox
  745. Macro hangs when run from a command button
  746. changing math operations for math operations with = sign
  747. Why doesnt this work
  748. Slow Program
  749. Re : Excel Worksheet_Calculate() & Worksheet_Change()
  750. Running Sybase Queries directly from Excel (using Visual Basic)`