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. Autofilter
  2. Re: Select Case - 2 causes problems
  3. Unique Random Numbers
  4. This workbook contains links to other data sources
  5. ScreenUpdating and ATPVBAEN.XLA!Random
  6. Re: Select Case - 2 causes problems
  7. Assign ChangeEventMacro to unknown SheetName
  8. Ineed a combo box to change its list dependant on the active cell
  9. searching for data labels with specific text
  10. Problem with ScreenUpdating Property
  11. hi, how to compare two string values, if the string values r from inputbox in VB
  12. Method range failed
  13. Need VBA Code
  14. Sorry, No Word Macro Forum. Macro To Search And Copy All Occurances
  15. Trasfer data to SQL Server
  16. Help...first time macro user question, loop needed?
  17. Macro Help
  18. Use Dir() to fill out missing components from Path?
  19. add to listbox
  20. I am new to VBA - Help needed on Macro
  21. Call parameter query in Access from Excel VBA?
  22. merge
  23. PLEASE CAN ANYBODY HELP - MACRO NEEDED
  24. Column Breaks
  25. Cubevalue (Excel 2007) versus Cubecellvalue (Excel 2003)
  26. Excel Programmatic (Existing) Workbook Access in .NET 2.0
  27. Sort Current Worksheet
  28. Using IF EXISTS inside CASE block in SQL
  29. password & Links
  30. Why does Range.Group() method crash after 7 calls?
  31. Pivot Macro
  32. Update my spreadsheet with MLB team records?
  33. university courses in VBA
  34. File Size Matters
  35. PivotCaches.add Difficulties
  36. Auto_open won't run on multiple files
  37. Sub to copy n rename book according to list
  38. Have code, need to travel
  39. Compile error using array
  40. additem
  41. How To Use The Number Part Of A TextBox Name As A Variable
  42. How to count rows with text
  43. A macro that deletes all green triangle error indicators in workbook
  44. vb code question
  45. PLEASE HELP MACRO NEEDED
  46. Reading file saved from Excel as Unicode text
  47. Background Processes in File Save versus File SaveAs
  48. Attaching an Excel Worksheet as An Object...
  49. Merging 3 rows of numbers together
  50. Force to run maximized
  51. Select Leftmost Spreadsheet
  52. Many to One Lookup Match in Drop Down List
  53. MACRO TO WORKOUT PERCENTAGE
  54. Troubleshoot formula's between 2003 and 2007
  55. Vlookup not refreshing data values
  56. How to delete that row if same cell in preceding row is identical
  57. BLINK CELL COLOUR OR TEXT COLOUR
  58. Range.Group() method fails after 7 calls
  59. Save As Macro options
  60. Message box and Save as Macro
  61. VBA Excel decimal formating problems
  62. Adding a calculator(Numberpad) to a text Box
  63. comparing abr. Date Text cell to a date formatted cell
  64. Macro Help
  65. joining spreadsheets together for reports and queries?
  66. Query
  67. Selecting Range of Cells
  68. Workbook_Open() won't run macro unless breakpoint set
  69. Need Help With My Loop That Creates Output File
  70. PasteSpecial failed
  71. XL 2007 records print command as XL4 macro
  72. Sort and Extract Macro
  73. Sort and Extract Macro
  74. Automated add-in UDF lookup in Excel 2007
  75. why won't this work???
  76. VBA Routine to split cell data...
  77. How can I protect cell from user entry but able to alter/clear in
  78. Code to do edit checks when user moves out of a cell
  79. Savepicture
  80. Re: Chart Deselect in 2007
  81. Choosing Multiple items from Data Validation Lists
  82. Calculate command
  83. Getting <Title> out of HTML source code
  84. A puzzling duplicate data issue...
  85. Is string allowable as a file name
  86. Modeless UserForm
  87. Add Row after last entry
  88. Username
  89. Is there a VBA command that will keep an program always on top
  90. Listbox data
  91. Macro to compare names
  92. Help getting next sheet
  93. UDF for multiple heading indexing
  94. auto_open problem for Expiry date
  95. Dropdown menu
  96. Non-modal dialog tracking Ctrl+click'd selection
  97. Conditional Formatting via VBA in Excel 2007
  98. Worksheet_Change doesn't work
  99. Macro copy data into another workbook
  100. Getting the function name (NOT SYMBOL NAME) - not quiteapplication.registeredfunctions...?
  101. APPEARENCES DURING THE MACRO RUN PERIOD
  102. open then modify file via hyperlink
  103. Copying worksheet into another worksheet
  104. check lettered ticket number
  105. Excel 2007 Chart-Objects don't work properly
  106. Vista has broken my SHDocVW
  107. Workbook before close
  108. Vba code
  109. entering value in a cell
  110. Where am I going wrong? (losing the variable because of need for quotation marks)
  111. The specified device is not open or not recognized by MCI -"mciSendStringA", VBA
  112. Compare two columns, delete rows that match?
  113. VBA / Formula
  114. Help with Vlookup of Find date
  115. replace copy and paste
  116. Using More than 7 possibilities in a formula
  117. I need help with a "Run-Time Error 13: Type Mismatch"
  118. spread out fields in different column
  119. Protect a sheet
  120. Macro for e-mail
  121. Previous active cell
  122. Code format question
  123. How to link PP shape to individual sheet in a workbook?
  124. Refresh form
  125. Insert new row after a name range
  126. hyperlink to password enabled website.
  127. Textbox
  128. VBA - before delete
  129. median of combinations from values in a column
  130. Get Dimensions of Image File Outside Excel
  131. Ignore a sheet
  132. If ...Then Statement
  133. Highlighting fields based on a dropdown in Excel 2003
  134. Shorter way to create multiple identical Event Procedures?
  135. xml toolkit not working in Excel 2003. Why?
  136. find box
  137. Excessing excel error responses
  138. How to delete the duplicate pivot cache.
  139. Task bar
  140. Controling a Pivot Dropdown
  141. Objects/properties that don't trigger the intellisense
  142. need help.
  143. Combo Userform
  144. Copy cells & sheet name to master sheet
  145. Cell color
  146. Excel 2007 Macro Security
  147. Call a callback to toggle a tab visible/hidden?
  148. Select Cell when hover over action hotspot
  149. Can't paste today
  150. Dynamic List box
  151. Revision clouds?
  152. Dynamic comboBox on Ribbon
  153. hiding columns in grouped worksheets
  154. Computer freezes when user clicks "enable" macros
  155. Command Button Changes Data Each Time It Is Pressed - Want it to workonce per worksheet.
  156. Insert text in cell using VBA
  157. Format Selected Chart
  158. Workbook name is read only property?
  159. find workbook names that are in sheet
  160. How to set page orientation to "landscape"
  161. Dates US and UK
  162. PopOver Help
  163. Change colour
  164. User-defined type not defined
  165. Macro: Copying to all possible rows
  166. cell ref in a formula
  167. XLAM for global macros cannot be run
  168. Find End of List
  169. Info about "Office Developer"
  170. Final space removed when moving to Object variable
  171. Change column headings or freeze row 1
  172. RibbonX Separator problem
  173. Pivot Table - VBA
  174. Userid
  175. Protecting sheet through vba while allowing some actions
  176. macro to change number format of a highlighted range in Excel 2007
  177. Macro to mail and save range from one sheet
  178. Class Module Method
  179. Error Message - VBE6EXT.OLB could not be loaded
  180. calculating percentage on timevalues
  181. macros -enabled Workbook is getting slower and slower!!
  182. Automating F2 to edit
  183. Listbox
  184. male & female lists
  185. charts, data in arrays, can same be done for ErrorBar figures?
  186. Avoid multiple select constructs
  187. Error Handling construct
  188. Combinations Sequence
  189. Lookup value
  190. Sending a date from VB2005 to Excel
  191. Calendar Control Drops on Distribution
  192. PLEASE CAN ANY BODY HELP
  193. Opening hyperlinks in separate windows
  194. Triathlete Club Needs Help!
  195. Lookup value
  196. ADO recordset: Convert RTF field into plain text
  197. Taking hours to save excel file
  198. how can i no margin string in listbox from left
  199. Chk sheet exits, copy all to another book.
  200. Edit VBA Code without opening the workbook
  201. Do Not Export Button Objects
  202. Address of cell invoking current UDF call?
  203. Why am I losing my Range object?
  204. Extract a section of a text string to anew column - Excel 2003
  205. lock a workbook until certain cells are filled
  206. Is it possible in Excel to have the result of a formula hide rows.
  207. Remove end folder from path found with ThisWorkbook.Path command ?
  208. Re: IsBlank() in VBA code?
  209. Simultaneous scrolling for 3 worksheets.
  210. Unselect Forms Toolbar Listbox
  211. Recognizing When An IE window changes URLs and closing the IE wind
  212. Find filename of open file
  213. copy several files into one file
  214. "Dim" query
  215. VBA Checkboxes
  216. Need to create table that shows last rolling 30 business daysdifferences on 4 accounts
  217. RE: IsBlank() in VBA code?
  218. check for numeric values in a column
  219. Re: IsBlank() in VBA code?
  220. VBA Code to go to one Bookmark.
  221. asset allocation optimization
  222. Password issue
  223. How can I unprotect multiple same passoword worksheets at once?
  224. combining multiple find/replace subs
  225. ADO Field Size issue
  226. Automatic Conditional Row Deletion?
  227. visual basic code runs very slow in 2007
  228. On Change Event and Intersect
  229. Macro to hide rows?
  230. FileSearch worked in Excel 97 but not in Excel 2003, how to fix???
  231. Split Workbook based on user Input
  232. CAN ANYBODY PLEASE AMEND MY MACRO
  233. Dates in SQL query won't match
  234. macro: Copying to all possible rows
  235. Protect cells based on Date and previously entered data
  236. Calendar Control
  237. calculate time if greater than a given time
  238. Read value from text file line, process, then Loop until EOF
  239. GetOpenFileName to select a .URL file
  240. disable objects on form
  241. Excel 2000 open using C# error - Unable to cast COM object of type
  242. Textbox
  243. ToyotaKV
  244. Format Cells with VBA?
  245. DELETE DEBIT AND CREDIT FIGURES ROW BY MACRO
  246. The hunt for the disappearing textboxes.....
  247. Copying cells from one worksheet to another, within the same workbook
  248. Adapt code to copy out pictures as well
  249. 'object disconnected from client ...'
  250. Find WkBk Path, Then use this path to open another WkBk in Subfold
  251. Last Item of Listbox not getting displayed
  252. Using CREATE TABLE DDL on Excel creates two tables
  253. All macro are disabled due to encryption?
  254. VB CODE for password protected sheet to release part of the worksh
  255. Protecting Workbook on Network while Allowing VBA Updates
  256. Switching monitors
  257. Automation:Selecting a different worksheet from another excel work
  258. List Directories and Subdirectories
  259. copying rows to all possible records during a macro
  260. Copying worksheets - loosing range names
  261. Inserting a row in one named range and having it update another
  262. Link Sheet tabs to Org Chart
  263. Stock Quotes to Excel
  264. Printing what is between tags
  265. VB to run a .exe file
  266. Using RIGHT function to get right-most digit for each cell in acolumn
  267. How do I bold entire row with an asterisk in the text?
  268. MS Internet Transfer Control
  269. How do I refresh user defined function data?
  270. Programatically set control source - not working
  271. Random selections with criteria
  272. Row Height and Printing
  273. Toggle Command Button to Show/Hide the Shaded Headers Columns
  274. BEST suggestion to keep formats?
  275. distinguish Range and "Single"
  276. Excel 2000 vs 2003 date issue
  277. Copy A File From Internet To My Desktop
  278. Solver dialog box
  279. query code failes on different PC
  280. INDEX
  281. Paramters or Argument Auto-Label/Balloon Tip for User-DefinedFunction
  282. A macro to deactivate Input Message textbox without deactivatingError Alert messages
  283. Microsoft Visual Basic UserForm 2 columns, Excel 2000 & 2003
  284. Error after chaging file access in Office 2007
  285. Copy totals from master tab to other tabs
  286. Selecting tabs - tab names given in a list
  287. Points, pixels, in, and fonts
  288. Excel 2007 - Deploy a function across the network
  289. Vba Password
  290. Automate Pivot Creation
  291. Form Help (Re-post)
  292. Pivot Tables in VBA: Problem with AddFields Method
  293. Sort on no less than sixteen keys
  294. Sheet names in a MenuBar menu
  295. Re: Referencing Sheet names/numbers
  296. RE: Referencing Sheet names/numbers
  297. Make a copy of a sheet and add it into a new workbook?
  298. Help with vlookup
  299. Query Help
  300. Formula/Function to lock and unlock a cell in excel
  301. Re : Excel AutoFilter being Toggled of VisibleDropDown
  302. MULTIPLE CALCULATION
  303. CALCULATION IN BACKGROUND
  304. Formatting in Text Boxes
  305. A little help for a newbie
  306. Standards and tips for VBA
  307. Selection.Cut Selection.Offset(1, 0) HOW to understand this code
  308. RaiseEvent Problem
  309. sorting with a macro
  310. Shade date headers, if Weekends or Holidays
  311. data pulling with sharing violation
  312. Macro to add the " symbol to the beginning and end of cells selected
  313. Can I blanket update all controls inside a frame?
  314. Lookup help needed
  315. imagelist filling at designtime
  316. creating labels using MS exel and MS word mail merge
  317. Cells will not change from text format.
  318. VB CODE for double click?
  319. Copying Worksheets with macros
  320. multiple web querys
  321. Extending a range selection
  322. VB CODE for moving the range of cells down by one row?
  323. VB code for Active cell to the last cell
  324. Replacing formulas with values programmatically
  325. Menu disappears when selecting a graph
  326. Save & Load A Range
  327. Record Name of Workbook on Close
  328. How do I lock certain cels i a worksheet
  329. Need help with a formular ?
  330. Paste-Transpose macro needed
  331. Automation Server Events Usage in VBA
  332. Can an array be redim inside a for loop?
  333. array of labels
  334. archery scores templates
  335. Get Folder Name
  336. How to enter a macro that performs when a file is closed
  337. Help please - real beginner at form code
  338. page problem
  339. Code for form
  340. Displaying active cell in particular position on screen
  341. Date formatting
  342. Pivot Tables and Macros
  343. HOW TO SELECT RANGE IN MACRO
  344. Error control dont work!
  345. Cecking for duplicates
  346. copy and sort data then past in specific area on new sheet
  347. How do I loop in EXCEL !! Pls EX-cel-erate me!!
  348. Lookup Macro
  349. How do I loop in EXCEL !! Pls EX-cel-erate me!!
  350. Can I change the format of a control at Runtine?
  351. How to align decimals in a Listbox
  352. Is there a way to view the VBA code dynamically...i.e., while usingthe record macro tool
  353. ComboBox Query
  354. xla and add-in
  355. clear data and named cell
  356. Can Chart Refresh be Disabled temporarily?
  357. What's meaning of the Number Format?
  358. HyperLink function runs wild when unrelated column is filtered
  359. urgent help required.
  360. Want to select row
  361. totally newbie question about macros and programing it
  362. Listbox
  363. MAKE SUBTOTAL APPLICATION ON AND OFF IN MACRO
  364. HOW TO SELECT SPECIFIED RANGE IN MACRO
  365. Funtion as Matrix function?
  366. why is this form code not working
  367. Activate Excel application event
  368. Checking the connection to a network Share
  369. Is this a valid IF statement in Excel?
  370. Macros dont work when file used on another computer
  371. Copy dynamic range
  372. Avoid DIsplay of links
  373. Extracting Values and inserting Rows/Values
  374. Unlock certain cells based on ColorIndex
  375. FTP MVS to Excel
  376. Application.StatusBar or equivalent for user defined functions
  377. get cell value where offset cell = X, use this value to populate list
  378. Not exporting controls to a new workbook
  379. Problem creating PivotTable from ADO recordset using VBA
  380. Day of year (Not Julian)
  381. Initializing Form Controls
  382. Worksheet Protection Question
  383. Automatically resize a picture to a cell
  384. Why null reference to ListBox?
  385. how can I make a graphic that have two scales?
  386. CONDITIONAL FORMATTING TO VBA. Row format based on cell value.
  387. replace special character for filename save
  388. Moving the last character within the cell so it will be the first
  389. HIDE-UNHIDE VBA MACRO
  390. Re: Run code based on version
  391. Re: Run code based on version
  392. Help with VBA Code - once again
  393. execute a make table query in an access database
  394. Show Image When File Opened
  395. undoing a pivot table
  396. Show Image When File Opened
  397. Letting users calculate Excel forms on the web while hiding the logic
  398. What is missing from this form code?
  399. Problem with formating
  400. VBA code to run & wait for cmd line interface application
  401. Excellent resource on line for the Ribbon
  402. Before Print Event
  403. sum certain columns
  404. listbox
  405. Get Text Value of Dropdown
  406. Limit an GoTo Function command
  407. Macro
  408. Help Needed in Macro
  409. Hyperlink Help
  410. Bug? Unwanted date format pasted on two sheets when csv file importedin excel using ADO
  411. Shell or shellexecute
  412. how to plot a chart with 3 axes?
  413. Multiple Conditional Formatting in VB
  414. F8
  415. how to export a column as text separated by comma?
  416. Insert a line at the bottom page
  417. Variable not set
  418. Deleting excel rows based on multiple criteria
  419. worksheet_change not working
  420. Help on coding please?
  421. VBA Worksheets save new file to Folder on Desktop
  422. ListBox1 - returns no value
  423. Using excel to access MS Access saved query
  424. Vba to go to another sheet in same workbook
  425. I have formulas larger than 7 functions, how can I use them?
  426. Creating a conditional formula
  427. CAN ANYBODY PLEASE HELP ME WITH THIS MACRO
  428. MACRO TO LOOKUP AND SUM
  429. Formula needed changing font color
  430. Custom Excel Entry Form
  431. Replace function result captured in variable.
  432. logical expressions of formats
  433. deselect any "active" charts in workbook
  434. Re: Find and Replace with Formatting
  435. Create external link to another workbook cell programmatically
  436. Dynamic WebQuery freezes around the 50 or 60 iteration of the loop
  437. Save file as...
  438. Re: font size of cell comments DA
  439. Conditional Formats on Autofilter Headers
  440. Pivot Table
  441. save a workbook using Two different cells for a reference
  442. F8 macro step by step
  443. Can excel export to, run, and run a spread sheet that is closed?
  444. Text plus formula
  445. Document.Body.InnerText is empty in Excel 2003
  446. RE: Find and Replace with Formatting
  447. 2 Macros in VBA???
  448. delete pivot table data fields
  449. save all component in project...
  450. Need to disable my vba macro once I email out the file.
  451. VBA Macro
  452. Save contact to a particular folder in Outlook
  453. BeforeAssignmentAction
  454. Conditional Format assistance?
  455. Text search in VBA/Excel
  456. Use of Public for data declaration in Excel 2000
  457. creating columns based on date range
  458. Conditional Copy Macro
  459. AciveWindow.ScrollColumn / Excel file embedded in word
  460. Excel 2007 Chart Plot #N/A Data labels
  461. Scrolling in a form's listbox
  462. PLEASE HELP - MACRO NEEDED
  463. Get certain words from a line into a cell
  464. Need Help With Finding Date And Copying Everything To The Right OfIt?
  465. MS VB 2005 / 2008 EXPRESS EDITION
  466. Forms: Why do they cause Excel to crash?
  467. Is there a formula for identifying prime numbers in Excel?
  468. Re: Autocomplete behavior EXCEL's or WINDOWS?
  469. PLEASE HELP
  470. Help with VBA Code - again
  471. Formula to choose X number of unique random cells from array?
  472. Cancel query
  473. Command Button VB Code w/hyperlinks
  474. Excel VBA FTP
  475. Test if File is Shared using VB
  476. userforms
  477. Nested Import Loops
  478. Names.Add - compile error
  479. Macro for cross referencing
  480. Issue with UnProtect userinterfaceonly:=true
  481. Help with Forms
  482. Popup-Message when using UDF from add-In
  483. Selection.EntireRow.AutoFit
  484. listbox
  485. Run Different Macros for the Up & Down Spinner Form Buttons
  486. How to group empty cells in a column
  487. how can i to use excel to analyse?
  488. CORRECTION NEEDED IN MACRO
  489. Query adds rather than replaces
  490. How to generate a random uniqe alfanumeric number?
  491. how to generate series of random numbers which are all unique
  492. Input Cells on a Chart tab
  493. Anyone know an answerr?
  494. OLEObjects: Adding jpg Object
  495. search for variable worksheet name and rename
  496. Format Text Boxes
  497. Re: reformatting "text" format for dates and numeric data
  498. Pie Chart Colors
  499. RE: Formula Help
  500. Re: reformatting "text" format for dates and numeric data
  501. conditional formatting
  502. Macro terminates early without error message
  503. Help with optimization
  504. ScreenUpdating = FALSE
  505. Hide Userform when viewing a different workbook
  506. Auto Refresh and Protecting a Sheet
  507. Pop Reminder
  508. Can I write a macro to insert a row after a data change?
  509. UserForm - Right-click a Textbox and Paste
  510. help with vba/Macro sorting
  511. Simple Folder, Workbooks, Worksheets Import ?
  512. Display of control check boxes and option buttons
  513. vba instruction for file saving
  514. html
  515. linking worksheets programmatically
  516. Writing from an excel user form on one spreadsheet write to anothe
  517. Sorting files by name(i)
  518. opening and searching files in filesearch
  519. How do I convert HTML tags within cell to text?
  520. From Immediate window to Text file - create a log file
  521. Find cell value, set cell shading
  522. Lines not executing
  523. Average of low five numbers?
  524. Help! Why doesn't this work after 2 times?
  525. info on faceid
  526. Run-time error 3265
  527. Check if Workbook is shared
  528. List of Pivot Tables and info
  529. push button question
  530. public functions using roundup
  531. Searching Subfolders for .htm files
  532. copy worksheet without opening the workbook
  533. Passing parameters from clicking a button
  534. MACRO TO DELETE ROW IF CELL VALUE IS ZERO
  535. Files In A Subdirectory
  536. specific number input, specific number output
  537. Export sheet to C# DataTable
  538. How do I run macros upon opening only if it is not the template?
  539. List of Recent Files
  540. Macro to open the text import wizard
  541. Copy Filtered Data by selecting from a drop down list
  542. Safety & incident reporting
  543. Getting error:External table is not in the expected format.while u
  544. How to control the Excel VBA Editor Main Window Caption
  545. Macro needed
  546. MATCH function, with variable lookup_array
  547. Modifing example code
  548. Advance Filter in Multiple sheets
  549. Problem with Listboxes
  550. WORD ART MESSAGE BY MACRO
  551. What VBA will work when Excel opened in IE?
  552. PLEASE HELP - HOW TO SPLIT AMOUNT BY MACRO
  553. Identify Hyperlink Selection
  554. How to make a particular cell alone as Read-only
  555. number set input, specific number output
  556. Macro insert rows depending on # in Column B
  557. How to get row number?
  558. activate sheet only using hyperlink
  559. ShowDataForm not showing selected range
  560. Re : Excel After-Life for an AutoFilter upon VisibleDropDown;=False
  561. how do I calculate number of characters that will fit in a cell
  562. Macros attached to WordArt
  563. Finding specific excel files
  564. trying to catch error 1004, don't work in 2nd loop...
  565. Macro to Sort
  566. unload Me compile error
  567. Question on RDBMerge Add-in
  568. Cell Coordinates and Printing
  569. popup msgbox ok continue simple code
  570. Add attachment to an already open Outlook email
  571. How to programmatically access Number Format String in the Format
  572. Searching through Subfolders
  573. using Application.Run
  574. Search by Font Colour
  575. INFORMATION MESSAGE BY MACRO
  576. Reset Custom Button on toolbar
  577. Error 1004 - again
  578. Oddity when opening templates from code
  579. Opening a .csv file thru a macro
  580. RE: Circular Reference (Two problems)
  581. Array and not loseing trailing zero's 123.00
  582. row totalling venture
  583. Re: Searching comments?
  584. Re: Searching comments?
  585. OleDb Excel 12.0 bug
  586. Insert image, get name of image
  587. Excel Properties get lost
  588. Set fs = Application.FileSearch
  589. conditional formatting
  590. VB code stalls when file is shared
  591. Macro not updating labels? XL 2007
  592. choosing a range dynamically
  593. Phone book formatting
  594. Highlighting cells
  595. macro updating imported data and pivot tables
  596. Excel AVERAGE function
  597. Can you trap the Delete event?
  598. Opening Text Files Through Notebook
  599. Importing text files into same workbook.
  600. Linked Access Queries
  601. Building a Macro for different size trend-Charts??
  602. Maximum Memory Issue Excel 2003
  603. Adding Procedures
  604. Drag/drop from TreeView (not in ActionsPane) to Excel Worksheet ?
  605. User Form
  606. Text box behavior difference
  607. Simple Macro
  608. Re:Converting an Excel sheet to an XML file.
  609. Finding variables in code
  610. Close workbook
  611. Blackened cells on pasting
  612. Why would Excel react this way to this loop macro? Driving me crazy!
  613. binding pivotchart with sql server in vb.net
  614. VBC Code
  615. Spell Check in excel
  616. Sort Worksheets Alphabetically
  617. RE: Find and delete
  618. Change Color of Caption in User form 2007
  619. Using same Class in several projects
  620. Option Base 1 in class module
  621. Speed of direct link
  622. Nice and easy - convert text to its numerical equivalent
  623. Range.Find gets slow
  624. Inputing information from one worksheet to another
  625. Lastrow of a range
  626. ActiveSheet test
  627. Manipulating a combo box on a website
  628. Rrefesh pivot table without ODBC
  629. Return table fieldname on recordset
  630. Problem with speed marco excel 2003 and excel 2007.
  631. help with an array formula
  632. weird behaviour from combo box
  633. Why would Excel react this way to this process?
  634. Global Variables
  635. Different Font Sizes In The Same Cell
  636. Creating a Ribbon in XL2003?
  637. Deleting rows
  638. Changing a file extension
  639. update from file?
  640. General ODBC Error
  641. Reading columns and rows in selected range
  642. array formula question
  643. hide rows variable row length
  644. Hide Rows Based on Cell Result
  645. Cell doesn't change if another cell is Y, otherwise make it = a thirdcell
  646. How to programmatically upgrade .XLD to .XLXS
  647. Tab Name Error
  648. Excel to Access
  649. Cell by Cell Loop
  650. MSQuery and NZ()
  651. have a range of cells shade a certain color
  652. Sort problem
  653. Excel 2007 Forms show information
  654. Problem with Logos as pictures
  655. Variable workbook name references
  656. sorting dynamically
  657. Webbrowser and DocumentComplete
  658. Switching between open workbooks
  659. Importing Access Query in Excel 2007
  660. Passing a variable to a GoTo
  661. How do I lock a column in Excel once data is being exported?
  662. Frustrated with my ignorance of the ribbon
  663. selecting workbook
  664. Deleting filtered data
  665. VIA Excel - Composing a Lotus Notes email without sending
  666. Minimise Workbook
  667. Sheets.name
  668. Creating Splash Screen in Excel 2004 MacIntosh
  669. Finding a cell value and deleting the row with that value in it
  670. Error with toggle code
  671. Email files on C Drive
  672. Writing Array To A Named Range
  673. automate excel to login web pages
  674. Re: listobject or listobjects sample code
  675. Data Validation and Macros
  676. Remove Module / Form
  677. Replace old schema with new one in EXCEL file
  678. How to create an HTML mail and open it with outlook using CDO
  679. An issue with "References" in VBA
  680. format Text box in userform
  681. oldest OS that microsoft supports
  682. .net question
  683. Need to generate a msgbox telling how large the file is
  684. Displaying cell contents
  685. The New Rich
  686. Down button goes past bottom of combobox list to next object.
  687. Copy worsheet from different files in to one file
  688. Err.Raise X...anybody got a list of X's and what they are ?
  689. Excel2000 procedure in Excel2007
  690. simplify date input
  691. Print row when cell in one column blank
  692. Custom VBA Function to sort an array of values.
  693. Need formula 1 x 2 1x x2
  694. RE: Newbie question - code attached to spreadsheet vs code in module
  695. combine Myvalue with formula
  696. How to Enable Redo Option
  697. Excel programming - Conditional sorting
  698. From where i can ask relating formula in excel
  699. ExportAsFixedFormat printing issue
  700. Can i save activeworkbook to binary data before save ?
  701. Populating Cells with Zeroes
  702. Column Headings Repeating
  703. Close workbook
  704. Number of objects in a collection
  705. Exporting to a "specific workbook"
  706. Creating a Hyperlink within a marco
  707. complete blank cells
  708. Macro for Retrieving data from closed workbook with date in title
  709. HOW TO SELECT SPECIFIC CELL
  710. Create New Sheets from Filtered List
  711. Get current cell after OK on user form?
  712. How to do when the Cell is in color jump to next cell?
  713. Is there an Excel equivalent??
  714. Dates Being displayed the wrong way around.
  715. Select random cell from defined range
  716. Re: Range concepts
  717. Cursors and Mousepointer
  718. PLEASE HELP - MACRO NEEDED
  719. Extract matching data from large data file (csv)
  720. how to show (excel export)webpage in our LAN?
  721. Code to automatically sort a list, each time that a new entry isadded to the bottom of the list
  722. Keeping getting a #Value error
  723. test if a value is in a range of values
  724. lookup help needed
  725. Desktop shortcut
  726. Userform scrollbar nightmare!
  727. Excel 2007 Recognize Formula
  728. Re: Retreive a variable
  729. VeryHideWorksheet With a Macro? .... or even normal hide?
  730. ComboBox
  731. Decimal question in variable?
  732. Move curser left one cell
  733. Update numerous comboxes at once
  734. RE: Autofill problem
  735. MS EXCEL (NEED HELP)
  736. Hide menus etc in Excel 2007
  737. User form combo box
  738. sheet protecting
  739. Working out the start day, for a particular month and year
  740. summarize multiple worksheets using VBA
  741. Re : Excel to Insert an AutoFilter (at will)
  742. Excel VBA macro to encrypt a Workbook or Spreadsheet
  743. Excel VBA macro to send email attachment from default email client
  744. Re: A thanks to all help here
  745. VBA:Populating Cells/List From External Data
  746. nse website query
  747. Help on Visible Property
  748. reset end of wksheet
  749. using mouse click events in macros
  750. Comparing lists in Excel/Visual Basic