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. RE: Macro that concatenates content from cells if given keyword is fou
  2. Insert a code
  3. BorderAround Method
  4. Problem inserting cut range
  5. Excel 2007 'Copy as Picture' doesn't paste at 100%
  6. Sort data to show in a series 1,2,3
  7. Excel 2003 VBA Phantom Breakpoints
  8. String search
  9. Append Worksheet name to each begining of each row with values
  10. Run-Time error '13': Type mismatch
  11. using countif function in code
  12. Shift key doesn't stop Auto_Open() from firing
  13. if statement with or
  14. Macro to Exit Worksheet when vbNo selected
  15. Allow VBA code to change a locked cell??
  16. Delete Named rnage and Add Named Range
  17. Loop IF
  18. macros disabled
  19. Sheet Codenames
  20. Chr$
  21. from mdf to excel data export
  22. A coding style question
  23. Macro to check if current cell value is 1 and previous cell was 0
  24. Vertical Center Alignment for Labels
  25. Capturing "text" instead of the formula
  26. Adding code right after the "Save As" dialog box
  27. Copy/paste speed
  28. Shorting a long title to a worksheet tab
  29. Memory Issues with UserForms?
  30. Message Box - Formatting Question
  31. Take Up A Collection
  32. RE: Need macro that deletes B columns in all sheets
  33. Mixing data from 2 different tables
  34. select range in column, calculate on range plus 3 columns, output inrange plus 7 columns
  35. Delete a sheet and delete a module in Another Worksheet then save
  36. Any more effective method to get selected item in Listbox?
  37. Error handling in VBA
  38. len replace function
  39. Application.enableevents = false not working in workbook open even
  40. RE: Need macro that deletes B columns in all sheets
  41. UserForm show mode
  42. Merge data from sharepoint workbooks
  43. Dynamic Named Range
  44. Re: Need macro that deletes B columns in all sheets
  45. Visual Basic library?
  46. Lookup item in table/one of many columns to return value in first column
  47. mapping columns
  48. Can Excel startup Word?
  49. Return Primary Key
  50. Copy from one Sheet and Paste to Another
  51. Input box replace text in textbox
  52. Open files with same name?
  53. Find number in Row 1, Copy Paste Values in Rows below
  54. Cannot use recordset twice with copy From recordset
  55. Hide Screens While Macro is Running
  56. Check to see if cell is blank
  57. Pivot Table Errors
  58. Exporting issue to excel 2007
  59. Where is VBA's BeforeSheetChange event?
  60. Checkbox in Treeview control
  61. HELP copy and paste
  62. HELP: Auto Populate Excel Userform fields from access query result
  63. Change cell color after processes - type mismatch
  64. Data mining question
  65. Check if clipboard is empty before pasting
  66. Import Modules
  67. Suppressing questions in Excel Macros
  68. error while running macro, but not if stepping through lines.
  69. Problem with If,Then, Else
  70. Comparing values in a cell and looping
  71. Addin - Look for a File when it is opened
  72. C# Excel 2007 workbook application with VSTO Problem
  73. How to check programmatically if Excel is installed?
  74. Compile Error: Procedure too large
  75. EOF behaviour
  76. Excel 2007 VBA shape fill colour problem
  77. Calculating(Processor(2)): %
  78. Slow Macro
  79. Moving an ActiveX control
  80. Vba code cannot select text pasted from .txt file
  81. Monthly Report
  82. Disable close unless key held
  83. Search any part of an Access recordset from Excel
  84. mporting multiple text files into Excel with corresponding filenames
  85. Everchanging number of rows
  86. Vlookup
  87. Getting the next higer value with Vlookup - True
  88. find idmso custom tab in ribbon
  89. Macro that unhides a sheet and takes the user to that sheet
  90. importing multiple text files into Excel with corresponding filenames
  91. Dynamic Array for data consolidation
  92. Share Portfolio - Averaging the Cost per Shareholding
  93. Trouble with open workbook code.
  94. How to separate Excel Workbooks into new files
  95. Paste Value Toolbar Icon
  96. Re: Passing a Parameter to the workbook open macro
  97. open text file, get file from directory, update file
  98. variable for percentage
  99. Run Time Error on trying to save workbook
  100. XML in Worksheet w/o Looping
  101. Charting multiple graphs from a list on another worksheet
  102. RefEdit in UDF ?
  103. Need a way to verify a string is present in 1-column array?
  104. Advanced Filtering
  105. On/Off control?
  106. VB Script XL - Range Selection
  107. Is it possible to assign fonts using formular?
  108. Calculating(Processors(2)): %
  109. Read only issue with Windows XP Service Pack 2
  110. Implement a progress bar when the macro run inside another workboo
  111. Vartype, range uninitialized ? Feb2010
  112. Compressed seq data, again. I want to pay to make it work.
  113. #Value in FormulaArray
  114. Display value of a VBA variable inside a cell
  115. Macro code to clipboard
  116. Breaking User Form Code into modules question
  117. How do you add data entry grid to a form(UserForm) in Excel 2003?
  118. Call oNet.MapNetworkDrive(sDrive, myFolder, True) no longer workin
  119. Compress seq data from txt-file into 15 min chunks in another file?
  120. HELP: Populate Excel FORM from Access - Pull from multiple rows
  121. Combine columns from seperate sheets into new sheet- macro improve
  122. formula to place real time in a cell when data entered in an adjacent cell
  123. Generating random numbers from a given range
  124. An alternative to Target.EntireRow
  125. Copying recordset multiple times using copyfromrecordset
  126. Detecting an orphaned Excel.Application
  127. Uer Form Window resizing according to Monitor
  128. Cursor color
  129. How do I highlight certain results in an excel formula?
  130. setting defaults for multiselect listboxes
  131. Calendar Form Update
  132. Right icw getfromclipboard
  133. cell content change so...
  134. macro triggered by changes to cell only works if i run it twice
  135. Format time to hh:mm? and 24h?
  136. Excel - Auto update of daily web data into excel
  137. stop numbers auto rounding
  138. Grouping dates in Microsoft Query
  139. Create a macro to re-create a format?
  140. Typemismatch when duplicating graph
  141. can we copy the code from the addin to excel workbook
  142. how can we embed the code to the excel workbook from addin
  143. Hiding and unhiding rows
  144. Adjust data range without opening multiple excel files
  145. Re: Dynamic range w/in formula in macro
  146. Help with this macro script on single results.
  147. Option Box on user from to update workbook
  148. Page Format lost while saving to html
  149. file chooser
  150. Macro to delete rows
  151. How do I find the currently selected Scenario?
  152. How to load page with specific date?
  153. Conditional formatting code that looks up a list of criteria
  154. Can Sharing Workbook Corrupt Sheet Password?
  155. Can Sharing Workbook Corrupt Sheet Password?
  156. Locked cells
  157. Bypassing password protection in Visual Basic
  158. BILLING ON EXCEL
  159. Counting blank cell issue
  160. vba project explorer
  161. Getting FileSystem Date
  162. HELP PLEASE: populate form fields from multiple access tables
  163. HELP PLEASE: populate form fields from multiple access tables
  164. Hide Message Bar
  165. No print settings in Excel HTML files
  166. Adding hyperlink to access database from excel
  167. Run Sub automatically on periodic basis
  168. Re: Going back to the start of a string
  169. Simple Array
  170. sql to database
  171. RE: Going back to the start of a string
  172. Strip records from large textfile with VBA
  173. Re: Going back to the start of a string
  174. how to get address of source of copy (range with marquee a.k.a. "marching ants")
  175. Constants
  176. Excel prompts for VBA password when opening
  177. Computationbs on Duplicate Entries
  178. Error 58, file already exists - why?
  179. User Form Display Question
  180. Excel Object Not releasing from Task Manager (Vb.net)
  181. Outlook private calendar
  182. how do I display last two digits of a SSN in a separate column
  183. deleting rows automatically using a maco or vba
  184. color pivot area
  185. Run Time error 1004 - Pastespecial method of range class failed.
  186. Hide worksheet when moving back to another sheet
  187. Conclude new account number
  188. RE: white screen
  189. Repost with correction on turn report data into list
  190. How to turn report data into a list
  191. User authentication/protection
  192. Code to change part of a formula across worksheets
  193. hide colum based on cell value on each worksheets
  194. Automatically hide unused columns
  195. Sharing workbook removes cell protection
  196. looping through text files in a folder
  197. RE: Worksheet change when creating new sheet
  198. eliminating unwanted data
  199. Saving values from Multi-select List Box
  200. how do I create a macro to select all colored cells in a worksheet
  201. Re: collection obj
  202. Password Protection set for all worksheets
  203. Macro that adds all numbers that have formulas
  204. Advanced transpose/grouping question
  205. collection obj
  206. Macro to "separate" entries in a field?
  207. Data Validation
  208. short circuit for next; continue?
  209. Sheet that never closes
  210. How to load specific range of data from html into excel?
  211. Check Box Question
  212. Making Plug-In Macros Visible for Custom QAT Access
  213. Copying Sheets to a woekbook
  214. Hide Row If Any Cell In It = 0
  215. Data range in Array worksheets
  216. multiple cells text to text in one cell
  217. SumProduct in VBA - Allow the user to select the file
  218. Array Question
  219. Prevent Coloumn & Row Deletion / Insertion
  220. Extracting a list of individual values created with sum of values
  221. How to modify specific lines in a .ini file?
  222. Excel save takes 18 times longer than Windows Explorer copy - why?Options
  223. CHM documentation downloads
  224. Pretty indent reformatter
  225. Need some help with Excel 2003..?
  226. Dialog Box Buttons
  227. How to insert row after data from user form
  228. FormatConditions
  229. Unable to set the Text Property of the Characters class
  230. copy/paste in the next column
  231. Macro That doesn't work - Please help
  232. Validation error
  233. Please HLEP: whats wrong with my code!? Adding textbox as runtime
  234. HELP: Add textbox to a frame at run time
  235. Using a range object inside a formula
  236. VLOOKUP - help
  237. Macro to match 2 column values in different sheets
  238. SET UP FORMULAS AND CODE TO WORK WHEREVER WKB IS USED
  239. Move and delete files
  240. Cell Interior Color
  241. Help with code
  242. Macro to append number to file name
  243. Dialog for selecting range within subroutine
  244. Adding textboxes based on what user inputs in Total Students textb
  245. Programming a button to add a row
  246. VB.net select column and format
  247. EXTRACT FULL NAME
  248. How to sort number follow cell accordingly
  249. Tracking updates
  250. Formatting within this macro
  251. Cannot run the macro 'XXX'
  252. Excel 2010 Object Model
  253. inability to apply formulas
  254. Import image as binary data to a cell
  255. Sort.Orientation Query correctness of me or Library document
  256. Deleting Auto_Shapes
  257. Suppress warning message
  258. Counting selected cells
  259. Removing filters from data
  260. Disable cut/copy of shape and images in excel 2007
  261. Adjustable print range
  262. Macro to open and close addins
  263. Alternative to Workbook_Open()????
  264. excel 2010 symbol files PDB
  265. minimize workbooks in macro
  266. Considering cells colored via conditional formatting
  267. single user form with multiple worksheets
  268. Redirect Selection in Cell to Print Job
  269. Programming a macro in Excel Office 2007 to create Pivot Table
  270. routing slip in Excel 2007
  271. Loading PivotCache directly from a text file
  272. Copy Range of Cells to Outlook
  273. USING IsNull Function in PivotTable
  274. File Name and Full Path Name
  275. Counting Selected/Highlighted Rows
  276. Hyperlink opens word template for editting, not as new document
  277. Positioning a Text Box
  278. Personal.xls Workbook
  279. routing slip in 2007
  280. 4 different axis in chart ?
  281. 4 different axis in chart ?
  282. 4 different axis in chart ?
  283. Tab color change on specific value
  284. ListBox Size and Screen Resolution
  285. Using data filter
  286. Refresh Macro to run each day?
  287. adding a data series to a chart with variable inputs.
  288. Create Detail Sheets from Pivot Table
  289. Is it possible to add a Search Box within a spreadsheet?
  290. Create a list using two criteria
  291. ActiveWorkbook.FollowHyperlink strURL
  292. Reg:Macro needed to pick up only distinct values but it picks up allthe values
  293. Pictures/Clipart
  294. Visual Basic On-line Training
  295. Find And Replace
  296. how to perform custom sort in pivot table
  297. Works in 2000, not in 2007
  298. Accessing the AutoFilter method via VB.net
  299. Date format error with CSV file
  300. Data Consolidate Limitation
  301. Delay when userform resizes??
  302. Print macro
  303. Macro runs within VBE, but does not run to completion via a hotkey
  304. Conditional Formatting VBA with formula to find string
  305. Application communicating with Excel
  306. copy range to a variable.
  307. File unable to open
  308. OleObject-Preventing deletion
  309. custom function to convert numbers stored as text
  310. Class Programming
  311. BeforeDoubleClick code
  312. Macro
  313. Auto populate Email when Name is chosen
  314. Find and replace with bold in cells
  315. How do I draw shapes on a user form? (VBA Excel 2007)
  316. Email from excel: Format dollar amount in outlook body
  317. Re: Macro to convert ASCII File to Excell
  318. Trouble entering formula into cell
  319. QAT Reference to Macros in Another Workbook Don't Stick
  320. Can a macro read a list and insert the names into a web address?
  321. Loop Macro to add Formula only on rows with data
  322. Formula help
  323. Re: Do not delete row with cell in Column B = 0
  324. RE: Do not delete row with cell in Column B = 0
  325. Macro to look up values in 2 different columns
  326. undo a macro
  327. looping thru rows
  328. Pivot Table Fields
  329. Search string to search for wild terms in Access database
  330. Help with a macro to display documents
  331. Import XML spreadsheet from database with VBA
  332. A little help please on a macro to display results.
  333. Range for Body of E-Mail
  334. Pivot table "Sum of" or "Count of"
  335. RunWhen error
  336. RunWhen error
  337. Paste and cut code
  338. XNPV with yield curve
  339. Attaching files to Outlook
  340. Comparing two dates
  341. How to make X, Y axes of Excel charts to have same scale on thescreen?
  342. Write to Module While Macro is Running
  343. Macro-calling shape
  344. how do I write a loop macro?
  345. Count unique
  346. Graphs & charts
  347. Locking specific cells
  348. VBA Functionality Lost
  349. Which shape is selected
  350. References to Other Workbooks Don't Stick
  351. Position of drawing object on Excel-worksheet
  352. CAN WE LOCK CELLS AT F COLUMN BASED ON VALUE AT C COLUMN
  353. Show shape on cell select, Hide shape when cell is deselected
  354. Search Post by user
  355. VBA to find filename and replace
  356. Regarding excel and VBA
  357. Factorial function...whaaaaaa?
  358. Open Excel 2007 .xlsm doc, but not allow user to copy it?
  359. Go to named range nominated by user
  360. Address of Selection Prior to Clicking on a Cell
  361. Find and Replace in VBA
  362. Need help to modify code to track changes in a column
  363. How do I match 2 items in excel to return a unique value?
  364. Help needed to modify macro to convert User IDs to Names
  365. Writing VBA function with loop and condition
  366. Only run if check box is checked
  367. Table format - connection string problem
  368. List of names that can be divide by catagory in a single step
  369. Changing time zones
  370. Logic question. Comparing 2 lists.
  371. Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents
  372. RefEdit Exit not firing
  373. Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents
  374. Lat and Lon coordinates from address
  375. Find duplicate, save in a list, delete duplicate using macro
  376. Loading combo box list
  377. Counting Manual Page Breaks Only
  378. VBA Password - Excel keeps prompting for it
  379. extracting specific info from text cell.
  380. RE: Macro to convert ASCII File to Excell
  381. How to clear contents of a cell without removing the formula
  382. problems when removing validation
  383. form combobox auto expand
  384. Disable Print button & pulldown menu
  385. Adding picture
  386. Re: COPY METHOD FAILED
  387. SetFocus Not working
  388. date format
  389. Determining the row limit in a macro
  390. Copy from one workbook to another failing
  391. Build an Array of Different Values From Column
  392. Compare data, and if different, copy to another worksheet
  393. Insert Worksheets based on column data.
  394. Workbook locks up after Worksheet_Change operation
  395. Handling different Error 1004 errors
  396. Testing for ODBC names
  397. how can i append data to a sheet or book from another one
  398. Close various modules/codes windows
  399. How to find a number from a given data range?
  400. Compile Error in Hidden Module: Module 1
  401. Populate userform spreadsheet
  402. prompt for path to loop through files
  403. MATCH command does not work with dates
  404. OpenDatabase Error
  405. Adding formulas to rows using a Loop Macro
  406. How to run macros from combobox selection
  407. Help with looping in Excel
  408. Creating Graphs + VBA
  409. Trying to get just part of an XML file?
  410. Name Formula
  411. Autofit columns, password protected
  412. Conditoinal Row Delete
  413. Use combobox value as sheetname to set sheet object
  414. Inserting picture stored in an Access DB table
  415. 2 fonts in Chart title in E2007
  416. Run-Time Error on Cell Range Select
  417. Copy and Paste Function
  418. Extract data from web
  419. Did the newsgroup search programming change?
  420. TextToColumns using VBA without the prompt
  421. Open delimited file
  422. Data Matching
  423. Differentiate between False and Zero for Input Box return?
  424. Excel 2007 query - Access MDB question
  425. Novice - using macro to protect with password
  426. lookup help
  427. HasFormula
  428. Slow Code
  429. Copy Userform ListBox AND TextBox values
  430. Setfocus question
  431. Unexpected internal error or not enough memory
  432. convert to capital letters
  433. ActiveWorkbook.SaveAs Function - Can I specify the user account tosave the file with
  434. CreateObject("Outlook.Application")
  435. RibbonX Controls and Determining Enabled?
  436. Look up
  437. subtotals on every user - newbie help required
  438. Package & Deployment Wizard
  439. xldialogprint arguments
  440. Excel Database - Magic Printing Macro
  441. Target Range Activation
  442. Marco to protect / unprotect worksheet
  443. command button
  444. Invalid Circles - Can I force their display?
  445. how to count columns i pivot table?
  446. Help with error 2015 in macro
  447. Efficient way of finding string and changing cell value
  448. Not ranking 0's
  449. Reference a specific cell in the active row
  450. Refresh screen method?
  451. ThisWorkbook.Close question
  452. Multipage control help
  453. Speeding up the importing of data from file
  454. select non contiguos columns by variable name
  455. Speeding up the importing of data from file
  456. Problem with DTPicker 6.0 control
  457. Package & Deployment Wizard
  458. Excel won't close properly
  459. Excel: Cell Value as Excel Document Metadata Property
  460. Getting right date value
  461. Get Outlook Settings for E-Mail from Excel
  462. Passing an array of strings from VBA to C
  463. How to list dates in a month of particular weekday
  464. Monitor Changes in a folder
  465. Find Highest Date in a range
  466. Creating an older version pivottable
  467. Problems with MS-DateTime-Picker 6.0
  468. Question about modal userform.....
  469. Passing a range between two subroutines.
  470. Run subroutines in other workbooks?
  471. How to run auto-open macro in Excel 2007?
  472. How to calculate % in summary sheet from cell A9 in multiple sheet
  473. Control Tip or MouseOver label on Excel shapes
  474. Send round office a macro enabled ss
  475. Linked Spreadsheets
  476. Calendar Control Shadowing Issue
  477. Split data around a carriage return
  478. Is it possible to include a macro by a macro?
  479. Grey out Cell content
  480. What is NNTP Server Name?
  481. Delete chart series
  482. commandbar control works on some computers, not others
  483. Permission Denied
  484. Left Click
  485. Help-how to install a macro for everyone to use
  486. UDF Drawing Shape Not Re-Positioning
  487. Selecting specific rows in data range.
  488. Weird behaviour of VBA when generating multiple PivotCharts
  489. Excel To Access: Transfer multiple rows from excel at the same tim
  490. Format Returned Values in VBA Q
  491. pausing macro while cells update
  492. Using VBA to change default color palette
  493. Copy range to different columns depending on cell value
  494. How to calculate % in summary sheet from cell A9 in multiple sheet
  495. clip art shifts
  496. How tcalculate percentage of values in cells in different workshee
  497. delete blank rows from other tab
  498. Editing multiple cells at the same time
  499. Scripting.FileSystemObject stopped working
  500. Editing dynamic worksheet exported from CRM to Excel 2003 *Correct
  501. Editing dynamic worksheet imported from CRM
  502. "Scripting.FileSystemObject" suddenly stopped working
  503. Kill the annoying "Auto Fill Options" button
  504. how to store values in a 2 dimensional array
  505. Finding Closest Text Match
  506. Retrieve tables from web with variable URL
  507. Excel 2007: Return rownumber when text data on 3 columns match exa
  508. Personal.xls ?Save? on exit but no changes
  509. How to de-activate Menu bar in only one Excel Workbook ????????/
  510. Cells(my_crt_row,my_crt_col+1) crashes for my_crt_row>65536
  511. VBA DataEntryMode bug?
  512. Combining 2 Text Strings in Body of E-Mail Q
  513. How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed
  514. Insert a specific number of rows
  515. Pivot Table (Excel 2007) Display Full Year Budget Field only in Gr
  516. test to confirm non-numeric characters
  517. Excel Model
  518. deselect chart
  519. Stack columns from a matrix
  520. Find a row based on a word in the cell
  521. How to Calculate if a Range of Times Falls Between two Date/Time S
  522. Question about how to use range in VBA
  523. Re: Reading through an XML file
  524. Adding a dropdownlist programmatically to a ASP.NET webpage
  525. Looking for suggestions/advice on a Flexgrid replacement
  526. Highlight Row Based On Condition-So close
  527. There must be a better way to code this
  528. Compile error :: Trim, ...
  529. Solver slow
  530. How to copy only to cells where there is data
  531. Excel Query locks Access
  532. using vba so search multiple Sheets
  533. Help with Excel sheets
  534. Calendar Control 12.0 - Missing
  535. Message/Input Box - filename in question text?
  536. Device I/O Error
  537. Web query - extract data from web to excel
  538. Visually represent project dates and activities as shapes in Excel
  539. Filename in Input/Message Box
  540. Macro to split the contents in a single cell separated by "," intonext cell in that column
  541. Cut from one sheet, paste in another
  542. How to autostart a macro?
  543. Copy / Paste Not working with Target.value
  544. Index Generator - Help with Permutations
  545. Cut from one sheet, paste in another
  546. Disable user interaction in VBA
  547. Performance issue with accessing Microsoft.Office.Core.DocumentPro
  548. Need Macros
  549. Locking User Interaction
  550. count resize range
  551. Suspend old code while new code is running
  552. Text is Truncated With String Variable
  553. Compile Error: Expected:(
  554. Oh look...the forum is not working again. NOT SURPRISES!!!!!
  555. Excel to XML: Need some help fine tuning a macro
  556. Modify sub to exit if password is incorrect
  557. Refreshing query data via vba button
  558. How to determine if a chart is embedded or not
  559. Excel with internet exp freezing up
  560. Checkbox problems
  561. Re: Using Autocorrect to remove spaces
  562. computations at odd but specified locations
  563. How to autofit variable columns?
  564. Sending E-Mails from Excel
  565. Want code for emailing Excel files that aren't the activewrkbk-Out
  566. Please help: Interrupt routine to get input from key
  567. Howw can I make a function return a date in date format
  568. 400 rows, takes ages to delete
  569. Excel To Access: Transfer multiple rows from excel to access
  570. isblank function in Excel VBA 2003 ???
  571. Conditional Formatting Code
  572. Refresh a Combobox
  573. Email from Excel Function
  574. How can I access the "style" definitions in my Add-in?
  575. Compatability issue
  576. Workbook BeforeSave
  577. Code for emailing Excel workbooks will only attach activeworkbook
  578. Runtime Error 1004 when runing Sub() from btnClick
  579. Sending a macro-enabled spreadsheet
  580. .odc connection managing with vba in excel 2003?
  581. Retrieving consecutive pages in web query What's wrong here?
  582. Transfer data from one spredsheet to many others within one work b
  583. Export to XML exports single row only
  584. Move data to right with variable rows
  585. When does conditional formating fire?
  586. 2003 v. 2007
  587. One range inside another, Intersect
  588. VBA Custom Toolbar
  589. Duplicate Rows - Combining and Flipping
  590. select a certain range of data
  591. runtime error 438 when opening an excel file
  592. Shortcut key and UserForm
  593. Querying Data from Access
  594. How can macro open daily generated files?
  595. how to Delete Format Menu Toolbar From Excel
  596. Re: Conversion from 123 to Excel
  597. Macro to seperate data
  598. Stop users deleting& inserting rows
  599. Compile error - Expected: list seperator or )
  600. VBA Password Recovery
  601. Userform with currency format
  602. Restricting activation of a form button
  603. RIBBON COLOR
  604. prompt password for a worksheet
  605. Help to modify a macro for deleting rows based on two or more colu
  606. sumifs help
  607. 2007 wont run 2003 coded sheet_change event.
  608. Copy to a Word Table
  609. Extracting records from a list
  610. Change color of specific text piece
  611. Program won't stop
  612. copying cell comment from one sheet to another
  613. Help needed: How to adjust the SUM range??‏
  614. Weird behavior on Worksheet_beforedoubleclick event (XL2003)
  615. Excel VBA
  616. cannot set range class?
  617. Strip file extension from fiel name with multiple periods."file.9.69.txt"
  618. Command Bar Creation
  619. Converting User IDs to User Name
  620. userform problems
  621. Routine does not run when workbook is opened
  622. Excel WB opened from Sharepoint as ReadOnly, ReadONLY for WB = FAL
  623. VBA: optimize If conditional expression?
  624. Write a button to run macro on *ANY* chart area clicked.
  625. Need help with VBA - complicated copy and paste
  626. CountIF Statement combining 2 different pieces of data
  627. Selecting a Drawing Object
  628. Multiform coding problem
  629. Creating a userform?
  630. Is there a macro for returning multiple values through a Vlookup?
  631. Macro to subtract cells if...
  632. Perform compare of multiple selected columns
  633. Web Query Formatting not ready for Production
  634. Select all tabs after a certain tab
  635. Formula in Vba code help
  636. OpenOffice
  637. Sort data with a varying range
  638. Issue with INDIRECT function.
  639. Form Controls on Worksheet
  640. Multi-Step Worksheet Export - HELP!
  641. Delete Tabs
  642. How do i refer to cell contents in a macro?
  643. Where do I paste in the following Access SQL code into my routine?
  644. Worksheet chnage event
  645. Can I run code from a PC on a Mac?
  646. Copy and Insert Row
  647. MsgBox when the cell is empty
  648. Problem with the code, probably with Private Sub Worksheet_Calculate()
  649. VBA Code to calculate SUM and COPY&PASTE cell value in inserted li
  650. Target.Address Being One Of The Cells Of A Named Range
  651. Excel + Query Tutorial Recommended?
  652. visibletemslist for excel 2007
  653. Syntax problem
  654. Spreadsheet in userform
  655. save OLE Object to a file
  656. Adding a New Tab-and Naming it from a Cell Name
  657. Auto_Open update VBA
  658. UDF that returns a Hyperlink
  659. Printing a selected worksheet
  660. Please help with On Error GoTo
  661. How to reorder/rename modules?
  662. Why show Enable/Disable macro prompt after I deleted all macros?
  663. Comparing a date to todays date
  664. Exclude header row when copying autofilter results? (XL2003)
  665. Excel open files on task bar
  666. Determine if a sheet is protected?
  667. Using Excel GoalSeek on Access form
  668. Personal.xlsb always locked
  669. Autofilter Array
  670. Re: Creating New Workbook from Sheet
  671. Re: Creating New Workbook from Sheet
  672. Conversion of 10 digit number into xx-xxx-xx-xxx
  673. Sheet protection complications
  674. Programatically sort and highlight
  675. Error generating a list of unique values in range (XL2003)
  676. checkcompatibility not working in Windows 7
  677. Large footnote
  678. Getting data from a webpage
  679. Passing arrays through procedures
  680. Using a macro when opening an excel spreadsheet
  681. SumIf across multiple worksheets
  682. Find in UDF VBA
  683. retrieving data from a table on a website
  684. Identifying a button on a toolbar
  685. Print a user form image
  686. Insert Record
  687. Will 32 bit compiled Add-In run in 64 bit excel 2010?
  688. Syntax Error '1004'
  689. Get a specifc button Handle inside ribbon
  690. Copy and rename a sheet
  691. Colour a row, based on a cell value
  692. Chart sheet causing error
  693. Loop Enumeration Constants
  694. Simple Vlookup Looping
  695. Read the next line in a text file
  696. Reg:Trying to write a macro in excel
  697. Count how many instances of an item appear in a range
  698. How to autofit text containing CHR(10)?
  699. Deleting decreasing data and naming rows.
  700. Deleting selected images from Excel worksheet
  701. How to reference variable rectangular range?
  702. Need something simple
  703. how can i disable/enable "copy and past" in excel sheet?
  704. A code to import other xls data into one xls file
  705. Select Case Syntax
  706. can anybody send me complete list of MS Office Object model ?
  707. Fire Worksheet_change event from module
  708. Textboxes on userforms
  709. Copy HIDDEN columns to a new workbook
  710. Matching Values to Enter New Value
  711. vba to send multiple workbooks to different address
  712. search text files for a certain word
  713. RE: Slow Running Subroutine
  714. Desktop icon
  715. How to constract an array UDF?
  716. Converting currency to text and spliting to two lines
  717. Macro/SUB to merge two columns of text
  718. Transfer data from Excel col. A to columns B-E in the same sheet
  719. VBA code
  720. Re: Setting workbooks
  721. Insert a square in a cell with VBA
  722. Mail Merge Option
  723. RE: Setting workbooks
  724. ActiveWorkbook.Names.Add Name ???
  725. Remove Duplicate Numbers in One Cell
  726. Copy/paste/sort
  727. Test for NULL string?
  728. Access Version being used
  729. MRP Excel Spread sheet
  730. Disabling all pushbuttons
  731. Frastrating-doesn't give all the data
  732. Blank cells corrupt?
  733. Visual Basic Editor opens automatically after lock, unlock
  734. Multiple OR and AND conditions
  735. Way to Override Policy & Use 2003 Vice 2007 Excel Interface (VB.NET)?
  736. Store a picture in a cell
  737. Divide into groups.
  738. how can I disable a control in the ribbon at run time
  739. help with/for pivottable code
  740. PrintScreen and save 2 Internet pages
  741. Count of text in cells
  742. Graphic template Excel 1997
  743. calling a macro within an excel formula
  744. autofit column, password sheets
  745. running applications
  746. Re: Automatically pull data from one file to populate a template
  747. Converting from 123 to Excel
  748. #NAME? error in nested if & VB
  749. Symbol # after numbers
  750. displaying formula result