PDA

View Full Version : 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 | 

  1. Trap Mouse Move event for Images inside the shape or Image control
  2. if fuction in data validation
  3. Two dinamic graphs in a worksheet
  4. How can I covert Indian Rupees to Word in excel 2007
  5. Sub to open n close .xls files in folders
  6. Renaming worksheets taking REALLY long... any ideas?
  7. Dialog box for Inserting Rows
  8. Capture an event for hyperlink is Excel
  9. Shapes Fill
  10. Change SourceData with ScrollBar for SheetChart Type xlColumnClust
  11. copy method of range object
  12. Creating a ratings spreadsheet?
  13. Macro to insert row in protected sheet
  14. Very Unusual Sort Rows Needed
  15. MACRO - INSERT ROW
  16. recalculating RAND() inside a VBA loop
  17. Macro fails on 1 out of 4 computers
  18. How can I seperate Imported text with delimeter as part of the par
  19. determine current theme in xl2007
  20. Bolding a Cell under certain conditions
  21. Premium Solver Macro Problem
  22. Numbers in combo box
  23. filling a table depending on column heading
  24. Fill/Copy Up to fill blank cells.
  25. Is Sumproduct best for me?
  26. index and names of open workbooks
  27. Null value in excel
  28. Cell Reference
  29. More efficient code than this?
  30. How can I get Memory used by Current Excel Application?
  31. Automatically increment cell reference
  32. Get smaller range from within another range using VBA
  33. Excel 2007 Named Range - Naming convention
  34. Changing rows
  35. New to VBA
  36. Working with Excel via Visual Studio 2008
  37. disable macros in a worksheet
  38. Problems with ChangeLink Command in Excel 2003
  39. Excel 2007 - Workbook.Open Question
  40. Working with Excel via Visual Studio 2008
  41. Tick Quandry
  42. Fine Tuning
  43. Copy from Internet Explorer & Paste in Excel
  44. runtime error 13
  45. Export to Excel with different sheet names
  46. problems with calendar control
  47. need mulitple lines in a cell
  48. Are links relative?
  49. add 1 to the value in a cell
  50. enter check mark with one click
  51. Up and then down VB code
  52. Object Library References Question
  53. Excel 2007 Add-ins
  54. Columnwidth in cm?
  55. I need help creating a macro
  56. Program to insert pictures
  57. Need to you quotations ("") in a string.
  58. Method 'Range' fails while using AllowEditRanges
  59. FileSearch on a remote server
  60. Tiny Charts
  61. Event Change code
  62. userform question on UserForm_Click()
  63. Problem copying formulas using VB
  64. Hi, i need help whit macros
  65. Lotus Notes VB code (yes, it works)
  66. Batch Delete VB code
  67. loop though numbers
  68. Problem when copying a range from closed workbooks (ADO)
  69. Calling a function within a macro
  70. Userform is blank
  71. Macro output as Text
  72. Inserting Comments with VBA
  73. error 13 when setting worksheet listbox
  74. Keyboard shortcut values displayed on custom ribbon
  75. data validation (multiple options)
  76. macro needed for saving
  77. excel macro to copy the word document to new excel workbook
  78. How to run Excel Macro on all files in folder
  79. goto next if
  80. .Refresh BackgroundQuery:=False
  81. List Box Select All Values
  82. delete unused rows
  83. Modifying a LARGE text file
  84. Standard numbering
  85. Excel as a data source for Outlook to email Word docs
  86. Chopard Mille Miglia Chronograph Mens Watch 16/8271-95
  87. Cartier Santos Galbee XL Steel Mens Watch W20098D6
  88. Why is my UserForm event procedure disapeared?
  89. Knowing what Folder I'm in when I open from a shortcut
  90. Required Columner Data
  91. Date Diff Help
  92. EOF Parse Text file
  93. finding the next empty column
  94. average of column
  95. Count number of like occurences across all worksheet within workbo
  96. VBA Newbie
  97. Workbook closing
  98. Header horizontal margin seems fixed, won't move
  99. Make sure all items in a Collection equal the same thing
  100. images for user form
  101. How can I locate image code in a worksheet object
  102. UDF or SUMPRODUCT with 51 named ranges?
  103. Determine if particular procedure(s) exist in module
  104. CustomProperties
  105. Using VB to change a defined formula within a pivottable
  106. Parsing, mid, left, trim or right to find specific word in string
  107. Exposed Workseet names
  108. Move downloaded bank transaction to a specific worksheet in same workbook
  109. Custom View Macro for Excel 2007
  110. Variable equal to values in a list
  111. Variable Address in Pivot Table VBA code
  112. Disabling Function Results in the Function Arguments Window
  113. Copying an entire sheet from 2007 to 2003
  114. UNABLE TO IMPORT A TEXT FILE HAVING 30 COLUMNS. LOADS ONLY TILL 26column.
  115. Application on my desktop
  116. Excel VB ListBox 'Height' Problem
  117. relative path
  118. Excel import data from old accounting systems
  119. Named Identity
  120. Using Form Buttons / Objects
  121. Link source - Need change?
  122. Record Comparison Between Two Databases
  123. Output file to My Documents
  124. Prevent SaveAs on Protected Sheet
  125. Macro is choosing by tab name?
  126. Macro (Modle) naming insight
  127. Problem with "Call was rejected by callee."
  128. Run-time error '1004', the macro xxx cannot be found.
  129. looping down 1 column then start agian at the top of the next column?
  130. Checking for duplicates
  131. ISERROR
  132. Changing the "From" field in Outlook using Excel macro
  133. Convert Range to Array
  134. Prorgram doesn't work on different computer
  135. End loop
  136. Hiding rows
  137. Window Caption
  138. Cancel Toolbar load
  139. Delete rows based on more than one condition.
  140. FileSearch in Office 2007 generates an error?
  141. Deleting a Worksheet??
  142. Quotation marks in a string
  143. How to copy data from merged cells to their individual cells?
  144. doesn't read all data from cells into xml file
  145. VBA Vlookup
  146. PivotField CurrentPage Change Event
  147. freeze or lock rows when using Auto filters
  148. Userform - placing
  149. Using IF to decide action
  150. Autoname a range
  151. Color sorting
  152. Autofilter-sorting from specified cell
  153. How do I create an organization chart in excel
  154. Common set of macros
  155. How to use SUMPRODUCT or SUMIF with 2 criteria?
  156. Re: How to open correct Module window in VBE by macro
  157. Macro to copy active worksheet from multiple Excel files into 1 fi
  158. Relative Path in Excel to a word document
  159. Pulling data from mySQL DB to Excel spreadsheet
  160. User form bug
  161. Search Form
  162. Launching PowerPoint from an Excel application
  163. Write filepath to file
  164. Problem with Naming Cells
  165. Find variable in a sheet
  166. Command Bar Excel 2007
  167. EDATE & #NA Errors
  168. Music files
  169. Tags for worksheets
  170. finding numbers
  171. use only part of window name in a macro
  172. mousepointer
  173. Can you use offset and empty in the same code
  174. Can you hide and unhide rows with a macro based on content of colu
  175. little mistery..
  176. Simplify Code help
  177. Importing to Excel 2003 - Code from Jean-Yves
  178. Add two cells if one cell is greater than 0
  179. Surpressing a Message
  180. Multiple ADO queries at the same time
  181. idiosyncracies of user form
  182. Changing printer defaults in Excel Worksheets
  183. Need code assistance to update pivot table from an ADO recordset
  184. Regional Language
  185. Web Queries : Passing variables via POST method not working
  186. Converting xlsx to xl
  187. How to obscure functionality
  188. Help!!! Database lookup from excel
  189. VBAProjects still open for workbooks closed in Excel 2007
  190. Using Variables in ActiveCell.Formula
  191. help required to change format when converted from excel to xml.
  192. Mail with "Lotus Notes"?
  193. Auto Filter
  194. excel macro to copy the outlook mail body to a new excel workbook
  195. Macro to delete on condition
  196. Excel 2007 - Textbox Formatting
  197. Offsetting to identify value in header row
  198. Assigning value to text
  199. User defined range for vlookup w/ loop
  200. Inserting a blank line
  201. Fill series event detection
  202. and + or
  203. XML export form a Excel
  204. Open Workbook Empty?
  205. code instead of functions
  206. For Next If help
  207. howto: disable date recognition?
  208. Image Control Question
  209. Force Save Folder Location on Network
  210. File closes without prompt to save!!!
  211. using an excel database function in Visual Basic
  212. Open a workbook from a written path
  213. Selection
  214. Select locked/unlocked cells
  215. 32000 chart limit warning
  216. Wildcard use in comparason.. Please help
  217. delay in msdos batch file
  218. Using 2 cells in the same row within a form
  219. multi threading
  220. Writing Data to cells
  221. Re Excel 2007 Trend Equations
  222. why do I have to have the table files.xls open in memory to query
  223. putting criteria directly into a database query, dsum, daverage, e
  224. Excel 2007 Shell Command Runtime Error HELP
  225. a way to make this more compact ??
  226. standby for parts of code
  227. Creating an AutoNumber ID as a primary key
  228. Data validation list limit
  229. Search and Replace Problem
  230. Can't Unhide Complete Workbook after adding code to hide it
  231. take fields from form to report
  232. How do I pass a value from an event back to my VBA Programming enviornment.
  233. relative reference between two tabs
  234. Setting Up a Dynamic Print Range
  235. Trying to Mimic an Array Function in VBA
  236. Print selection using check boxes
  237. Macro to create different groups
  238. End without Next Error
  239. use different string variables in FOR loop
  240. Position a user form next to selected cell
  241. Find and Replace Help
  242. Inserting a value based on another value
  243. Find and Replace Question
  244. relatetive reference-to perform a series of cal and return result
  245. keep last row added visible on the screen
  246. find a value in another sheet
  247. Get value from one row to another
  248. Accelerator keys
  249. How Can Make equation With IF X>Y>z
  250. Changing BackColor of ToggleButton produces a muddy grey color
  251. File path extracted to the cell in lowercase and sometimes it does
  252. Convert numbers to HEX
  253. find by font size
  254. Fails then continues without error
  255. Redraw problem
  256. Hide rows of active selection
  257. Macros using drop downs
  258. Plotting a number of single point series on a scatter graph
  259. output unique records to a dynamic range
  260. Format Textbox on an user input form
  261. Max patient census by day by hr
  262. Adding selected numbers
  263. Select Case
  264. Looking for Input
  265. Macro
  266. using vlookup in a loop
  267. Filtering A CSV file during the import
  268. can you specify a worksheet during file open in excel?
  269. WorkSheet Change Event - Need Help With Coding Syntax
  270. simulate pressing CTRL and A
  271. PasteSpecial between workbooks
  272. Listbox with available procedures
  273. Need to Add Text to Control Text Box via Command Button code
  274. Permission denied code 70 on killfile
  275. copy to clipboard
  276. RefEdit
  277. Set print area based on last row with a given value
  278. Find text Sequentially Number
  279. When do AddIns load?
  280. Sum and Rank
  281. Excel macro Cc distribution list control
  282. How do I create a .bat file to create a shortcut on the desktop?
  283. Input on a user form
  284. Macro takes a while to run - should I be concerned?
  285. Final Days 2008 East Coast U S Excel User Conference
  286. Run a Stored Procedure from Excel
  287. Are there any other way to run the vba code than...
  288. Reading Data from an Excel Sheet
  289. Protecting an Excel worksheet from being renamed
  290. Long Shot !!
  291. Get a Date to show as a Date Format in Combo Box
  292. Macro to create charts - Points to wrong sheet
  293. VBA unable to recognize code after reinstallation of MS Office
  294. Pictures.Insert not working in Excel 2007
  295. Clear selection in CSV-file
  296. Software copy Protection
  297. Calling a public function from a worksheet
  298. Setting an array of text boxes equal to individual form text boxes
  299. [Microsoft][ODBC Driver Manager] error
  300. Can I use the address function as an argument in another function?
  301. Complex Count
  302. Cell justifcation
  303. Cell to display certain if an entry is provided
  304. "Move Several Cols Down One Row"
  305. Macro to execute at a set time, pull data off of a web page, and e
  306. Need help with formula to count currency of personnel between 2 da
  307. at excel start need macro to remove autofilter & apply sort mult t
  308. Merge Worksheets w/Comments & Hyperlinks
  309. multi-line controltiptext
  310. first user form.....
  311. Custom Icon
  312. Over-ride protection for one user - doable???
  313. How to make a custom function to work in another workbook
  314. ControlTipText
  315. Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions
  316. Newbie Needs Help.
  317. User Form - use of single form for multiple sheets
  318. Strange problem when running macro from PPT'07 copying ranges from
  319. Autofilter, protected worksheets, Debra Dalgleish's code
  320. Calculations
  321. Conditional format based on adjacent cell value
  322. Retrieving Part of a Cell Contents
  323. auto copying Excel spreadsheets
  324. Compare List A to List B, Return List B Items Not in List A
  325. Array vs. Collection
  326. Find Worksheet code names from PowerPoint 2007
  327. Trying to concatenate based on font color
  328. Linking Cell Data to Text Boxes on a Form
  329. Control scrolling in a TextBox
  330. Single hotkey to do a date time stamp into a cell... and then type
  331. create spreadsheet where all changes can be stored
  332. Cannot pass argument from control to sub and back
  333. Compare columns - weird baffling problem
  334. Print Worksheet by Page Number
  335. xlApp.Quit - Doesn't Close Instance.... Any ideas?
  336. Multiscaling the same graph
  337. Looping through multiple sheets and pasting data in first blank ro
  338. Excel 2007 - Legend.Position
  339. Pick data from web page (no query)
  340. macro to open the mail and copy the data to excel
  341. find text within string and then delete
  342. Link to a sharepoint list
  343. Saving a workbook using VBA
  344. Inserting getpivotdata formula using vba macro
  345. Trapping invalid dates
  346. Macro for Tab Changes
  347. stuck in loop
  348. Conditional Formatting Issue
  349. Hide Rows
  350. Time stamp with undo funktion
  351. ComboBox Queries
  352. Advice Sought
  353. Code to add attachment
  354. Select range
  355. Help with Debug issue
  356. Count number of times macro was executed
  357. test dbl click 'target' is part of named range
  358. some simple (?) simulation
  359. validation
  360. How to creat custom made error message in separate window
  361. lock a cell from users but not macros
  362. Worksheet change time format
  363. VBA code to select a cell so it appears in the top left of the screen
  364. Macro "out of Memory"
  365. Create Multiple Filter and graph data
  366. Unprotect Cells When Radio Button Selected
  367. Filesearch .LookIn fixated on MyDocuments
  368. Delete Workbooks
  369. Excel 2007 File Slow Response
  370. Call a procedure using a variable
  371. strange formula array issue
  372. I would like to block access to my VBA coding
  373. Excel chart data in Power Point
  374. Clearing contents from a range
  375. worksheet template
  376. drawing text on a worksheet
  377. VSTO 2003 deployment problem
  378. Compare two spreadsheets
  379. Macro Help Please
  380. Index # of selected embedded chart
  381. Macro doesn't work when Sheets are protected UserInterfaceOnly
  382. Setting cell colors using RGB( ) function
  383. using best approach for activecell property
  384. Application.Quit Does not Close the Application
  385. Changing The "Printing Sheets Per Page" In VBA?
  386. How to return query with out headers
  387. RE: Code to open multiple files from within a folder
  388. use information from an input box in cell reference formula
  389. Scroll bars and how to print
  390. Again, for Excel 2007, Clipboard image saving issues
  391. Using a Range variable to call a procedure with a ByVal statement...
  392. Macro to find and copy to another sheet
  393. using OFFSET to fine DUPLICATES in a list
  394. call Excel subroutine from Sql Server?
  395. Hyperlinks and Comments
  396. Set Priority for Conditional Formatting in Excel 2003
  397. Excel 2007 pivot tables - calculated fields and SSAS cube
  398. Programmatically copying range in design mode
  399. Scrolling
  400. Need to change the following code
  401. Re: copy data to one file from all files
  402. Error using Union in a Loop
  403. Worksheet_Change event not running from Form control.
  404. using loop in ontime
  405. PlotArea.Left Question
  406. command button not working
  407. Excel References Not Release When IDTExtensibility2 Used
  408. Macros assigned to Menu Items
  409. Please add a "Paste Value" Command to this macro.
  410. RE: Browse for folder - not selecting folder
  411. User-defined functions not calculating/recalculating
  412. User-defined functions not calculating/recalculating
  413. User-defined functions not calculating/recalculating
  414. Updating "active window" in Embedded Excel OLEObject in PowerPoint
  415. AutoFilter
  416. Use number in text box to look up value in a workbook sheet
  417. Re: Browse for folder - not selecting folder
  418. RE: Import data from web page into excel
  419. Re: Browse for folder - not selecting folder
  420. RE: copy data to one file from all files
  421. Re: goto next line
  422. Re: macro to save the file as per the path selected
  423. Re: Code to open multiple files from within a folder
  424. A problem with HPageBreaks
  425. VBA to create directories based on 'date picture taken'
  426. Listboxes Without User Form
  427. Array as defined list in sheet 'Temp'..
  428. List all applications running
  429. Excel Programming
  430. Clipboard images to Bitmap files through VBA in Excel
  431. click image in web
  432. Creating a que
  433. Accessing The Value Of A Merged Cell
  434. newbie
  435. Excel 2007 macro problem in editing a cell
  436. Dynamic Array Problem
  437. creating multiple pivots fails
  438. Drop down list
  439. Script out of range
  440. validate entry via messagebox
  441. Copy as Picture takes up to 5 seconds to copy
  442. Automatic Update links to web query
  443. Code to close many open workbooks
  444. Is it possible with a macro??
  445. VB Code to hide rows
  446. format issues
  447. Combine 2 Ranges as One and copy to another worksheet
  448. Create two pulldowns from another pulldown.
  449. Macro Help....
  450. Insert Macro into Excel Workbook using C# code
  451. Compile Error: Can't Find Project or Library
  452. Loop Macro
  453. how to disable Office alerts...
  454. Time to Unhide an Entire Column
  455. Checking Outlook Email Address
  456. How to catch events from an outlook mailitem object from an Excelmacro
  457. Control the OLAP Cube Value updating in Excel 2007 Workbook
  458. go to child window
  459. Scroll
  460. Classic PivotTable Layout
  461. linking worksheets
  462. Lock
  463. Format Page setup for multiple worksheet in a workbook
  464. Aboslute path to reference macro
  465. vlookup sub procedure help
  466. Lists
  467. Using VBA to Print duplex (two sided)
  468. Basic VBA questions....
  469. code to parse a multi-colum multi-select listbox
  470. Error trying to write array to range
  471. MAXA won't work with VLOOKUP?
  472. Sort Range by Font Color
  473. Excel 2007 VBA speed update
  474. Problems in macros after chaning Operating system to Windows XP
  475. Hiding Tabs
  476. Change VBE Settings
  477. RE: loop whole sub
  478. how to execute a stored procedure in SQL server from Excel 2007?
  479. VBA Converter
  480. can excel simulate three dimensional spreadsheets
  481. Error after code is run
  482. Winzip and email multiple files (RondeBriuins code not working)
  483. Modifying Ron's Sub Copy_To_Workbooks
  484. Change refedit control image
  485. Problem with RefEdit Control in VBA
  486. LoadPicture(FileName) with size?
  487. RE: Change the background color of cells once it being edited
  488. pivot table
  489. Searching for non null cells
  490. count cells in range
  491. Help with code to run macros from hyperlinks
  492. suppress Workbook_Open event
  493. application-defined or object defined error
  494. Macros and hidden worksheets
  495. Add a Image to sheet attached in Ron Debruin's email attachment code
  496. Extract a single file from a Compressed Folder (Zip file)
  497. Combo Box Data Validation - First Entry Blank
  498. Formula to sum up customers totals from other sheets
  499. VBYesNoCancel Modify the YES and No Text
  500. Last Save date/time and User for a specific sheet in a shared work
  501. Check if text box has more than one entry seperated by a comma
  502. Using Data Validation to Filter Lists
  503. Copy Paste Macro not Pasting Values when Blank
  504. Blank Cells
  505. I want to create lists from web pages
  506. #VALUE
  507. Excel rejects XSD from Visual Studio DataSet Designer.
  508. Read of excel spreadsheet with ADO recordset
  509. Putting a default nam e in a SAVE AS dialog box
  510. VSB more efficient then standard functions?
  511. Copy Paste from Class Sheet to Filtered List on Combined Sheet
  512. How can I make a cell to flash?
  513. "Counter" in macro
  514. Programming Invoices for Reports
  515. Edit Comment from UserForm
  516. Can you tell me the Print options for ExecuteExcel4Macro?
  517. Share workbook update changes setting
  518. filter the data and paste in another workbook
  519. Excel 2007 / application.filesearch no longer works
  520. limiting text entry into columns
  521. Delete rows based on text value in a range
  522. Run Procedure when The Value of A Cell Changes
  523. Excel 2007 losing cell validation
  524. Disable all Control Events on a Userform when it is Intialized
  525. Can I detect if user has Excel 2007 and display different pages?
  526. Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003
  527. controlformat.enabled failed in excel macro
  528. Filename in Macro
  529. pivot table; adding kolomns to the base-table afterwards
  530. Update sheet one if data is not present.
  531. Logic
  532. Select Coloumn Range based on cell value
  533. Refering to Codenames in Remote Workbooks
  534. Code in 2003 not working in 2007
  535. Transition Formula Entry and Copy of Values
  536. New Web Query, from very long URL
  537. Multi-column Dropdown combox on a commandbar
  538. How to move AutoCorrect entries between computers in Word 2007
  539. Macro Help
  540. simple vb question
  541. Copy all data into one sheet and insert origin data... code amend...
  542. Input Box w/Drop Down List
  543. Match Value in Range and Then Paste
  544. Protect / Unprotect Sheet in Share Workbook Excel
  545. How to Zip then emai 4 files please
  546. Count Different Values in a column
  547. Hyperlinks
  548. Removing text before and after word in cell
  549. Determine File Filter Selected
  550. Save As window with vba
  551. Static variable
  552. If/And formula showing true/false instead of cell value
  553. How to avoid arrey formula?
  554. Replace password with *** in input box, xlVeryHidden
  555. Auto_Open and global variable
  556. HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED
  557. Change the background color of cells once it being edited
  558. Forms Buttons on Sheet Frozen
  559. Word to Excel
  560. Prompt to Unprotect Single Worksheet
  561. ftp paths defined in variables are persisting. How to clear?(vba)
  562. Popup Window Containing Image
  563. Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet
  564. Manual Page Breaks in VBA
  565. Creating an automatic log of filenames copied to flashdrive?
  566. Select worksheet using a variable
  567. Find Value and Move Rows to another Sheet
  568. Create a vbCheckbox from code in vb command button
  569. complex column addition
  570. Accessing a Stored Procedure
  571. file size increases drmatically
  572. Subscript out of range
  573. excel instance stays open
  574. Compare several cells in row & output value for match
  575. VBA dates versus Excel dates
  576. Control Zoom for Print Preview
  577. String variable name is incorrectly used literally
  578. CONSOLIDATION OF TEXT FILES. DATA FROM VARIOUS COLUMNS.
  579. Loop to insert data from a form - Help
  580. Vba - Access Setup Question
  581. Help with paths
  582. Color gradient
  583. Multipage Name
  584. Remove the $ from a cell reference
  585. Help with Array & Split
  586. Making a spreadsheet lock up after a demo period expires
  587. worksheetfunction.match
  588. Merge a range from all workbooks in a folder with AutoFilter(RDB)
  589. Search Columns and return multiple rows.
  590. Calculating a cell
  591. managing time
  592. Picture property
  593. Solver Error with Function "EXP"
  594. How hold multiple versions of the same range?
  595. (no subject)
  596. Comparing lists in 2 workbooks and copying missing rows into new W
  597. vlookup in vb
  598. Database password
  599. Phantom workbooks in VBE in Excel 2007
  600. identify specific word in a range of words
  601. Create Folder Variable
  602. hyperlink - colors and macro question
  603. Book about using VBA to run SQL queries with results put in Excel
  604. Data Validation error
  605. Getting data from a spreadsheet without opening?
  606. How to zip an active workbook
  607. Find Posts?
  608. HELP PLEASE Any one Know how
  609. help creating a marco please
  610. Mail Merge from Excel
  611. Save worksheet after printed
  612. Help creating a macro please
  613. Macro help (not the sharpest tool in the shed)
  614. Merging two cells within the same table
  615. Clearing Hyperlink formating from undefined # of cells in a column
  616. Add a row with data
  617. Pivot Table
  618. Data Validation, Drop Down Lists
  619. This sub runs to a function in a Module. Why?
  620. Strange Background
  621. Very Slow reading excel data into an array (while opened in new xl
  622. Annotating charts with text from within VBA
  623. Filtering Data
  624. Macro for recurring formula; max of set of cells
  625. Design Selecting Controls
  626. sorting in a macro and defining last row into varible not working in
  627. how do i export excel data directly to my outlook agenda?
  628. Help adding a label to Total line
  629. Unselect option buttons
  630. Need Code To Run Always
  631. HelpContextID on a single field
  632. creating custom menus
  633. Help with annoying VBA editor behavior
  634. Protecting conditional formats
  635. Excel Instance Hanging Around
  636. Protect VBA Project By Macro
  637. format table
  638. REMOVING DATA BASED ON OTHER CELL INFORMATION
  639. Chart with a defined named range?
  640. REMOVING DATA BASED ON OTHER CELL INFORMATION
  641. Change the value of particular cells in a Named Range
  642. SetFocus in a custom dialog
  643. last date saved in excel
  644. those little "moving lines"
  645. finding control
  646. Prevent users from saving if cells are blank
  647. Event procedure or ............
  648. combo boxes again
  649. How to Determine group of numbers best fit into 1 number
  650. Import XML Problem
  651. Display Excel Data as a Calendar
  652. XML Importing Problem
  653. Update a specific worksheet
  654. Insert a symbol using VBA
  655. Using Form Combobox in VBA Excel
  656. Very basic question, please
  657. Help....
  658. Numeric representation of curve/distribution for resource forecasting
  659. Data Validation Error
  660. Change Cursor Image if Workbook is not the Active Window
  661. If - Then Code Help needed
  662. Sumproduct with A1 notation instead of R1C1
  663. Exiting a workbook
  664. Dynamic list based on sheet names
  665. Help! Cannot calculate 123 * 456
  666. Parse a txt file and save as csv?
  667. Filtering VBA
  668. Help with "floating pop up menus" (if that is correct)
  669. How do I decrease the value of a column by 10%
  670. Limiting number of characters in textbox
  671. Formatted Date in header applied with a macro
  672. Need help with hyperlink character limit
  673. Help with Macro
  674. Calling Excel methods from a different thread (COM add-in)
  675. Scripting Error
  676. **URGENT** Macro to find a Cell
  677. Userform causing a slip for Worksheet activate?
  678. What is proper way to Open Close Release xls files in VBA?
  679. Text and Pic pop-up box
  680. Format RowHeight question
  681. Script Error?
  682. Formating question
  683. need SUM code help
  684. Loop Through UserForm For Multiple Different Outputs
  685. automatic charactor replacement
  686. Order in a array / ListBox
  687. SpecialCells
  688. Need Help programming treasure hunt sheet!!
  689. Accessing the Bessel Function within VBA in Excel 2007
  690. Move one record to another sheet when I type in a cell
  691. How to control the OLAP Cube Value updating in Excel 2007 Workbook
  692. Referencing data validation list in IF Statement
  693. Get address from iFrame reference in page source
  694. Manage and run a WMP Playlist in Excel
  695. Multiple wrksheets same columns globally change order of columns?
  696. Macro in UserForm
  697. Split address in 1 cell into 4
  698. Disable AddIn via automation
  699. how do i run an external file
  700. Function Trouble: Not sure how to correctly reference my variable
  701. Input box
  702. match up columns and move data
  703. creating a pulldown based on the value of another pulldown menu
  704. Task Tracker
  705. Dynanic Print Range
  706. removing data based on other cell information
  707. Copy two summary ranges to master summary sheet
  708. Name/Description of error?
  709. Remember FLIGHT 93
  710. VB Command Button
  711. Name of Sub/Procedure?
  712. Execute an external file in Active X control Button
  713. Adding a selection of values and storing result in a variable
  714. Remove buttons from worksheet programmatically
  715. Kill Function by author
  716. Import "ThisWorkbook"?
  717. Search data w. use of msg box and copy results to new blanc worksh
  718. Put data from various cells to one cell
  719. "object variable or with bock variable not set" - quick reply greatly appreciated!
  720. How to access cell properties in arrays for automation?
  721. Clearing a listbox
  722. Time Format
  723. Hide/Show rows based on Conditions
  724. Problem with Updating data from several Sheets
  725. Problem in opening Excel which is already opened by VB code
  726. Error handling
  727. Strange validation list problem.
  728. Need to find macro
  729. Evaluate duplicate rows and delete information in specified columns
  730. Password Protection "Sheet 2" ???
  731. Search multiple worksheets and return value to main worksheet
  732. Activecell Count
  733. Pass Workbook Name Into Another Workbook As A Variable
  734. Line Charts - Is this possible?
  735. Creating a DLL for Excel
  736. Automatic Chart update Excel File 2003
  737. Compare Ranges
  738. Clearing data in a row when rows start to duplicate
  739. Placing cursor in message box
  740. Clearing data in a row when rows start to duplicate
  741. Populate combo box with external data
  742. Folder Passwords?
  743. Hiding Pictures "Run-time error '1004'"
  744. How to copy a part of a cell coming from a Web Query?
  745. Change Mouse Pointer Image in Workbook
  746. Condtional Formatting or VBA Code
  747. Blinking Scroll bar
  748. CONCATENATE
  749. Looping clmns, Copying worksheets, and Projections
  750. How to set a value in a list?
  751. Can sales register be linked to custom forms?
  752. Scroll bar
  753. Prompt for Save Path - Use Cell Content for File Name
  754. Start UserForm From Different Workbook
  755. Excel Sort
  756. Userform Commandbutton mousedragover event
  757. Convert decimal Englishpoint (.) to Swedish (,) (texts to digits)
  758. Nasty intermittent
  759. Image Property
  760. Macro to set print area
  761. XLDialog for setting the Print Area of a worksheet
  762. dyamic printing
  763. Excel2007 crashes while setting chart formatting
  764. Faster Pagesetup in Excel VBA using xlDialogPageSetup
  765. Formatting text that appears in messages
  766. Complex copy and paste looping VBA help
  767. Permanently remove rows
  768. error question
  769. Excel Expiration
  770. Display rows if conditions met
  771. Need Help with If,Then
  772. Excel 2007 Programming Error - 0x80010105
  773. how to copy matching data in next sheet
  774. How to get current information regarding a fresh query refresh?
  775. "collapsing" data--but only for certain rows
  776. Excel - PowerPoint VBA
  777. Copy/Paste in VBA fails?
  778. Sorting CSV Data By Date
  779. file resizing
  780. Last ActiveCell
  781. Value LIKE
  782. create text file
  783. How to enable / disable ControlButton added to Cell CommandBar
  784. 2008 East Coast U S Excel User Conference
  785. Determining if ChartObject is in PrintArea on Worksheet
  786. Problem with new programme
  787. Unable to set ColumnWidth property
  788. Reference
  789. Macro Sensitivity analysis Update table
  790. Colors on a pie chart
  791. macro delete rows <>1
  792. Using a Macro to Hyperlink to another Excel Workbook.
  793. Name of VBAProject ???
  794. Place formatted Text in Shape(textbox)
  795. Run-time error '1004' . Please help. Request for immediate attent
  796. number format
  797. Identifying duplicate entries
  798. Control Row Height
  799. Each cell in selected cells test
  800. Accounting Format Text in a Textbox
  801. Add Two Columns of Data into a ComboBox in Userform Initialize Eve
  802. Identify Smart Tag
  803. Find All Replace All
  804. Date & Time Picker Control 6.0
  805. Unlock Protected VBAProject via code
  806. Set DTPicker Date Value if it is not Visible on Userform
  807. string width
  808. list permutations
  809. Cube functions won't refresh when Printing
  810. WTF?? Stange happings with a VB code
  811. Automated Macro
  812. quickest way to find last "used" row in a 2D array? (repost)
  813. set command button on a worksheet
  814. Input Box Question
  815. Fill cells
  816. Icon Size in Ribbon
  817. Append Unique Records to Master Worksheet
  818. Stepping through v. running code
  819. xlDialogPrint
  820. Adding text to the start of a formula
  821. Copy/paste rows to new sheet based on cell value
  822. Cross Function when array crosses above another
  823. Data validation list box
  824. Referencing a cell as a row number
  825. Pivot table sorting - can I do this?
  826. How to change the font used by dropdown list box?
  827. list of folders and subfolder.; quit simple ..but.;
  828. Can't figure out how to do this loop
  829. I'm stuck
  830. Reset ScrollArea
  831. Time Format on Worksheet Change
  832. Excel API or documentation for ActiveX?
  833. Getting Underlying Data from a Pivot Table Cell
  834. Scrolloing
  835. Copy Contents from Cell
  836. Copy Autofilter Source Workbook A result in Destination Workbook BSheet1
  837. Bypas Nil Values
  838. in a columnGet to first positive value
  839. How can I time the speed of a macro?
  840. Creating a formula in Macro
  841. Entering two functions in code
  842. Cannot get accurate results from Hittest
  843. Sub Workbook_Open not called when opening spreadsheet
  844. Output sql query results to text file
  845. Why do I still need to cast "Range selected = (Range) app.Selection;" ???
  846. Limit Characters Shown in a text box
  847. Embed Command Button in Cell
  848. Cycle through Variables
  849. Embedded Combo box changes size
  850. Date Entry
  851. Copy History (recently opened) to Cells
  852. A macro solution - replace text given the values
  853. Create two combo box in a single worksheet
  854. Looping rather than code for each row
  855. Can I put a Formula into an Excel User Form?
  856. Start a macro when cell >=0
  857. Digital signature
  858. Time format via Worksheet Change
  859. Divide rows equally & extract first & last of each block... Possible?
  860. Copying data from different sheets to one mastersheet
  861. MultiSelect Listbox
  862. Modify to do to each required cell
  863. Time sheet in calculate per 15 minutes.
  864. Userform question
  865. Macro to show which cells have validation
  866. "deselect"
  867. Making sure the user is able to run macros
  868. Macro within a macro
  869. Allowing Hyperlink to Work on Protected Worksheet
  870. After Insert
  871. Sover -- how do you stop "The maximum time limit was reached..." b
  872. cannot see text box
  873. opposite of Union
  874. Passing Control Names in an Array to another Procedure
  875. Deleting characters after 3rd occurence of a string
  876. Create an Outlook Task
  877. ExecWB
  878. Can Excel capture a screenshot?
  879. Autofill down over blank cells until new data, and repeat.
  880. IRibbonUI error
  881. Pivot table filter - Selected Item Event
  882. AutoComplete Entry in Text Box or Drop Down List
  883. Excel Sort
  884. Exporting Data with Line Break
  885. formula to define the number of gallons used
  886. code signing - avoiding "enable macros" once digital signature expires
  887. VLookup in a Macro
  888. New Loop, 2 workbooks
  889. set range to bottom of sheet
  890. formula to blank cells
  891. Using variables within countif
  892. Skipping the "Overwrite" warning within a Macro
  893. MouseDown with an AutoShape?
  894. Find value copy and delete
  895. Freezepanes
  896. Re: Status Bar Message
  897. Cant set the date into a Date & Time Picker from Cell value
  898. Send Network Message
  899. add vbyesno to existing macro
  900. Macro Help
  901. I am trying to create a formula
  902. iterating through a Dictionary object
  903. Linking worksheets for updates
  904. Lock Position of Controls on a UserForm
  905. Last Row
  906. How to determine which columns are used in formulas?
  907. macro is slow when I minimize spreadsheets
  908. Logical statement: equivalent of an IN function?
  909. Formula not consistent
  910. Selection in a range.
  911. Change Mouse Pointer on protected sheet.
  912. Macro to select A1 in all sheets so that users always at top of sh
  913. Basic help with sheet
  914. Encrypt 2007 xlsx file using VBA
  915. Empty selection with vba
  916. Commanndbar and tooltip display
  917. Detect copy and paste action
  918. Cell formats change while opening the file via VB
  919. Multipage control
  920. For Don Guiilet,please help, 1004 error,1003 (type mismatch etc et
  921. Open workbooks in one click
  922. Is there public domain code to calculation cointegration coeffici.
  923. Re : Excel AutoFilter Detectable via the Most-Recent Activation of aFilter
  924. ListBox Condition Not working for 1st Entry
  925. Anyone had this problem
  926. Appending sheet
  927. Modules
  928. Displaing result in Entire worksheet
  929. Good reference books for Office programming?
  930. Copy, modify and save a spreadsheet a from web application
  931. Delete Sheets to the left
  932. Help with Instr function
  933. Form - Get Selected (true) value of Option Button
  934. Excel and Active Directory
  935. Global Variables
  936. Trouble referencing the correct cell. Function will not work.
  937. Re : Excel To Call Sub and Assign Arguments
  938. In Excel:How do I ? =N14 BUT IT MUST SHOW O14 IN D18
  939. color cells of period
  940. check digit scheme: mod 10 or what?
  941. Send network message
  942. Tools / Options
  943. Colors programatically
  944. Copy Rows based on column value
  945. Getting stock market prices
  946. Displaying the infinity symbol in an excel spreadsheet
  947. Print Preview Office 2007?
  948. Sorting a named range using first three columns
  949. Taking data from other workbook ina macro
  950. Unable to run macros...
  951. Controlling Change event when loading a form
  952. Run-time error '1004' . Please help. Urgent
  953. Change Font Color for Dupes on Selection Change
  954. Paste non-adjacent cell content from Excel to open Word document
  955. Next Line in Auto Filter Macro
  956. input box searching and adding values
  957. combobox
  958. Opening a Word Doc
  959. Color List
  960. Find if between dates
  961. Copy 3 columns become one column with macro
  962. dropdown menu accross row data as list fill range
  963. runtime error 9 -- subscript out of range
  964. One Variable Available In Three Workbooks
  965. InputBox Date Value
  966. UDF shows #NAME? when moved from XLA to XLL
  967. Dont know cellformat in vba
  968. batch file call from a macro - how ? and required batch format
  969. Cells.Find and PivotTables
  970. Open Webpage and Extrat data based on list in excel
  971. Autofil syntax to auto-complete the range
  972. Change all files format in folder
  973. Deleting number strings
  974. New Loop, 2 workbooks
  975. Links cannot be updated related bug - DA
  976. Sum based on mulitple criteria and show indicator
  977. Code to automatically close an Excel spreadsheet
  978. Creating a macro to sort a complex dynamic named reference
  979. Error handler not handling
  980. How to consolidate multi-row data into a single row?
  981. Percentage Formula Issue
  982. Creating new worksheets using data from a single worksheet
  983. Calendar Control (Embeded) - Populate thru a command button
  984. Combo Box Selection Changes w/o Input
  985. Reassigning a macro to an ActiveX button
  986. Simple GetData Question
  987. VBA help needed
  988. Graphing the sum of an autofilter result
  989. Copying workbooks
  990. VBA
  991. Formula help?
  992. Survey building and analysis tool
  993. Convert from "xls" to "xlsm" format
  994. Saving a file with a macro without a path
  995. trust access to Visual Basic Project checked
  996. Formating listbox columns
  997. No Excel Help Section for DTPicker and other code.
  998. Add range after selected cell
  999. html chart and table in outlook mail
  1000. MMult function . Highly frustrating experience please help.