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. Excel 97 - Comparison
  2. Rename Sheets but.....
  3. Macro in a endless loop
  4. Excel Fields to Text
  5. Code doesn't generate correctly on two of 37 instances
  6. Remove WrapText
  7. Data validation - prevent cell overwrite
  8. File to close itself and the current instance of XL
  9. Redefining chart series
  10. Input box and assigning to a variable.
  11. Automating MS-Access DB to open correctly
  12. Testing for Shared Workbook
  13. Macro to move unspecified chart
  14. Crashing!!!
  15. Get Workbook path but from another excel instance
  16. How Do I Create a Range in Excel VBA?
  17. Automatisch beantwoorden vragen
  18. ListBoxes_Change; Err.Num = 400
  19. HTML files into Excel
  20. Change row height if cell is blank
  21. autofill more then one cell when the cells are not close to each other
  22. Insert Row & Copy Formula
  23. Populate cells with Listbox items
  24. VB and I can't close the excel file
  25. Format a ListBox column
  26. Excel - Analysis Toolpack loading problem
  27. Conditional Formatting Not Immediately Refreshing after Macro Exec
  28. Font to be larger in line of VBA
  29. GetCommandLineA fails under Vista
  30. Saving to "MyDocuments" on users computer
  31. Userform initialise not executing.
  32. HOW TO INSERT "CONDITION" IN DATES BY EXCEL
  33. help with macro to read and sort data from multiple text files
  34. vba & SOAP - which soap library & version?
  35. Copying and Pasting Worksheet between workbooks
  36. print certain cells at the top of each page
  37. print certain cells at the top of each page
  38. Excel 2007 exponential slowdown
  39. selecting sheets within a macro
  40. order of evaluation
  41. Excel and Sharing over Network
  42. getting worksheet names from workbooks
  43. Advanced filter vba
  44. getdata macro with selection
  45. Can I set an automatic timeout for a shared spreadsheet?
  46. Interpolation
  47. Err sending WD emailthru XL VBA-F8 OK, F5 not??
  48. Copy method of Worksheet class failed
  49. Convert Column letter designation to a number
  50. Rows in macros
  51. Pivot Tables
  52. Linked Textbox Controls on Form - Avoiding Cascading Change Events
  53. Help!! xlfGetDocuments returns invalid function error (xlretInvXlfn)
  54. Microsoft Query?
  55. Help!! xlfGetDocuments returns invalid function error (xlretInvXlfn)
  56. Clear All Check Boxes
  57. How to retrieve data from worksheet to a textbox
  58. Fill column with default value
  59. VBA Page Setup/Formatting EXTREMELY Slow... Help!
  60. Formula for fill color?
  61. Why doesn't this find the connectors on my sheet?
  62. simple visual basic question - multiple If statements
  63. Method 'Rows' Of Object '_Global Failed
  64. ISO 3166 compliant countries
  65. Get only unique values?
  66. How to copy an image object to new location in shame sheet, Excel.
  67. retrieve entry from a list in excel
  68. Workbook named range not seen by ADO when workbook closed
  69. event question
  70. displaying 'inches' (") in VB
  71. Display Zero's (0) in blank cells
  72. Selecting more than one cell/colum with an offset statement?
  73. How to open a workbook as a copy?
  74. Inputting info in webform from excel vba
  75. Paste not a Worksheet_Change event?
  76. For each row in a range...
  77. pivot tables: pivotselect with a very large table
  78. Grouped shape name
  79. Break this down...
  80. Get image dimensions
  81. Reindexing worksheet numbers
  82. Auto run macro
  83. Error message when opening a .doc file using excel macro
  84. Shape number for a connector?
  85. Time array
  86. Trigger Question
  87. Delete Columns not containing certain values
  88. General Mail Failure error when routing
  89. Hyperlinks issue
  90. Loops question
  91. Making Hyperlinks from a list of sheet names
  92. selecting multiple cell
  93. Help! Error 1004
  94. How do I renumber a worksheet
  95. Copy sheet into a new workbook
  96. VB code to save worksheet as...
  97. Converting to a htm file
  98. saving excel workbook as csv format?
  99. Copy image to tabs
  100. Getting at the range or cells
  101. Finding the row address with the specic value
  102. date field is held as 38932 how do I export as 3rd August 06
  103. how do i show extra information in data area of pivot table
  104. Dates
  105. Filter
  106. how do i display some extra text information in pivot table data area
  107. How do I add a new row?
  108. Copy...Destination question
  109. [C#][COM] Excel crashs when a cell name is a function name
  110. find duplicate entry and replace across sheets
  111. Display multiple results in 1 cell
  112. Get Webpage data as text using VBA w/o Webquery
  113. Help ! Project crash
  114. creating an array
  115. Emailing Range in Body CC Problem
  116. working with rounded numbersnin a time sheet
  117. Count consecutive repeats
  118. Excel version
  119. how do i derivate a math function?
  120. Message Box with a twist...........
  121. macro to cut/ paste ever nth row
  122. Need help with a Macro or VB code for Header/Footer
  123. LIST Button - Removing Arrow that goes left to Right
  124. Move the cursor to the next row
  125. If drop down list is blank, return error
  126. Date Time Question
  127. Date Time Question
  128. surpressing listbox changes
  129. Does an object exist?
  130. repeating code on files in multiple subfolders
  131. Concatenate Question
  132. Automatically adding an Add-in
  133. copy to closed workbook on a different drive
  134. getting worksheetnames as links.
  135. Passing collections to an object
  136. Error Help - Method "Range" of object "_Worksheet" failed.
  137. help to adjust my code
  138. use VBA to tell if all the text in a TextBox or TextFrame can be displayed
  139. VB macro
  140. mapping table
  141. Updating "#Invalid entity XXXX" using VBA
  142. solver
  143. Select standard toolbar button option
  144. Deleting PivotFields From PivotCharts in VB.NET
  145. Runtime Error '1004'
  146. Conditional Summing
  147. Unload/Hide Userform when switching to a new Wbk
  148. After Query Update
  149. SUM same range from multiple workbooks
  150. Application.DisplayAlerts
  151. Conditional Format: NOT Hidden Row, Not Locked Cell, No Data in Ce
  152. DateSerial Troubles
  153. How to Copy from One File to Another File
  154. Pop Up Message only once.
  155. Capture Enter in textbox
  156. VBA Search Date Range and Populate Spreadsheet Cells
  157. unchanging worksheet reference
  158. how do i program a combo box
  159. very simple VBA question for Excel
  160. Can I save a copy of Excel workbook in MSSQL database using VBA?
  161. Remove .xls from a variable filename
  162. Loop Through Array Copy/Paste Value into VBA Code
  163. help with macro
  164. "Cannot change part of a merged cell" when AutoFilter is turned on
  165. Search Existing Toolbars
  166. Programming a Directed Flow Chart
  167. Date update only on action????
  168. Importing Multiple Text File in Excel
  169. Microsoft Query?
  170. XP 2002 Office Suite vs. XP 2003 Office Suite
  171. VBA Gone!
  172. Problems with ADO connection to same workbook?
  173. Entering data into arrays
  174. Need ComboBox to require entry before moving to next control
  175. Sheet protection and cell fomat changes
  176. Compare columns for dupes
  177. Natural log function
  178. sort macro
  179. format cell reference in a text box
  180. Find empty row and color
  181. Hidden Worksheet
  182. Excel crashes when opening file
  183. how to do this vlookup
  184. SumProduct - Why won't it work?
  185. worksheetfunction question
  186. How to round of the value with ends zero(0)
  187. How to round of the value with ends zero(0)
  188. Input box
  189. Adding, naming Worksheets sequentially
  190. Use R1C1 to select cell
  191. Combo Box
  192. Count duplicates as unique record, sum amounts?
  193. Re-set autofilter selection after adding a new row - programmatica
  194. Formula needed to show blank when values do not appear
  195. Copy image from existing workbook / template
  196. macro that copies and pastes
  197. Inserting a BLANK row
  198. Auto insert blank rows
  199. Copy sheets without macros
  200. VBA Program to calculate Subtotals
  201. Copy destination = different file / different Workbook
  202. Importing Text File
  203. STRING SUM UNTIL
  204. Help with selective info in a FORM
  205. IF Then Statements for comparison
  206. Aligning a connector to a cell edge?
  207. Help with Enable Macro Error Msg (Excel 2007)
  208. SmallScroll & LargeScroll Methods in Visual Basic Applications
  209. Query Folder for Spreadsheets
  210. Returning values to unique rows
  211. COST CALCULATOR
  212. Help with Autofill Routine
  213. Folder Tree and size
  214. remove macro and security warning
  215. create tabs and add hyperlink to each tab
  216. how can i isert a funtion in F1 or F2? Like F1 put DEP in a space
  217. checkboxes' return value
  218. If Statement
  219. Deleting Sheet Message
  220. Help Creating Code
  221. Is there a simple way to combing 1D arrays?
  222. English (UK) Settings Problem?
  223. Excel 2007
  224. Text box results to become a Variable
  225. Macro Help
  226. Using result from text box as a variable
  227. question regaridng checkboxes
  228. q: is this possible in vba - multiple command buttons..
  229. Help w/ Class to get app-wide Wkb.Open event?
  230. getting worksheet names
  231. Moving around an User Form
  232. Excel returning a record set from a stored procedure.
  233. Reset Validation lists to display 1st value in list
  234. have excel go to defined cells when pressing ENTER
  235. Search two Strings
  236. Stand Alone program
  237. Runtime Error '9'
  238. concatinate a textbox name
  239. Pasting hyperlink from sheet A to Sheet B?
  240. Programmatically reading from Excel and formatting
  241. Matching to dynamic range.
  242. Excel 2000/2003 to Adobe PDF convertor
  243. Question on macro (copying filtered selection into the newworkbook
  244. Hi-Lite "empty" unlocked cells in non-hidden rows
  245. Programming with the VBE using AddFromFile gives Run time error #9
  246. Set drop-down box name
  247. Dynamic change of limits in for...next loop
  248. Web query problem when password required
  249. if statement and cell formatting
  250. Updating a last modified date using the worksheet change event
  251. Disabling error message with Web Query
  252. Color locked cells only in specified range
  253. Opening different files one by one in same folder
  254. AVB Help please
  255. cell date format problem
  256. VB Code..
  257. unique list from a range of cells
  258. Automated graph distortion
  259. using vlookup in a custom function
  260. Resource to begin programming
  261. Limit distribution of a spreadsheet
  262. Referencing a sheet name thats ever changing
  263. Trouble with csv export...
  264. Extending objects in Excel 2003 with VBA
  265. Sorting Multiple Columns in a single operation?
  266. Help in adding another check to my code
  267. Help with events
  268. Macro Formula
  269. remvoe the prompt?
  270. Unhide sheet on open only if password to modify is given
  271. How to run Solver from Visual Basic?
  272. Excel 2003 Pivot Table Drillthrough
  273. Excel 2003 Pivot table Drillthrough
  274. Search Access Table with Excel
  275. Data Validation - Multiple Time Slots
  276. Help With Code:Arabic Number to Text
  277. Mod and Int gives me a Runtime Error 13 -- Type mismatch.
  278. Programming a button
  279. Protecting menu in a workbook or sheet
  280. Staff Capacity Plan Template
  281. ActiveX Control with workbook
  282. help on while loop
  283. Can I pass control to a 2nd workbook
  284. Lock Page Field in a Pivot Table
  285. Opening a pdf file with Adobe Reader
  286. Worksheet Activate event if only one sheet in book
  287. Can't Get Listbox Value
  288. dates and pivot tables?
  289. BackgroundWorker inside a user defined function
  290. Farmula wrong result
  291. Format Number as Arabic (Saudi Arabai) inside text
  292. Using If Statement
  293. do xl add-ins have worksheets?
  294. Convert number to arabic(Hindi) format with text
  295. Dependant List
  296. UpdateLinks error?
  297. Convert number to arabic(Hindi) format with text
  298. Count the number of users accessing a shared excel workbook
  299. Excel 2007 Bug
  300. Hiding a Form that's not open
  301. how to select a particular range
  302. copy rows that do not match values in dynamic range.
  303. WorksheetFunction OR
  304. DDE - Chart.Wizard does not work in Office 2007
  305. external data works in 2003 not in 2000
  306. Setting tab widths
  307. copy data from source file to w/book
  308. Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
  309. Adding checkbox to worksheet in C#
  310. Programming a NAME
  311. Dependent lists
  312. Pivot & Ranking
  313. Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
  314. Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
  315. Sorting and mapping change
  316. Using a code n times
  317. setting print range
  318. R1C1 Problem
  319. Can anyone tell me the proper code to copy a range...
  320. Breaking excel links in code?
  321. Merged Cells: Any way to backtrack?
  322. Drill down combo boxes
  323. Can Bloomberg BLP functions create an event?
  324. Cursor movement
  325. Upload range into an array
  326. How do I export data from excel to Powerpoint by macros in excel
  327. No userform, runs from module, want to change mouse pointer
  328. Hide worksheet changes when userform displayed
  329. SumProduct, Match in a UDF
  330. Providing suggested filename
  331. sumif and countif?
  332. getting worksheetnames from subfolders
  333. Fill formula to last populated row
  334. RE: Macro - 2 Sheets - Find/Insert/Copy/Paste
  335. How do I use UDF's in Excel 2007 from 2000
  336. Userform sizing problems
  337. Using a macro to add a count and sum on a dynamic range
  338. Creating a PRN file from Excel
  339. Disable Range Reference Update in Vlookup
  340. Disable Range Reference Update in Vlookup
  341. font scaling problems
  342. Save default dtpicker value
  343. pulling information from a closed workbook (revised)
  344. Message box trigger?
  345. Macro not protecting every sheet
  346. pulling information from a closed workbook
  347. Save default dtpicker value
  348. Excel and 'refresh data' dialog
  349. xlPasteValues
  350. Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas
  351. String concatenation having null character
  352. Pivot Table w/IF Stmt
  353. Launch an excel hyperlink programatically without clicking
  354. VLOOKUP question
  355. VBA Excel Macro
  356. Listbox Code
  357. Public variable not accessable
  358. format of copied data unclear
  359. Conditional Formatting Formula
  360. Dynamic Dropdowns
  361. Copy row to next available blank row
  362. Unwanted Listbox Horizontal Scrollbar
  363. Application.quit
  364. convert 1006 to date (01/10/2006)
  365. COUNT Function
  366. Rowsource Invalid property value
  367. How do I search by user profiles by username?
  368. Passing a range to a UDF in VBA that references a different worksheet
  369. Fill Listbox with Unique Items
  370. Populating a combobox
  371. Start Date And End Date with pivot tables?
  372. Assigning range to variant
  373. Vijay 1
  374. Assigning range to variant
  375. Work Sheet
  376. Please Help with Short Macro
  377. Insert page breaks every 50 rows but do not include hidden rows
  378. VBA - Row Deletion using If/Then Statement
  379. spliting data in a cell
  380. VBA macro resul Microsoft Excel for Windows has encountered a prob
  381. Long footers in Excel 2000
  382. Macro to set end to create range
  383. Is Win API needed?
  384. Dynamically hiding fields using VBA
  385. Create a pivot table with a local connection
  386. Disabling the refresh of a pivot table
  387. Workbook_open event disabled by manual calc command
  388. Using count for an AND statement
  389. Validation Testing through list
  390. Programatically Naming Worksheets (using catenated values)
  391. Running Macro at sheet activation
  392. Select cell without copying it
  393. identify consecutive columns they are coloured
  394. Need help creating a variable size printarea marco.
  395. Connection between MSSQL from/to Excel
  396. looking for duplicate rows
  397. Two questions about PivotTable in Excel
  398. WorkBook open event
  399. Automating Tasks
  400. Is there any protection change event?
  401. Please explain code
  402. Effecient method of copying and pasting required
  403. How to identify account username/userid when connected to a sharepoint list
  404. listbox issue
  405. Highlighting first line in list box
  406. ActiveSheet.Paste takes FOREVER!!
  407. List Box
  408. Drop down select with same cell entry
  409. opening excel file
  410. BeforeDoubleClick doesn't seem to work
  411. Temporary suspend the validation
  412. List Box
  413. Open event trigger
  414. adding range values to array
  415. WorkSheet_Change code from a CommandButton
  416. best way to set up macro library so all spreadsheets have access?
  417. ListBox with header row, delete row, protect header row
  418. Microsoft's drop down box
  419. Excel 2007 - Personnal CommandBars
  420. GetSaveAsFilename alwyas overwrites existing file
  421. Rota cycle
  422. copy from one sheet to another
  423. Error code - Could not decrypt file
  424. Show/Select Visible Rows via ComboBox
  425. Help with code
  426. Column function
  427. Chnge code help requited
  428. Find * in a cell & ClearContents
  429. Copy paste from Excel to Outlook - Graphs, pivots & cells
  430. Transpose certain cells in a row while keeping other cells intact
  431. Using Excel template from VBA - Virus scanner problem.
  432. Use of Like to extract data
  433. Application.run is not working
  434. Auto Update Pivot Table Help
  435. Combine consecutive Rows
  436. How do I Create 'ragged' arrays in Excel VBA?
  437. SaveFileName in Excel
  438. I am trying to create a sheet with doubled drop-down lists?
  439. Syntax for a macro to unprotect a union of cells
  440. VBA print preview hangs Excel
  441. ADO - Paste Links
  442. Pivot Calculated Field -If Statments
  443. Call Macro on KeyPress
  444. Excel 2007 formula error
  445. Create hyperlinks from external links
  446. Thank You all for the help..one more question..for now
  447. Track color change
  448. 2007 EC Excel - Access User Conference
  449. I need a work schedule template for a union plant with 170 people
  450. File protection
  451. Search for Code
  452. Combine consecutive Rows
  453. Copy from recordset errors in ADO
  454. Include help for a user defined function written in C#
  455. attaching specific files to e-mails
  456. RE: Edit Microsoft Query
  457. yield analisys tools
  458. yield analisys tools
  459. Blinking Text
  460. Moving a shape with text inside without editing text
  461. copy excel
  462. formula help
  463. Using Lookup in a macro
  464. Tabstrip
  465. Loading a JPG into an Excel worksheet
  466. Excel Copy/Paste Macro to another open application. QWS3270
  467. Click Event - list box
  468. Image on Connand Button
  469. Send data from userform to specific cell on specific sheet?
  470. Can we get the current page number, or just row number?
  471. Can macros be viewed or edited while in shared mode in Excel 2007?
  472. Problem loading userform with frames
  473. VBA Stringbuilder
  474. Split data to worksheets
  475. I need to add an Input Box
  476. Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc..
  477. Excel 2007 - Deleting Rows from a Table with AutoFilter
  478. Exception from HRESULT: 0x800A03EC when setting string in Range.Value2 field
  479. Export Excel Spreadsheet into specific table in Orcale
  480. rng no work correct...
  481. Macro protection - How to test Windows registration infos
  482. Store Data
  483. browse between worksheets ?
  484. How to add a button in Application Level Excel add-in?
  485. Remove Left Most character
  486. Sending e-mail using CDO
  487. Please help with relative file path syntax??
  488. How do I implement this in Excel? Need programming tips.
  489. Macro
  490. Trying To Open Second Copy Of a .XLA?
  491. Copy Multiple Workbooks to Worksheet
  492. Userform Stepping Through Sheet Data
  493. Userid
  494. Distributing macros with an addi-in
  495. Slow down by page set up code
  496. Record macro to include changes in dropdowns
  497. user entry form for excel search
  498. Hyperlinks after a SORT
  499. I need a Macro to extract data by customer to new worksheets
  500. For Tom Ogilvy - ADO issue
  501. Excel document not saving
  502. ADODB.Connection
  503. "Procedure declaration does not match description" error, _dblclic
  504. Password protect macro via a macro
  505. Can column character be added?
  506. importing files from our mainframe into EXCEL
  507. Find matching tab names between different workbooks
  508. Disable Customize dialog box
  509. print no shading on selected sheets
  510. How can I stop date formatting?
  511. Cannot remove custom commands from 2007 add-ins tab
  512. Help with my macro for two autofilters
  513. Copying and Pasting
  514. Renaming a tab to a date from a cell value (Tom Ogilvy code)
  515. novice working with a spredsheet
  516. conflict between validation list and export data from access
  517. Code exucution stopping spontaneously
  518. Mocro trouble - Sum if and check for formula
  519. Using a TextBox value in a file String
  520. Datafields disappear in PIVOT table
  521. How to pass cell reference to VBA function?
  522. highlight punction marks in active cell
  523. Macro Run to Slow..How to improve?
  524. Macro to Copy Mulitple Worksheets to New Multiple Workbooks
  525. How to retrieve from Excel/VBA the SharePoint (v. 2003) user's ID when he/she is connected to a list
  526. E-Mailing Code Error
  527. Paste special
  528. Check if a sheet exists in a file, without opening that file
  529. Selected sheet within a Private Sub
  530. Getting Excel to not plot emty cells
  531. lock cells
  532. Date format
  533. sample macro for printing by selection
  534. Copy sheet problem
  535. RANGE DATE CODE
  536. Stopping calculation on workbook open
  537. Interrogating Data on Hidden Sheets
  538. Labels and Captions
  539. Syntax- drop down menu contents wanted
  540. Macro to Hide Row based on Value and then change Checkbox value
  541. Cycling Through Pivot Field
  542. Using vba to search for all workbooks filename within a directory???
  543. Retrieve data from external excel document
  544. On Time Function when Logged Off
  545. Using Transpose from within VBA with >256 array
  546. _xlfn.SUMIFS name?
  547. List Box Row Source
  548. programming in excel
  549. Printing a number of pages with them numbered
  550. Referencing output on a drop down field from two columns
  551. Required Selection to save or print
  552. Using the AUTOFILL Function
  553. open workbook, display certain sheets
  554. click an internet pop-up "OK" button
  555. Filter on multiple criteria, same cell
  556. Capture request/response HTTP headers with VBA
  557. Worksheet-specific event handling needed
  558. Run a macro on multiple files in folder
  559. VBA Not Running in Exported Pivot Table
  560. Need Help
  561. How to Install Older Object Library
  562. Autofill Macro
  563. Translate in English please...
  564. Multiple Worksheets - Protection
  565. Goal Seek
  566. Can anyone help?
  567. Listbox - Width
  568. cell referencing with variables
  569. Query Refresh - Turning it off completely
  570. Get Control Before AND After Printing
  571. Query Refresh
  572. How to get the value of a meged cell
  573. VB code to check number in Rectangle box
  574. Is filepath valid?
  575. Copy selected mulitple worksheets to mulitple new workbooks
  576. can't modify field
  577. read next two cells over using Large function
  578. Can we make Excel close itself without asking anything?
  579. How can I check to see if I can see a server or shared drive?
  580. textbox array
  581. RE: Is filepath valid?
  582. browsing between worksheets ?
  583. Preventing macros in attachment
  584. Number Stored as Text.
  585. When does the Access query run at worksheet open?
  586. annotation
  587. How to pass arrays of integers or doubles to VBA function in Excel
  588. RE: read next two cells over using Large function
  589. RE: Get Control Before AND After Printing
  590. RE: Copy selected mulitple worksheets to mulitple new workbooks
  591. Require second qualifier in attached code
  592. How do I make a set of invoices from a list?
  593. Anyone have ideas on the Public Variant problem I posted about 5 or 8 posts ago
  594. How to catch the event when an Excel window gets focus?
  595. SUMIF from another workbook
  596. textbox formatting programmatically
  597. Turning pages into PDF
  598. Open a form from Tool bar
  599. Public Variant problem
  600. Looping thru TextBoxes
  601. Copy/Paste problem
  602. Evaluate("1")
  603. Event not shown for an ActiveX control
  604. Concatenating Numbers & Text to create a String
  605. Dates calculation should consider holidays and weekends to suggest
  606. Remove Macro Message
  607. Keyboard vs Mouse
  608. CTRL+R Fill Right
  609. Finding an occurence
  610. Simple problem, must be too early...
  611. SendKeys variable
  612. Save Button in Excel
  613. Page Break Location
  614. Linking Excel Charts to PowerPoint (Office 2003)
  615. need help on how to grey out one option button in one group box based on the selection of another option button in another group box
  616. Sheet Tabs
  617. Subscript out of range error
  618. Retrieving Excel data
  619. Userform Queryclose and Unload problem
  620. se e somente se
  621. How can I select non visible cells?
  622. Graphs with entries in multiple column and dates
  623. Storing important values: ini file, XML, Registry, where else ?
  624. Problem with FollowHyperlink and Firefox
  625. Set selection of Pivot Table using VBA
  626. How to specify a range?
  627. Run time error 1004 - cannot insert object
  628. help me out
  629. How to find cell with specific format?
  630. SaveAs filename PDF
  631. ADO SQL syntax query, using a variable
  632. Sheet1 Data Autometically Uploaded in Sheet2
  633. Import Data from 2 Workbooks in the same folder
  634. Creteria Help
  635. names and deleting them
  636. Proper Name Totals
  637. change the fore color
  638. pagesetup object
  639. Prompting user to answer a question before saving and closing wkbo
  640. how to unhide a multiple sheets trigger by a checkbox
  641. Help with Excel Array?
  642. PLEASE HELP ~ want to have users enter date only once --
  643. How to get "/automation" when automating?
  644. option button (Form)
  645. .Avi video's and Excel
  646. Link Cell with Comments
  647. Mysterious auto_open
  648. ListBox3.ListIndex = ListBox3.ListCount -- How to select the last item in a Listbox?
  649. deleting an entire row if the cell in col A is empty
  650. Delete Temporary Internet Files with VBA
  651. Problem linking assembly to existing Excel file
  652. Help with My Macros Program
  653. Go to cell based on formula result
  654. sorting on a non active sheet
  655. Programming my macro
  656. Parameters of SUMIF in VBA
  657. excel macro
  658. VBA to copy a template worksheet to new excel workbook
  659. Adding empty row with code
  660. Macro to Autofill until there's a new value
  661. Creating a list from previously selected list
  662. Validation List Width
  663. VBA can't find file as it moves from folder to folder
  664. Search multiple workbooks in file for data
  665. automatically installing mscal.ocx
  666. Importing data from website directory
  667. using MailEnvelope
  668. Unable to modify cells in a VBA function
  669. form appears on second monitor
  670. VLookup OR If Function?
  671. Why this error and how to solve it ??
  672. Format cell based on function result
  673. Import images into excel cell from database
  674. Can I link to a print command from a cell?
  675. Can't select worksheet
  676. Select C6 down to last used cell, as determined in column B
  677. TextToColumns 2000 and 2003 differences?
  678. Call the edit-links dialog box
  679. convert Excel data to Access
  680. how do I prevent access to certain cells?
  681. Copy sheet problem in Excel 2007
  682. Change event and ranges
  683. Executing Macro when Workbook is Open
  684. Clear Named Ranges
  685. comparing lists in 2 workbooks and de-duplicating
  686. Inserting comment in unlocked cell in protected sheet
  687. Open File in Folder
  688. How can I delete rows programmatically based on certain criteria?
  689. Relative reference in VB with If Then
  690. How to deleted duplicate record on columnA
  691. Runtime Error 5281
  692. Help seperate Arrays
  693. dot net excel error
  694. InputBox Question
  695. select all sheets?
  696. How do I write a looping in VBA in Excel?
  697. Add-In File Size Growing Inexplicably
  698. disable cut and paste
  699. Links Box
  700. Admin password to Individual protected worksheets by users
  701. Data Validation type query
  702. Selecting the Last row
  703. What of these is the correct syntax to refer to Properties?
  704. Find item in list, return a value
  705. Sorting data over multiple sheets into array
  706. Calculate Sheet Option
  707. Update option button from c#
  708. Calendar
  709. button that controls macros?
  710. find identical record in one sheet
  711. Checkbox - Change color of label when clicked
  712. Help - Nested IF
  713. List Separator
  714. VBA Extensibility library and dynamic code compilation
  715. Cursor
  716. Comparing two lists and removing duplicatations
  717. txt tab-delimited to CSV
  718. Recordset from excel worksheet
  719. On error GoTo Question
  720. Save all files opened
  721. copy last row with formulas and paste into next row same sheet
  722. Filter sub
  723. When I hit return in a multiline text box, focus goes to next text
  724. how to copy / paste in userform multiline text box
  725. Selecting the correct range
  726. Checking cells contain a value
  727. dialogs
  728. dialogs
  729. Help with syntax
  730. Highlight a cell if it changes as a result of formula recalculatio
  731. Uploading in Internet
  732. Closing Print Preview in Excel Macro
  733. How to paste a date to the last blank cell?
  734. Merged cells .Offset(row,Col) inconsistancies
  735. Extract Country/Region of email sender from outlook message
  736. If then to hide a combo box
  737. Adding Custom property
  738. userform error 1004 select method of range class failed
  739. adjusting a macro that retreives access data
  740. Offset,Match,Copy, Paste Special - A Complicated Task - Help Pleas
  741. merge columns
  742. Connecting to SQL Server table
  743. Record macro to name multiple ranges
  744. Opening "locked" application
  745. VBA: AdvancedFilter - Unique Copy of column of names doesn't work?!
  746. filter results to userform-sheet
  747. Problem with Combobox.Dropdown method
  748. Using a Macro to Copy and move data! - HELP!
  749. VSTO Excel AddIn Question
  750. How to copy the new Excel 2007 conditional formats