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. Activate a worksheet and paste / Import a code
  2. Visual Basic code
  3. Help with Drop-down control
  4. Tough for me - Import 30 macros from one excel file to another in one step
  5. Tough for me - Import 30 macros from one excel file to another in one step
  6. Display 0 in the cells...
  7. 2 questions: Macro Mapping & Active Chart
  8. Read Lotus mail from excel
  9. Display 0 in the cells...
  10. Go to a specific cell when selecting an entry in a validation list
  11. Help creating a proper loop
  12. Listen to "rename sheet" event in excel
  13. TRANSPOSE WITHOUT ZEROES(0's)
  14. Filling in Numbers on Forms
  15. Need help with VB code to find certain values & select changing va
  16. Summation of latest running 3 month total
  17. Inserting Multiple Columns
  18. How to call a soap web service in excel 2007
  19. Problem with Web Query
  20. VBA References
  21. Hope to stock data at every single update&all the sheets stocking synchronized
  22. Error message in Web Query written in VBA
  23. style propertie causing excel not being released
  24. refreshing web query
  25. macro to check file open
  26. Return Excel's current security setting
  27. NEED VB CODE TO REMOVE INITIALS FROM A NAME AND ATTACH IT TO THE END OF THE NAME
  28. Solution to your problems
  29. Hope to stock data at every single update&all the sheets stocking synchronized
  30. Hope to stock data at every single update&all the sheets stocking synchronized
  31. userform textbox to variable
  32. Fill function to next cells
  33. How to convert philippine currency to english words
  34. PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
  35. PLS SUGEST VB CODE TO REMOVE INITIALS FROM NAME AND ATTACH IT TO THE END OF THE NAME
  36. Create Sub Directories From Excel Column via Macro
  37. Copy paste error
  38. Display all items in outlook 2003 folder
  39. pastespecial
  40. force update/"refresh" of cell & workbook_open?
  41. How to Disable Ctrl+Break?
  42. Deleting Worksheets
  43. From Office 2003 to Office 2007
  44. Setting Windows Timers for a specific time
  45. Cancel = True not turning edit feature off
  46. Office Automation through C#.Net (with out save option, ctrl-s and mouse click disabled)
  47. msgbox text vbyesno
  48. Excel Data Import Question
  49. Flush Memory/Cache Clear:
  50. Spreadsheet getting corrupted
  51. Moving Excel Chart to Powerpoint (getting runtime error 91)
  52. copy sheet from Server URL
  53. Click on a cell to get a check mark then...
  54. Calculation based on entry into one of 2 cells
  55. problems adding Rich Text Box control to a VBA form?
  56. Flushing Memory/Cache Clear:
  57. NEED VB TO REMOVE INITIALS FROM A NAME
  58. NEED VB TO REMOVE INITIALS FROM A NAME
  59. change contents of cell to another cell's value via macro or??
  60. Macro to return averages within a column
  61. Counta with VBA -
  62. Changing Sheet Names
  63. remove embedded images from a spreadsheet
  64. Need Help with an Excel App to Submit information to a Webservice.
  65. Web Query Without URL
  66. create a macro to delete columns and then border remaining columns
  67. subscript out of range error in Excel 2007 at Vista
  68. Data validation on different sheets?
  69. Reset Sheet name tracking number
  70. refedit column
  71. Refedits / Autotab
  72. Userforms in Excel 2003
  73. Userforms in Excel 2003
  74. Compare sheets
  75. Divide existing data in cell
  76. Adjusting scale of an adjsuting chart
  77. Before Save
  78. Dynamic Ranges & Invisible Offset
  79. Numeric TExt Into SQL Server
  80. Flushing Memory/Cache Clear:
  81. continous assessment help with vba
  82. Selecting cells for a desired result
  83. VBA help needed please
  84. Concatenate question
  85. Error Handle: File is already open.
  86. Latest running 3 month total
  87. DateAdd question
  88. Errors 3705 and 3709...
  89. How to listen to "rename sheet"
  90. Best place to learn VB online
  91. How to develop a "Shpping Cart"
  92. Selecting ranges in macros
  93. Editing Recorded Macros in Excel - VB
  94. Grouping/Collapsing lines in VBA editor - xl2000
  95. How to stop multiple refreshes on worksheet
  96. Chart Titles - Thanks
  97. Cell should show "0" as character....
  98. Memory/Cache Clear:
  99. VBA - Trying to insert records
  100. Looking for Ideas - Page Breaks
  101. Need help saving to multiple locations
  102. Warning when saving in Excel 03 running on XP
  103. e-mail macro
  104. VBA question: Condense cell contents to first character
  105. Syntax Problem
  106. Linking custom toolbar to personal.xls
  107. How2 automatic refresh advanced filter based on validation list?
  108. A macro to change font size
  109. Use a List to Generate Worksheets
  110. jump into the loop
  111. Macro fails to select pivotitems
  112. Code snippets for custom menu
  113. Macros stopped working
  114. Macro keyboard shortcut problem
  115. error handling question
  116. Custom Software Development
  117. Pivot Table Columns force visible
  118. How to call out "other" open book
  119. automatically change column references in formulas
  120. Message box for overdue dates
  121. Hide Sheets in the Work book....
  122. Delete shapes, not buttons
  123. Document Level Project in VSTO 2005 For Excel 2003
  124. Open an excel-file from the web
  125. Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO
  126. Embed image in excel
  127. COUNT IF + using 2 sets of data
  128. UserForm Pointers & Class Modules
  129. PExcel AddIn hangs when trying to access data programatically
  130. Escaping Quotes problem
  131. Excel Form data to closed workbook
  132. Check current location
  133. Creating A Text File From Single Column Via Macro
  134. xl2007 Application.FileSearch
  135. Do we have time for yet another Sort problem?
  136. create messagebox when a date is overdue
  137. Big Idea lacking enough knowledge
  138. Trend Analysis/coefficient of differentiation formula
  139. Run a query with two tables connecting to two different ODBC
  140. Delete break line between column A & B
  141. Excel/VBA 2007 Problem
  142. VBA to Copy Range
  143. Scroll Bar/Chart links in Excel 2007
  144. How to intercept each pressed key
  145. How to get the current path
  146. Summary Sheet
  147. How to transfer a ListBox to a function
  148. Double Lookup Without Exact Match-Price Breaks
  149. Sort order via excel userform combobox
  150. put a procedure into comments with code
  151. Custom Position UserForm
  152. Transpose cells skipping blanks
  153. Bottom border for each row code not working
  154. Merged Cells ' Range height
  155. name_range auto filter
  156. Excel 2007 referencing other wb
  157. Using Find and FindNext to Format Cell Text
  158. Userform picture
  159. RowSource as a row
  160. a macro...for a virgin sheet
  161. Marco Help
  162. macro Help
  163. Programing a code
  164. Help with summing.
  165. Excel: Using Look up to return multiple corresponding values
  166. Search for value move to next column code not working
  167. Excel bug
  168. Countif with parameters from another range?
  169. multiple workbooks
  170. Convert number to nearest multiple of Five
  171. Delete from the bottom up
  172. Control Q
  173. Pop Calendar Fixed
  174. Array with unknown elements(apologies if reposted)
  175. Unknown element array
  176. Macro to run based on drop down list
  177. Complex Copy/Paste HELP....
  178. Excel, WordPad and DDE
  179. Complex Copy/Paste help
  180. Extract all non-table data from Word
  181. Import MS Access data into MS Excel using VBA...
  182. How do you insert wingdings symbols using VBA macro?
  183. Subtotal Macro Help
  184. Sorting a data list with a variable
  185. How to get the index in VBA of the selected item in a ListBox
  186. VBA Question: IF value in M >0, set O="Delete"
  187. short message box
  188. Complex Copy/Paste help
  189. Calculate Sets and Subsets
  190. Help or Information about Microsfot Excel Aplication Objet model
  191. ADODB Create New Database from Excel
  192. Excel does not execute a button's code when another macro simulates mouse movements & clicks
  193. Copying Worksheets Question
  194. ignore first 10 characters with find and replace
  195. Formula Change
  196. DisplayHeadings
  197. Open WB
  198. Is there a limit on the length of a PrintArea?
  199. Lookup latest entry
  200. GetOpenFilename in Windows Excel 97 bug?
  201. Order of Add-Ins Loaded By Excel
  202. Ideas for "linking" rows for printing.
  203. Opening another workbook while current one is open
  204. downloading query generated csv file
  205. Copy and paste between sheets error
  206. Create Pop Ups
  207. Convert .CSV format to .XLS format in C#
  208. microsoft map is no longer associated with microsoft excel
  209. Writing code for Events in Class
  210. String in a range
  211. (auto)filter on row
  212. Copy From One Column to Text File
  213. NEED VB TO FILL A ROW WITH ABSOLUTE CELL REFERENCE
  214. Visual basic code query
  215. replace text string in cell automatically
  216. URGENT: #REF! ERROR WHEN COPY AND PASTED
  217. Better way than Nesting, or other solutions
  218. "Getting Rid Of Save Prompt On Quit Command"
  219. Edit Ribbon
  220. clear defined named cells' contents
  221. Merging data
  222. VBA in Excel for Pivot Table Selection (want to use a variable)
  223. Set Source two Worksheets
  224. Error When using ActiveWorkBook.SaveAs and EnableEvents in same macro
  225. Find and Format code doesn't work
  226. Cross-sheet hyperlinking, data insert,lookup
  227. #REF! ERROR IN EXCEL97 WHEN TRIED TO COPY AND PASTE A RANGE
  228. Pop Up Excel Calendar VBA CODE
  229. Macro Suggestion
  230. RE: Searching into Non-Contiguous ranges in a columns
  231. Re: Searching into Non-Contiguous ranges in a columns
  232. Select Case syntax
  233. Add text change row colour
  234. copying hyperlinks to another sheet
  235. Color
  236. Changed module names don't register in toolbar links
  237. red "X" disable
  238. workbook open event
  239. Highlight Highest number
  240. Extreme opening time of workbook (15 minutes)
  241. How to disable cell entry ?
  242. disable the red "x" @ top right coner
  243. Select and Save as
  244. Page break Page number
  245. Open workbook with the same sheet every time
  246. Help Required
  247. pasting values only
  248. file edit view insert etc disable
  249. populate listbox as textbox changes question
  250. Need help with recorded macro
  251. Change pivot source w/o refresh? Can't change original/copied pivo
  252. Maximized or minimize
  253. Delete macros
  254. Set bk = Workbooks(...)
  255. Data Validation Failure Excel 2007
  256. "Saving Chart to New WB?"
  257. How do I Use Solver with the Macro Recoder/VBA
  258. Disappearing data
  259. select case error
  260. counting with multiple conditions
  261. 2007: CheckCompatibility not honored
  262. Copying data with a macro using autofilter
  263. Userform causes Excel to crash
  264. Decrease an array?
  265. seperate field criteria to diffrent worsheets or files
  266. Sub to copy only result lines within formula range, omit null string lines
  267. Add Code to File Opening Q
  268. Print Excel worksheet several times, looping value of 1 cell
  269. "compile error in hidden module"
  270. cell lock
  271. Error When using ActiveWorkBook.SaveAs in Excel
  272. How to store Range for "home-made" Undo Function?
  273. workbook protect
  274. Shell and Process.Start do not work
  275. Activate and Select range/worksheet
  276. regular expression parse string Perl $1 VBScript.RegExp
  277. how to assign external icon for a ready saved macro
  278. C#/Excel Code Slow; Suggestions?
  279. Obi Wan Kenobi: You're My Only...HELP!!!!!!
  280. Finding the last value entered for an entity
  281. data validation and named range
  282. Truncating values of each sale in the range
  283. Copy cell to another that is blank
  284. How can I use VBA to set the value of an ActiveX ComboBox
  285. Remove Duplicates Based on more than one column
  286. Linest, Pivot Tables, and VBA
  287. Numeric formatting: decimals and no decimals
  288. How do I count the last six non blank cells?
  289. Why does this happen same code different results
  290. Pivot Grouping
  291. Pivot Table Dates Grouping Issue with Olap Cube
  292. How to call a private sub() in another module
  293. VBA determine download URL
  294. AutoFilter on a protected worksheet
  295. using variables with Find
  296. remove non-numeric characters from cells
  297. Reading Access Form Field and Copy to Excel Field
  298. Email from vba
  299. How can you log users' interactions with MS Office applications?
  300. plus 1
  301. Sub () that does NOT appear in Macro selection
  302. Creating an array
  303. Custom Fields with spaces
  304. VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column
  305. Refence a global in a another VBA Project
  306. Problem With Auto_Close and QUIT() Function - XLM4 Macros
  307. on closing excel enter password problem
  308. Chart titles
  309. Chart zooming
  310. writing to text file
  311. Toggle Switch
  312. Can you make it so you choose more than one item from a drop down
  313. Filling a Combobox 10 th column
  314. (reposte X 3) Anyone???? Have I stumped the Excel community?
  315. Need help with a vb function
  316. object variable not set with commandbars
  317. Please could anybody help with a file
  318. Last numeric cell
  319. Stupid question
  320. Using two object variables
  321. Formula in code
  322. Find #Ref! and replace
  323. adding custom images to a button on custom toolbar
  324. Listbox on Excel Userform
  325. form separator
  326. Problem with function WorkBook.ChangeLink
  327. How to convert .CSV file to .XLS File in C# Programming?????
  328. Detect if workbook is readonly
  329. copying cells
  330. Dates in Pivottables
  331. Returning full contents of an array to excel
  332. BIG FILE : 40mb to 95mb
  333. Array retained in memory despite procedure execution ended
  334. Position of selected rows
  335. How to make a cell blinking by conditional formatting?
  336. read the values from a excel row
  337. CountIF = function not defined ???
  338. Combobox listing display
  339. create array
  340. Sum a column using fixed start cell and variable end cell
  341. check.offset
  342. defining Grouping
  343. Conditional Formatting VBA
  344. How do I get Excel to give me a warning, if a given cell contains a given number?
  345. initialization of an array????
  346. Can't link from Access to Excel worksheet
  347. break?
  348. How to copy rows from 1 workbook to another workbook
  349. Spell check button on a protected excel doc
  350. Capturing Define Names
  351. Magnify contents of cell when mousing over - is this possible?
  352. Dim & Copy & Paste
  353. Ron on email code
  354. Macro that will extract information from database into excel form?
  355. Clear/Create Subtotals Macro
  356. 2007 Macro issue
  357. delete duplicate rows, keep latest date and time group
  358. Excel VBA error - Select method of Range class failed
  359. Help with, Select then Save as
  360. total hours worked for salary timesheet
  361. Copying Range Just To Get Formatting?
  362. Moving multiple entries to one row?
  363. Macro to Save to Sharepoint
  364. (repostX2) Pivot table: Grouping first row field by fifth row fiel
  365. copy from dbf and paste to xls
  366. Page Break????????
  367. Excel 2007 Formula help
  368. How to Active Window
  369. Conditional Format in Pivot Tables
  370. Download multiple html files and save as txt
  371. SUM() Problem
  372. SQL Server login in Excel 2007
  373. Check if file exists...
  374. Name Connvention in Excel VBA
  375. How to test if a cell is empty in a custom function?
  376. Chr and Chr$
  377. Check whether text in a cell contains a string
  378. array question, referenceing
  379. ExportAsFixedFormat Options
  380. Paste "text" value on one cell by macro...
  381. Auto run Macro when file is replaced daily?
  382. Auto run Macro when file is replaced daily?
  383. Problem with Window Message
  384. Find Number of Weeks in a Month
  385. Dialogs
  386. how to save an image as a bitmap
  387. filling cells via Macro with a Vlookupfunction
  388. SOAP Error in webservice ( Connector:Bad Certificate)
  389. excel macro excecution from command line via bat file?
  390. Chart .Location failures
  391. Macro error when file not found
  392. Setting Top and Left of Modal UserForm
  393. Cross referencing pulldowns
  394. insert method of Character class failure (error 1004)
  395. Setting Top and Left of Modal UserForm
  396. Test for existance of data validation
  397. filtering with combo boxes
  398. Operning Intranet page
  399. Green screen scrape
  400. Advice needed re:data linkage between separate workbooks
  401. Offset Range Naming
  402. lookup value in column
  403. Replacing a date in date format.
  404. List Box Macro
  405. Help using With statement to move command buttons
  406. List Box Macro
  407. Help! Subtotal using formulas or VBA
  408. doubleclick mrehod
  409. Delete Worksheets in same excel
  410. senkey - double click
  411. help with script for internet download
  412. It works .... but only 1 time
  413. Macro-Security level value
  414. Time Aggregate in [h]:mm:ss format in a loop & julian date
  415. Registrating data on a sheet without activating it
  416. Get data from Lotus Note Database.
  417. Select Case
  418. User Defined function to format
  419. Compare Data between 2 columns, Excel 2000 & 2003
  420. Multi-Language Issue - TEXT function
  421. Using PivotSelect method to find the top of a range
  422. Turn on Track Changes in Excel from C#
  423. vlookup in reverse search direction
  424. SQL - Insert from Excel HELP!
  425. Colums/Rows different Pixels from one monitor to another - Excel 2
  426. How can a VB function determine the cell within which it is runnin
  427. Maco to copy data from wks to wks
  428. ActiveCell.Row noncontiguous
  429. absolute relative reference
  430. Setting Source Data for Chart Ranges in VB
  431. simple command button question
  432. Access to Chart Trendline Equations in VB
  433. How do I set option button value using VBA
  434. Command Button
  435. Application.CutCopyMode
  436. Alarm Timer
  437. More on 2.5 StdDevs
  438. Concatenation prob
  439. Progress bar/meter for duration of code - No loop
  440. Newbie needs translation of Andy Pope's code
  441. Value in Drop down list disappears
  442. How can I get Excel to prevent me from making mistakes, when choosing from a list?
  443. How to extract data from autofiltered worksheet
  444. Add information to a cell with Data
  445. Returning arrays
  446. (Repost) - Pivot table: Grouping first row field by fifth row fiel
  447. Macro to insert sum calculation at every second blank cell for data above in column F
  448. ActiveCell Value match with Cells in range problems
  449. Disable Open/Save Dialog in IE Page using VBA
  450. Run-time error 57121 & 32809, Excel 2003 SP2
  451. email chart
  452. Simulate left click...
  453. Referencing Cells in a Selected Row
  454. Formula question
  455. How To Keep Worksheet_Change From Firing?
  456. With End With question
  457. Number Cells, Excel 2000 & 2003
  458. Stop an excel file from being moved or copied - do I validate filepath?
  459. Combo Box
  460. Importing Excel Workbook into Access
  461. Search marco to update a table
  462. Formula to use in Macro
  463. Simple SSN UDF
  464. Changing work hour days from 16 to 24
  465. Delete Row Help
  466. Normal.dot
  467. Desktop icons
  468. VBE Security
  469. Synchronize PivotTable Items
  470. Macro - Copy row and paste on all tabs
  471. vba in FrontPage
  472. Saving a Macro
  473. replacement for Application.FileSearch in 2007
  474. Range with a variable
  475. Pivot table: Grouping first row field by fifth row field
  476. userform and VBA code
  477. Subtotal Macro Through Numerous Tabs
  478. Histogram and macro?
  479. Pivot table: rouping first row fied
  480. Cut Button Problem
  481. Office Add-ins and threads
  482. Simple Excel Question?
  483. Progress Bar
  484. Need help with Date formula....
  485. Get Oracle client version
  486. Re: Concatenation prob
  487. changing time formula from 16 hour days to 24
  488. Any way to reduce/combine in this code?
  489. Check that all cells in a range have same values
  490. Input Box selects a cell location to use in code
  491. List AlternativeText names for every shape on a worksheet
  492. choose range name according to cell
  493. Internet data retrival
  494. Timer to flash msg on a form
  495. repeat row button
  496. Saving Macros
  497. Copy a workbook that already exists
  498. Copy lines with specific value
  499. find/replace macro
  500. About my looping
  501. My program read the wrong msgbox
  502. Limit to # of cells using validation
  503. Add separate values in a Column
  504. block manual entry
  505. Saving sheets as tab delimited text files
  506. How to let the looping wait
  507. Multiple Check Boxes calling same macro
  508. Change variable value of -1 to 1
  509. loading text file partially
  510. SeriesCollection.(X)Values: locale settings specific?
  511. Delete rows containing "ISA" in column A only, starting from row 6
  512. Cancelling Application.OnTime - error message
  513. delete from matrix
  514. Macro to work list in filter and save (reposted from MPE misc)
  515. run procedure when exit design mode
  516. Cancelling Application.OnTime
  517. Fill variable number of cells with a fixed text
  518. Macro error I cant solve
  519. ActiveFormula R1C1
  520. Naming Ranges
  521. Copy Worksheet to new Workbook and naming
  522. Macro to select "last used column + 1"
  523. Attaching files to emails using a wildcard
  524. Macro to go back to last used sheet
  525. Workbook Size
  526. Use Pivot Table to Sum Most Items and Subtract Only a Few
  527. Excel 2007 VBA How can I install my spreadsheet in a user director
  528. Range("Reset Sheet!F13").Select Makes VBA Code Fail
  529. Visual Studio / VSTO
  530. Collapsing rows
  531. System time to GMT
  532. Populating a check sheet from a frequency table
  533. Hyperlink to target
  534. Hyperlink to target
  535. Hyperlink to target
  536. COUNTIF Query
  537. Request for Help
  538. How to display the active row number
  539. Run UserForm Invisible
  540. simple excel process not killed
  541. Removing dupes without selecting column
  542. if statement conditions
  543. The differents of the sheets name and caption.
  544. accessing named range
  545. changing paperbin /papertray in excel 2003
  546. Row number of last cell with data
  547. Adding a space within a cells value
  548. Email a file as an attachment in Outlook 2000 using Excel VB macro
  549. Replicate amount over time based on date
  550. how to do other things while excel runs my simulation
  551. Programming for multiple version of EXCEL
  552. Unique values from list of many values (with duplicates)
  553. How to find function set about text
  554. Adding timelines to a chart
  555. Hide rows in visual columns without data
  556. find and paste - help with code
  557. Macro to lookup in a workbook and append it to a table
  558. IF Statement giving a Syntax Error
  559. Having Trouble Creating an Add-In Application.
  560. Run macro on columns with a "defined name"
  561. Long VBA Code - Can it be reduced
  562. Adding Percentages to a Stacked Chart
  563. Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument"
  564. Positioning UserForms, Input & Msg Boxes
  565. help saving trees by excel *free* macro...
  566. Custom button behaviour (activation and deactivation)
  567. lookup for bright solution...
  568. Solver Macro in Excel 2007
  569. add a .jpg to msg box
  570. RE: Concatenation prob
  571. Help with ADO query on MS Excel worksheet ...
  572. Adding leading zeros
  573. (previous discussion with Tom - re:Dynamically creating pt from li
  574. Re: Concatenation prob
  575. How to count blanks and spaces that look like blanks
  576. Setting AutoFilter to "Show All" when worksheet is opened
  577. Macro Reference Cells
  578. Macro to search every row in sheet2 then display all matching resu
  579. Macro Saving
  580. Link Not Embed Images from URL
  581. Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date?
  582. Delete rows with data
  583. left align active column/cell in window
  584. If Then ?
  585. Halt Macro Execution
  586. VBA - Character Removal
  587. Rename a range of cells with a macro
  588. Subtotals Formatting Question
  589. sql
  590. (repost) Dynamically creating pivot tables from page-field list
  591. IF formula - positioning difference
  592. Is this code ok?
  593. Deleting
  594. Calculating Gaps Between Numbers
  595. Password recovery help needed due memory loss caused by cerebralinfarction
  596. Slow Analysis Tool Pack
  597. Place Value in Cell
  598. Import XML file from the web in EXcel
  599. Macro Help
  600. Simple qu i hope
  601. Deployed add-in doesn't load
  602. "Another ScrollBar Question"
  603. Insert picture
  604. Workaround for ChDir/CurDir when path has unicode characters
  605. WorksheetFunction.Substitute
  606. Using Mutiple Sheets in excel in shell script
  607. Using checkboxes on a userform
  608. List all the groups a user is in
  609. Excel Solver Macro: Contraints Get Lost! - Please Help
  610. cant sum the values in cells
  611. Insert row on diff sheet IF
  612. Question on SubTotal function
  613. ChinesePingyao518
  614. Copy schema objects
  615. Vlookup VBA on dates
  616. Conditional Formatting Problem with currency.
  617. Enable/Disable Command Button
  618. IE Automation - Trouble getting changes recognized/committed
  619. xlup to find last row
  620. Calendar Contol with mutiple textboxes
  621. Why isn't the conditional formatting working?
  622. Dynamic Cell Reference
  623. Replicate VBA code to multiple files
  624. Converting Text to Numbers
  625. How does VBA interpret Dates?
  626. Using a variable to add fields to a pivot table
  627. Name Increment on Open
  628. Problem with getting numbers in some range values!?
  629. Excel and Powerpoint
  630. Disable command bar Excel 2007 and Vista
  631. Toggle Macro
  632. Importing a web page into Excel (picture)
  633. Checkbox Event Macro
  634. Help Can not Copy Sheet but Can add a New Sheet!!!
  635. Find text in between to knowns
  636. Create a list of hyperlinks
  637. how to monitor worksheet usage - using counter workbook
  638. Let property changing all values in Class module
  639. Transfer Writen Notes
  640. Creating Pivot tables dynamically from page filter values summary
  641. How do you delet all the defined range names in a excel file
  642. Add to Chart
  643. Cannot change Cell value
  644. Closing a workbook from a macro doesn't close the workbook
  645. Extract string after specific characters
  646. Progressbar on userform for waiting querytable retrieving data from web
  647. Testing for <Incorrect> Dates
  648. Alphabetic lookup within a pick box
  649. Help about macros
  650. Find and replace, or insert in VBA code
  651. Storing times in an array
  652. Removing Field Subtotals except for 2 from from PivotTable
  653. Mail Merge with Macros
  654. Offset issue
  655. 2.5 StdDevs
  656. Trendline Coefficients
  657. Copy Average Caluclations
  658. Combo Boxes - What to do first
  659. Extremely Urgent need to arrange data
  660. Problems with the OnWorkbookClose() Event
  661. Issue with For loop
  662. RunTime Error 1004? _Default Property?
  663. Relate a Number with an ARRAY
  664. Powerpoint chart -> Excel
  665. Sharepoint File Dialog
  666. How To Automate Copy Certian Cells from Worksheet A to Certian Cells Worksheet B?
  667. string size limitations for array formulas
  668. Help with type mismatch error
  669. Sum all search results?
  670. Strange RefEdit Problem
  671. Personal.XLS Prob.
  672. Code for Calendar control
  673. please help me program excel to scan for top 10 highest values
  674. Active Sheet
  675. Print Routine Error
  676. Memory Issues with Excel
  677. A real cut and paste
  678. Need help creating, manipulating and reading global arrays ...
  679. Retrieving Data: Speed of beating down rows vs retrieving from array?
  680. Can Excel "extract" ranges of numbers listed in the A column?
  681. Swap 2 ranges
  682. Help needed for old thread Please ??
  683. Excel / Access User Conference - Oct 24-26, St Loiuis
  684. Pivot Table Page Field (Repost)
  685. Delete rows where colums 4 is empty
  686. best solution for db
  687. Find a value and delete that row
  688. number cells within a range
  689. Sorting and Subtoaling
  690. Code Protection
  691. Global Book Protection
  692. count number of non empty columns
  693. Use the Excel LogEst-function at server
  694. Empty row
  695. Automatically add Conditional formatting on data/subtotals
  696. Add method of "Sheets" class fails
  697. make changes to excel workbook
  698. Newbie Error
  699. A) 2 Contiguous Popups B) The 'reverse' of .onaction
  700. "Scrolling with Scrollbar or SpinButton on UserForm"
  701. Looking for someone who could extract data from web-page to excel- with paying fee!
  702. macro to identify columns to hide
  703. Can I type text in one cell and have a value auto-enter in 2nd cel
  704. Numeric data only in text box on userform
  705. Custom Cell Format problem
  706. Health chart
  707. Print If Column Contains Blanks (No Characters)
  708. Read Network Groups Belonged To
  709. Roger Whitehead contact details
  710. SpellNumber
  711. VBA to lock & send multiple workbooks into Essbase cube
  712. Why R1C1 range parameters in VBA Pivot Table setup/
  713. 3 combobox.values to one cell
  714. Auto filtering pivot table field
  715. Do Not Load if Not Using Auto-Execute Macro
  716. Cells Protection
  717. Shift cells to the left
  718. Help!
  719. Select Variable Number of Columns
  720. Messing Up on AutoFit
  721. Biff8 standard encryption(office 97/2000 defalut encryption way)
  722. Biff8 standard encryption(office 97/2000 defalut encryption way)
  723. multicolumn listbox
  724. filling web forms from excel
  725. NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON
  726. Unhide roes in a different worksheet - My code is not working
  727. strange problem with public variable
  728. Excel fornual to delect rows
  729. copy range with different ranges.
  730. Webbrowser control not loading Html string
  731. New rows overwriting existing problem
  732. Copy last row from sheet 1 to last row in sheet 2
  733. Copy and paste file name
  734. Macro creates formula with $ absolute. I want to drop the $
  735. Basic Macro Question (Urgent!)
  736. Excel 2007 VBA/Vista - How do I deselect a selection programmatica
  737. Create a shortcut to a folder with VBA
  738. Copy from Sheet 1 to Last available cell in specified column
  739. find and delete
  740. Filling In Cells Using Lookups Via VBA?
  741. VBA to lock & send multiple workbooks into Essbase cube
  742. PivotTable question about grouping numbers in it
  743. Shorter Code
  744. reset ALL checkboxes (created with control toolbar) with the click of ONE BUTTON
  745. NEED VB FOR PASTING THE CELL REFERENCE
  746. Heading for Report from UserForm.
  747. How to us macro for designing a statistic table (i.e soccer score table) auto update after i enter the game result
  748. VB program for excel sheet
  749. Adding Validation When Source Validates To Error?
  750. Join text and 2 dates in A2 column in worksheet