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. Delivery number for all dates in delivery period
  2. Complex comparison of Columns of Data: Extracting unique records after comparison on 4 levels
  3. Concatenate Text Statements
  4. ActiveSheet.Next with hidden sheets
  5. More complex macro can anyone help
  6. Easter day formula
  7. delete entire row based on conditional test of column A
  8. Re: ADO connection Steps
  9. Load Object
  10. Compare 2 Columns in 2 Sheets that are Not Ordered the Same
  11. enable/disable checkboxes based on other data
  12. Add 1 to cell when another cell changes
  13. autofilter
  14. PHP Excel generation libraries
  15. finding records
  16. Excel VBA tech interview
  17. Range name problem for DA
  18. A Little Favor for a Friend
  19. Data validation and lists
  20. Function not completely volatile help
  21. syntax qustion
  22. Filling Textboxes from Combobox selection
  23. Calculating Standard Deviation while ignoring Zeros
  24. RE: For Ron Bruin Please
  25. Will not copy to City-Panmure
  26. Excel-g ?
  27. How to know the windows language
  28. Re: Call up form calendar form VBA
  29. Connecting lines
  30. if Cell B1 = "Day1" show chart
  31. Parse data from string
  32. How to stop a macro at a Shell line.
  33. Hi,
  34. Argument
  35. Insert row after last (filled row)
  36. modify size of calendar control
  37. Deselect a range?
  38. Need help on generating non-duplicated result
  39. How to modify this code to not include header row cell?
  40. formulas for conditional formatting
  41. paste - skipping cell
  42. summ aumont with interesec two index....
  43. Copying cells- the cell references don't update
  44. Index function in VBA - on Multiple cells
  45. summ aumont with interesection with two index....
  46. =VLOOKUP validity
  47. I need help using the Assistant.NewBalloon feature.
  48. Matching Value placed in next column
  49. Re: Page Break Preview sliders not working
  50. Re: Send to function
  51. Stop the _Change event? Is there EnableEvents for Forms?
  52. Re: Excel and "send to" function
  53. Having issues with .SetFocus after msgbox...
  54. Re: how do I get a visio pic on my worksheet on a form?
  55. Excel Timesheet Counting problem
  56. Selecting Next Worksheet
  57. Select Data by Date Range, Delete Rest
  58. Re: Better way to delete rows wiht #N/A?
  59. .PageSetup on multiple sheets in workbook
  60. User-defined formula (VBA) that can convert a text value into MD5
  61. Call Add-In Macro from VBA
  62. Re: Reading Chart Coordinates with Mouse Events
  63. Re: link chart axis title to cell?
  64. calling macro from another instance of excel
  65. Re: Counting Formula
  66. Macro - Loop/automatization problem
  67. Add-in
  68. Re: Even More Data Table Problems
  69. RE: Excel Worksheet Select (Activate ?) in VBS
  70. If statement to move data from one column to another
  71. Re: array
  72. Change color of Shape based on condition - Macro?
  73. Simple Print Macros
  74. think i need sumproduct help
  75. grouping large pivot table columns
  76. grouping large pivot table columns
  77. Disable Workbooks_Open() Macro when opening from VBA
  78. How do I convert text to numbers in excel?
  79. combine change event codes
  80. or operator
  81. Userform Q
  82. summ aumont with interesec two index....
  83. Save as DBF in 2007
  84. Missing VBA Code in Excel 2007
  85. for next question
  86. CSV file has ,,,,,below last data row
  87. RE: AutoFitMergedCellRowHeight
  88. RE: How to invoke a user form from a custom button on the menu bar
  89. Re: User Form Input mask
  90. Re: EASY QUESTION: Formula to add filename to cell
  91. Re: Report on missing numbers
  92. Dynamically populating a 14-column listbox
  93. Put CommandButton1 code in Module1
  94. Programatically Delete command button and code.
  95. RE: Error 1004, Looping Error?
  96. Passing variable to worksheet function
  97. Re: Appending Filename in Macro
  98. RE: Error 1004, Looping Error?
  99. RE: Error 1004, Looping Error?
  100. VBA, Reading File As Binary
  101. Increase in the size of Excel Workbook.
  102. Increasing a cell value by 1 each day from date in another cell
  103. Standard PivotTable report selection format
  104. Re: Office 2007 + VSTA
  105. Re: active offset
  106. Re: Better way to delete rows wiht #N/A?
  107. Re: Email with Notes
  108. Re: Office 2007 + VSTA
  109. Scrollbars
  110. Macro to Perform Same Function Across Selected Sheets
  111. Excel component references in .Net
  112. Putting cursor in cell A1 for each worksheet
  113. Putting
  114. Macro to rename Excel files in a folder
  115. Re: Help needed - populating comboboxes from list??
  116. Where does excel store the pictures of a userform's 'Picture' property?
  117. Determining Variable Declaration
  118. Excel references in .Net
  119. Textbox on user form type mismatch
  120. Textbox on user form type mismatch
  121. cell locking problem
  122. Clearing Comments?
  123. added a range of data
  124. Re: entering new data thru combobox
  125. Not Your Average Personal.xls Problem
  126. Count the number of characters created by string text
  127. RE: array
  128. Display a value in a column
  129. Error 1004 : function returning a Worksheet
  130. Getting Column *Letters* From Range Objects
  131. 2 questions, one difficult.
  132. Hide rows based on colour
  133. VBA get ColumnName
  134. Re: Changing Transparency of User Form or Splash Screen
  135. Re: Macro not allowing inserting cells/colums/rows
  136. Please help debug this macro.
  137. Insert Bullet in E-Mail text
  138. listbox events
  139. Pressing a CommandButton on a Userform via Code
  140. conditional formatting formula
  141. saving userform textbox data to worksheet as a number, not text
  142. Re: Data overrun
  143. Re: Help needed - populating comboboxes from list??
  144. formating cells with procedure
  145. RE: Convert text to hyperlinks
  146. Modify language options from control panel using VBA
  147. Re: Using Printout with Adobe PDF as the printer
  148. Reverse Frequency
  149. Re: Excel 2003: Control tab in "Format Control" doesn't show up.
  150. VBA Passing information from one worksheet to many others
  151. Re: Excel cannot complete this taks with available resources... why?
  152. Help with colums
  153. Re: Using Printout with Adobe PDF as the printer
  154. Re: How to sum 2 +2 = 22 in Excel?
  155. Re: How to sum 2 +2 = 22 in Excel?
  156. Find/Replace in VBE takes focus off window Excel 2003
  157. Help with code
  158. Combine cell contents into a text box
  159. Excel 2003 Suppressing Errors
  160. Re: Simple "If" statement ?
  161. Excel ODBC Data Connection
  162. Re: Calling? Invoke Public Function
  163. Parsing data into seperate sheets
  164. Need help comparing & flagging email lists in separate worksheets
  165. Re: Create personalized toolbars in Excel 2007
  166. Re: Excel 2003: Control tab in "Format Control" doesn't show up.
  167. Re: For Ron Bruin Please
  168. Log-in Screen
  169. Re: Can I make a cell into a macro button?
  170. Copy Formula without changing cell refence
  171. check if name object exists
  172. Values of Variable after Project has Run
  173. Running macro with different references
  174. Hiding Unused Rows
  175. Re: setting a file with variables
  176. Excel will not open
  177. Increment a variable?
  178. Increment a variable?
  179. Run bat file from excel macro
  180. Re: locating carriage return within cells
  181. Re: locating carriage return within cells
  182. Hiding a row based on a cells content.
  183. Re: Control which sheets get Recalc?
  184. Re: Replacing Sheet references within formulas with VB
  185. Part Time Job Opening At Purdue Campus
  186. Re: vba error
  187. Delete Function:
  188. I just want to select the first word...
  189. Password/UserName
  190. Re: setting a file with variables
  191. Help on Dictionary datatype??
  192. Re: Hide ribbon or menu bar in Excel 2007
  193. problems with a localconnection to a cub file
  194. Re: find
  195. Re: find
  196. Inserting a Static Date and Time thru a Macro
  197. Use module, not thisworkbook
  198. Re: print hidden range
  199. msgBox after update cell
  200. msgBox after sum values
  201. Command Button Request
  202. Apply Formula to Selected cells
  203. Cannot load Excel 2000 Addin from Word (and that's so weird!)
  204. Command Button
  205. Copying sheet containing GetPivotData, new sheet references old workbook!
  206. Display WorkSheet data Size
  207. Excel format Cell
  208. Can't get PageSetup to work
  209. Re: Position the shape
  210. Dynamic Creation of list box on excel sheet and handling events
  211. Subject out of range
  212. Userform formats time incorrectly
  213. ADO get data from Oracle by SQL field type missmatch
  214. paste special all and column widths
  215. Re: database calls
  216. No Worksheet Range Object in VSTO?
  217. Macro - Issue with cut and paste if a column is blank
  218. De-concatenate but maintain relationship/record structure
  219. Storing XML In Workbook
  220. ControlSource Property Throwing Errors After Changing Regional Settings
  221. Can i remove a value from being listed with this ?
  222. Matching a Month Year value
  223. Retrive a value from another worksheet in the same workbook
  224. Re: Problem with web query string to number conversion
  225. Re: Date to be placed into Column "C" with matching value in Column "B" in same row
  226. Can somebody help me convert this logic into running code please?
  227. [VBA] Check/TIck the selected Item List in Pivot Table
  228. Need ComboBox Help
  229. Re: opening a doc file within a userform
  230. Incrimental number from one cell?
  231. Code won't Fire
  232. Type mismatch when trying to convert to negative number
  233. Number validation in Textbox using UserForm
  234. Making a Message Box appear on top of all other windows
  235. Save worksheet to a unique filename after worksheet is printed
  236. Re: For Loop
  237. VB in Excel 2007
  238. Number Matching, one to many
  239. Import Module to New Workbook
  240. Excel COM application hangs on Workbooks.Open
  241. Worksheet excluded doesn't exclude
  242. Re: Public?
  243. Object doesn't support...
  244. Macro to sum sheets in a folder
  245. Re: Importing into Access from Excel
  246. Excel Looping Question on multiple ranges...
  247. Log data from timecard into table in separate worksheet
  248. Do not let user save template if it has been been modified
  249. Programming Outlines (expand/collapse rows) in Excel
  250. Re: For Loop
  251. Help with UDF
  252. Help creating an Excel Add-in using VS205 in either VB.NET or C#
  253. Re : Date to be placed into Column "C" with matching value in Column "B" in same row
  254. Extracting Cell Data Based on Input Mask
  255. Extract Numbers From String
  256. Re: Range Selected.
  257. A macro that can delete the contents of a cell after a delayed interval
  258. Re: Converting a string of numbers to decimal
  259. Excel Application.Quit problem
  260. Re: Converting a string of numbers to decimal
  261. Run time error 1004 When running in 2003
  262. User Specified Grouping
  263. userform, StartUpPosition
  264. Ignoring End Statement
  265. Application.CalculateFull
  266. Re: help with code
  267. Hiding unused rows
  268. Adding Several Rows at a time and Asking for User Input
  269. add worksheet checkbox and change parameters
  270. Re: database calls
  271. Excel VBA question...Need help..
  272. Re: ActiveX Option buttons
  273. Re: ActiveX Option buttons
  274. Re: ActiveX Option buttons
  275. Trying to hide all rows where no data is in columns AQ-AV
  276. Re: problems when moving code from Macro to Command button on sheet
  277. Re: help with code
  278. thanks 2 everybody here who asks questions & answers them!
  279. Re: After Paste Value and Replace
  280. Re: "Application.ScreenUpdating = False" on the intranet
  281. Re: Macro to run everyday???
  282. User Name/Password
  283. Re: Return column numbers where word appears on row
  284. Re: Compare two lists and producing a third list
  285. find text delete row
  286. Sheet name = cell value
  287. Re: Change cut/paste operation to cut/insert operation
  288. Merge data from one sheet to another and print
  289. Re: Can I make a cell into a macro button?
  290. VBA: How can I check if an array is declaired with a dimension?
  291. Asking for better logic to avoid multiple if's.
  292. Re: Can I make a cell into a macro button?
  293. Re: Dead screen for a periode ???
  294. macro runs when workbook is saved, but only with vba change...
  295. Re: Data validation when pasting data
  296. Re: Daylight Saving Time (DST) and calculating time difference.
  297. pasting excel range into a Word doc
  298. Re: Temporary borders appear
  299. Save as single file webpage
  300. Stop Loop
  301. Date to be placed into Column "C" with matching value in Column "B" in same row
  302. SendKeys Help
  303. Disable Select Cells Q
  304. Extract Info From All Files in a Directory Q
  305. Search Excel and copy result into word
  306. VBA randomize vs. srand
  307. go over all the rows in data of autofilter
  308. Hyperlink Screentips
  309. How do I make this happen?
  310. Random Tab Color on sheet creation.
  311. Split last word into new cell
  312. Stop for input
  313. Re: xlExcel9795 Not Supported in 2007? 2003?
  314. Enabling a list autofilter in a protected worksheet - Excel 2003
  315. Copy Headers based on id# and data
  316. Cannot open PivotTable source file error fix
  317. Re: VBA Project Question
  318. copy method of worksheet class failed
  319. Re: Code not working
  320. RE: VBA Project Question
  321. Change the formatting of row by select a single cell & Editing should be working
  322. Too much nesting in if statement
  323. Add-in stopped working
  324. differrent fonts on parts of text
  325. Re: Find first unused cell in row
  326. Extremely slow macro
  327. Protecting Data Validation List from being modified in the formulabar
  328. Re: automate cut/insert tasks
  329. Change Cell Value when autofiltered
  330. Re: Hyperlink Macro
  331. Re: xlExcel9795 Not Supported in 2007? 2003?
  332. Menus using VBA?
  333. Rounding up to nearest 10 when "Enter" is pressed or user has clickedoff the cell
  334. Re: How do I program a macro to unlock and relock an excel worksheet
  335. Re: How do I program a macro to unlock and relock an excel worksheet
  336. Re: Excel report which excludes the blank rows?
  337. Re: need code to run when user changes value in cell
  338. Hide Macro's
  339. Re: need code to run when user changes value in cell
  340. Re: saving data in notepad
  341. Re: saving data in notepad
  342. COPYING A CHART!
  343. Always have cells add up to 100
  344. Re: Checkbox detection in macro
  345. Re: Daylight Saving Time (DST) and calculating time difference.
  346. Re: charts with calculated cells
  347. Re: Module question
  348. Re: Declare RegExp from Vbscript.dll
  349. Re: POWERPOINT IN EXCEL
  350. change of date format in footer
  351. Limit data entry to one of four cells in a row
  352. Menu for favorite macros in Excel 2007
  353. Workbook.Open fail in 2003, good in XP
  354. Define Names in Workbook through Code
  355. Re: Another Multipage question
  356. 'ThisWorkbook' Macro Question
  357. Deleting specific rows after an autofilter
  358. Creating a list of workbook users
  359. Re: Help with worksheet protection
  360. Re: Form Checkbox Updating
  361. Cancel Printing Except Q
  362. Textbox on user form in Excel VBA
  363. [Excel 2003] Exporting Diagram as Bitmap with VBA
  364. VBCRLF not doing anything
  365. jamping to another file excel2003
  366. Delete all code in VBA module - error?
  367. Dynamic Optionbutton Captions
  368. Delete all Range Names Except for 1 Q
  369. Searching Phone Numbers Online
  370. updating external references to cells, sheets etc.
  371. Hyperlink
  372. Re: VBA Project Question
  373. Select OR Activate ? Which when and Why?
  374. Convert date like string to serial number
  375. Handling Database connection error
  376. Need to buy a book
  377. listboxes
  378. Re: operation macro by clicking on cell
  379. Need code to convert files
  380. Issue on Close Q
  381. Problem finding pagebreaks
  382. Can Excel 2003 VBA work in Excel 2002?
  383. Create a function that sums based on two or more criteria
  384. Re: Play sub by clicking on cell
  385. Excel 2007: annoying pop-up msgbox titled "Name Conflict"
  386. Populate ThisWorkbook Q
  387. run macros local and on the web
  388. Checking for File/Directory Permissions
  389. reference to FileSystemObject
  390. Excel2003 in WindowsXP only 20% performance of Excel2K in Windows2
  391. Msgbox in worksheet activate event if design mode is turned off
  392. Automatization routine
  393. CustomTaskPanes and VSTO SE In Excel 2003... Where Is It!?
  394. Look Up Functions
  395. Change event --> cell colors change
  396. RE: Copied function is not working
  397. write data to two excel sheets
  398. Quit Excel if ONLY Workbook Open else Close Excel instead
  399. Now() to be placed in Next Column ?
  400. Range Reference
  401. Drop down list of Macros
  402. Still Stumped
  403. Using Excel VBA to control Word (open document)
  404. Re: Never tried this location in excel
  405. Re: POWERPOINT IN EXCEL
  406. Re: Module question
  407. Re: problem with moving controls
  408. Update "button" references automatically
  409. Restore users Text to Columns settings -HELP!
  410. Numbers Only in input box
  411. RE: If found Then move to new sheet
  412. e-mail from Excel to outlook
  413. Re: VB macros & "relative positioning"
  414. RE: POWERPOINT IN EXCEL
  415. Automating Excel Visual Basic to Schedule Outlook Events
  416. Delete comments in the workbook except few cells: CODE given
  417. Need assistance to populate sheet from Userform data
  418. Pivot Table Code in a For loop
  419. Importing data from Access to Excel 2003 for Invoicing
  420. Importing data from Access to Excel 2003 for Invoicing
  421. I can't figure out the correct syntax for referencing a workbook.
  422. Re: Never tried this location in excel
  423. Re: Changing cell colors in a row IF...
  424. Re: Semiautomated Saving of workbook
  425. Newly created Get Function is not working when I copied the syntax from a working function
  426. Re: Changing cell colors in a row IF...
  427. This should be so simple but it's not working, please help
  428. Automatization of data entry (and return of data)
  429. Adding a Name Crashes Excel
  430. Re: Nested If
  431. Re: 3d range names/references
  432. delete module
  433. using a workbook to open more workbooks with filenames stored in cells
  434. Re: Macro for printer selection
  435. AddFromString Code -> Excel crashes ... Why ?
  436. data ranges
  437. vba code to insert an range of Excel cells into a Word document
  438. Macro to autofill formula in every row
  439. Dim as Point
  440. Re: Line up graphs
  441. Change Font Colour in VB Q
  442. Problem with counting characters VBA
  443. Re: SkipBlanks doen't
  444. Re: Email message from Excel with Hyperlink to the file
  445. File and Don't save changes - Read Only File
  446. Re: every quarter
  447. Re: Characters in Strings
  448. CMS script into Excel
  449. is hyperlink valid ?
  450. VBA Code for deleting rows with specific value
  451. Re: array lenghts
  452. Jumping bar at bottom of screen
  453. Copy / Paste between workbooks into a specific worksheet query?!
  454. Question re random addition
  455. Protect via Code Q
  456. Re: every quarter
  457. Application.Visible = True and focus
  458. Nothing, Empty and Null
  459. Totals across increasing number of Workbooks
  460. Totals across increasing number of worksheets
  461. Summarizing the files in 1 folder to one file
  462. Stupid logic is messing up again... < = > Statements crapping out...
  463. Using dcount function within user-defined worksheet function
  464. macro code to find last record in excel
  465. stop for input
  466. Error in code
  467. Custom Menus, Toolbars, etc
  468. Determine if Excel App is shutting down w/VBA
  469. Multiple Selection of Non-Contiguous Data
  470. TextBox9.Text = Range("J:J") --- New line for each cell with a value?
  471. Excel VBA Class Objects - Parent & Successor Objects
  472. Format Pivot Table Row Where ...
  473. How do I getting data from another worksheet?
  474. RE: Calculate manual spread sheet
  475. Help needed with multi-sheet routine
  476. import csv
  477. If statements, conditions and cell display
  478. Conditional Formula
  479. Run on Opening Workbook Q
  480. Handling grouped groups
  481. Day-planer
  482. Create a new file, name it and overwrite an existing name without confimation
  483. Any good books?
  484. Taking 10 lefthand characters in a cell
  485. Change Password from an Array
  486. Changing the Zoom Property of a WorkBook without using an Array
  487. Copy Range / Including Adjacent Cells - into Existing Worksheet.
  488. links to word
  489. Setting range for the VALUES obtained from formula
  490. 2 lists - extract from one all matches, edit in a new list then re
  491. Activating macro by leaving a spreadsheet
  492. Re: Opening filenames from a list in a spreadsheet
  493. RE: Populating worksheet from userform combobox
  494. Re: Keep Custom Toolbar with Worksheet
  495. getting data from another workbook
  496. Excel VBA Code Modules
  497. PasteSpecial problem
  498. how to send message to multable recipients
  499. Re: Finding first blank worksheet
  500. Using command buttons change the value in a form text box.
  501. Populate ThisWorkbook via Code
  502. DDE links not updating after stepping into VBA code
  503. Re: Opening filenames from a list in a spreadsheet
  504. Re: Can I update vbaproject.bin in a package?
  505. Import Oracle Dbase over 65k rows
  506. Re: Object variable or with block variable not set - what's going on??
  507. Re: Drop-down menu referencing another drop-down menu?
  508. Is it Possible to Deny Access except to specified
  509. Re: Addin Locking Excel
  510. sheetname value
  511. Do 3 Tasks on Opening File Q
  512. Is it possible to have different pop up messages to appear
  513. Name Range
  514. E-Mailing a File but property set as Read Only
  515. Subtotal Report: Creating new sheet(tab) for each group?
  516. Please help! This problem is driving me crazy! Workbook sample provided!
  517. Drop Down Menu on tool bar
  518. Copy and paste to corporate sheet
  519. font color of partial cell contents
  520. Re: Addin Locking Excel
  521. delete rows where value of cell "starts with" something
  522. Excel VB User Form Using Vlookup?
  523. Take all unique values in sheet and place in 1 column
  524. Trying to delete rows and it's not working
  525. Re: Error Handling in Macros
  526. Replace font of one character in a string
  527. Re: Tough one; determine if an Access file is open
  528. Search/replace returns Formula too long
  529. could someone look at my code please and tell me what's wrong? tha
  530. Could someone look at my code
  531. Able to preserve value of variable after closing excel?
  532. Copy internet page excel
  533. RE: Need Help with Macro
  534. Email is a wonderful thing?
  535. Email is a wonderful thing?
  536. Excel crashes with a WebBrowser in it
  537. How do you do this? Uncrosstab
  538. RE: Referencing worksheet just by its name
  539. RE: moved vba code from macro to command button, now won't work
  540. MsgBox cancels "Step Into" Mode!
  541. Timer Event
  542. Link Excel 2003 named range to Access 2003 Table
  543. Re: Excel checkbox date question
  544. a simple date match?? |:(
  545. Re: formula for aquiring a gestational age
  546. RE: formula for aquiring a gestational age
  547. question on horizontal tab
  548. Re: Delete All Sheets Except "X" and "Y"
  549. copy all text files one by one and run a code.
  550. Re: Control on worksheet
  551. enable or disable a workseet control
  552. Re: Drop-down menu referencing another drop-down menu?
  553. Sorting
  554. Re: deleting empty rows within a range
  555. Re: turn off pastespecial warnings
  556. Trying to set a pivot field to a subset of values listed in range of cells
  557. Trying to set a pivot field to a subset of values listed in range of cells
  558. Using the Now() function but I dont want it to update every time the spread sheed is recalculated.
  559. Re: Have Excel file close itself
  560. Transferring Large Amount of Data from Excel 2003 to Access 2003
  561. Querying and Updating SQL Database Using Excel
  562. Re: Phantom VBA Projects (again)
  563. Getting rid of "#VALUE!"
  564. Re: How can I pick up a two digit Month?
  565. Whats Wrong With This
  566. calling a method on a object that you know the string name for.
  567. calling a method on an object created in a different addin
  568. Re: Send Chart report by mail using VBA
  569. detect all printers in networks
  570. Re: Lookup or maybe Vlookup
  571. Re: Send email to multiple recipients using VBA
  572. Re: Fixed Text-Private Sub Worksheet_Change(ByVal Target As Excel.Rang
  573. Is it an IF statement?
  574. how can the necessary information be extracted?
  575. Re: Phantom VBA Projects (again)
  576. Re: copying worksheets
  577. Re: Object variable or with block variable not set - what's going on??
  578. Re: Run time error 91 ??
  579. Adding data from Form to empty rows in spreadsheet.
  580. Re: Object variable or with block variable not set - what's going on??
  581. Copy from here to there
  582. Transpose from Col to row
  583. About Save Workspaces
  584. Re: turn off pastespecial warnings
  585. signed project drops signature when a macro creates a new sheet.
  586. Why did this code stop working ?
  587. Issue when accessing the property/method of a Calender control
  588. Problem with calendar planner date ranges
  589. Re: Macro written with VB in Alphacam. How do I put that in Excel?
  590. Re: Disabling Macros
  591. Re: Excel and Class, Function Structue for .NET
  592. Update MS SQL 2000 from Excel
  593. Re: Problems deplying a fix to a C# Excel add-in
  594. input
  595. Updating 0s in front of the number values in the column
  596. Wierd Bug with Format Date VBA???
  597. Count occurences of string in cell
  598. RE: How to hide/show a textbox depending on cell value
  599. RE: Command Button
  600. Finding MAX Value of Part of Cell Contents
  601. field names
  602. Re: Set Variable equal to........
  603. .PrintPreview ONLY Page 1
  604. Need help extracting data....
  605. Issue saving file in excel 97 SR2
  606. Re: Help Needed! VB Code to "Save As..."
  607. Find Selected value to .Offset from
  608. Re: Help Needed! VB Code to "Save As..."
  609. Dropdown List Syntax
  610. re: Worksheet events...Why doesn't this work?!?! So confused!!
  611. Using worksheet templates with named ranges
  612. Re: Array of UDT
  613. Re: Extracting text before a known character
  614. userform to remove from view
  615. Spin button timing
  616. Deleting Rows based on multiple criteria
  617. Problems running Excel under IE
  618. Is it possible to change the behavior of "paste" control in Excel?
  619. error 438 on ActiveSheet.Columns(16).Hide?
  620. Re: Problems caused during/after printing
  621. Re: Tough One - search for string and BOLD it.
  622. Procedure for SPECTRUM ANALYSIS of FFT coefficients???
  623. Re: If..Elseif...Else...EndIf
  624. Re: Automatically Update Tab Names
  625. Re: Workbook_BeforeClose in Personal.xls
  626. Re: EXCEL WEB QUERY PROBLEM
  627. Re: VLookup behaving strangely..
  628. Custom function acting weird
  629. Re: Testing if Directory has read/write access
  630. Error Auto Fill Method of Range Class Failed
  631. Re: Finding elements in a collection
  632. Re: Finding elements in a collection
  633. Re: Looping
  634. Re: Quality Control Macro -- Formula Anamolies
  635. Re: passing a cells content into a macro
  636. Resize Listbox Colums to match array fileds
  637. Protection Properties on WorkSheets
  638. Re: IF Formula
  639. If Active Sheet on Opening is X then do Y
  640. Re: Is there an ActiveForm command?
  641. Etiquette for borrowing code from a post by Harald Staff
  642. Hyperlink
  643. Re: Programmatic access to visual basic project via Visual FoxPro
  644. Re: Array of UDT
  645. Re: Array of UDT
  646. Re: Saving as a worksheet as a CSV file
  647. Re: Creating a macro where values are copied and pasted into a sheet
  648. Re: Macro references
  649. SelectRegion Loop
  650. Automatically have Named Ranges recognize New Data by way of Headings
  651. Re: Menu Bar Problems
  652. Dataform opening on startup, and validation list in form?
  653. Is there any easier way ?
  654. how to list calls to macros?
  655. Textbox macro - update problem
  656. Re: Delete cell names
  657. Delete cell names
  658. Button Visibility / Selectionchange Problem
  659. automatically updation of the excelsheet if i add new files in a .
  660. Modify code to Add ComboBoxes instaed of Textbox values on Userform ?
  661. CODE given: Please help to rectify the error
  662. hide ,unhide columns on protected worksheet
  663. Excel to have User Name and Password?
  664. is there a way to program my Excel file to do a loop?
  665. RE: Formatting Loop
  666. Re: Cell access within Selection.Areas
  667. find doc
  668. Re: Creating a macro where values are copied and pasted into a sheet
  669. Re: refresh calculations and external data
  670. open web page by clicking label1 of the form1
  671. Re: CASE STATEMENTS
  672. RE: hide one column skip two column and unhide one of 11
  673. Re: Copy cell contents?
  674. Re: auto-resizing UserForm window
  675. Re: Data Validation List Sort
  676. creating a spreadsheet function program
  677. Re: delete extra lines within same cell
  678. I am seek for powerful program for SEO!!!
  679. RE: Excel 2007 Functions
  680. Re: code for dragdown, minus one
  681. What is "my" cell?
  682. The date ??
  683. Re: consolidation of tables
  684. Re: debugging... "continue" button...
  685. Re: Converting cells from text to number format
  686. Re: How do I save an XLS without saving my macro with it?
  687. Use real time clock within a spreadsheet?
  688. Re: Can you check the coding here please?
  689. Re: passing a cells content into a macro
  690. evaluate and variables and loop...
  691. Re: Find and move base on value
  692. Re: Application.Run correct syntax
  693. Function Help Please
  694. Making email button work after email
  695. replacing range of cells with text
  696. Excel Macro / VBA to pull up the protect sheet command
  697. Name range visability
  698. Recognizing Smart Tags in formulas
  699. Transfering Info Stop When Null
  700. Fonts and Userform and VBA
  701. Re: Programmatically Name a Range
  702. Re: Deleting cell value
  703. Re: I'm not sure it can be done but....
  704. Xcelsius Resource Needed
  705. programaticly filling a cell with a formula
  706. Re: Set of varibles produces one output. Need series of output.
  707. popluating a list box without having duplicates
  708. Re: Vertical PageBreak not Working
  709. formula determinate problem
  710. Re: formula help needed for averages
  711. Re: formula help needed for averages
  712. Re: formula help needed for averages
  713. Use variable to reference a range?
  714. Re: delete extra lines within same cell
  715. List Outlook tasks from another person's shared task list
  716. Re: simple addition
  717. Re: Why does my file say it has macros, but I can't find them?
  718. Help with Macro (networkdays function especially)
  719. Re: Why does my file say it has macros, but I can't find them?
  720. Re: auto-resizing UserForm window
  721. Cells with Values Edit
  722. randomizer
  723. Hide columns and rows then separate the spreadsheet into different files
  724. Re: Why does my file say it has macros, but I can't find them?
  725. Populating Comboboxes
  726. Macro Button reference
  727. Running totals from timesheets
  728. Weighting Costs Across Multiple Months
  729. Re: Unprotecting (with password) the activeworkbook
  730. Re: Nudge graphics down and right
  731. time stamp based on action in column.
  732. Re: Error '7' Run out of memory while filling in a cell with a formula
  733. HELP WITH LOOPS!!!!
  734. Test Cell for Alignment
  735. password userform
  736. How can I check if a pop-up menu exists...
  737. Re: Begins with
  738. non-expanding range, and also a VBA Sort error
  739. Why does Last Cell Reset to last cell available?
  740. Changing the name of a variable using code
  741. password as ********
  742. Re: Begins with
  743. Re: Begins with
  744. Pasting from Excel to Outlook with VBA code
  745. Inserting rows from "unstable" csv
  746. Re: Removing Comma's
  747. Using vb to paste records from 1 sheet, to related records in another
  748. Methods .Save and .SaveAs throw run-time error '-2147467259 (80004005)'
  749. RE: Find duplicate and append
  750. Re: Removing Comma's