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. Get Range object from Cell Row and Column No.
  2. User Account
  3. Calculating calendar days and completion dates.
  4. Checking specific text string in excel files stored in a folder
  5. How to activate a User Form
  6. Problem using Match on columns of numbers with leading zeroesformatted as text ???
  7. active worksheet
  8. Populate User Form Text Box from Worksheet?
  9. Merging row data in Column A has duplicate.
  10. Select range from ActiveCell do to Lastcell in ColumnA
  11. Select range from ActiveCell do to Lastcell in ColumnA
  12. Using Variables in Two Workbooks
  13. How to use structured reference (ListColumns) in VBA
  14. Printing multi-page and multi-orientation excel tab to PDF
  15. Fill column question
  16. How do you set up backround with multiple pictures?
  17. Checkbox activate Combobox selection
  18. macros disappear in Excel 2003
  19. Copy part of text file
  20. Dynamically Adding Textbox Control To Frame Object in VBA (Workshe
  21. Can someone explian to me what this line of code does?
  22. dynamic reference to data in multiple closed workbooks
  23. Minimum row height
  24. Excel Date format changes
  25. Place a cell value on Charts
  26. Configure macro to run on all sheets Excel 2k7
  27. For Each loop doesn't work on First Pass, only on Second Pass
  28. Picture AlternativeText property Equivalent in Excel 97
  29. Color fill based on multiple conditions
  30. Fill with Gray if Column b is bold
  31. Macro to Check Dates
  32. months to full calender year
  33. Minimum row height
  34. Re: collect data automatically from a folder
  35. Auto row fit height
  36. Wildcards and Looping
  37. paste values without copy-paste values
  38. test for exernal links
  39. Send email from excel to notes - save email in sent folder
  40. Strange error message when loading a collection with an item of userdefined type
  41. Copy row when value NOT found?
  42. TODAY() and NOW() being reflected as zero
  43. Show Activecell Date in MsgBox
  44. How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE?
  45. Macro for Special Sorting
  46. Sorting with VBA (Tough)
  47. LookUp If Greater Than and LessThan
  48. How to handle dynamic Array properties in a class module?
  49. column copy
  50. Best Method
  51. Populate combobox
  52. Bubble Sort failure, Strcomp with binary compare
  53. Need help with chart formatting
  54. Remove characters
  55. Used Range and Source data of a Pivot Table
  56. Selecting from a randomized list
  57. Changing tab color locks the worksheet
  58. Word wrap and height
  59. User Select File on Import External Data
  60. userform in the VB environment
  61. PDF document that has Text Entry fields
  62. activesheet error
  63. Marking found records in Workbook A from Target List in Workbook B
  64. Trying to write a query
  65. Project Window does not refresh?
  66. Make Worksheet Deactivate Event only run once
  67. Problem creatting charts with VBA
  68. Novice question: I cannot get the immediate window to work
  69. Autocomplete
  70. how do i include an excel formula in a vb string?
  71. Convert Date-as-Text
  72. vba excel 2007 data mining
  73. Code to copy worksheet
  74. statistical database attack verses defense for online game
  75. How do I sort worksheet without affecting formula values?
  76. Lost a radio button on a sheet
  77. allow sort and filter on protected ss
  78. VBA Excel Macro worked for 2-years now dosen't??
  79. Auto complete a row
  80. AutoSave
  81. Carriage return character shows in combobox
  82. Is there a work-a-round i can use for making a datagrid....
  83. link in macro
  84. GetOpenFileName
  85. Excel button problem
  86. Save
  87. Choose folder with largest filename number
  88. Re: Dynamic Price Change Calculation
  89. LinkedCell
  90. ADO - Access to Excel
  91. Conditional Formatting of Percentages
  92. FYI: Microsoft admits Office patch gaffes
  93. Can't create recordset to populate userform combobox
  94. Data Validation Lists - Generating a list based on another list'sresult
  95. Open a file in another Workbook
  96. How to get notified when inserting cells, rows, or columns in Exce
  97. Repost - checking date of latest Forefront updates
  98. Re: Dynamic Price Change Calculation
  99. VBA: Paste in a range
  100. mstsc from hyperlink
  101. Excel VBA ?
  102. Re: Stumped on Object Variable not set
  103. Start a macro from a change in a cell value made by a formula?
  104. VBA-recovering a broken link
  105. Notify user macros are disabled.
  106. Excel events appearing unexpectedly
  107. Merge multiple worksheets into one
  108. controlling chart location
  109. Trouble with modifying cell right-mouse-click context menu
  110. Re: Stumped on Object Variable not set
  111. find mac address of my own computer by excell macro
  112. Novice q: allow user to select worksheet in middle of macro
  113. Change Selected cells references
  114. Activate Windows explorer
  115. Re: Stumped on Object Variable not set
  116. #Value! cell
  117. UserForm as Reader
  118. Setting column width on different computers
  119. worksheet_change becoming active just by entering the cell
  120. Change a default Excel warning
  121. Click on a Pie Chart
  122. Editing a Chart on a protected worksheet
  123. Using data from cells in a Query to a MS Access Database
  124. Opening Text Files and Re-Saving Them
  125. wkbModel.wb_Activate
  126. Find last user of computer from ActiveDirectory using Excel/VB
  127. Excel 2007: Formula bar text flicker, can't access other openworkbooks or close Excel.
  128. How to hide macro so as to protect them from editing
  129. Merging all the sheets in the folder
  130. Forgotten password
  131. Re: VBA Passwords - security
  132. Determine when Enter Key is pressed in a sheet??
  133. Buttons re-assigned themselves to the right macro name but in Book
  134. Folder location for Addins
  135. VBA Passwords - security
  136. Paste to next row if cells are not empty
  137. excel 2010 question regarding determining the last row
  138. Formula causing run-time error
  139. Would like a more efficient way to Copy/PasteSpecial
  140. Select contiguous cells by ActiveCell.Interior.ColorIndex and applyborders
  141. Passing Parameters to a Pivot Table
  142. colorscales, icon sets, and databars referring to remote cells
  143. Maintaining variables after program ends
  144. Macro to copy and populate an egsisting ssheet and save it.
  145. Syntax Error Help needed
  146. .StandardHeight property
  147. Convert date (m/dd/yyyy) in text format into an excel recognised date
  148. Referencing Chart Data?
  149. VBE Toolbars and Windows
  150. Clear contents of last two rows of data on sheet
  151. code for Allow Insert Hyperlink
  152. Is there something wrong with the random generator in Excel?
  153. Excel
  154. Connecting to Access database to populate a combobox.
  155. In VBE, how can I set a date format different than the system date
  156. Macro code mod - add tabs/apply to entire workbook
  157. Calculating relationships in table
  158. Compare worksheets
  159. VB to specify criteria then paste to a new worksheet
  160. Freezpanes address - apologies for incorrect post
  161. Referencing other Office programs in a Excel VBA App
  162. Simple shared code library, also how to find spreadsheets with macrosin them
  163. Genrate random numbers using the binomial distribution
  164. Problems in copying a Collection to another and removing elementsfrom two Collections
  165. Programming involving applications other than Excel
  166. MsgBox instead of compile error
  167. Is it necessary to Set a Object to nothing before referencing itagain to some other object?
  168. Delete duplicate rows of data
  169. Saving files automatically
  170. Message box warning of missing data
  171. Replace Worksheetfunction.ln code
  172. Select range from ActiveCell do to Lastcell
  173. Highlight
  174. How to know the correct height of the row
  175. Re: Adding date and time to cell programatically?
  176. Msgbox if cell is not a value
  177. change date format to excel format
  178. Select specific worksheets & copy - code problem
  179. Copy cell range to another sheet
  180. Error Handle problem
  181. touch screen apps
  182. linking cells in a column (result) to cells in a row (source)
  183. Pasting to Cells to the Right.
  184. How do I use Filesearch now that it is hidden in Objects
  185. Suspend Scrolling in a split pane
  186. Odd behavior using CONCATENATE
  187. Control to pick time?
  188. Printing of option buttons
  189. Check if value does not exist in range.
  190. Macros Help Needed, Thanks in Advance
  191. Searching question
  192. Repost - checking Forefront updates
  193. name manager?
  194. Copying Data from a workbook to another workbook
  195. PivotTable: formula for added & removed
  196. Pivot
  197. Lost locals and watch windows
  198. BeforeDoubleClick Event not working
  199. How do I make a Binary Search Algorithm on Excel?
  200. Personal.xlsb problems
  201. Create OptionButton at run time
  202. Delete ' from date
  203. not like syntax in querry not working
  204. GetSaveAsFilename
  205. How to print with a gap in the middle of a sheet
  206. Conditional Formatting VBA Multiple Numeric Ranges
  207. Modeless User Form Is Blank
  208. VBA-Protect Row
  209. How do I add numbers in two column based on the date in another?
  210. Select range from unopened workbook
  211. update in the workbook by different users
  212. Find Value in Workbook
  213. Out of context error in user defined function
  214. WorkBook Custom Properties
  215. Sumproduct formula needed
  216. Dependents problem
  217. How to reset the range name to refer to another cell?
  218. Special problem deleting a folder
  219. Call Stack Available ?
  220. Spliting Names
  221. ShowDetail
  222. Convert decimal digit to integer
  223. Excel Crashes when trying to open a User Form
  224. Need help with VBA help
  225. Unprotect Workbook with Function
  226. Why does column revert to date format after setting to numeric for
  227. ComboBox and rowsource from an external sheet
  228. Structured Table Refs in VBA
  229. if / then structure with macros
  230. Manadatory break after 10 days of work formulae
  231. Manadatory break after 10 days of work formulae
  232. Re: Need a accumulator driven from second cell
  233. Reliable send keys
  234. WorksheetFunction Calculation Error
  235. Error 1004-application or object error
  236. Chart datalabels linked to cells
  237. Command Button in Excel 2007 Chart
  238. Modify code from paste values to change font color / multiple rang
  239. Excel TextBox Control
  240. Launching from IE
  241. API License
  242. Error 2007
  243. Help with Microsoft.Office.Interop and c#..........
  244. vLookup with comma break
  245. If statement in macro to find blank cell/value in another cell
  246. Problem with Worksheet_SelectionChange
  247. Excel 2003 VB referencing #N/A not working but works in Excel 2007
  248. Custom XLAM tab not showing up when excel is opened from word
  249. How to add a worksheet from template without duplicate cell styles
  250. Retrieve part of a calculation
  251. RE: reading data from .xls file
  252. Re: Password for running Macro
  253. update sheet with data at bottom of present data
  254. Freezing Header Row
  255. Userforms with CommandBar Popups
  256. Link Drop Down list with Pivot Table
  257. Inconsistent behaviour of attributes accessed through structured r
  258. UserAccounts.CommonDialog - How it works
  259. Excel instance isolation problem
  260. Manipulate filtered data
  261. SFTP
  262. Timer to detect idle time?
  263. Adding daily updates to other master sheets
  264. Enter event in textbox control?
  265. Situation when file is "read only"
  266. How to code macro to import web link and avoid frame within HTML?
  267. Last used row within filter
  268. VBA code to paste data based on condition
  269. compare value of cell in one sheet to range of another sheet
  270. Calculations not keeping up with macro
  271. Responding to Keypress event on a sheet
  272. using formula =sum('*'!A1) in a macro does not work.
  273. val() is not work in my code
  274. VBA, refrencing a range
  275. Distorted display in spreadsheet apps
  276. conditional formatting of cells based on result in hidden cell
  277. Excel 2003 vs Excel 2007 #N/A in VB
  278. How do I insert a row ...
  279. Copy/Paste charts , ranges in PowerPoint
  280. How do I find text among multiple worksheets and return the cell .
  281. 2007 Excel Issues
  282. 2007 Excel Issues
  283. Problem with pasting special merged cells to merged cells
  284. Select One
  285. Find records that belong to a combo box value
  286. Save As Webpage - include my own HTML??
  287. Re: userform - list of clients without repetitions
  288. HELP: error handling in VBA
  289. Part protection of Excel 2007 tables
  290. what is the mime type for office 2003 xml formats?
  291. Sub or Function not defined
  292. How can I size merged cells to fit the needed rows of text?
  293. Disable functions on command bar
  294. Honoring page setup of each worksheet
  295. return checkbox value
  296. Do Until Macro
  297. Add text per user input
  298. Compare Two Workbooks
  299. Excel 2003 VBA Editor Context Menu won't open on right-click - Hel
  300. Save to SFTP not working.
  301. Search a range of cells for a specific word
  302. formula help
  303. Autofilter for fixed columns
  304. Selecting two different columns in excel using VSTO
  305. Personal.xlsb counts as a workbook, can I "super" hide it?
  306. Spin Button Programming
  307. Pivot Table Show Detail
  308. How to incorporate 2 sets of changing named ranges
  309. Date find Macro
  310. True/False Checkbox
  311. ADO query eating CPU power
  312. signing VBA Macros for Excel
  313. Hiding a userform properly!
  314. How to Loop?
  315. VB Editor Window
  316. Dealing with unknown array sizes
  317. How to reference a cell into a Dialog Box ?
  318. Copy rows with values in sheet 1 to next empty row in sheet2
  319. Drop and Drag Cell Data
  320. Excel 2007 returns data as 2007 table instead of range - how to turn off.
  321. Copy & Paste cells dependent on value
  322. Excel 2007 Object Model Map
  323. Re: Using a macro for a user-entry password - hiding the entry
  324. Re: Using a macro for a user-entry password - hiding the entry
  325. no change pivot item.
  326. RE: excel
  327. Input distanct from a map into excel
  328. Combo Box - Form Control
  329. Clearing cells but also not clearing other dependent cells
  330. Chart Problem
  331. Excel crashes on close
  332. Search CSV for string.
  333. record sheet row order, then restore to that point
  334. Macro Running very slow
  335. Clip art in Excel 2007
  336. Macro continues to run
  337. Macro with an IF/OR statement
  338. Determine who last modified an Excel file????
  339. refreshing combo box in form?
  340. Looping through visible cells
  341. Query using list of parameters
  342. List unique items
  343. How populate multi-column Listbox control?
  344. dictionary->(item, item, item); Can dictionary point to an array inVBA?
  345. Check for data in cell
  346. Move macro to Personal.xls
  347. -->edit -->clear -->all; Can removed from standard menu?
  348. Excel Application Warinings and Errors
  349. Can I have default data in new rows?
  350. RE: Find out, if test doesn't fit in a cell
  351. RE: Find out, if test doesn't fit in a cell
  352. Custom Header Aligment
  353. Placing Icons
  354. UserForm updated
  355. Listbox headers
  356. Data Entry to a Cell Range
  357. measuring waves in the currency market
  358. Apply format to >0 cells
  359. Select a specific row in named range
  360. XML File
  361. Bypass error message to debug
  362. Change code to look at a range of columns not a single column
  363. how do i link spreadsheets on common data points?
  364. i want to input data into a range from a simple input location
  365. Listbox questions
  366. Inserting additional rows and only copying certain columns
  367. Converting MS query from Excel 2003 to Excel 2007
  368. Task Scheduler or VBA to simple copy periodically folders contents toexternal drive
  369. find and replace multiple values in one statement
  370. Sheet Numbering Routine
  371. VBA solution to paste text into megred cells
  372. Working with Both Excel 2003 and 2007
  373. pagesetup.printarea Print non contiguous areas # rows varies
  374. pagesetup.printarea Print non contiguous areas # rows varies
  375. Convert Column Number to Column Letter
  376. Help with modifying a formula.
  377. Create a new worksheet and name it
  378. Trapping value before and after change
  379. Formula on two or more lines
  380. Funds allocation by Calendar Year
  381. Working with GroupName in a control
  382. Sort 2 dimensional Array, copy a row
  383. Moving rows in Macro/If statements
  384. The best way to build your own VBA library
  385. Using IsError with Match
  386. Create multiple Pivots based on list of parameters
  387. How to initialize a multi-dimensional array
  388. combobox after change but user hits cancel to message box
  389. Line break from vLookup
  390. VBA to insert date string
  391. i want to input data into a range from a simple input location
  392. Using VBA to gradually change cell interior colors...?
  393. Test Search For: function this community abcde
  394. Month & Year Text to Date Format - Help Please
  395. Strange Range copying
  396. Fool Proof Price Validation Custom Function
  397. What does the Userform.Tag do?
  398. Hlp! Adv Filter - Non-Contiguous rows don't copy
  399. Automatic conditional formatting from a list
  400. Find Next Row With No Value In It - But Not Next Row With No FormulaIn It
  401. How do I save external data in Excel?
  402. Suppress "Opening File" Alert
  403. Sort with subtotal
  404. Repeat the macro using different ranges
  405. Check column header value
  406. Please help me solve my problem
  407. what is the formula for what I want to do
  408. vba Function code
  409. Program stops (creating pivot table) when too many records
  410. Find then paste
  411. Match the value and highlight offset
  412. object required
  413. Using Date as a Variable
  414. formulas
  415. Centered Overlay Title in VBA
  416. Application-defined or Object-defined-error when changing color in
  417. inserting columsns variable range
  418. Spell Checking on a protected sheet
  419. Message still appears with DisplayAlerts = False & SaveChanges:=Fa
  420. help with dates in the past
  421. macro copy and paste criteria
  422. Web query - one table multiple pages of data
  423. Bluecoat
  424. Checking latest Forefront updates
  425. Display Print Dialog with Selection: Excel 2003
  426. Open a file and execute code
  427. How to execute a dynamically added or changed module
  428. Data Validation -> Validation list is larger than the cell width
  429. Excel runs slow
  430. Info in F but AF and/or AY no info so delete the rows
  431. Retrieve File Names in Directories
  432. Select a file to open
  433. create pivot chart in vbscript
  434. Re: ScrollIntoView Non-Selected Cell ..?
  435. Call
  436. Re: ScrollIntoView Non-Selected Cell ..?
  437. Need help to read Pie Chart Series Range
  438. Exporting PivotCharts and PivotTables from a workbook without"breaking" them
  439. Dates converted into text
  440. Date format problem
  441. Date formatting
  442. MS Excel 2003 - Advanced Features Add-In
  443. "implant" ActiveX ComboBox value into if eq'n
  444. set scroll property of ActiveX combobox in spreadsheet
  445. Re: Error trapping not working
  446. Macro Compatibility between 03 and 07
  447. VB list box print reports. Known # of columns. # rows unknown
  448. New to Userforms - need return value in a cell
  449. SumProduct basics
  450. Loop Overwriting
  451. Dates prior to 1900 are text
  452. VBA code for VLOOKUP - linked to another workbook
  453. Macro or Formula
  454. VBA online classes
  455. Code to Create Chart
  456. Userform with commandbar popup
  457. Count Conditional Formatting Colours - Excel 2003
  458. Use VBA to update Access table or Query from Excel
  459. RE: FileSystemObject: how to tell how my files were copied
  460. Macro
  461. VB and graphs
  462. Excel not opening properly when exported from Sharepoint
  463. Auto Enable Macro
  464. Worksheet_Calculate
  465. populate combobox from worksheet in different workbook
  466. How do I find a column number for a cell containing a value
  467. Re: Unhide Columns With A Password
  468. conditional formatting
  469. Copy Data From Varying Lines to One Sheet
  470. Stop macro
  471. IIF statement to hide a graphic
  472. VB Excel Macro
  473. help extracting data from 3 text files to csv
  474. view list of named ranges
  475. find and remove page breaks
  476. 2007 Excel vs. 2003
  477. Entering data from a userform into multiple sheets
  478. Insert Rows if Pasting more Than 1 Row
  479. add years to a cell
  480. Calculating age at different points in time
  481. Date VBA
  482. Visual Basic Editor Opening and Closing for User
  483. ? Index of Names
  484. Updated Links
  485. User Public Type, circular dependancy error
  486. toggle read only
  487. Can you automate the ALT+ function?
  488. 3 month rolling totals
  489. Re: Excel 2003 VBA program kills itself in Japan
  490. Sort code doesn't work on first pass, works on second
  491. rounding to nearest .5 in vba
  492. bizarre formatting issue
  493. loop until vlookup true
  494. Axspreadsheet datasource
  495. Nested loop Programing Challenge
  496. Split cells VBA
  497. Loop thru used rows in column
  498. VBA code for copying part of a sheet to another, with column widthsand formats
  499. RE: File status = "read only"
  500. If greater Then
  501. Printing Via By Macro for Network Printer
  502. Selecting items from list and attaching ratios to selection
  503. Combobox linked to Custom Views
  504. Check if webpage is open
  505. Private Sub Workbook_Open()
  506. Convert Case
  507. Convert Cells to uppercase
  508. Programatically open Access DB with user level security
  509. How to show a message box ?
  510. Dealing with windows 7 folder structure
  511. input numbers for code
  512. Problem with Word 12.0 Object Library
  513. remove vb project
  514. show column headings
  515. Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A
  516. drop-down for entire column
  517. Run-time error ‘13’ mismatch type
  518. vba help issue
  519. Identify last date of a specific month
  520. Passing a string to a function instead of a cell reference
  521. Update individual worksheets from Master Worksheet
  522. auto open from any folder
  523. SQL query in excel (VB) using multiple parameters
  524. Paste data from AJ to K
  525. User Form Text Date Format
  526. Formula Help
  527. Number Format with Macro
  528. Copy/Paste Values code
  529. print labels from userform
  530. vb to Unselect a Filter Value
  531. delete ghost spaces
  532. Marco to copy and paste values based on cell value (cont)
  533. Practical Jokes in Excel?
  534. Subtotal multiple columns and ...
  535. Editor Window
  536. Can I use an IF ELSE statment
  537. Update pivot table report filter using cell value
  538. Multiple Forms for Data Entry; re-loading data
  539. Match Ranges problem ,
  540. shortcut for same directory
  541. RE: File status = "read only"
  542. selecting qty to print via textbox entry
  543. Looping
  544. Code so that worksheets cannot be added to workbook
  545. change cell value by code
  546. Printing App
  547. alternate sort on different columns
  548. locate add-in
  549. To disable pressing of Enter key on a sheet
  550. Problem with VBA code not running in Excel 2003
  551. Help with creating drop down
  552. What is Selected?
  553. Autofilling Cells for Daily/Hourly Schedule
  554. xltm saveas xlsm
  555. xlookup & paste a picture
  556. even the codes in microsoft's help section don't work
  557. XL2003 - CreateObject("UserAccounts.CommonDialog")
  558. Excel converter download
  559. Does a workbook become fragmented after much editing?
  560. Startup Notepad from Excel???
  561. Re: Excel macro filter Like keyword
  562. Data Array Not Calculating???
  563. Change Shape text / Color
  564. Extend Custom function
  565. Save command before emailing workbook
  566. Macro to copy paste values based on cell input ...
  567. copy named range & paste values
  568. Parse only text from column?
  569. Copy a worksheet
  570. HELP modifying macro to delete rows if more than 1 condition met &
  571. find sheets with by part of name
  572. Macro to change pivot field with latest value
  573. How to disallow a zero value in an array
  574. copy active row and repaste values
  575. drop down list for IF equation
  576. Excel 97 replace vs newer versions...
  577. Remove lines from text file prior to importing in Excel
  578. Extract only text from column
  579. "Undo" creates bizarre behaviour
  580. Excel worksheets auto-incremeting question
  581. mark active cell and return to paste
  582. VBLOOKUP BY DEPT
  583. Insert Row without changing formulas
  584. Does Excel Support the VB List Class?
  585. Filter/Display only certain rows of information based on a user na
  586. Moving an active cell
  587. Delete all rows except...
  588. Password Userform Help Please
  589. VBA Select File
  590. Pasting into an active cell
  591. Pivot: grand totals
  592. auto generate sheets in a workbook from list using a master sheet
  593. Checkbox linked to calcs
  594. use command button to total datas in cells through VBA codes in ex
  595. Remove duplicates from list using code
  596. Distribute macro to users
  597. XML generating excel charts
  598. Checkbox linked to calcs
  599. Text in cell is not visible! 8(
  600. Check to see if a formula is correct
  601. Collating stock market data
  602. choosing cell to top left of visible window
  603. Test named range exists & exclude worksheet if it doesn't
  604. SendMail
  605. Automatically Sorting of Excel Records (Macros)
  606. MSCOMM Control with Excel 2003
  607. truncate date; nix the time component
  608. VeriSign Digital Certificate Failure?
  609. macro to continue running if error
  610. Excel VSTO pivot table code revision help needed...
  611. cpu usage when excel is in taskbar
  612. Conditionally disabling activex toggle buttons
  613. Automatic increment of onTime
  614. VBA code to find first blank cell in a column and activate it
  615. VBA code to "skip" empty rows
  616. Entering Values in a Single Cell to Update Next Empty Cell in a Ra
  617. Detect if Excel file is "read only"???
  618. Another '03 vs '07 Add-in Menu Question
  619. data validation, mouse action of select... then move right
  620. Shorten multiple sumifs
  621. better way to copy data from an embedded html box
  622. Macro to Insert Worksheet with Worksheet Name the Current Date
  623. Error: Microsoft ODBC Driver Manager Data Source name not found
  624. Shift Roster on Excel, pls help
  625. define range using col and row names; not cell name
  626. Import selected worksheet from another workbook
  627. VBA forms in excel
  628. using a command button in excel
  629. Filter Column
  630. Object Heirarchy Chart
  631. Using named ranges in macro
  632. Right Click - Disable item
  633. Copy Values From Wbk1, Outlook Them To Another PC, Paste Them IntoWbk2
  634. Vlookup help needed
  635. How to create a folder & error handler
  636. Hide Rows based on Combobox Selection
  637. Queries created by MS Query not in QueryTables collection
  638. More Useful Row Autofit
  639. Macros in PERSONAL.XLS
  640. Returning a named range source reference
  641. Userform Command Button
  642. Create shape, name shape, add text to shape
  643. Select, copy, insert, then paste.
  644. Accessing Autofilter Lists
  645. freeze panes from vba
  646. Passing Userform Control to Subroutine
  647. Printing App
  648. Macro to Delete Rows if true HELP!
  649. Sort function
  650. #VALUE ERROR
  651. VB: Convert rectangular clusters of # within field: FindNext, Find
  652. Do not calculate or update formula's during macro
  653. Compare row contents to baseline data
  654. Macro/VBA to loop through list of values and output row- Help Need
  655. Who do you read an ini file with Excel VBA?
  656. mouse pointer to be focused on userform command button upon opening
  657. Trigger Event Sub when A1 <> B1
  658. Upload file to SharePoint from machine with CAC
  659. Search for strings listed in column - Excel 2007
  660. Re: cell.value comply with cell.value before and cell.value after
  661. Finding Duplicate Entries - Saving Worksheet if none found
  662. VBA - ThisWorkbook
  663. Multiuse (Single Instance) or Single Use (Multiple Instances)
  664. Payroll,formulas and Macros?
  665. Side Filter
  666. Filters - sort state
  667. Lots of text in one cell
  668. Multiple tabs in 1 worksheet
  669. vbcrlf question
  670. Change Data Connection Definitions from local to sharepoint
  671. Macro needed Fortran to VBA
  672. Need Macro Fortran to VBA
  673. What is the right syntax for vlookup in vba?
  674. Reading a textbox ole/control
  675. Changing page height while in a multipage
  676. Impossible Macro?
  677. Enter data on one sheet and copy to others
  678. Autofill Data
  679. Resetting the chart count
  680. Type checking from VBA to C++?
  681. Links Based on Cell Values
  682. Unfilter a sheet which is filtered
  683. Name A Range
  684. list box controls - text property
  685. Validate to quarter units
  686. Data Validation for Prices in Cells
  687. prevent user from deleting a tab prevent running macro from menu
  688. Find a text
  689. Can't figure out this PasteSpecial error message
  690. number stored as text
  691. Sorting a protected worksheet
  692. Command Button Macro to Expand/Collapse Grouped Columns
  693. Need to make sure workbook is open before proceeding
  694. Macro Needed
  695. How to check if a certain function is used
  696. module not accessable
  697. excel vba language refernce manual
  698. Concatenate cells from M9 to Last row in M
  699. .Formula vs .FormulaR1C1 in 2007
  700. Disable autocorrect in active worksheet?
  701. Can some one modify the thirdfriday code to get me the following d
  702. Import MS Word 2003 Table to Excel
  703. what is wrong with this formula
  704. Move data from Doc1 to Doc2, end with 2nd doc open
  705. List ALL folders and files
  706. Rolling Total
  707. Rounding 2 decimal Places
  708. Autofill
  709. Minimum function in a list
  710. Certain string in cell A1 causes a change in Cell B1
  711. Can you write VBA to export objects
  712. Subscript out of Range problem Copy Cell from one workbook to anot
  713. I need to change from "=E7" to (equals the current value of E7)
  714. Finding the minimum value in a list but excluding zeros - a variationon an old problem
  715. VBA Loop If statement
  716. excel user form
  717. Nested Ifs VBA, How to
  718. Search options
  719. VB to search a value in an array from a sheet then write another c
  720. Copy and paste range ontime
  721. Unexplicable error
  722. Convert Macro to custom function
  723. Grouping Rows
  724. Copy data from one sheet to another
  725. Why use tables??
  726. Data Validation, Via A Formula
  727. Conditional Format With Wildcard
  728. Round to 2 decimal places
  729. Modify RDB's Copy filtered data code to loop through multiple shee
  730. I'd like to modify mt Macro ...
  731. Immediate Window Can't Be Viewed
  732. Calling a module from another module
  733. Combine multiple sheets within workbook
  734. Loop to retrieve value in worsheet A and put into worksheet B
  735. Deselect cells on multiple sheets after unhide
  736. Retrieving current custom sort settings
  737. Database to Excel REF#!
  738. Find Highest Score In List Formula
  739. Suggestions to start programming in Excel
  740. hiding row if the cell is found in a differeent column
  741. Re: Exporting Data to Excel
  742. Re: cell.value comply with cell.value before and cell.value after
  743. Resize Excel Window
  744. disabling specific items under tools menu
  745. Exporting Data to Excel
  746. VBA Programming help
  747. Optimization Modeling with Excel Solver
  748. Projecto VBA
  749. Input specific value into cell if Row has data
  750. Formula for Counting Two Characteristics in Separate Columns