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. Insert columns and values programmatically with IF statement
  2. Insert page break
  3. How can I Lock a Link?
  4. Error handling
  5. Wait till pivot finishes refreshing
  6. VBA Example of Using WHILE and LOOP?
  7. macro to copy columns from one sheet to another sheet
  8. Newbie help needed please...
  9. Odd Export as PDF problem - Killing me.
  10. C drive size
  11. Copy Multiple Areas from One Workbook to Another
  12. Delete characters from behind if too many
  13. Ignoring a blank cell while running a macro.
  14. Re: UserForm doesn't show?
  15. VBA Compare part of cell to another cell and then calculate
  16. Determining if a query is refreshing
  17. List all sheets in the work book and select by double click
  18. Error '1004'
  19. Pivot tables not refreshing after data source update
  20. Check a Check Box with VB
  21. How to print multiple sections from different worksheets
  22. Mixed-font string both to cells and word document
  23. Syntax in worksheet functions for individual values instead of ranges
  24. Working out of Statistics on Exam Results URGENT solution needed!
  25. VBA API for Outlook and Email managment
  26. Replacing the formula text's substring
  27. Lookup Formula Problem
  28. Compile Error:Invalid use of property
  29. Loop to hide sheet based on cell
  30. URGENT help needed for a macro to place and size command button
  31. Hiding Columns produces error <----HELP PLEASE
  32. Macro to select, set, and print
  33. HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns
  34. Macro to upload file to http://
  35. 4 out of 35 data connections running high cpu/memory
  36. Syntax question using :=
  37. Paste to next free column
  38. How to set range to autofiltered visible cells?
  39. Embed information in Worksheet for error checking
  40. loop to copy paste
  41. Pivot Table Refreshing
  42. Looking for all the opinions about Self Certification for macro's
  43. Vlookup error
  44. Find and delete error value
  45. Countdown 1 every workday
  46. Cycling through collection
  47. Out of resources error message - when not...
  48. Deleting backslashs and everything after
  49. VBA SaveAs function generates blank CSV file
  50. Days between 2 dates excluding Sundays only
  51. Put Name's Refer's to: field in cell
  52. Open a GroupWise .NAB File
  53. Sending mail from Excel with CDO by Ron de Bruin
  54. Sending mail from Excel with CDO by Ron de Bruin
  55. Declaring a local variable once for all subs
  56. Not able select list value in HTML
  57. Kind of MAPIfolder
  58. Variable Data Type
  59. Worksheet_Change - compare columns
  60. Vlookup error
  61. Re: Option Question
  62. switching workbooks using variable and wilcard filename
  63. Pivot Table Refreshing
  64. FInding Data Connection Name
  65. Programmatically setting pivot sourcedata
  66. Delete rightmost zeroes
  67. Finding right-most cell.
  68. Copy cell value from one worksheet to matching worksheet in another workbook
  69. Copy from Excel to Word
  70. Re: Magic Excel function or UDF?
  71. Extraction
  72. Excel vs .csv?
  73. Excel startup problem. Possible problem with stdole32.tlb
  74. Open Word file with Excel VBA
  75. count cells with diagonal borders
  76. Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!
  77. In Excel 2007, color for number format axis not working
  78. Populate TextBox with other textbox value
  79. REMOVING COLUMN FILTERS VIA VB CODE
  80. add hyperlink without changing the cell formating
  81. hope someone can help with excel save with 2003 and 2007 installed on my computer
  82. How to write Left Function in VB
  83. Combining Text based on Values
  84. Check if information exist in one column and if it does, type appropriate text
  85. Reading Excel Table in VBA
  86. Search for empty cells and move cells next to
  87. shorten sheet name
  88. Find and move cells with text
  89. Text To Columns then insert rows
  90. Code for RefersTo property
  91. Deleting Toolbar
  92. Deleting Toolbar
  93. Re: Excel 2003 - VBA Code Problem
  94. Macro to open file and copy information from worksheet
  95. Re: Excel 2003 - VBA Code Problem
  96. formula for payment, time vs hourly price
  97. Re: Add data to a PDF file or form?
  98. Excel 2010/2007 - How much can be done with Custom Validation?
  99. month gaps counting through whole column
  100. Wildcards in SumIF formula
  101. Check font of a cell
  102. Copying Cell Value AND Format into Email Body Macro
  103. colors change in graphic
  104. Global/Public/Universal variables
  105. Use only cells with data in
  106. Modifying a Defined Name's Contents
  107. Alter internal margins of chart title using VBA, Excel 2010
  108. execute .acsup script from VBA macro
  109. Require entry in one cell if data in another
  110. Filter based on cell contents.
  111. Re: Help bringing in hyperlink into Excel from Web
  112. macro to a number + 1 to a cell
  113. how do I link a constant or variable to form
  114. Should I activate workbook before activating sheet when button is selected?
  115. Automatically create ranges and then name them
  116. Auto Detect Data, Auto Print Data, Auto Erase Data Loop
  117. Draw line of defined length
  118. calculating Sick pay entitlement
  119. count cells with diagonal borders
  120. List of items from other sheets
  121. Keeping Conditional fromating When Emailing Using A Control Button
  122. ListBox with 2 Columns
  123. How to change a sheet name without opening the workbook
  124. No program is registered to open this file
  125. Efficient looping
  126. Unique Random Numbers
  127. Directional buttons
  128. Storing Multiple Selected Pivot Table Report Filter Values
  129. Include Layout name with filename when printing to PDF
  130. how to determine duration of meal break in timesheet (working with times)
  131. Controlling Page Break Preview
  132. VBA to set the font size for the axes of a bar chart
  133. Purging Excel's VM Usage
  134. Important Union Intersect VBA Problems
  135. Cannot recalculate
  136. How to parse text in a cell
  137. Looking For A Formula
  138. Iterating through a ComboBox's values
  139. Why does variant not need set?
  140. EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed
  141. Comparing dates
  142. Implement time-out
  143. ChDir "F:\dump" - not working
  144. Detecting when a process ends
  145. Possible to refer to a sheet's object name ?
  146. changing activesheet shapes label caption
  147. Can I use loops to enhance this code?
  148. List of methods and/or properties
  149. Wierd Formula Request
  150. Application.Filesearch FileCopy
  151. Obtaining list of all objects on worksheet
  152. VBA: Read picture filename
  153. Re: Average of a column, excluding spaces?
  154. XML and EXCEL 2003 standard edition.
  155. Prevent Sending eMail from Excel
  156. importing Access via code
  157. Convert Objects to Pictures (or Shapes)
  158. Re: VLookup a named range
  159. Shared Workbook Crash
  160. VBA - Copying a Certain Colored Row to Paste in Another Worksheet
  161. numeric value, vba to split out one digit per column
  162. Forcing Excel to Import .CSV data
  163. Spliting digits up to fit paper form
  164. Alt-F8 and Excel 2010
  165. Re: VLookup a named range
  166. Re: VLookup a named range
  167. Cannot display Add-in Macro list without going to VBA/Project
  168. downloading from excel to google
  169. Dynamic rowsource for ComboBox
  170. Need to run a macro on opening a new excel file
  171. VBA module for record data from datafeed
  172. Importing several web pages with macro/VBA?
  173. Excel 2011 for Mac tries to run a file when it starts up
  174. Get CPU Priority of a ProcessID
  175. How to create a variable selected range
  176. Parsing Month WorkSheet (one row/Project) into Folder & SubFolders by Project
  177. Sorting multi-dimensional array
  178. Finding a Value Between Two Numbers and Returning Corresponding Value
  179. Using VBA on Excel Pivot Tables
  180. Excel VBA Replace Data Validation Titles and Input Messages
  181. Enable macros
  182. Loop to copy paste rows base on table arrays
  183. Macro to display Tabular View of Active Pivot Table
  184. Save sheet bitmap to desktop?
  185. No characters data in Hyperlink cell
  186. VBA Go to Today's Date
  187. Saying No to Message Box prompt through VBA
  188. EXCEL 2010 VBA; trying to use INI File stored on local desktop machines
  189. Macro to remove squares from cells
  190. Large Dynamic Named Range Sort Problem
  191. Excel 2003 - Save as dialog box
  192. length of line depending on the value of the cell
  193. Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksheet
  194. only 1 time declaring variables
  195. Error handling
  196. scraping PDFs
  197. VBa Write integer to file
  198. Dynamic Creation of Arrays - Sorting into Bins problem
  199. VB Marco Reverse Variant and paste into other sheet
  200. VB Marco Reverse Variant and paste into other sheet
  201. Function in a VBA prog. or something like that
  202. Transfering Excel Tale into .csv Ones?
  203. Pivot: hiding rows with emty or zero as value
  204. Re: Adding CustomUI Ribbon code using macro to new generated file
  205. Re: Adding CustomUI Ribbon code using macro to new generated file
  206. Change cell type
  207. Run Macros
  208. Creating an ARRAY UDF
  209. Excel timesheet
  210. object library problem
  211. Copy Template with Updated Values Each Time
  212. Object libray invalid problem
  213. Output from Frames - multiple optionbutton groups
  214. Re: Userform Control validity check
  215. ActiveX ComboBox Linked Cell
  216. General question on multidimensional variables
  217. Excel 2010 Charting in Userform - Can't Access OWC11 Control from Toolbox??
  218. EXCEL SQL.REQUEST of ACCESS DATA
  219. Putting the series 1 and series 2 titles from a worksheet
  220. Recode values
  221. wildly varying execution speeds - is it the code?
  222. any ideas why execution speed varies?
  223. MINIF UDF
  224. Improving Nested Formula Calculation Efficiency
  225. Re: Get ColorIndex from Character in String
  226. How to maintain size of array: UniqRow
  227. Re: DSUM not unique records
  228. Macro Excel 2003
  229. Combobox list based on choice in previous combobox
  230. Combobox list based on choice in previous combobox
  231. saving the userform layout
  232. Combobox items based on choice in previous combobox
  233. Re: DSUM not unique records
  234. How to best set this spreadsheet up
  235. import data from a non existing datafile
  236. Retrieve numbers that meet criteria
  237. get column name by ADOX
  238. Produce Random Numbers
  239. Running macro operations in serial fashion
  240. VBA to set dynamic print area
  241. Test Message
  242. Robust Excel addin installation through vba
  243. Using code to edit spreadsheet formulas
  244. Check a value every time excel is loaded
  245. Runtime Error 1004 on Linest
  246. Runtime Error 1004 on Linest in VBA
  247. Runtime Error 1004
  248. Runtime Error 1004
  249. removing personal.xlsb file
  250. Cannot save macro spreadsheet due to ReadOnly = True
  251. Triggering auto_open
  252. Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook
  253. Variable Name Changes in Loop Operation
  254. Creating a UDF to search a cell's formula
  255. Stubborn toolbar
  256. When importing text field Excel chops off leading spaces
  257. Re: ByRef v ByVal
  258. Delete named ranges in VBA - by scope?
  259. Re: VBA Search worksheet, find text, change color of row
  260. Re: Excel consultant recs?
  261. Re: Excel consultant recs?
  262. Need : Application Developer - FoxPro Loc:William Street, NY
  263. count shaded cells with a gradient fill
  264. 2007 Compatibility Checker states cells outside of range when saving2003 version
  265. VBA code won't run, even with Macro Security set to Enable All Macors
  266. SUMPRODUCT Error
  267. Excel VBA assistance
  268. Runtime Error 1004:Method 'Range' of object'_Worksheet' Failed
  269. Task manager’s system CPU PercentProcessorTime
  270. vsdvfs
  271. Returning the name of a deleted cell style
  272. Deleting a row where characters 34, 35, 36 are 000
  273. Referencing a cell value in a macro
  274. A way to count cells in a range containing text or formulas
  275. Problem with ActiveWorkbook.Close command
  276. Manpower Calendar Distribution, Skipping weekends.
  277. Re: How do you detect a Left click on a Worksheet
  278. Help: Find Matching Cells, If - Then Move Cell With Self
  279. Error 1004 on Range.Text with AutoFilter
  280. Importing a JPEG image to excel as matrix
  281. Keyboard shortcuts
  282. 回覆:Read back the source data from chart
  283. Read back the source data from chart
  284. Passing Parameter with OnAction
  285. Re: Formula re value in column C or D, calculations made on either in column E?
  286. Workbook_BeforeSave
  287. Re: Formula re value in column C or D, calculations made on either in column E?
  288. Re: Formula re value in column C or D, calculations made on either in column E?
  289. Conditional Combobox
  290. Import Hours as Text
  291. VBA code for Range
  292. Excel Add-In to catch application events
  293. excel cell to text file and text file to cell dir to cells and renamefile from cell
  294. Convert Time to Text
  295. Summary sheet
  296. Copying Value to Range
  297. how to quit in BeforeClose
  298. Find more than a word in a table
  299. Clearing Office clipboard 2010
  300. Change SQL in VBA
  301. Filtering Worksheets by Same Criteria - Object variable or with blockvariable not set
  302. Change Format of Active Cell
  303. selecting multiple cells from multiple worksheets for printing
  304. Sendkeys to external application not working
  305. Excel Bar Charts Issue - How Dynamic can charts be?
  306. How to find sheet names without opening files
  307. Make a crosscast reprot from a tabular report
  308. Help with creating a Macro to copy data from Excel to Word.
  309. Count or Match Help Please
  310. Calc Number of Months PER YEAR Between Dates
  311. Moving data from column to row in groups of 250 per row for fourrows, then skip a row and continue the same throughout the data in column A
  312. xls Compare Software
  313. Searching
  314. Coding
  315. CreateObject Software Versions
  316. Is Range Offset property needed
  317. Re: Close dialogs
  318. Routine too fast for Form to Update?
  319. automation error 440 when adding to collection
  320. how to copy worksheet to new workbook with values only
  321. Count no empty cells at the right of a selection
  322. Problem with printer name while using executeexcel4macro
  323. USB Communication
  324. Match using VBA
  325. Error Opening Workbook
  326. UDF for Aging in excel - Help needed
  327. UDF for Aging in excel - Help needed
  328. Auto-Calculate price based on width x height
  329. Re: Error populating a list box
  330. comboboxes, extracting specific item
  331. Re: Create a password protected Zip file
  332. Re: Error populating a list box
  333. Error populating a list box
  334. overlapping sheets' frames
  335. Have shapes react to events in Excel 2010
  336. Inputbox from another OPEN workbook
  337. Finding Intersection Points between different lines
  338. Finding Intersection Points between different lines
  339. Adjusting alogarithm
  340. Re: Import module
  341. Re: Import module
  342. Re: Import module
  343. Trim leading numbers
  344. Finding, grouping, then copy/paste to new sheet
  345. Adding PivotTable fields with a macro
  346. Best way to make all sheets in a workbook Values only
  347. Why is Cell not an object
  348. Corrupt files due to pivot remnants after saving via VBA
  349. Worksheet appears briefly before UserForm opens
  350. CountA and Countif and Arrays
  351. Protect / unprotect a form
  352. stopping a range from calculating
  353. how to protect a program
  354. Identify invalid folder in VBA
  355. Macro to link data to template
  356. + / - Percentage Variation
  357. Returning 100%
  358. Save ActiveWorkbook dilemma
  359. =SUMPRODUCT Question
  360. Delete some letters
  361. Duplicating worksheet based on range and changing worksheet name
  362. Using a sub within a function
  363. Cell list value from another sheet
  364. VBE object in 2010
  365. Advance Filter
  366. VBA dropdown vs Validation
  367. Read contents of #Name cell
  368. Unable to change ActiveSheet within Workbook_Open
  369. Nested If / And Statement with Conditional Formatting.
  370. How to Average a Sumproduct() formula
  371. Outlook Code Run from Excel
  372. If then statement based on time of day
  373. Apply macro to all worksheets
  374. Add Hours by Looping through Data Q
  375. Excel Macros to zip a file
  376. Custom filter
  377. use ComboBox value to select range and then use selected range tocreate a chart
  378. How to copy row data from Sheet2 to Sheet1 based on Conditional Date
  379. CountIf / SumProduct in VB
  380. Rounding up/down time
  381. Copy worksheets to control file
  382. Copy a range instead of just one row but with condition
  383. Open excel Visual basic code window by clicking on hyperlink
  384. criteriarange not equal to
  385. Re: Where to put / register a 3rd-party activeX component for use in Excel 2010
  386. Excel VBA on server
  387. In need of more guidance please....
  388. Need help on this strange event
  389. Guidance required please...
  390. Week numbers from an entered date
  391. Need help with vlookup & MACRO
  392. Macro Sorting according to a chosen name
  393. Using VBA to automate printing with mail merge
  394. Code to identify whether a cell has manual highlighting or not
  395. Calculate percentages depending on the values
  396. Re: Excel 2007 "Custom Toolbars Button"
  397. Excel 2007 "Custom Toolbars Button"
  398. For, Next, Loop vs. Select / Case Is
  399. alignment of SOME text in a textbox
  400. Number Match Formula?
  401. Knapsack Problem
  402. Select two items from many
  403. Macro to Create Name Ranges for variable lengths of Data
  404. For Next loop
  405. FINDPREVIOUS on UNION not cycling correctly
  406. Q: UDF with Interior.colorindex Help needed
  407. Match based on a lookup and then flag
  408. Math Problem in Excel
  409. Need help with worksheet_change script
  410. Help with worksheet_change script
  411. Search for values in a sheet and copy found records one after theother in another sheet
  412. Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and Pivot Charts
  413. Re: Original Picture Size in VBA?
  414. MINIF function
  415. Shapes in 2010
  416. The Mt. Everest of requests
  417. Re: PING: ANYONE PLEASE I NEED YOUR HELP!!!
  418. Paste failing after cut
  419. Re: Macro to navigate through a Java Web-Page
  420. Macro to navigate through a Java Web-Page
  421. Re: Delete lines with a blank cell
  422. Shapes in 2010
  423. Collate data from multiple workbooks into one worksheet
  424. Copying excel charts to word through VBA
  425. Disable optionbutton
  426. Bold items within text string
  427. VBA Lookup table / Array
  428. Highlight Cells in Active Row
  429. 2010 MultiThreadedCalculation Incompatible with Range.Calculate
  430. Print to PDF format
  431. Help with VB macro for Excel
  432. Excel 2010 is not acting the same with ReadOnly...
  433. Loop Repeats - PLS HELP
  434. Copy Sheet and rename it.
  435. create a pivot table and chart from a named range
  436. Macro will copy formula instead of value
  437. Timed Scrolling
  438. Data exchange between macro and spreadsheet
  439. Breakpoint not highlighted after file save
  440. help please with macro assaigning to a list
  441. Re: Excel for Windows/Excel for mac compatible?
  442. Need Excel Macro to select an unknown, named table and convert it toa range
  443. What's happened?
  444. Intersect needs fixing
  445. Copying in sheet with protection with the use of a macro
  446. Lookup formula problemo
  447. simple code but it doesn't look like usual vba code
  448. Data Validation & Filtering Lists
  449. 'Save as' dialog opens despite Application.DisplayAlerts = False
  450. Macro to open a designated sheet in a separate file
  451. Windows XL, Mac XL, and the Ribbon?
  452. Change cell state with protected sheet
  453. Search box excel
  454. Formula Help: Monthly Statistics
  455. Error opening XLS file
  456. Re: Excel Formula to add network file link to each month
  457. Can't Get To "AccrIntM" From MS Access
  458. Excel Formula to add network file link to each month
  459. Format data using macro
  460. Read MHT file using macro
  461. How do I get WorsheetFunction.Average to work
  462. OT: Google Groups not Threading
  463. Time Format Issue (Email message body)
  464. copy & past text every30th Row into new sheet
  465. Pictures not being sorted in VBA
  466. Excel macro
  467. How to test if two object variables reference the same object?
  468. How/where to declare variables shared by objects of a class?
  469. Intuitive Macro that changes based on cell value
  470. Accessing array values
  471. Command Button Text Cut Off
  472. Re: DOS batch files
  473. Populating a Named Range & Cell Array
  474. Re: Parsing names
  475. Re: Excel for Windows/Excel for mac compatible?
  476. Excell 2003 VBA Code needs
  477. Macro need for Excell 2003
  478. need help
  479. Application.Inputbox Type2
  480. Re: Count tokens in a string
  481. Re: Count tokens in a string
  482. Data Validation blanks for formulas
  483. Win7 VirtualStore Weirdness with Excel 2002 and earlier
  484. Apply different color to datalabels
  485. What kernel function returns process stats
  486. Re: Excel for Windows/Excel for mac compatible?
  487. Diff btwn Dim x and Private x in class module?
  488. VBE tricky question
  489. LoadPicture command
  490. macro need
  491. Sports Arbitrage Formulas
  492. Send mail
  493. Print entire workbook with each sheet starting at page 1
  494. Help Required - 22nd May 2011
  495. Just switched to Excel 2007 from 2003 - Unclear how to enable macros
  496. generating zip code and county information from latitude andlongitude data
  497. how to find union of two arrays
  498. Method to automate page numbers on single worksheet
  499. Have Cell To Left Show Fixed Time When Cell Changes
  500. Inserting blank rows after ranges
  501. Insert Border
  502. Help file for VBA custom function
  503. Re: Macro for Fill Blank Cells Macro
  504. Re: Extracting web data
  505. How to copy several nonajacent cells and paste to ajacent cells in one row
  506. cells.interior.color values
  507. Identify Hidden Columns - New issue!
  508. Re: Extracting web data
  509. Sheet print doesn't center with pivotcharts
  510. Extracting web data
  511. Countif Code
  512. VBA get range from cell offset
  513. Excel to Word to Outlook
  514. Copying same data range to a summary sheet
  515. Error 2042 problem with vlookup
  516. GETPIVOTDATA function on pivot filter
  517. combo box
  518. Save each sheet of multi-sheet workbook as a single-sheet workbook
  519. Howto declare and fill a custom collection of worksheets ?
  520. Re: " Select method of range class failed" if sheet not on top
  521. " Select method of range class failed" if sheet not on top
  522. Label controls change apparent font size when moved up/down
  523. Re: VB to merge cells but that warns when only one cell is selected?
  524. Re: VB to merge cells but that warns when only one cell is selected?
  525. Accessing Exchange via Task Scheduler run on a Server
  526. prevent pasting to more than one row
  527. Re: Stuck with multi function Part 2
  528. demerging add-in
  529. demerging add-in
  530. Creating a workbook(s) based upon a cells value <--HELP please
  531. Querry in relates to the function SUMIF
  532. Linking Attributes
  533. Identify Hidden Columns
  534. Stuck with multi function Part 2
  535. Stuck with multi worksheet Function
  536. A macro to parse a wordlist in Excel
  537. Loop to End
  538. Re: Autofilter based on user inputbox
  539. Re: Autofilter based on user inputbox
  540. Move all from Listbox1 to Listbox2
  541. Move row based on value in cell
  542. Working with 2 range but wont work with 3
  543. Re: Autofilter based on user inputbox
  544. Re: Autofilter based on user inputbox
  545. Re: Button to copy, save a sheet in a new file
  546. rotating an Isoceles Triangle in the shape of a Gauge needle
  547. Re: Button to copy, save a sheet in a new file
  548. Re: Button to copy, save a sheet in a new file
  549. Parsing XML with VBA
  550. renaming tabs based on a on a worksheet
  551. Re: Autofilter based on user inputbox
  552. Problem when publishing to PDF
  553. Re: Macro for compare between 2 workbooks and copy adjacent cells
  554. Re: Macro for absolute reference
  555. expanding SUMPRODUCT
  556. Problem - Show values as % of Grand total
  557. Re: Macro for absolute reference
  558. Re posting - Transpose employee data from Columns to Rows
  559. Pivot Table Excel 2010
  560. Re: Counting (unknown at present) discrete values
  561. Re: Counting (unknown at present) discrete values
  562. Image recolor with VBA
  563. Autofilter based on user inputbox
  564. Connection between Solver add-in and file path code
  565. Re: CommandBarPopup not recognised as a keyword Excel 2003
  566. Re: Convert a yyyymmdd date format in code
  567. Macro assistance?
  568. Loop through all open workbooks except Personal.xls
  569. inserting graphs into word
  570. Macro help please!
  571. Re: Copy Column Width
  572. Deselect a worksheet?
  573. Re: Copy Column Width
  574. Re: Copy Column Width
  575. Re: Copy Column Width
  576. Re: Copy Column Width
  577. Re: Click event for UserForm Multipage
  578. Copy Column Width
  579. Click event for UserForm Multipage
  580. Copying files with attributes
  581. Open file from path in cell and open from current file path
  582. Number showing row location when you scroll
  583. Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule
  584. VBA Function
  585. how to write a macro to club data in multiple excel workbooks into asignle one???
  586. Re: List sheet names in "pop-up" box for users to select
  587. Re: List sheet names in "pop-up" box for users to select
  588. Re: List sheet names in "pop-up" box for users to select
  589. Disable save/saveas dialog box upon closing
  590. converting a for next loop into a for each loop
  591. Sorting Alphanumeric data
  592. List sheet names in "pop-up" box for users to select
  593. Adapt macro
  594. count cells with diagonal cell borders
  595. validated, stop all calculations on bad data
  596. Move row to another location on sheet
  597. how to convert COUNTIF() into VBA macro
  598. Re: Vertically centering text in a label field
  599. Re: Vertically centering text in a label field
  600. Re: Vertically centering text in a label field
  601. Re: Vertically centering text in a label field
  602. Re: Button to copy row to first empty row on another sheet
  603. Re: Button to copy row to first empty row on another sheet
  604. Re: convert unformated text from word to excel
  605. helpp on being able to cut & paste automatically from a web client into a sheet.
  606. Macro to save contents of a named range to a file
  607. Dialog controls and display settings
  608. code to open another workbook
  609. code to open another workbook
  610. code to open another workbook
  611. Run time error
  612. Auto Save
  613. Copy rows to another sheet
  614. Insert rows at change in cell value
  615. insert worksheet shift 11 tab
  616. macro that extracts specific data from multiple worksheets
  617. file path or IP address protected
  618. Calculating a worksheet
  619. re-creating vbcomponent
  620. Re: Automation Error
  621. splitting text in cell - row and column operations
  622. Open Webpage in Excel
  623. Scrollbar on userform in design mode
  624. find beginning of line to first space?
  625. Why cant I get the path to the sharepoint library????????
  626. security, enabling macros to enable a disabling saving function
  627. Adding multiple handling errors
  628. Lookup cell, find Tab then copy/paste
  629. Solver iteration in VBA macro
  630. Scatter Chart
  631. Look up match and highlight
  632. Find #Value Error
  633. EXCEL DROP DOWN
  634. Re: Use index and match function to get data from pivot table
  635. Need Help in Selecting PrintArea Dynamically ..
  636. automation error when closing excel
  637. Re: Filling an Array in VBA
  638. Re: Impossible with regular expressions?
  639. Date showing as numbers in Textbox on Userform
  640. Multi listbox change event - selected or deselected
  641. Help copying last sheet and renaming to next consecutive number
  642. ? Function to copy based on choice
  643. Re: error correction on vba macro
  644. Restrict Input of InputBox to numeric values between 1 and 10
  645. Excel 2007 Charts & Memory Leak??
  646. Changing name of worksheet based on data in cell of another worksheet
  647. Superscripting text in a cell
  648. Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter
  649. R: Re: function - find first number in row > 0, return cell column number
  650. function - find first number in row > 0, return cell column number
  651. xlPortrait in Macintosh
  652. Automatic copy of cell formatting between sheets
  653. Mac Excel 2008 question
  654. Re: VBA Runs After Application.Quit
  655. Change cell backgrounds from VBA with undo enabled
  656. VBA triggers on tabkey
  657. R: Re: Basic regular expression question
  658. R: Re: Basic regular expression question
  659. Utility can't live without
  660. Array - delete and replace elements
  661. Re: Basic regular expression question
  662. Re: Reading image size?
  663. Sum a column to a certain value
  664. Selective selecting of multiple tabs
  665. Advanced Find and Replace
  666. Name vs FullName
  667. Re: Bound Controls on UserForms lock Worksheet cells
  668. Hiding 0 value data labels in chart
  669. Concatenate VBA syntax
  670. error trying to sort data
  671. How to create a shared procedure
  672. Upload Excel data to Access error
  673. R: Alternate ways to extract a substring?
  674. R: Alternate ways to extract a substring?
  675. Read only file
  676. Re: HOWTO Time VBA code
  677. type mismatch error
  678. Re: HOWTO Time VBA code
  679. Re: HOWTO Time VBA code
  680. Re: Question about FileDialog
  681. Re: HOWTO Time VBA code
  682. Re: On-Worksheet ActiveX Controls - is there a bug in the Excel engine??
  683. Re: On-Worksheet ActiveX Controls - is there a bug in the Excel engine??
  684. Enum bug?
  685. Help With VLOOKUP VBA Script Line
  686. Re: Find pos of next whitespace char?
  687. Merge Two Excel Columns into 1 Columns
  688. XL2003: VBE Won't let me break into running code
  689. Re: compare same data in two workbooks
  690. Re: compare same data in two workbooks
  691. Macro to copy multiple sheets x amount of times.
  692. Re: Find the first numeric substring
  693. Extracting Excel2007 data from structured Storage
  694. Re: Compare same data of column in two workbooks
  695. compare same data of column in two workbooks
  696. Worksheet level names
  697. Re: Convert time to military time?
  698. Cells drop leading zeros from numbers
  699. Multi-select listbox - mousedown event
  700. For Each Type mismatch
  701. Match 2 set data and combine to 1set
  702. Re: Change ActivePrinter?
  703. Conditional Min/Max Question?
  704. Comparing two columns
  705. Insert string from Pup up box selection
  706. VBA code based on column heading
  707. "Duplicate declaration in current scope" during edit and continue
  708. How To Import Excel Data With Excel 2007?
  709. Type Mismatch error when trying to generically set ComboBox to aComboBox variable
  710. How to copy a range of dates
  711. how to reshow userform after following a link
  712. Getting Last Non-Blank Row Number With VBA
  713. selecting names in a list
  714. Multiply a range by Input Box Value
  715. Saving files based on lookup
  716. Problem in Excel 2007 when Range beyond 65536 in SELECT statement
  717. looking for fileio instructions
  718. Vlookup or SumIF to sum multiple cells matching the same criteria
  719. Re: VBA code if/then
  720. VBA code if/then
  721. renaming named ranges
  722. Spin button to scroll up&down a database with a userform
  723. Get visible pivot table items
  724. Work week
  725. How to stop a macro
  726. reporting yes results in one column
  727. Flip a spin button
  728. Macro Syntax Again
  729. Using a button to scroll Up & Down a Database on a Userform
  730. File not found: VBA6.DLL
  731. SpinUp & SpinDown in Excel 2010
  732. Floating List Box
  733. Copy/Paste_Value problem.
  734. Save without Macros without prompting
  735. Chart rotation
  736. Macro to clear clipboard on exit
  737. Problem adding a reference
  738. Conditional Sum
  739. question on a feature of this site
  740. comparing textbox value with values in named range
  741. Attaching a trusted certificate to an Excel macro using Excel 2010 64 bit
  742. Bar Chart With Custom Labels On X and Y?
  743. Y/N and print job sequencer
  744. Re: SUM of alphanumeric cells
  745. SUM of alphanumeric cells
  746. Deleting Duplicate Rows with Same Sum?
  747. Run powerpoint macro in excel
  748. application.version ... is a application.servicepack? vba
  749. Re: Double-sided printing and printing entire workbook in one go. Macro to help ... ??
  750. Increment a row based on another column with duplicates possible