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. Validation of input against the active directory
  2. New to Macros
  3. Create Workbooks and then create Worksheets within them
  4. How do I find the errors causing Excel to Auto Recover my file?
  5. Validation criteria
  6. round to nearest 30-minute interval
  7. Quick Macro Needed
  8. Msgbox when a cell with a specific text entry is selected.
  9. Possible Macro Solution To My Problem
  10. General Thanks
  11. Is it possible to use a macro to type numbers to another applicati
  12. cycle through hyperlinks in column b
  13. Array speed
  14. find row address of target cell
  15. Simulating tab stops in Excel cells
  16. RE: I can't figure out why these lines don't work
  17. Worksheet Number Max
  18. Issue building pivot tables with certain names
  19. Re: I can't figure out why these lines don't work
  20. Problem with Chnaging fonts to Strikethrough
  21. counting values as they turn up in a column
  22. printout as jpg format
  23. printout as jpg format
  24. Look up values in a range, then summing from another column
  25. Copy changing group of cells from Sheet1 to Sheet2
  26. Formula Help
  27. Long Macro
  28. Interactive web browser object embedded in an Excel print
  29. How to set chart series border property with variables read from cellvalues?
  30. How can I detect change to Autofilter selection
  31. Turn off Security Alert dailog box for office 2007
  32. fresh start/better explanation....totally stuck on loop code.pls h
  33. delete a shape
  34. Re: Extracting account details
  35. VB, Vlookup worksheet function and copying data
  36. SaveCopyAs and FileType
  37. Count down display
  38. Convert Date to End of Month
  39. End a procedure form a UserForm
  40. End a procedure from a UserForm
  41. Toggling display
  42. Re: Extracting account details
  43. Re: Extracting account details
  44. Image Control
  45. Conditional Formatting with reference to another worksheet VBA
  46. IE Document Object
  47. How to return special values from function? (Excel 2007 + VS 2008)
  48. Collapsing groups in Macro
  49. Autofilter on a combo box
  50. Changin Number in cell on click of button
  51. Totally stuck trying to format,loop etc...re-post.please help
  52. Totally stuck trying to format,loop etc...please help a novice!tha
  53. Workbook doesn't fully close - sorta
  54. Count number of appearance in a cell
  55. helllp!
  56. Is it possible to Protect all Cells that are, say, Colored Gray?
  57. when I create a chart for the first time,
  58. To be able to show only certain sections of worksheet
  59. Paste special VB code.
  60. Autofilter method of range class failed
  61. Move line as Worksheet change not working correctly
  62. Is column below title row blank
  63. Digitally Signed Macros in Personal.XLS
  64. Retrieving Key value from dropdown
  65. Open Referenced Add-In Worked as Read Only
  66. Merge Cells Complexity
  67. Using a macro to delete cells from any row
  68. Error - Replace command within access acting on excel file
  69. Date as filename
  70. Deleting Shapes
  71. Hide/Unhide Multiple Sheets
  72. Code OK in XL2003 but Run-time error '1004' in xl2007
  73. Referencing Inactive Workbook Cells
  74. Picture Load in Image Control
  75. Reset AutoFilter in code
  76. Adding quotation marks to each line of cell contents with carriagereturns
  77. Similar Function in VBA - does it exist ?
  78. Clearing IE cache and cookies through VBA?
  79. formatting ms access to ms excel report
  80. Re: Extract only part of a string
  81. paste special code
  82. HELP... Pivot table sorting
  83. Setting page layout and print set up in code for a new worksheet
  84. using vb to change row height for a whole worksheet
  85. RE: Proper syntax for selecting a range using cells instead of range
  86. Re: Proper syntax for selecting a range using cells instead of range
  87. Export to CSV values
  88. Looping(Rookies)
  89. Calculation based on 2 seperate ranges
  90. display special characters in some textbox fields to ensure data f
  91. Another Vlookup for VBA question
  92. If ElseIf statement can not adapt to new data?
  93. Button points to wrong macro
  94. RE: run multiple macros from drop down list
  95. unprotected cells
  96. Change the Mouse Pointer on a Excel Worksheet
  97. copy past two existing sheets into 30 workbooks
  98. Error 1004 SaveAs Object workbook failed
  99. Set value of checkbox on userform without triggering Click event
  100. How record each refresh?
  101. How record each refresh?
  102. Conditional formatting Cell Value Attribution
  103. Copy a worksheet that can be attached to a web-based internet system
  104. excel working with desktop application
  105. Syncronize Autofilters on Multiple Tabs
  106. MSAccess output to Excel losing formatting of number
  107. Loopng through specific worksheets
  108. Insert macro using current workbook
  109. Textbox mask for textboxes in my Userform (Excel 2007)
  110. Which Excel references used for Workday Formula in MS Excel 2003?
  111. Programming a column so the it displays the lesser of two values
  112. Searching multiple fields and then print the entire row from resul
  113. Reference Library Upgrading
  114. Activate / deactivate a link based on the value of a cell
  115. Setup
  116. Workbook_open not running and Phantom Projects
  117. Create new workbook and new worksheet and close. Worksheet not sav
  118. Hyperlink cell change color upon activation?
  119. Fast intro to dictionary object in VBA/Excel
  120. Automate data from Web to Excel.
  121. Exporting data to excel file with code
  122. Hooking into Refresh/RefreshAll events from listobject
  123. Select a Sheet Issue in VBA on a very hidden sheet - fails
  124. If statement(rookies)
  125. Excel automation from a Windows service
  126. Forms and WorkSheets
  127. Change InputBox Range Selection to Column Letter Selection
  128. Unable to specify position of InputBox Method Dialog Box on the sc
  129. Identify offending cell
  130. Dynamic filtering into a new range
  131. Macro to add sheets works sporadically
  132. Working down a column
  133. Loop works for x = 1 but not for x = 2 : gets Type Mismatch error
  134. Export a module to .bas file -> No Password
  135. Adding a -L at the end of each number within a column
  136. my VBA procedures stopped calling other procedures in excel 2007.
  137. Using Worksheet Objects from PERSONAL.xls
  138. Incorrect Function error
  139. Sub runs, but gives error when called.
  140. Identify row based on criteria and copy paste special values only
  141. Help with Office Assistant VBA
  142. Open Excel file
  143. formulas not auto calculating and will not calculate
  144. How to Load Combo Box with Named Range
  145. combobox problem
  146. .DisplayFormulaBar = True doesn't display formula bar...
  147. Text & Colour Hi-lite of "blank" cell
  148. Transfer data between two worksheets
  149. Need to Speed Up A Macro
  150. How can I stop my workbook being attached to an email?
  151. Extract only part of a string
  152. ReSizing InputBox Parameters
  153. exclude hidden worksheets while merging.
  154. Sheet Deactivate Loop
  155. for next coding wants me to define variable...
  156. Question
  157. http link
  158. Custom color in Excel 2007?
  159. Find variable with the highest value
  160. Excel doc saved as an HTML file - can't unhide worksheet
  161. Compare 2 ranges
  162. Match Values and Copy Rows
  163. Workload spreadsheet - pivot tables
  164. Help with sorting lists of data.
  165. Minimising VBA Code
  166. modify macro to execute based on current path
  167. How to save/move a personal workbook
  168. userform question
  169. Display of gridlines
  170. RE: Get External Data returns error message
  171. Draw on image object on useform
  172. Creating Email using Windows XP, Office 2007, Outlook 2007 "worksh
  173. Copy an Access recordset starting with Column 2
  174. Can You Reset a shape's Left & Top position
  175. extraneous data in macro recorder
  176. Network Computer Offline
  177. Help organizing large program
  178. Network Computer Offline
  179. .find not finding value
  180. FUNCTION TO COPY STRING ARRAY !!
  181. Run Macro when a cell within a range changes
  182. Multiple line controltiptext
  183. Write select columns to array & back to another spreadsheet
  184. Launch msn messenger box by clicking on a name in excel? Help! Urg
  185. Automatically Deleting Comments In VBA
  186. Calcuate 2 days prior to TODAY
  187. Locking An IE Window As Active
  188. Info Message without a response needed
  189. Problem changing numbers in a string
  190. Open Excel file stored on Web
  191. colour coding alternate weeks
  192. Re training expiry date formula required
  193. 2nd highest value.
  194. Macro creation via VBA
  195. Listbox Validation
  196. Mouse double-click to select listbox item and run userform
  197. BOOLEAN VBA FUNCTION !!!
  198. Excel 2007 MS Common Controls
  199. Macro to copy existing sheet to end
  200. Macro To Automatically Save As
  201. Pasting a date to a cell from UserForm
  202. Randomly choose x numbers from y data block
  203. VBA MsgBox close button has changed...
  204. Using relative references in macro
  205. Copy & paste range
  206. Programmatically press CommandButton
  207. Trap ctrl+Break
  208. Return to starting point
  209. Using Filter List to set Chart Symbol, data labels etc
  210. SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003
  211. #NAME error on all VBA module code
  212. You may not use references to other worksheets or workbooks forConditional Formatting criteria.
  213. training Out of date formula required
  214. How to Learn Macros
  215. Re: Parse Duplicates by Latest Date?
  216. RE: input box for a date -- how to make an enter key the current date
  217. Label Control
  218. Re: Parse Duplicates by Latest Date?
  219. Second Find after a first find fails
  220. Missing:ATPVBAEN.XLA
  221. RE: Parse Duplicates by Latest Date?
  222. Sever side excel automation issue
  223. Last line selected in ComboBox
  224. SearchDate
  225. Re: remove autofilter results with a macro
  226. remove autofilter results with a macro
  227. Macro/calculations/for loops/ dropdown lists/ and fun.
  228. Determine if all items or elements are equal
  229. Sumif
  230. Excel to Open, Fill, and "package" .doc word forms
  231. Switching to Manual Calculation stalls workbook
  232. Check Validation List for Matching Entries at Start-up
  233. How do I get an Excel macro to run completely using the keyboard?
  234. Adding rows
  235. Reading data from CSV file
  236. Merge Cells Logic
  237. Disable 'Select Multiple Items' and '(All)' in PivotTable ReportFilter
  238. Populate Excel 2003 Spreadsheet with XML Data
  239. Macro Shortcut Key
  240. Working with AutoShapes - Adding Text Vs Adding Formulas
  241. Checking a listbox
  242. Excel Range name case sensitivity in VBA code
  243. merge worksheets macro
  244. Macro Paste Problem
  245. Turn Off automatic parsing of data in Excel
  246. Fill cell based on cell value
  247. bug in sort routines
  248. display $ in a userform textbox
  249. Generalize sub to work on all open books and views
  250. Date Formula
  251. Inserting results below and not above
  252. Another FileSearch Question Please Read
  253. Excel 2003 Autofilter Alphasort, Hyperlinks and Validation Drop dn
  254. Simple Loop
  255. Create Object MS MapPoint
  256. how can i select the data from 6th row 7th column using VBA
  257. Add Sum to the columns at the last row
  258. Can I have a macro that will delete an email in an Outlook public folder?
  259. TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?
  260. Re: last name first, first name last -- is there a code to combine 2 cells with last and first names?
  261. How to set the text in a textbox in a chart object with VBA?
  262. sorting list to a new place`
  263. How add a value help parameter to User Defined Funtion
  264. List active onkey assignments?
  265. Removing words from a string?
  266. excel 2007 convert one sheet into multiples sheets (for excel 2003Compatibility)
  267. RE: last name first, first name last -- is there a code to combine 2 c
  268. Problem with Range Find in C++
  269. Autofilter with optional criteria
  270. Filesearch error in Excel
  271. Columns other than one selected by macro being erroneously selecte
  272. shell function + wait parameter
  273. how to change For i - to refer to specific columns instead of rows
  274. Copy Range from Open Workbook to Active Workbook
  275. Point to "Contacts" in email 2007
  276. ComboBox Problem with ListIndex
  277. Find value in hiden row
  278. Bring data from header fields to the columns
  279. Concatenating Formulas
  280. Help with Macro in Excel 2003
  281. Convert from ColumnNumber to Range(" ")
  282. Circular ref
  283. Counting Occurrences
  284. Why is Excel 2007 macro creating extra blank rows?
  285. Trying to make a form for SEO.
  286. Re: Delete & Merge Columns,Delete Rows with filter, etc
  287. Re: Automation to calculate the SLA date?
  288. Accelerator Property
  289. Need help with formulas
  290. Formula Syntax Problem
  291. Check if Workbook fully loaded...
  292. Not a programmer...am I in over my head??
  293. Start copying an access recordset starting with the next column
  294. populating a workbook but not opening it
  295. using variable in
  296. SUMPRODUCT IN VBA
  297. File Lister- (Code help) Pull File Name without Extension into Col
  298. Using Vlookup, hyperlinks do not work
  299. Excel to Word help needed
  300. Excel 2007 vs Excel 2003 = Runtime Error 438
  301. not able to enable macro in password protected .xlsm workbook.
  302. Programmaticlly sign and password protect a VBA Project in Excel 2
  303. Populate Excel from Word
  304. text wrapping in coding lines
  305. Code to automatically fill cells
  306. Make a formula work with a checkbox
  307. Budgets
  308. deleting source code without IDE
  309. The long way round seems faster...
  310. Early variable type issue
  311. Prompt the start of an email...user fills in email address
  312. Application On Time
  313. Macro that uses three hidden sheets
  314. Tell what format each cell is in
  315. how to view filter in html file generated from excel?
  316. Bring fields from header to columns
  317. Macro Problems in excel 2007
  318. Re: Excel Combo box & Autonumbering
  319. collapse an expand rows using VB
  320. VSTO-Detecting Read Only status of workbook opened from Sharepoint
  321. Have macro force user to selecat a value
  322. Delete duplicates and add worksheet name
  323. Preventing workbook_open code executing.
  324. XL 2003: How do I get every possible combination?
  325. How to take a current Excel file and make it into a program
  326. Placing values into summary sheet
  327. Refrencing Excel cells on a Excel file on a NAS with VBA
  328. Cannot initialize Microsoft@ SQL analysis services
  329. HELP!!! Excel with C++
  330. VBA Offset (trying to resize an element within nested array)
  331. Close External Apps Issue
  332. Text case question
  333. returning data of type range; error 91
  334. Textbox reference
  335. Textbox reference
  336. Textbox reference
  337. Type Mismatch Error 13
  338. Stumped
  339. Preventing a graphic image from being deleted or added
  340. Ambiguous name detected - help how fix?
  341. Referencing columns in formula
  342. Reference to ATPVBAEN.XLS
  343. Counting and Comparing
  344. using .copy to copy a worksheet several times
  345. one or two monitors
  346. protect a sheet such that it cannot be deleted
  347. VBA Regex syntax problems (XL2003)
  348. Trouble opening a spreadsheet
  349. Extract/process Excel files in outlook.pst file?
  350. Essbase Add-in VBA programming question
  351. HELP WITH THIS FORMULA
  352. Separate report on tabs based on Sales Rep Info
  353. Date criteria for adv. filter in code
  354. finding line number selected in combo box
  355. save user inputs from userform in a seperate workbook
  356. Store input from userform in a password protected sheet
  357. Get data from closed workbook for use in a variable (no copying)
  358. find where a number belongs in a series of numbers
  359. Can't change connection property on querytable
  360. Code for avoiding slashes, ampersands, etc. when naming sheets
  361. SAVE AS HELP
  362. Print Preview
  363. how do I copy streaming data values into excel
  364. Rotate Fill Effect With Shape in VBA
  365. Reversing from a Hyper link
  366. Range named Add_Info_** issue
  367. Help with lockiing/unlocking cells in subroutine
  368. Sorting Problem
  369. Conditional formatting using relative refrencing
  370. Disable the PauseBreak key
  371. Macro for Print Area
  372. Counting When Last Occurance
  373. Invalid qualifier with dates
  374. clear ranges
  375. RE: combine lines, cumulate value
  376. ...more repetitive copying
  377. Find and Replace text with formatting
  378. Exporting weekly data from different sheets to a word document
  379. Help with condensing a lot of copying/pasting...
  380. subalterne sub in parallel
  381. Drop down menus
  382. Excel 2007
  383. Pivot table in VB
  384. Delete records from result-cell after a find-function call
  385. Google AJAX API from Excel?
  386. [VBA] Get the content of each value of a line
  387. Align text in a text box
  388. Access to Excel-pivot, changing location of Access
  389. Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart
  390. Looking for better way than .formula = "countif....."
  391. Allow changes to Shared workbook
  392. why does Average only on certain cells?
  393. Too long to save an Excel file
  394. Display Current date
  395. Minimize the ribbon in Excel 2007 using code
  396. Re: Macro to set column widths in a worksheet
  397. Re: Macro to set column widths in a worksheet
  398. dynamic radar chart
  399. "T" function broken?
  400. Subscripts and superscripts
  401. copying down a formula only where there is data
  402. How do I modify an existing template in excel 2007
  403. Excel Run-time Environment
  404. Macro to Copy hidden worksheet to new worksheet
  405. Referencing specific cells in an array of ranges
  406. How can I enable a macro to run in a hidden worksheet?
  407. How to make an excel macro go to a cell a choose value from list?
  408. TextBoxes and Data Filtering
  409. Auto-size the UserForm with Monitor Configuration
  410. vlookup macro in excel
  411. Macro's, Buttons, and 2 Instances
  412. sum of cells that may contain #n/a
  413. Done with Code1 Find Code2
  414. Date Picker Control
  415. Entering a long formumla in Validation criteria
  416. Custom Validation formula for business rules
  417. Returning a range from application.inputbox
  418. Find duplicates or missing numbers
  419. VBA Code Locked for Viewing
  420. Using VBA to send out mail via gmail
  421. Programming the treeview control
  422. Date Picker on Multipage
  423. VBA currency or percent format object
  424. Code to copy and paste based on today's date
  425. Pivot Table Page Fields ~ Filtering for multiple values
  426. attendance sheet
  427. if, then, replace text
  428. Error 438 on With statement
  429. Error on Discard of Checkout
  430. RE: Trying to write a macro that will copy a formula - TIA
  431. Re: Trying to write a macro that will copy a formula - TIA
  432. Data Seperation w/ multiple sheets
  433. Not saving as xls file
  434. Is there a way to copy a bunch of cells to another workbook, But also bring over the named ranges?
  435. How to rotating a Label control in VB 6.0 to, say 90 or -90 degrees
  436. number not recognised
  437. Open a workbook using a stored name
  438. QAT buttons on template
  439. onmouseover
  440. Exract individual page ranges from sheet
  441. Problem with filename =Heute()
  442. VSTO: Detecting Read Only status of workbook opened from Sharepoin
  443. AutoFilter Criteria in VBA
  444. Re: Macro to convert abbreviations to its expansions?
  445. Trading File
  446. Extra E-Mail in a Column Q
  447. Check number and return code value
  448. Excel VBA Matrix Operations
  449. increase Range by 1 row, until all rows with data have been execut
  450. vba create text format cells in excel 2003
  451. Drop down menus in excel
  452. Prevent event macro from executing on ALT-Enter
  453. Speeding up this code- when a custom function is used many times
  454. Determining Max value in a dynamic range
  455. Excel 2007 recalculating custom function when scrollbar is moved?
  456. HELP- Need TSV extension for Excel
  457. show selective data - help in code
  458. Range("Defined Name").Sort
  459. customize email title
  460. so close but not quite there on an insert rows and copy paste spec
  461. Emailing excel sheet: Help Ron De Bruin
  462. Unable to paste to worksheet
  463. VBA - Calendar with more than 1 textbox
  464. If Cell in Column C is Blank, Make Adjacent Cell in Column B Blank
  465. Essbase Retrieve
  466. Excel VBA to acess currently open web page (existing IE6 instance)
  467. Someone help me!
  468. Is there an Excel Function that can be used in lieu of this formul
  469. Pivot Table Code - Is there a better way?
  470. Filtering info to corresponding sheet
  471. Re-format Date
  472. transpose variable array
  473. One connection multiple unique SQL's
  474. Screen scrolling to show active cell
  475. VBA to lock column values
  476. FreezePanes not working when chart present
  477. Validate same month and same year
  478. VLOOKUP
  479. Problem with reference to Refedit control
  480. Setting Curline to 0 on a text box fails (Excel 2007)
  481. File name
  482. creating folders one level down
  483. Strange behavior with Macro - Import from Access
  484. sub or function argument
  485. Send data to another workbook
  486. Cell Fill
  487. VBA - Monthview working with textboxes
  488. Change workbook name to a generic name
  489. Return to todays date macro
  490. Size of 'find and replace' window
  491. Compare two Ecxel Sheet
  492. Code to copy the last row formulas and paste it in the bottom row
  493. Prevent UserForm from displaying
  494. Emailing out of Excel
  495. End(xlDown)
  496. User Name
  497. accept and decline buttons in excel sheet emailed to me as attachm
  498. accept and decline buttons in excel sheet emailed to me as attachm
  499. Open IP address device with multi ports, read only
  500. Re: How to convert number format to date format?
  501. convert hyperlinks to commandbuttons via VBA
  502. How to count number of rows with data?
  503. Include cell text in web hyperlink?
  504. Copy and paste only filtered cells
  505. Problem displaying a UserForm
  506. Re: Want to calculate the appointment date and deappointment date?
  507. Re: Want to calculate the appointment date and deappointment date?
  508. Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved
  509. Executing Part Of Macro Only On Cells Meeting A Condition
  510. detect the filter mode ?
  511. array udf
  512. Since we moved from Windows XP to vista Excel opens minimized !
  513. Copy ranges in sets of 30 rows into separate worksheet tabs inworkbook
  514. Timer Procedures
  515. Paste TextBox value to worksheet with specific format
  516. projects left open in vba after closing workbook
  517. Re: Find value of cell in other sheets
  518. Debugging: how to see entire string var value?
  519. Re: Resourcing Multiple Pivot Tables
  520. How to get list of subfolders, including shortcuts to folders?
  521. Re: How to convert number format to date format?
  522. Re: How to convert number format to date format?
  523. Re: Solution needed
  524. Re: How to use the code?
  525. Re: How to use the code?
  526. Transfer AutoFiler list to a ComboBox
  527. Count With Criteria
  528. Delete single conditional format
  529. Re: Automation to add 99 before any 10 digits?
  530. Re: Automation to add 99 before any 10 digits?
  531. Change PDF Properties via Excel Code
  532. ComboBox Rowsource question
  533. Setting Up a "Reply-To" Email Address In MAPI
  534. Save Sheets In Different Files
  535. Transferring data between worksheets?
  536. Simple macro, even simpler programmer!
  537. Edit Locked Cells with UserForm only
  538. Delete row by color of font
  539. Help with mess of code
  540. Select next blank cell in column, before running macro
  541. Activate Find Results
  542. Clearing trext box values
  543. Instead of a long Case?
  544. Add check mark to cell upon selection
  545. Summary Tab for Workbook
  546. modifying merge all workbooks..
  547. BeforeSave
  548. Creating popup messages for User Defines Functions
  549. Formula to calculate what percentage
  550. Delete temp files
  551. List Applications That Are Running
  552. Download CSV from webpage
  553. Test If Add-In Workbook is being Referenced
  554. VBA to delete column values and formats NOT formulas
  555. Should VBA Developers be worried?
  556. Data Validation Formula
  557. Quarterly date format issues
  558. Range question
  559. set font color depending on value Range
  560. Sharing Excel Work Sheet
  561. Xl2007 not unprotecting worksheet!!!!
  562. Matching Debits and Credits in same column
  563. Error 1004 very puzzling indeeed
  564. Clearing an Active X text box with a macro
  565. Combine contents of a column
  566. Disable Preview Button in Print Dialog Box
  567. Excel to Word report problem
  568. File Save As macro for users with different paths
  569. 1004 Run-Time Error
  570. RE: Macro to enter a value, tab to next cell in the row, enter ...
  571. Macro to enter a value, tab to next cell in the row, enter ...
  572. PivotTable ShowDetail not into ActiveWorkbook
  573. Date & Time Picker Control 6.0 - another challenge (for me)
  574. Flexible autofill in macro
  575. Script entry to add a new worksheet
  576. Transposing hundreds of addresses in a column using VBA
  577. RE: BeforeSave Event
  578. BeforeSave Event
  579. Looping Sort
  580. Building Menus with Macros upon opening Excel
  581. Test for Error in cells
  582. RE: Worksheet Change in Excel 97 does not run first time
  583. Comparing Conditional Formatting in VBA
  584. Worksheet Change in Excel 97 does not run first time
  585. WorksheetFunction.Match
  586. Re: Overlapping Sequence Number Range
  587. User Form - Finding the value in an Array
  588. C.Value #N/A
  589. How can i read a specific coloumn values and get its contents?
  590. About the Macros in Excel 2007
  591. Populate combo box with a range
  592. E-mail a worksheet via internet e-mail such as hotmail or yahoo?
  593. Pivot Table - Source Data Information
  594. trouble setting colors
  595. date fields in excel user form
  596. Excel Do...Loop
  597. Provide ability to resize form when open
  598. Save Form Position on Close
  599. Generate web address string from date range in column?
  600. strange
  601. Tooltip and ActiveX control
  602. Combo Box and Multiple row / column display
  603. Alert messages
  604. Adjust userforms to fit in screen
  605. Expose formulas
  606. Comparing 4 columns on Two different worksheets.
  607. Deleting a PivotTable.
  608. Set Boolean Variable for Changing Any Control on Userform
  609. Pasting Pivot data
  610. Changing Value using vba
  611. VBA to delete columns
  612. Page break code
  613. insert picture
  614. Sharepoint
  615. File save as produces corrupt file
  616. Sub ShowAll_Records()
  617. auto changes in chart
  618. Filter, Cell Reference formula and copy formula on filter data
  619. Excel 03 to Excel 07
  620. trim, chr(10)
  621. Format cell depending upon type of data pulled
  622. strange behaviour for the multi-threaded calculation in Excel 2007
  623. Custom Macro for pulling information into one sheet
  624. Modify Insert Object Macro
  625. function to make plot data section of charts auto-resize?
  626. Excel Hyperlinks not retained when importing from workbook.
  627. Comparing Conditional Formatting in VBA
  628. How to remove dashes in Social Security number
  629. Context sensitive menu options
  630. culture mismatch with Button name and get_Caller
  631. Data type not defined
  632. After e-mail, unhide sheet
  633. check if a string contains a particular character
  634. Syntax to Run Macro in ActiveWorkbook
  635. ms excel template memory increase
  636. Command Button Gets bigger in size.
  637. File count excluding those which are hidden
  638. Unprotect workbook and merge
  639. Fonts
  640. Triger macro on and of a file on diff. machine
  641. ExecuteExcel4Macro in GetValue not working
  642. Find in Recorded Macro
  643. Sub to copy n paste special discontiguous ranges from 1 sht to ano
  644. error : can't find object or library
  645. Changing Option Buttons status
  646. E-mail a worksheet, then auto open another and do the same by valueof a cell
  647. Resize range of non-contiguous cells
  648. Macro to select columns and replace data
  649. Macro to select columns and replace data
  650. Find Cell When Interior.ColorIndex =3
  651. formulaArray limit of 255 chars - what workarounds exist?
  652. Expand a range by rows and columns
  653. Edit Macro script
  654. syntax in VBA to create a pivot table
  655. VBA Save
  656. User input from excel form not populating Access Database
  657. Re: WriteResPassword
  658. Refreshing Web Query & Saving
  659. Autofit/wraptext on vbLf problem
  660. Pasted text will not spell check
  661. VBA for Month and Quarters Output
  662. First save to save as
  663. Using Excel to call Oracle Stored procedure.
  664. How do I set the source data to make this graph?
  665. XYScatterPlot - Setting colors of lines and datapoints (C#)
  666. cell formula in string variable doesnt work
  667. Checking if a cell has a range name
  668. Data Not populating in Access database from excel form
  669. Hide Cols ??
  670. Application.Match - Is it possible to use named ranges?
  671. Re: Option Button in User Form
  672. chart name not saved when save as another file
  673. Displaying a linked Image in a spreadsheet
  674. Sorting columns on weekdays
  675. Sheets won't move
  676. finding a minimum
  677. Difficult Macro
  678. Resizing the Go To Navigation Pane Larger
  679. Active X text box using Excel 2003
  680. Automation error for proecssing few xla files
  681. RE: Getting count of entries in a column
  682. Getting count of entries in a column
  683. Automating complex workbook
  684. Spell checking a TextBox
  685. Sending range via excel macro
  686. Excel 2007 and macros/functions
  687. Slow Macro "CheckSum()"
  688. How to avoid selecting an object?
  689. Check Postcode and suburb
  690. ARRAY SEARCH PROBLEM !!!
  691. Loop through sheets and create a small PivotTable on each
  692. excel form populating in access 2002-03 but not 2007
  693. msAccess Report Header export to Excel
  694. Form question
  695. Command Button Ctrl+Alt+Shift_F9
  696. How do you get Excel to refresh data on Worksheet from within VBA?
  697. Macro Trouble with Numbering Sequence
  698. Count to Table Format
  699. Add/Update data stored in another worksheet
  700. create new worksheet"ERROR"
  701. Change color of points of scatter plot
  702. HyperLink _ to show detail?
  703. Combining Formulas
  704. Excel macro programming question
  705. DatePicker control lost in Excel 2007
  706. SPREAD SHEET FORMULA
  707. Syntax for AutoCad File Type *.dwg
  708. Move active cell through current selection
  709. querytables.add..Invalid argument for URL connection type
  710. Add Macro Hot Key
  711. ERROR 424" OBJECT REQUIRED
  712. Import Data, using a command line switch
  713. connect excel user form to access database
  714. Print problems w/ charts excel 2003/2007
  715. Secure Data sheet from users
  716. Code to get ActiveCell to start a Subroutine
  717. confirmation window once user clicks submit on user from
  718. Export data from excel into an existing word document
  719. Is this possible in Excel (User Form)
  720. Trying to get info and control a "child" web page
  721. Untick a Checkbox on a userform
  722. Monitoring progress of Excel/VBA routines with a long runtime
  723. Object Library feature not supported
  724. Add Total to End of columns
  725. Run-Time Error "9". Subscript out of range
  726. Need VBA Code to check if MSOutlook is open
  727. Simple Answer ?
  728. A macro (or other) that limits the number of computers a file can beviewed on?
  729. macro to delete all labels
  730. Add data at top of text file
  731. Conditional formatting using text
  732. saving a file using a cell for file name
  733. automation of formatting
  734. hide rows on different sheets
  735. Hyperlink
  736. how to cast in a select
  737. Autoupdate data in a report
  738. Split worksheet into multiple worksheets
  739. page select in multipage web site
  740. Save clipboard images to file
  741. Repetitive block of statements
  742. Problem with Font
  743. Moving Focus On Web Forms
  744. Complicated search and complete analysis on results
  745. Environmental Variables
  746. How remove invalid references in Tools>References drop down box?
  747. Help with macro - deja vu
  748. Another Try - Calculate from ActiveCell
  749. Named Ranges in various sheets
  750. data validation in excel user form