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. Merging cells with same parent.
  2. Finding what has changed.
  3. Excel 2003 interacting with another program
  4. LOOPING THROUGH A 2-D STRING ARRAY !!!
  5. Change the structure of words?
  6. more array help needed
  7. array help
  8. Unexpected Error
  9. macro code to a shared file
  10. finding dates from drop down
  11. How do I assign variables
  12. Floating Bar Chart 1004 error
  13. insert rows after data change in column
  14. Simple VBA
  15. Find next problem
  16. Macro
  17. VBA to Assign Outlook Task
  18. Conditional Formatting a tab color
  19. deleted cells
  20. tab order in excel
  21. macro pasting and moving
  22. sum of absolute value of each cell of a column..
  23. Disable right click menu
  24. Re: Workbook still won't save customized QAT
  25. Little Problem, Difficult and Hard.
  26. Need hardware locking for Excel application
  27. My ref: RN0001 Find the first & last occurrence of a strings
  28. Automate Pivot Table with varing number of records
  29. filldown recurring 121212
  30. Filldown recurring 121212
  31. Format cells help
  32. Formulas using two cells
  33. How to password protect an 2007 workbook without show readonly opt
  34. print button prints two images in same chart
  35. Scrolling and date matching
  36. Using variable names in a loop
  37. Workbook custom document properties
  38. Looping through sheets and comparing data
  39. making code more efficient
  40. How to sum the 3 best scores for each country in a contest?
  41. copy method of worksheet class failed: trying to copy a hidden she
  42. copy method of worksheet class failed: trying to copy a hidden she
  43. copy method of worksheet class failed: trying to copy a hidden she
  44. Programming error - Procedure too large
  45. subscript out of range error: tyring to copy a hidden sheet
  46. subscript out of range error: tyring to copy a hidden sheet
  47. subscript out of range error: tring to copy a hidden sheet
  48. IF, and, or statements combined
  49. Finding a specific text
  50. looping macros
  51. Sorting Images in Excel 2007
  52. Excel to Powerpoint 2003 Chart Width
  53. CSV code works on some, but not all machines
  54. print command from command button in userform causes double chart
  55. Macro Recorder Doesn't Record Anything
  56. flash movie on userform doesn't play when code is running
  57. Error when saving as TAB TXT (euro transforms in $)
  58. Go to sheet based on ListBox selection
  59. System Dates
  60. Graph and data
  61. Countif help
  62. Application or object error - one last try
  63. SubTotal when Cell Changes
  64. How to run same macro on 14 out 15 worksheets
  65. Exclude sheets from code
  66. fixed filter criteria made variable
  67. Delete Method as it applies to format Condition object
  68. DTPicker stopped working
  69. Copy two sheets from workbook & create new workbook
  70. Manipulating MS Access records with excel VBA + ADO
  71. Filter & sort
  72. Remove buttons from workbook
  73. Lookup where target worksheet may vary
  74. unable to load WinSocket dll in Excel Visual Basic Editor
  75. trouble with subtracting elapsed times
  76. Vlookup in to find in multiple table
  77. Macro Help!!!
  78. Auto Update a sheet through Macro
  79. How can I search the Excel groups archive
  80. VBA Code Error
  81. Code error message for Excel 97 users
  82. RE: Problem with VB Objects in Excel
  83. How to get lookup data from Access Table
  84. Open userform at top of form
  85. Application.Ontime for Private Sub(Proceedure) - ThisWorkbook*
  86. re-activate personal workbook
  87. consolidate data that occurs close together in time
  88. RE: Detect #N/A or number
  89. Delete Sheets Without Contents
  90. RE: Detect #N/A or number
  91. New using macros
  92. Find string/date in array to get value of nearby cell
  93. vba
  94. Row source question.
  95. Loop through textboxes on a userform?!
  96. Possible form error.
  97. Filtering based upon a remote value
  98. Object Selection
  99. SendMail
  100. Re: extract formula result form cell without running formula again
  101. extract formula result form cell without running formula again
  102. Enter Value based on Cell Color
  103. Concatenate and Delete
  104. How to Pre-Select items in Multi-Select List on Form
  105. Public Function Description
  106. Question about running macro from VBS
  107. Error 380
  108. CountIf function refering to another worksheet
  109. clearing data from a user form
  110. Help finding first empty cell in column
  111. How to insert picture using VBA which refer to cell value
  112. Subscript out of range
  113. Open Folder containing Jpeg files to get hyperlink
  114. Macro to Delete a Row
  115. xlFillDefault
  116. Macro Activation
  117. RECORD SENT EMAIL
  118. copying information from a web site
  119. Value of type 'General' cell different from 'Number' or 'Text'?
  120. Password protect worksheet
  121. Find links to other worksheets using VBScript?
  122. Macro for extracting the filtered data only.
  123. Copy contents of cell to another tab
  124. Script to refresh data and save and close
  125. Transpose Links
  126. Determine cells with "General" number format
  127. Macro to copy data to next available row
  128. Multi Workbooks / Emails
  129. If cell contains specific formula (GETPIVOTDATA)
  130. method 'cells' of object '_global' failed
  131. Excel workbooks and programming upward compatible?
  132. Sending 3 email?
  133. Help with my userform code
  134. File in Use dialog when I Open an extra excel via the (start menu)
  135. Find first row number after filtering
  136. CDate or CVDate
  137. Sum sections of data
  138. Copy a set bit of text to the clipboard?
  139. .htm error
  140. Which Worksheet is Active?
  141. Find in another worksheet and copy to original worksheet.
  142. Efficiency in code
  143. quick!!!!!!!
  144. What is the VBA equivalent of the excel function VLOOKUP
  145. Select method of Range class failed
  146. Unmerge cells and fill duplicate data
  147. Function that returns if a given cell is visible or not in a filteredrange
  148. Copy 18 Cells in one row
  149. New line of code.. same argument?
  150. Find a cell based on value?
  151. How do I preserve references to table cells across sort operations
  152. Why vbscript examples do not work?
  153. Re: macro / formula problem -- rearranging names in a selected cell
  154. Cond. Form. Adding In dates & out of dates
  155. Re: macro / formula problem -- rearranging names in a selected cell
  156. Re: macro / formula problem -- rearranging names in a selected cell
  157. RE: macro / formula problem -- rearranging names in a selected cell
  158. List of text in a message box arranged in rows
  159. savecopyas read only
  160. Copy Text From PDF to Excel
  161. Suppress Zero
  162. Macro button that asks for password before proceeding?
  163. Move data worksheet to worksheet
  164. Add to LinkSources
  165. Create Interactive Web Page from Excel File
  166. Application.Run error
  167. Linking to Summary Sheet Changing Range
  168. Counting number of e-mail arrived with specific subject for a day, from Excel
  169. Macro copy values to a different workbook
  170. Upload Excel data to web service
  171. Set datatype of a cell?
  172. Need Code for Opening Old Files
  173. Odd Workbook.Name result
  174. Code to Delete Data in Specific Cells
  175. [VBA] Conditional Formatting
  176. Saving outlook attachments with VBA code
  177. RE: Import Excel Data to SQL Server
  178. BIDS - Excel Pivot Table - Data Cube - What - if analysis
  179. Sum only selected cells
  180. VBA code for sending multiple email attachment??
  181. Excel 2007: Graph macro using reletive reference?
  182. 2 level sorting
  183. Excel VBA-Worksheet Name length issue while Querying frm another E
  184. Find Method for finding the next value in a range GT certain value
  185. popup balloon (not msgbox)
  186. Excel addin doesn't work.
  187. On time from cell time
  188. How do I preserve references to table cells across sort operations
  189. Raise Event Problem
  190. Excel 2007 -- Automation Error
  191. Add Microsoft ActiveX Data Objects 2.8 Library in code
  192. cell value
  193. Copy/Paste?
  194. Run macro when when changing cell value with formula.
  195. Selecting a specific file from many
  196. cut/copy & paste w/source formatting except for conditional format
  197. = Today()+1 into Sheet1, Sheet2, and Sheet3
  198. Trying to Close File
  199. Import MS Project Data through Query
  200. Replace
  201. Lotus Notes email background processing and open new message.
  202. HOW DO YOU MAKE EXCEL REPORTS INTO ELECTRONIC EMAIL
  203. Re: getting values of a range of data
  204. (Excel 2007) API to get computer IP address or domain name?
  205. Keep destination formatting when pasting?
  206. Maximun number of fields in a pivottable in excel 2007?
  207. Looping with multiple conditions in Userform
  208. Time stamp function trouble shooting
  209. enable macro automatically when we open a workbook
  210. Data validation in Userform sub
  211. Unique values in a Collection
  212. text/number formating question
  213. Re: How to calculate the number of non-zero cells in range?
  214. Skip Run macro if module has been deleted
  215. Reacuring subtraction from a balance
  216. Save as question.
  217. Grouping like transactions
  218. To Update ComboBox
  219. Add drawing shapes to Userform
  220. Dir help
  221. Moving Charts
  222. Retrieving Excel data to post to a form
  223. Widen Sheet Tab View Q
  224. send e-mail from Excel, copy and paste at specific place in e-mail
  225. (Cross Post)
  226. Formulas containing hard coded values
  227. Excel 2003 toolbar with custom image
  228. Re: Change linked cell reference to absolute
  229. Calling VBA Function from VSTO Code
  230. ActiveWorkbook.SAVEAS for *.xls
  231. How to tell a user no range has been selected.
  232. Multiple message boxes, one after the other in AutoOpen or other?
  233. Elapsed times > 24hrs
  234. Need cell value not cell pointer returned from formula
  235. Need cell value not cell number in formula
  236. Update ComboBox
  237. importing data from excel to sql server 2008 by code at run time
  238. Exit Sub alternative
  239. Type Mismatch
  240. Call Sub
  241. Type Mismatch Error
  242. UserForm Shown while Program is Running other Code
  243. Screen aspect ratios changes when macro runs
  244. Macro for multiple prints
  245. calculating based on color
  246. RE: BeforePrint Sub auto referencing
  247. Loosing VBA project when opening up Excel 2007
  248. MsgBox Special Characters
  249. Macro Help
  250. Insert Column based on data in Row.
  251. users have to manually enable macro everytime they launch userform
  252. userform on intranet: disable save button on initial launch
  253. Drop Down List were Text = numeric values for formulas
  254. TextBox exit routine 2nd try
  255. VLOOKUP question
  256. Email permission question...
  257. FYI Excel 2007: Saving a xlsm file with a hidden worksheet activated makes worksheet visible
  258. Filename str cut too short
  259. swap contents for one workbook with contents from another one
  260. InStr Help - Multiple Criteria
  261. Error Message: Sort Method of Range Class Failed
  262. Concatenate with currency w/2 decimal places
  263. merge cells part deux
  264. userform on intranet: have to enable macro every time
  265. Transfering Data From Userform1 to TextBox1 in UserForm2
  266. Userform on intranet: disble save option, allow open only
  267. .net dll - error 429 ActivX component cannot create object
  268. TRYING FIGURE out how wide a text box should be in userform
  269. Macro to delete part of a macro
  270. Subscript out of range when selecting worksheet...
  271. Progress Bar
  272. Finding the average of two generated totals
  273. Please Help
  274. Range Value Assignment Failure in Event Proc
  275. delete row if text not in specific format
  276. Store custom doc properties Temporarily ?
  277. Variable Not Defined
  278. New Application opening for each file
  279. Excel 2007
  280. Sorting by month
  281. Timing for an event longer than 24 hours
  282. Unable to call a DLL function from Excel
  283. Rename Excel File
  284. Adding filename
  285. Command button icons when disabled
  286. RE: Workbook won't save customized QAT
  287. 2003 to 2007 compatability
  288. Send Email If
  289. Excel macros and Open Office suite
  290. Position Input data in Cash Flow table
  291. 2 Column ListBox, Selection data
  292. Make option button link permanent to cell
  293. SQL loop of input values
  294. clear all raws after 5000th
  295. Copy Values to empty cell below filled cells in selection
  296. retrieving cell reference data
  297. RE: Subscript out of range error - selecting a sheet
  298. fill dowb using macro
  299. TextBox exit problem
  300. Test a grouping of OptionButtons
  301. testing cells in a row
  302. Search an Array
  303. macro to browse files then copy certain data from the selected fil
  304. Type mismatch
  305. need macro for fill down
  306. I have a rng problem
  307. Workbook activate help
  308. Populating a ListBox with an Array
  309. using Solver add-in
  310. VBA and SharePoint permissions
  311. Date in the workbook name
  312. To "freeze" Spreadsheet
  313. Worksheet copy problem
  314. TextBox_Change() problem
  315. Run-time error 57121 "Application-defined or object-defined error"
  316. Ribbon
  317. Copy to Visible Cells only;Modify Code
  318. Auto Filter - Custom Auto Filter
  319. VBA Code Bug
  320. Code to produce consistent new Workbook name
  321. Intersection of two curves
  322. Copy Visible Cells and paste in another workbook visible cells only
  323. UserForm Control Question
  324. Pivot Restrict Macro Only Works for 1 table
  325. column of a input box selected range
  326. Pass activecell(.address?) as a range in a function parameter?
  327. Inserting a row below a combobox determined cell
  328. Hide Column AD
  329. How to PasteSpecial to a Different Worksheet?
  330. how to pre define what to show on the top of the Combo Box
  331. vba Syntax?
  332. option button
  333. Collapse away VBA lines with deep indentation
  334. Collapse away VBA lines with deep indentation
  335. use macro to select printer profile...
  336. '?' displayed in excel: when I hit enter for a new line in textbox
  337. Where to store VBA code for executing against xls in email?
  338. challenge for the braniacs!!! i need help.
  339. Macros
  340. How import a MS Excel Userform into Mac Excel?
  341. Worksheet_Change vs Worksheet_Calculate
  342. RE: Import Excel data to Access table
  343. merge cells
  344. VLookup to a different workbook
  345. chane what 'x' button on top right of the form does
  346. Private Sub Worksheet_Change code not robust enough
  347. cell selection, merging.....
  348. Query on month and day in code?
  349. [VBA] SUM RANGE OF VALUES
  350. Move data to top of column
  351. Assign Macro to Ribbon Button
  352. Pull date from cell with text also
  353. Corresponding Row Question.
  354. beforesave macro help
  355. calling cells in for-loops
  356. Marco to open the "Customer Auto filter dialog box"
  357. Copying selected rows into new worksheet
  358. Putting a value in cell based on another cell
  359. use border for IF test
  360. Determine address of pagebreak preview
  361. Speed it up?
  362. Reposition Chart Macro
  363. Pausing a macro during execution
  364. [VBA] Sum Range os values
  365. Re: Set cell color with VBA results in "#VALUE!"
  366. RE: Set cell color with VBA results in "#VALUE!"
  367. Log to a file everytime I open a spreadsheet
  368. How to convert and xml to excel ?
  369. Locate a value in a cell and delete rows above
  370. Script to conditionally copy data to another sheet?
  371. Counting Errors
  372. Linking Worksheets
  373. New Sheet Macro
  374. Using a sheet's 'Codename'
  375. Cannot find/see AddIns
  376. Problem with retaining numbers formatted as text after code runs
  377. userform textbox: hit enter to start writing in a new line
  378. How public is public?
  379. How public is public?
  380. Using VBA for Inputting a "-"
  381. Pivot Table macro - strange behaviour
  382. How to select a single word from a cell?
  383. Workbook jumps to Sheet1, cell A1, regardless of where it was whenlast saved
  384. Right click - Normal view/ Page break preview
  385. VBA Code
  386. Display custom function
  387. Getting the date from my left footer
  388. Relative references in formulas
  389. question regarding pasting controls
  390. Recording Data
  391. File handling in excel
  392. Passing single-cell vs multi-cell ranges to a variant array?
  393. Referencing cell content and formatting
  394. using range name VB help
  395. Ron: email a closed workbook? possible?
  396. Protect template worksheet
  397. merge rows based on criteria
  398. display $ sign in excel sheet
  399. Correcting "Circular Action" in Worksheet_Change
  400. Mysterious Happenings
  401. Stop all macros in worksheet when left
  402. Macro Creation
  403. Copy a sheet and all formats to a new sheet
  404. DMS to DD
  405. Need a pause in my macro before printing
  406. Adding Rows after dropdown menu
  407. concatenate not working
  408. SUMIF with sections of data
  409. Temp folder location for ACE/JET ODBC driver for Excel/Access
  410. Changed decimal on fixed numbers
  411. Trying to get DOM of web page
  412. Converting range to variant is easy; how do I handle rows vs colum
  413. Run procedure in stored in module on worksheet change event
  414. Conditional Problem Or What?
  415. Macro to insert row
  416. Run a Word macro from Excel?
  417. Email: email a user back once his request is accepted
  418. Linking Items in the Combo Box or List Boxes
  419. Change number text to Date format?
  420. MsgBox cell address
  421. Need formula dates
  422. Using sheet reference instead of name
  423. AND & COUNTIF in same formula
  424. Excel 2007: Data connection returned empty table
  425. Restore menu & toolbars
  426. Getting objects other than 'Excel.Application using GetObject()
  427. generation of: qty to serial numbers, plus date
  428. How to count number of errors?
  429. Embeded excel's parent
  430. Re: Excel Warning Message on New Sheet Created
  431. Finding and working with rows that have data in only
  432. Closing, Saving question
  433. ExportAsFixedFormat method and print margins
  434. RE: Run time error when accessing Internet using VBA
  435. Macros: Why 'wbook.xls'!MyMacro
  436. Inserting a number of rows based on the number of columns filled bytext values
  437. Easy Peasy Explanation required
  438. VBA Code to Change Currency Format
  439. Limit on Column Selection
  440. Cascading dropdowns
  441. CODE 2 SELECT SHEETS LISTED IN A RANGE
  442. Learning VBA - Resources & Stories
  443. Combining Data from Multiple Closed Files in Folder
  444. Assigned Macro with argument?
  445. Excel Version
  446. Custom images on a button or other control
  447. Textbox to display Listbox 2nd column value
  448. How to find .Name of leftmost worksheet tab
  449. Clearing data from Excel 2003 Form
  450. Issue With Save As
  451. Why does the Formula in VBA not calculate
  452. Copying Worksheets in Different Books to One Workbook
  453. Efficiency of Code Help
  454. Protectin/Unprotecting Sheets
  455. Pressing Esc to make a form disappear
  456. how to: c.value = "a cell value"
  457. Re: macro works at home but not at work
  458. Object programming in Excel
  459. cells that contain data-->unclickable
  460. Sorry for the cross post but this may belong in this section inste
  461. Determine if variable contains a valid range reference?
  462. copying a template sheet and inputting a formula into another sheetthat references the new sheet
  463. Applying formatting to non-continuous named ranges
  464. Spin Box
  465. OnTime unreliability
  466. Finding specific data and changing cells next to the data
  467. vlookup not working
  468. Conditional Tab Colors
  469. restrict users to input atleast five characters
  470. Mid and Find in macro
  471. Conditional Formatting More Than 3 Items
  472. Unreadable Content Errors
  473. selection of cell at the intersection of column B and the row ofwhatever cell is active
  474. Interactive Macro in Excel
  475. IF statement inserting new rows
  476. Pivot Table Page Break Issue
  477. UserForm and It is beyond me.Please help.
  478. Vbscript and VBA
  479. Open Text Method Fails
  480. restrict user to enter 5 digits only
  481. Open Workbooks and Password Protect all Worksheets
  482. Comparing two cells
  483. macro code selecting moving range
  484. Need help searching
  485. type mismatch error
  486. VBA code relative to current date
  487. export excel chart to file error
  488. export excel chart to file trouble
  489. Copy and paste error
  490. Enter formula in a message box
  491. VB6 Expected Array error
  492. Export data from Listbox into text file
  493. FOR-TO_NEXT is *very* slow
  494. Disable the toolbar options button
  495. VBA Help
  496. Create a button that automatically fills out data
  497. Anyone know why this doesn't work ?
  498. Select Worksheet Code
  499. Find
  500. Macro help needed
  501. Copy a spreedsheet
  502. ADDING/DELETING SHEETS WITHOUT LOSING FOCUS.
  503. SELECTED SHEETS' NAMES
  504. Subject: Macro for Address verification/validation
  505. error in code
  506. "Out of Memory" error in editor
  507. Formula
  508. Macro question
  509. auto fit & horizontal alignment not working
  510. Assign a range-name from B2 to {end of data}
  511. Indirect/match formula - array
  512. expand or collapse
  513. Spinner
  514. Use button to add 1 to total
  515. I want to insert "n" records and then copy the formulas to them
  516. Sorting hidden cell
  517. Locking/unlocking cells based on column headers
  518. Using Macros on the Web?
  519. Searching in an excel spreadsheet
  520. Renaming wrong worksheet. Why?
  521. Help in creating formula in a macro
  522. Find text string and move contents to another cell
  523. Activecell select properties
  524. Worksheet arrays in VBA
  525. I'm a newbie and need help searching
  526. Date to Text conversion
  527. Macro not working with XLAM add-in
  528. Remove Hyperlinks
  529. Return Portion of Variable
  530. Update Excel Column Data from SQL Fields
  531. Insert Row based on count and copy range to inserted rows
  532. Multiple Workbooks Using the Same Custom Toolbar
  533. placing calculation based on two sum fields in loop
  534. Shapes.AddShape msoShapeBlockArc...ShapeRange.Adjustments.Item(1)
  535. separar texto de numero
  536. Automatic Crossing Axis Values
  537. UserForm Issues
  538. Opening Internet Explorer Only from VBA
  539. Auto-Populate
  540. excel programming
  541. Open CSV File
  542. Clear "Blank" cells
  543. pick out arguments from formula
  544. Hide cell select border when clicked
  545. Prevent saving of files to P:/ Drive
  546. find last updated row
  547. email issue: need last user input only
  548. Match and Extract Data
  549. Viewing a .doc in excel
  550. Excel freezePanes not on non-active Workshhet
  551. Issue with nested data subtotals
  552. Close w/o saving changes
  553. UserForm Variable
  554. How Do I Change Two Pivot Table Page Selections with VBA Code
  555. save as - to any desktop
  556. macro for deleting a particular string and inserting commas in it
  557. Reference to external program
  558. Looking for an example
  559. Transferring data between worksheets
  560. stuck on the timing refresh....
  561. Apply Conditional formatting if cell contains formula
  562. Last row in a particular sheet / workbook
  563. Hi All - How do i get my vba macro to refresh every minute?
  564. distribution of Excel Addin - errors
  565. [Ask] Triangle Distribution and Latin Hypercube Sampling
  566. Vertical Scroll bar w/ picture background
  567. Run a macro when sheet name changes
  568. Hide Ribbon In XLS Workbook When Using Excel 2007
  569. "Highlite" a "row" that has a "particular date"
  570. create new sheet with zip code as name
  571. Code Not Recognizing Decimal
  572. Changing Path of .JPG file?
  573. email only current entry, not the past data
  574. Hide rows based on cell data
  575. Excel 2007 VBA - macro stops after autofilter command
  576. Show Method/UserForm Object
  577. Postgres
  578. Sum At Top And Move Cells Down in VBA
  579. Advance in a cell range using VBA
  580. combining data from 2 sheet into new sheet based on like values
  581. If Then Conditionality Help
  582. VBA Chart
  583. Macro support for Mac
  584. Multiple names Print_Titles
  585. MDX query in Excel
  586. remove autofilter on close of workbook
  587. Conditional Formatting adding different cell dates
  588. Copying and Pasting Macro from one worksheet to another
  589. chart series macro
  590. Re: Multi Column Combo Box
  591. Remove File import using VBA
  592. Trouble with formatting text in a Function
  593. Passing Arrays Between Worksheet Functions
  594. [C#] Excel Print Dialog
  595. Problem in Using Control Tab to scrol trough several Workbooks
  596. Save Archive Copy as Read Only
  597. Skip / Execute Macro Q
  598. Inconsistent Formula Result
  599. Data Transformations
  600. drop down deletion errors
  601. Code to delete shapes in copied sheets
  602. Lock certain cells from edit- test if select cell name starting wi
  603. FormattingLost
  604. How to find table position on page
  605. Sumproduct in Macro
  606. Re: Looking to Pay Someone for Help with Excel VBA Script
  607. Userform and Macro code
  608. Require Password to overide data validation
  609. Run MS Excel Macro From MS Access
  610. Excel/SQL Automation help
  611. Import File Line by Line
  612. Iterate through the autofiltered rows
  613. Worksheet function - array result, C++
  614. Re: creating last name first, first name last from a column of first name last name data
  615. Convert Full name in Intials
  616. Close help
  617. Re: creating last name first, first name last from a column of first name last name data
  618. Re: creating last name first, first name last from a column of first name last name data
  619. Hyperlink Back w/ locked worksheet
  620. hyperlink to top left 'between' worksheets
  621. using UCase
  622. Adding Variables to a range with quotes
  623. just curious Xlpart xlWhole
  624. charting run time error, Excel 2007 SP2 problem with SeriesCollectionand .Formula property
  625. Recovered file has "File format is not valid" error
  626. recognizing the day of the week
  627. trouble assigning array to variable (variant) runtime error 9 please help (ignore correction, this didn't appear for some reason)
  628. Building a dynamic right-click context menu in excel
  629. Mail sheet template for Excel 2007 and 2010
  630. Correction to previous post re runtime error 9
  631. Runtime error 9 subscript out of range - assigning array to variable
  632. How to find invalid formula references with VBA
  633. how do i get the Genetic Algorithm in Excel Solver?
  634. Stuck at Trying to Extract Data from a Website using JSP
  635. RE: 'Save As' Macro Debug Error
  636. Find macro on columns A,B and C.
  637. Protecting a range or cell in a worksheet Excel 2007
  638. Changing select ranges in VBA
  639. Re: Select all, but one, sheet?
  640. Re: Select all, but one, sheet?
  641. RE: Select all, but one, sheet?
  642. run sub when one cell is changed
  643. run a sub only when one cell changes
  644. return a value from a vba function in another xla
  645. Macro to cause a password to display ooooo's or other symbols
  646. Re: prvent viewing a workbook
  647. Re: prvent viewing a workbook
  648. form follows user's activity on sheet and updates itself
  649. can't find project or library
  650. help with copying of excel spread sheet from template trought VB
  651. Re: Diary Page Printing
  652. Argument list of Dialog box objects show method
  653. How to refer to an ActiveX Control itself in event handler?
  654. Formula/programming in excel for cinema movie scheduling
  655. Insert Row Event
  656. Counting TextBox values
  657. selectin the whole column beside the target cell
  658. Question about input boxes
  659. Colo's Junk Room
  660. I need to get tthe sum of cells with certain colors in a range.
  661. Private Sub
  662. RE: creating variables
  663. Re: creating variables
  664. Compile Error "Invalid Outside Procedure"
  665. UserForm Hangs
  666. Command Button
  667. Current Document Name From Ribbon Control
  668. Drop down errors
  669. Unload a Form using SelectionChange
  670. Re: Run portion of loop when value in column changes.
  671. Which workbook caused calculation
  672. Still not flying
  673. Saving the revised date for any workbook.
  674. Save Excel 2003 in Excel 2007
  675. Constants
  676. worksheet change event running slow
  677. Function in Excel
  678. Form Control vs. Active X Controls
  679. REPLACE HELP
  680. Save specific sheets to new workbooks adding tomorrow's date to na
  681. help on comparing datasheet with a master sheet
  682. Customizing row color
  683. Sort error?
  684. synchronising data in 2 excel files
  685. Can I pass arguments to my formatted empty spreadsheet file?
  686. Macro for using solver function using visual basic
  687. Paste formula in numerous worksheets
  688. Creating Pivot through VBA
  689. Split data into multiple worksheets by row count
  690. hi guys (thanks for loop help) part 2: cumulative summing/counting
  691. hey guys, thanks for all the help with the loop problem...part deu
  692. combobox rowsource = named range ??
  693. ActiveWorkbook.Save - adds quotation marks to the file content
  694. IXMLDocument
  695. Create a Macro that help paste the lot#
  696. Object Library invalid or contains references to object defintions
  697. Create Workbooks and Copy Template Worksheet to those Workbooks
  698. Excel 2003 - SOAP
  699. Excel 2007 : Excel is crasing if hyperlink is click on the workboo
  700. Dialogue box ghosting
  701. Impossible? - Close code
  702. UserForm ComboBox Date Format
  703. temporarily disabling subroutines
  704. Help with Access query from Excel
  705. Stop a find after the last occrance of the search value.
  706. workbook open in looping
  707. Validation
  708. deleting cells that are controlled by target code
  709. Obtaining AutoFilter Filter Settings Automatically
  710. the hard way
  711. copy sheets & name them from list
  712. RE: Welcome message change by time of day
  713. Re: Welcome message change by time of day
  714. Recording a Macro-can I stop the Active window info from recording
  715. Auto Fill Columns A and B with varying ranges
  716. How to make a variable equal to a value that includes quotes
  717. loop through txtboxes in userform then fill array with the text
  718. Access to sharepoint via VBA?
  719. Clear cells in a column that contain 0
  720. associative arrays
  721. replace missing values
  722. Check Date, Include dates from rest of month and all of next month
  723. Parsing Variable string
  724. Increment Number by on unsorted list
  725. Create new workbook and new worksheet and close. Worksheet not saved
  726. Multiple entries from a drop down list
  727. Excel 2000 - Round to nearest month
  728. How do I save a password protected .xlsm file containing old macro
  729. "Subscript out of range" -- using variable as new name of workshee
  730. keep getting the error message - Compile error: Else without If
  731. Macro Pulling set of information
  732. piece of code keeps failing....
  733. Macro to count down and select specific number of rows
  734. Query run automatic update
  735. Time close and save
  736. Paste Special Macro
  737. Updating An Excel Sheet From Sheets In The Same Workbook
  738. copy updated table values to a "summary" worksheet
  739. Customized Tool bar
  740. Assigning a button to a subroutine
  741. Msgbox Based on Cell Content ???
  742. referencing multiple controls using a variable
  743. WorkSheet.PageSetup.CHartSize Property
  744. print to a text printer
  745. Shift a cut row up
  746. How do I insert the name of a named range in a footer in Excel?
  747. Press space bar or click on mouse button to insert a check mark in acell
  748. How do you delete overlapping shapes
  749. Validation of input against the active directory
  750. New to Macros