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. Re: help for myWORKDAY UDF
  2. non disruptable run time condition
  3. Re: Rank Code
  4. Changing pivot chart format
  5. Re: custom commandbarPopup control - how to return its identifer?
  6. Re: Delete workbook..?
  7. Macro to delete first and last row
  8. Re: Problem with too large a range
  9. Re: any UDF for sum or rounded product
  10. Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look
  11. Number to Date convertion
  12. Passing excel cell values as sql variables
  13. Need help with adding Controls and event handlers at runtime
  14. Need help with adding Controls and event handlers at runtime
  15. Re: Automatic Dates
  16. Re: Automatic Dates
  17. complex time formula
  18. Help with a simple Excel macro
  19. Counting recurring cells
  20. Re: Option Button forces user to input into a Textbox
  21. Re: Hide all windows while macro is running
  22. Re: Save into different "user's" folder
  23. Re: Hide all windows while macro is running
  24. RE: providing serial numbers with cells hidden
  25. Re: providing serial numbers with cells hidden
  26. Display value in same row of most recent date in a different column
  27. Create a command button in Excel using C#
  28. Formula in text formatted cell
  29. Re: Save into different "user's" folder
  30. Macro to save data in one cell and add new data in cell below etc
  31. display alert when workbook open
  32. SaveCopyAs generating the 0x800a03ec exception
  33. Creating backup of a data file
  34. Loadpicture - check if file exists
  35. can i copy a hyperlink with absolute and relative references
  36. how to trap cell cut and paste
  37. how to trap cell cut and paste
  38. RE: Open Read Only
  39. Protection to add a line to Remove "Select Locked Cells" ???
  40. Userform Canellation.
  41. General Ledger template from Microsoft website - adding GL categor
  42. Macro to open the Subtotal function
  43. bug in excel range naming?
  44. How to Add 21 Textbox values to give the Sum ?
  45. open (or save to) other workbooks
  46. Cannot jump to 'VBProject because it is in the library 'VBIDE' which is not currently referenced
  47. RE: Open Read Only
  48. Redirecting
  49. How to tab to next from a texbox
  50. Advanced math
  51. help with a special timer
  52. RE: I think this is a hard one
  53. play wave file from Excel 2003 macro
  54. RE: how to use .xla -- addin file -- Office 2003?
  55. userform Max value in Column A
  56. are these 2 statements equivalent?
  57. One problem
  58. How to check if a cell is blank and, if so, apply a formula
  59. Center Comment Over Selected Cell
  60. Re: Can any controls name concatenated?
  61. Opening workbook in its own program
  62. How to detect when Find returns nothing?
  63. Selecting a Record and copying it to another Workbook
  64. Help!
  65. Help!
  66. duplicating a page while adding a progressive date
  67. Listbox value help needed
  68. Problems With PRN File
  69. Counting Cells By Color
  70. RE: Mutipage
  71. Removing columns and rows from an imported worksheet
  72. Re: Mutipage
  73. RE: Macro help with copy/insert into mutiple workbooks
  74. Excel and Barcodefont distribution
  75. Query text too long
  76. URL forwarding in Excel?
  77. Resetting an object counter
  78. pivot cash
  79. Copy rows to new sheet based on variable cell reference
  80. Using Checkboxes
  81. How to refer to an other worksheet (or book)
  82. is this possible, replacing password protected sheet text with mac
  83. Hidden macro
  84. UDF function on Matrix
  85. Create a 5 second message box that shows text in a cell
  86. Macro help with copy and insert
  87. running a macro on another worksheet
  88. Zoom Window Selection Possible?
  89. User Forms availabilty to all workbooks
  90. Creating the name of a worksheet in a cell
  91. macro doesn't work on Excel for the mac but works on Windows XL??
  92. Programming a worksheet to find last row and add formula's
  93. Re: Setting Path for Word AND Excel
  94. How do I call a dynamically created String in a VBA Sub
  95. How to store variables of a single cell in a column?
  96. Render the contents of a cell invisible
  97. Passing a function as a parameter
  98. Odd copy and paste question
  99. Excel Window
  100. RE: How to set the format of cells after importing into Excel
  101. using range, and/or offset to complete table.
  102. Create a date that will not change
  103. Spacebar Exits Macro
  104. Run Macro from cell change THEN select adjacent cell
  105. XLCALL.H problem with C++
  106. Distorted Fonts on Controls
  107. Preventing Range Name changes
  108. Placin Data In Next Avaialble Cell
  109. Combobox and Textbox settings
  110. Getting info from FIND/REPLACE
  111. Force Path for File Saving
  112. Object creation
  113. Hashing function CryptAcquireContext Lib "advapi32" not working in new computer.
  114. Ex Rate
  115. Comment Positions
  116. Test Initialization of an Array
  117. Re: Convert String variable to code
  118. read data in an excel file on a remote sever
  119. Going nuts on this one...
  120. Application.InputBox
  121. Parsing Strings in Excel
  122. inserting a formula next to populated cells
  123. Sub that cannot be executed from Excel
  124. Running code before saving workbook
  125. Excel concatenate duplicate rows
  126. Updating a sum
  127. data from password protected files
  128. How can I execute a macro right after the user clicks the validation drop down?
  129. Assign borders and colors with a condition
  130. VBA code for outline border
  131. Re: Delete Duplicate rows
  132. VBA to -0- an amount during a Copy/Paste of a range of cells
  133. Loop through Row Range, Excel 2000, 2003
  134. Finding Cell Address from Listbox
  135. Downloading Multiple Pages of Get External Data from Yahoo
  136. Wait Seconds and Tenths
  137. userform to appear in the center of the screen
  138. Find last row with value
  139. Complex--don't even know how to word the subject for this
  140. define a range knowing the corners?
  141. To go to a particular Sheet
  142. Writing macros to sequentially change the address of a cell in Exc
  143. CryptAcquireContext Lib "advapi32"
  144. RE: Use of Calendar in both a form and excel sheet
  145. Find Common names in multi ranges
  146. Hours Minutes and Seconds
  147. How do i assign the ActiveWorkbook.Worksheets to a worksheets object?
  148. this code makes excel crash
  149. Easy (for you) question
  150. Rounding a Rounded Number
  151. How to use an array ?
  152. Run Macro in another workbook already OPENED in another instance of Excel
  153. Excel Object Model Diagram?
  154. Yet More Question about Newsreader
  155. RE: Formula to count distinct values not working in VBA
  156. Re: Delete Duplicate rows
  157. Selecting Drawing Object By Name
  158. Re: Function Question
  159. RE: Function Question
  160. running macros from LIST choices
  161. save workbook but doesn't really save
  162. Clear all borders with VBA
  163. Copy/Paste Range
  164. cusotm formats
  165. RE: I dont understand why this happens
  166. Quick Question: Buttons
  167. Control Toolbox Checkbox Macro - Help Please!
  168. Find First Row where "value" = ""
  169. Excel: Compare Two Worksheets
  170. Excel: Compare Two Worksheets
  171. Excel: Compare Two Worksheets
  172. Re: What could be wrong?
  173. Set Focus Not working on a form
  174. Re: What could be wrong?
  175. God's New Year present.
  176. Select Cell on Same Row as Checkbox
  177. variant/error Error 2023
  178. Re: error handling - dodgy syntax
  179. Re: Claiming Dependents
  180. Re: Claiming Dependents
  181. Loop through a range, allow user input during...
  182. Re: Continuous Loop
  183. Looping Error
  184. Re: Make 2 Macros Work as 1
  185. Unchecking all Forms checkboxes in entire sheet
  186. please help me
  187. next cell
  188. Re: Active Conditions
  189. Petty Cash book
  190. Excel 2007 Problems; in writing macro and convert text to colums
  191. Retrieve a the date created date of an Access Table in Excel using VBA
  192. closing dummy file
  193. Offset function
  194. Trying to improve the performance of my code
  195. modeless userform problem
  196. Basic Syntax
  197. Re: Multiple responses from a look up table
  198. Re: Multiple responses from a look up table
  199. Count the times a file is opened
  200. Reference cell in previous worksheet to then add +1 for serial pag
  201. Same footer for worksheets (grouped)
  202. Re: Adding Images
  203. Re: How do you create an Array of Arrays?
  204. How to pass text to web page ?
  205. Re: Adding Images
  206. Re: UseFunction question
  207. More Concise Way To Assign Borders?
  208. Error Checking Code, Excel 2000 & 2003
  209. Don't Copy If Null --> Help
  210. Userform. How to Have TextBox Selected & Return/Enter Key to be same as OK Button ???
  211. Setting the text in a cell to the text of a cell on a different sheet in the same workbook
  212. Re: How Do I Password Hide a Sheet
  213. RE: Named Range Macro Formula
  214. Pivot SubTotals - Request help
  215. Re: Named Range Macro Formula
  216. Macro Loop Throws 1004 error
  217. Re: How Do I Password Hide a Sheet
  218. Sorting a range on another worksheet without selecting the worksheet
  219. Check if a optionbutton is selected
  220. Auto Log Into Site, etc......
  221. Create list of worksheets and cell values
  222. (VBA Function ?) Lookup value and copy it into antoher worksheet
  223. Comparing two worksheets
  224. Can't select image on a worksheet that was inserted by c#???
  225. Wanted: Syntax for Filename changed without impacting Macro
  226. Re: Can't add macros to buttons I've created....
  227. Re: Why are some dates changing and not others?
  228. Re: How do you create an Array of Arrays?
  229. Re: copy and paste to multiple cell
  230. Re: If / Else Code (hiding rows based on cell value)
  231. Hide Columns based on network username
  232. AURO SUMMING FROM TABLE AND COPYING TO NEW WORKSHEET
  233. One subroutine to run another
  234. Needs help converting some pseudo code into VB code
  235. Counting Groups
  236. Re: GetSaveAsFilename
  237. Delete Rows
  238. Extract Part of Sentence for Separate Cell's Value
  239. Re: Fill FromDate to ToDate
  240. Re: program tab button
  241. Re: Use string as cell location, need help
  242. #1 How to best learn VBA? #2 Division problem question
  243. returning the first name on the list assigned to a particular rang
  244. Save as space delimited file from VBA
  245. Re: TextBox Values to Outlook
  246. Chart series delete all then add new
  247. English German CSV issue
  248. Cell References and Ranges
  249. Re: Data Validation
  250. How to using VBA to send/get data in logined web page ?
  251. worksheet_calculation problem
  252. sum with multi criteria
  253. How to block all macro when a particular file is open
  254. Excel macro to calc payment/payoff of credit card
  255. Open Outlook from a macro
  256. display worksheet on form
  257. Flexibility assign Cell value
  258. multiple criteria statement
  259. Re: slow code
  260. Replicate PMT calculation
  261. Re: Linked cell location in VBA
  262. Automatic sorting in excel
  263. RE: Insert new row and retain borders
  264. Text in TextBox to Program
  265. How to Hide Toolbar
  266. Re: Find next Date
  267. Chart not working
  268. How to delete a question mark throughout database
  269. Delete part of cell contents
  270. Re: How to extract a value from Excel and include it in a query
  271. Re: Multi Column Listbox Help
  272. Delete Row Macro
  273. Test
  274. help with chart
  275. Paste Special
  276. Help with automating data style change
  277. How to keep macros attached when moving sheet to a new workbook
  278. copy values in rows to columns
  279. Dynamically generating a spreadsheet with custom pivot table including data
  280. Newsgroup Reader Advice
  281. Re: PLEASE help Bernie are you still available?
  282. Figuring out if a day is a legal holiday
  283. Sort 4 of columns by matching cells
  284. "find" finesse needed
  285. Worksheet change event with cell linked to combo box result
  286. DSO Summary Properties Error
  287. XL 2003: Problem running Solver from VBA
  288. Re: Colour Cells onSheet
  289. Re: Input Box
  290. Re: Row Height
  291. Emailing range in Outlook- so close! just need a little help
  292. Re: Filter Macro
  293. Desperate for help with these formats
  294. Re: PLEASE help - Fast approaching deadline
  295. Cell Formatting
  296. Re: Variable Range for Sum Formula
  297. Re: Save Workbook as another file without an fomulas inside
  298. variable sheet names not working
  299. Re-setting HPageBreak
  300. Removing all data from two columns
  301. Help with If,then statement Returning Value (or Select Case)
  302. Speed this up for me, please
  303. Data Split and sort problem
  304. Force macro to wait with next step
  305. Re: Find last row and column in a selected range
  306. File Size Problem
  307. Re: PLEASE help - Fast approaching deadline
  308. Cocatenating two variables with a space in between
  309. Basic VBA Question
  310. Date Format Macro Problem
  311. VBA & Conditional Formatting >3 conditions
  312. Time formats
  313. Delimiter for csv and text file using ADO
  314. Re: For Next Loop Chart Titles
  315. How to disable column autosizing in Excel 2007
  316. RE: Worksheetfunction Substitute
  317. Re: Worksheetfunction Substitute
  318. fourty different spreadsheets with the same macros
  319. Excel saving as textfile quotes issue
  320. Remove All Macros
  321. Registry Location for References in VBe
  322. change code
  323. Big Problem using VLOOKUP formula
  324. Help with looping macro / goto
  325. Listbox In VBA Growing
  326. Listbox In VBA Growing
  327. Problem with Range reference - Odd error
  328. How to use drop down lists in Worksheets using VBA
  329. Add a button to each row of a spreadsheet
  330. Combobox Properties Textcolumn
  331. Concatenate anyone?
  332. Disable menu item when a particular excel file is opened
  333. How to debug class ?
  334. Macro to delete specific rows
  335. Excel VBA, XMTHTTP & Cookies
  336. Excel VBA run twice?
  337. Corrupted Excel File
  338. Re: How to solve 70-point gas network problems using solver tool?
  339. How to fatch Range's from an excel sheet when the file is on netwo
  340. Maximum Controls on UserForms
  341. Macro to add "
  342. Re: how do i use UserForm1.Show vbModeless command?
  343. Re: Can't find project or library
  344. Re: User-Defined Type
  345. rows for visible cells
  346. Re: get actual date from variable text string
  347. Last Row in Disjoint Range
  348. Data Sort Macro for specific cells
  349. How can I insert excel sheet in to powerpoint slides with autupdate option?
  350. Re: show modal
  351. Re: adding code from a template
  352. Saving txt file from excel by specifying path - drop down directory explorer
  353. Re: change permission on a folder like cacls command
  354. Re: Formula Macro
  355. RE: Two excel version conflict?
  356. Re: Formula Macro
  357. Find and Replace Macro
  358. CreateDocumentFromUrl
  359. Re: Formula Macro
  360. select case statement?
  361. Creating Chart Dynamically (It is Driving Me Nuts)
  362. Write data to Access table with INSERT when table has auto number
  363. Automating copy-pasting of data values into a new spreadsheet layo
  364. Setting Cell Values from VBA
  365. how do I prompt the user to select a cell?
  366. Re: Finding lowest number depending on value from corresponding cell
  367. Paste validation, Copy, Paste Special Validation
  368. Re: msoFileDialogSaveAs
  369. Macro that sums cells in rows of varible number and....
  370. Excel Re-Starts after shut-down
  371. Help file problem
  372. Re: If statements
  373. Copy thru VBA
  374. Macro that deletes the last character in a cell
  375. List of values / unique problem
  376. PIA interop Excel - VB.net accessing Cell
  377. Re: Row Number with Text
  378. Re: Name of button
  379. Error message if duplicate data entered
  380. Button do not appear on Sheet !
  381. Sorting Help
  382. Intermittent Error - Method 'Add' of object 'HPageBreaks' failed
  383. Re: Pivot Table Question
  384. SQL Query Function
  385. Format of amount in label
  386. Copy Total to the following row in Column A
  387. Excel to e-mail, with a twist
  388. Values in Columns to convert in rows
  389. Excel with game is stuck in a loop
  390. Re: Find the closest value
  391. Running Two Macros as One
  392. For/Next loop to process INSERT INTO statement
  393. Re: I'm dying over here...excel
  394. Find First empty cell at end of Column A
  395. Error Trap Via Message
  396. Re: I'm dying over here...excel
  397. Pivot Table Question: SubTotals for 2 of 4 Pivot Tables in same worksheet
  398. Re: Dynamic Chart Building - "Unable to set the ... property of the Se
  399. How to intersect two coloumns in a third coloumns
  400. Tracking Changes to Cells?
  401. How do I bring up the select cells dialog ?
  402. Changing file name
  403. Replace VBA Reference for Type Library
  404. Re: Call a VBA module from Microsoft Access
  405. Re: Question about RANGE (easy one, or at least it should be)
  406. Re: Question about RANGE (easy one, or at least it should be)
  407. Copy data from one file sheet into another
  408. Re: get actual date from variable text string
  409. Locale issue
  410. Re: Never-ending For Next Loop
  411. Switching from Jan-1 yields 1/1/2006, should be 2007
  412. Help in syntax
  413. For Each array - TextBoxes in a UserForm
  414. Hide Sheets
  415. delimiter
  416. Query
  417. Question about a formula
  418. Series XValues, determine if labels or values
  419. arrays from Excel VBA
  420. Run-Time Chart Only Displays Even DataLabels
  421. Using VBA to open an excel file
  422. RE: Multiple print title rows
  423. Re: Copy - Paste Special (Values)
  424. Delete sheets - all except 3
  425. Detecting the workbook name on startup
  426. unique range
  427. Selecting Values in Worksheet
  428. average rate of change per given time period between 2 moments in time of a value
  429. Conditional Format
  430. Check File name for its existance in a folder
  431. User Forms
  432. RE: Can't find project or library
  433. Re: Calculate number of records in a Group
  434. Is this a joke or Microsoft screws up again?
  435. how to disable chart tab in Excel?
  436. how to disable chart tab in Excel?
  437. Referencing a Column with a Variable name
  438. RE: Add Delete Hpagebreak Macro
  439. Editing in formula
  440. Lookup Sheet
  441. using data validation list for dropdowns
  442. Can VBA save file after deleting all VB code?
  443. RE: Macro to Pull Data from Seperate Workbooks
  444. Re: drop down cell link to worksheet not working
  445. Re: drop down cell link to worksheet not working
  446. RE: Macro to Pull Data from Seperate Workbooks
  447. RE: User-Defined Type
  448. printing an external document
  449. selecting multiple ActiveCell items (possibly loop problem)
  450. Continuing problem populating userform from a previous record
  451. Re: help with code
  452. Office COM Add-in by Using Visual C#
  453. Compare cells and concatenate on match
  454. Autofilter / CF
  455. Re: The undo button is greyed out due to this formula
  456. Re: ActiveCell.FormulaR1C1 referencing a moving target.
  457. Re: need macro to call a workbook w/o the actual name of the workbook
  458. Lookup on a sheet so that every time when file open it copes data from another file sheet
  459. Re: MS-DOS commands from within Visual Basic Version 6.3
  460. Re: Sheet referencing in a macro
  461. Re: Sheet referencing in a macro
  462. Re: send range results to a certian cell
  463. Macro help
  464. Re: removing programs
  465. Re: removing programs
  466. Re: Excel 2007: Macros disabled when workbook is protected (why?)
  467. Conditional formatting of a range of cells?
  468. VBA Copy Info from Excel Sheet Displayed in IE
  469. A Substitute for Vlookup
  470. Autosaving an Excel Workbooks as versions
  471. Move Total from Column B to A
  472. Concatenate Variables
  473. Help! Selecting a Worksheet with VBA
  474. Automatic Exchange Rates
  475. Excel graph (newbie)
  476. Location of mscal.ocx
  477. Pivot Table: Optional Page Field
  478. Web Query a changing URL
  479. Reference Table
  480. VBA to Save Web Pages
  481. COMBOBOXES
  482. Store TextBox entry into Variable
  483. Interpolation Problem
  484. Re: Converting currency to text "One & 00/100 Dollars"
  485. Re: Converting currency to text "One & 00/100 Dollars"
  486. Using Vlookup worksheet function in VBA
  487. Unique Data ID tags help (average)
  488. Detecting Broken links
  489. Really Interesting
  490. Re: calling subs
  491. Coding if formuals
  492. Variable - Date
  493. Help with Arrays - making a total formula
  494. Basic VBA Question
  495. Re: rounding to nearest 1000
  496. Delete Sheets Problem
  497. Delete Cell Contents IF
  498. Multi Column listbox
  499. How to make Excel the active application
  500. Copy specific data over to other worksheet
  501. WORKDAY #NAME? Problem - tried the toolpack already
  502. Charts and EMF
  503. Save as problem
  504. Operators/if etc
  505. Combobox Dropdown method
  506. Date format Problem Macro
  507. validate
  508. Password on VBA Code
  509. Unique
  510. Last digit automatically changes to zero (0)
  511. VBA code in Excel
  512. About function BAHTTEX
  513. runout - plant production scheduling tank inventory
  514. runout - plant production scheduling tank inventory
  515. on error don't resume next?
  516. Big sort problem
  517. A1 reference style
  518. Difficult find and move
  519. How to check Excel worksheet contents before routing?
  520. Can I create a userform in Excel to create an appointment in Outlo
  521. set up a flashing background
  522. PT dimension renamed after AS2005 migration
  523. Password
  524. Linking Excel-areas to word-documents
  525. Nested Loop
  526. Combine 2 codes from WorkSheet_Change & WorkSheet _SelectionChange to ONLY WorkSheet_Change
  527. paste excel text into a comment box
  528. Selecting multiple ranges
  529. Re: Creating a worksheet for every weekday
  530. If A1=H Then B1=1, Excel 2000 & 2003
  531. Sheet selection
  532. Can I use standard Functions with MS Query?
  533. Rename Sheet Goofyness
  534. While/Do Loop problem
  535. Breaking up long line of code doesn't work
  536. Getting and setting all printer driver features supported using VBA
  537. converting from gedcom to excel
  538. Class module and a lot of records
  539. How to list objects defined - buttons, etc.?
  540. Where can I find Microsoft.Office.Interop.Excel.dll?
  541. Create Add-in
  542. Chart macro okay but sometimes ends by moving to a new location?
  543. Connect Pivot Table to WSDL web service source?
  544. Code ignoring filtered (visible) tasks.
  545. 2007: weird position of labels on 3D bar charts
  546. Fill Colour
  547. collection and limit
  548. XP control look ?
  549. Problem with filtering
  550. Code for auto league tables!
  551. Trigger a Macro
  552. Re: send range results to a certian cell
  553. Re: Loop vertically, copying and pasting inputs for each cell in Col A
  554. How to Use Relative Reference in Array Formula
  555. Return filtered tasks
  556. How not to show zero in textboxes?
  557. Re: Code to instruct "Insert new disk"
  558. Code question
  559. Change Event not firing
  560. SendKeys "(^ {HOME})"
  561. Inserting 3 new rows after the word total
  562. auto-open macro lost within workbook
  563. auto-open macro lost within workbook
  564. Problem accessing an Excel file from ADO
  565. Extracting part of the data from a single Excel cell
  566. Help with variables
  567. RE: Monthly Report
  568. How to select a single "column" of a VBA array?
  569. Re: copy row when matching colums found
  570. Printing form with .printform leaves out headline (caption) on pri
  571. Need halp with pivot table in vba
  572. Holding Shift to bypass Auto_Open doesn't work in Excel 2007...
  573. webpage tabs
  574. Is it possible to exit Excel completely from a macro?
  575. Re: How do I print batch run to pdf files?
  576. Opening another instance of Excel
  577. Does Office 2007 have VBA?
  578. Substitute for Vlookup
  579. Sort Column, Excel 2000 & 2003
  580. Re: equaision displaying phantom numbers
  581. Dimmed Keyword as Variable
  582. Re: Delete all Shapes from selected Range
  583. select based on 2 columns?
  584. Pivot Table: Totals for "Last 12 months" and "Preceding 12 months"
  585. Re: Problems with Application.FileSearch
  586. Concatenate Text in Visual Basic
  587. Re: Chart Labeler Macro
  588. Letter alternative to 1 - 26
  589. Autofilters and Userforms
  590. Moving rows with out removing from range
  591. Using filename hyperlinks in Macros
  592. Re: Macro Problem
  593. Adding spaces into a variable
  594. Concatenate Text in Visual Basic
  595. Re: Create Function using Excel VBA
  596. Macro to find odd due dates and move them
  597. Macro to go to last cell in a column
  598. Re: OleObject really embedded in cell - not as shape overlay
  599. Check if Date within this week/last week
  600. Find Blank Line
  601. SQL database
  602. Call user defined function in an add-in
  603. Excel 03 Macro/Code
  604. Re: Troble with Code
  605. RE: Troble with Code
  606. Creating and using add-ins
  607. Alternative to integer?
  608. VBA Syntax to :select" or activate a module in Project Explorer
  609. Formatted output to text file
  610. Range Definition
  611. How can I get the row number Based on cell value
  612. copy no match
  613. 'Save as' problem
  614. Chart Code
  615. Re: Window Class of UserForm controls
  616. Is there any way to speed this up?
  617. Rename selected (highlighted) sheet with cell contents of sheets in cell A1
  618. RE: Find & Replace macro limit?
  619. Compare 2 list and extract continous range
  620. Can i Bunch a Many Macros & put them into a Single File
  621. Lookup Multiple Values in Same Range
  622. Paste filenames into cells
  623. converting matlab scripts to VB to run in excel
  624. Drop-down list dependant on another cell value
  625. assign shortcut to macro
  626. Re: Create pivot table with VB
  627. Clearing cell contents
  628. reading tags from an mp4 file into excel sheet
  629. Insert Data Last Row Loop through cells Excel 2000 & 2003
  630. VBA for index match and an IF statement to make a cumbersome formula easier
  631. How to have data ordered via Data validation
  632. Next without for??
  633. Delete all Macros Error
  634. RE: What Does FormulaR1C1 Do?
  635. Re: What Does FormulaR1C1 Do?
  636. if selection from drop down menu = X, then...
  637. RE: Selecting Activecell in hidden sheet
  638. Chart code
  639. RE: Subscript out of Range Error
  640. contar.se
  641. RE: Subscript out of Range Error
  642. Help speeding up my code
  643. Re: What Does FormulaR1C1 Do?
  644. How to detect selected cells in Excel, in VSTO
  645. FAX from VBA
  646. any function to replace loop
  647. Delete cells where value is 0
  648. Re: Adding working days
  649. Re: vba macro to cut and shift text>65 char
  650. Save only one sheet from workbook
  651. Re: problem with spreadsheet number format loaded from array
  652. Re: public property in one workbook, want to set value from another
  653. Re: Selecting Activecell in hidden sheet
  654. VBA UDF Calculation (not)
  655. Re: Please Help.....................
  656. Re: Please Help.....................
  657. Re: Inserting formula
  658. RE: Inserting formula
  659. vba arrays, count blank cells
  660. Merged cell auto row height revisited
  661. VBA Code and Protection Sheet
  662. Newbie Web Query and Date Formatting + Error Handling
  663. Re: copy and paste values in a range
  664. Re: copy and paste values in a range
  665. Error Handling doesn't work!
  666. Re: load 2 dimensional array into excel sheet
  667. Re: load 2 dimensional array into excel sheet
  668. Re: Window Class of UserForm controls
  669. Excel VB: Problem Clicking Submit In Online Form
  670. Re: Expected End With..
  671. Re: New workbook / 3 sheets
  672. Help with using arrays or just help in general!!!!
  673. Re: Expected End With..
  674. Re: Expected End With..
  675. Re: Expected End With..
  676. Convert Weekly Forecast to Montly
  677. Not recognising value
  678. Re: Auto Row Height in Merged Cells with pre exisiting text
  679. Re: Converting all numbers to negative
  680. Re: How can this code be made more efficient?
  681. Difference between VB and VBA?
  682. Re: How can this code be made more efficient?
  683. Re: How can this code be made more efficient?
  684. Formatting help
  685. code error
  686. Suppressing the Disable/Enable Macros Message Box Programmatically
  687. xlBook.SaveAs (documentName) when file open by another process
  688. Re: Paste filenames into cells
  689. Range text alignment
  690. Run a macro continuously
  691. Using a variable in more than one sub procedure
  692. Re: For Next help
  693. HOW CAN I CONVERT NUMBER IN WORD USING VB6
  694. Error on opening more than one workbook containing the same code
  695. Automatically fill in dates?
  696. Help with for/next statements
  697. Filtering problem
  698. creating a new collection
  699. Automatic type conversion prblm when populating Excel sheet from C
  700. Delete row if formula brings back an error
  701. Re: Find & Replace macro limit?
  702. Re: Help , reading an Excel value from the C program
  703. Re: Excel Worksheets Menu bar
  704. Re: Userform: Showing Cell Data
  705. Are Excel Shim Dll's have COM support
  706. Extracting data from web page with an imbedded DB query
  707. Worksheets("Sheet1") for foreign languages
  708. RE: Copy Sheet Names to a Column
  709. hide columns by column number
  710. quick question
  711. Best Excel VBA book?
  712. Deleting Charts
  713. Limit characters
  714. ip addres
  715. Cell Select Excel 2000 & 2003
  716. Re: Code for Unicode
  717. Excel Formula using relative position of cells in two different worksheets
  718. Program too large
  719. Trigger an Excel VBA event from another application
  720. RE: Macro to copy selected data
  721. Copying workbook with VBA
  722. Code runs slooooww
  723. RE: ScreenUpdating = False not working
  724. Microsoft Query Help
  725. Using Relative Reference Function to apply to Range
  726. Forms
  727. Re: Unhide Picture Using msoFalse
  728. Re: ScreenUpdating = False not working
  729. Re: Oval-print location
  730. Re: Locating 1st blank cell in named range
  731. Re: Locating 1st blank cell in named range
  732. RE: Locating 1st blank cell in named range
  733. Using Multiple Variables in an Array with Booleans
  734. Userform to have Last Updated Values Time & Date Displayed ??
  735. Locking certain cells..
  736. Re: Is there a way to know when a user has selected the find funct
  737. Re: Auto Response to Dialog Box
  738. Re: Locating 1st blank cell in named range
  739. Workbook reopens after close
  740. Re: Auto Response to Dialog Box
  741. Inputbox Location on Screen. Can you code it to popup lower on the screen ?
  742. go to website, fill in blocks from Excel
  743. Re: Long Strings
  744. Re: Macro to run when sheet activated
  745. allow entry in only one txtbox
  746. Re: Macro to run when sheet activated
  747. 3D column chart
  748. Number stored as text error message
  749. Re: Colour the rings in a radar chart?
  750. Re: Macro to match values in an array.