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. Licensing policy for Office Web components
  2. autofill values
  3. Newbie question on deleting duplicate rows
  4. multiple search criteria to find and copy from sheet1 and paste into sheet2
  5. Another loop & sheet question
  6. Read security level
  7. Underscore character _
  8. Crash on save
  9. How to shift address info. from rows to columns?
  10. Loop worksheets
  11. ATTN: KEEPITCOOL
  12. Button Enabling based on check in checkbox
  13. Compile Error, Can'f Find Project or Library
  14. Conditional Button Enabling based on Checkbox
  15. Return the column of the next empty cell
  16. Semi-log graph?
  17. Algorithim to generate/check valid serial keys
  18. Strange Module line
  19. how do I stop the find at the end of the sheet
  20. is this formula possible in excel?
  21. Control tip text - can you have a new line?
  22. error trapping
  23. Naming objects on creation
  24. Change a date in text format xx.xx.20xx to a recognised date format
  25. VBA generated command buttons
  26. beginner text box question
  27. Updating sheets to include new data beside old data
  28. Project Window
  29. Need help with sorting, please.
  30. Close and save macro
  31. Excel VBA and XML
  32. mail merge
  33. Getting list of open workbooks
  34. Last cell within an address
  35. Converting a string date into a Excel Date
  36. Adding items to the second column of a list box
  37. Array Help
  38. Calculation
  39. Hide Columns That Contain Checkboxes
  40. option groups, formatting
  41. How do I?
  42. Limit a macro
  43. scroll bar
  44. scroll bar
  45. MAPI create object error
  46. VB String Comparison In Excel
  47. Searching Columns
  48. Public Function IsStrikeThrough(rng As Range)
  49. VB Find
  50. In VB, get Auto Filter Range
  51. Format row based on cell value
  52. Remove Formatting Apostrophe
  53. save command bar into an excel workbook using vb
  54. Fillright
  55. Control Excel
  56. Simple Variable Question
  57. Portability of early bound code - clarification
  58. Starting Excel
  59. I am a little confused with the VLOOKUP results I am getting....
  60. finding cell info to rename sheet(s)?
  61. Help : Code for selection non-contiguous cells
  62. Copy ranges (columns) instead of whole row
  63. Problems with Match function
  64. Read a single column text file
  65. VLOOKUP Problem
  66. Copying a sheet to new work sheet
  67. dynamic arrays as an argument/result in programmed functions
  68. Insert Page break in Word
  69. Passing data back from a form
  70. Re: Passing data back from a form
  71. Updating (Adding Rows) To A Second Worksheet
  72. Calculating # Days in a Date Range
  73. Validation from a list
  74. Re: Create controls dynamically
  75. Re: breakup spreadsheets
  76. breakup spreadsheets
  77. Formula Explanation
  78. excel VBA or VB6 -which one
  79. Making a macro run when the user closes a workbook
  80. Re: Making a macro run when the user closes a workbook
  81. Re:
  82. vba gridlinecolorindex question
  83. Seperate columns with a tab??
  84. many workbooks in one.
  85. Re: Turning macros into executable code
  86. Import output from mailmerge
  87. Reading Userforms
  88. What is the easiest way to setup a 'global' macro which is always available to Excel on a PC?
  89. Currency
  90. Importing Access Data and formatting it in Excel....!
  91. PivotTable DefaultVersion
  92. I post the same subject.please help me on this
  93. Inputbox or UserForm
  94. File directory into a listbox
  95. Excel 2003 VBA Help for TRanspose is missing
  96. Deleting name-objects
  97. ListBox array
  98. Checking database field
  99. VBA function returning the value EMPTY
  100. First four columns lose formatting when DAO macro is run
  101. conditioning 'find'
  102. Sort cell values
  103. Scope of a public variable
  104. time indication bar
  105. Pictures in file
  106. Delete worksheets
  107. Prevent Users from switching worksheet
  108. Maybe a little off topic
  109. Calculating total days from 2 dates
  110. printform vba
  111. Validation from a list
  112. vba problem
  113. CDO email questions
  114. error message
  115. Automation SaveAs HTML
  116. Help with text box and time
  117. Autofill months in cell
  118. Procedure kills copy and paste
  119. macro? clearing/ transferring info to another sheet
  120. Userforms - Dealing with zeros and non-entry of data
  121. Opening Text File From internet
  122. Excel to Zip
  123. Conditional Cell color change
  124. Moving worksheets
  125. Colorvalue of cell Z1
  126. Digital Signatures for Excel 97 Macros?
  127. Scaling controls
  128. Location of control button
  129. Longer loop than expected
  130. Enable/disable page on multipage
  131. Restricting scrollig by arrows to certain area
  132. Disabling standart menu options
  133. Locking the Application Window size
  134. Preventing users to move object in the sheet
  135. selecting multiple sheets
  136. Copying workbook contents to another workbook
  137. to find next data
  138. If then statement
  139. ms query xp issue
  140. range onclick?
  141. Eliminating Excel msgbox from popping up while macro is running.
  142. Using controls in excel to store data
  143. Printing with coordinates
  144. Some helps Please
  145. Peek at data in open excel sheet
  146. MsgBox
  147. Array questions
  148. Is it posible to set up some code to Filter Worksheet on Colours
  149. Call to custom function appears as typed not as result
  150. External data queries within applcation collection
  151. RGB of highlighted Excel button
  152. Using VBA functions in Worksheet cell data validation
  153. error 1004 "Cannot edit a macro ..."
  154. Calculating with textboxes....
  155. Find Metohd again...
  156. Stopping an animation macro
  157. Listbox help
  158. AutoFilter Problem
  159. object or structured orientated??
  160. Working with lists
  161. MultiLine/WordWrap usage
  162. vba that give you folders size
  163. Putting Listbox data in cells
  164. Worksheet menu bar using code????
  165. Pivot Table Formatting
  166. Loop Edit
  167. Do While, OnTime and CommandButtons
  168. Excel increasing slowdown, in multiple versions
  169. file writing
  170. display message upon open
  171. VEENLR3.HLP
  172. Auto Filter use
  173. Storing non-user data
  174. reducing file size when done
  175. Sharing custom forms
  176. Links in Excel Files
  177. Convert List box from excel file to VBA list box object
  178. Help with some code please
  179. Excel shared file
  180. Jump to duplicat entries
  181. UCase Help
  182. ActiveX control
  183. forms in excel
  184. Development hours (off topic)
  185. Range Reference in Visual Basic
  186. Help
  187. read last line of a file
  188. AutoFilter
  189. OLE Embedded File Link
  190. Find Method ; search area
  191. embed excel in ie using vbscript
  192. VLOOKUP : how to use defined name in it
  193. Simple copy and paste
  194. Columns and Rows Values
  195. Reset Combo Box back to Null
  196. Stop a loop with a keyboard
  197. COUNTIF()
  198. Help with creating CLEAR button
  199. Help! What's wrong with this simple copy and paste
  200. VB File Controls available to Excel VB?
  201. data check
  202. MultiPage Error
  203. MACRO TO LINK DATA !
  204. modules
  205. cancel a print
  206. .FileSearch
  207. Prevent smearing of treeview when scrolling
  208. Pivot Table Problem
  209. On Error Resume Next
  210. VB Help Errors Out
  211. Running macros from another workbook
  212. "AfterPaste" event again
  213. ADO Link does not work...help
  214. Copying RESULTS of a FORMULA to another worksheet
  215. Excel data validation multiple lists
  216. Autorun a macro
  217. Can't get Excel to quit
  218. validate list xl2000
  219. protect a macro
  220. Reformatting question
  221. Which event puts *white* handles around a chart?
  222. Word positioning from Excel
  223. Copy ranges of data from Master worksheet. Thanks
  224. excel to manage access data file
  225. Array-problem
  226. Defining an auto-open macro that prints specific worksheets
  227. help needed with excel macro
  228. Find Empty Cell
  229. How to change cell colors based on an IF statement formula?
  230. Need Some Practice
  231. Userform Capabilities
  232. Trying to set validation range using string yields error
  233. line breaks in a variable
  234. Getting values from a closed file
  235. Worksheet_Change Event
  236. Buttons
  237. need to split month out from date formatted cell
  238. Calling Macros from a list
  239. 'Properise' text strings using VBA
  240. auto format of info in footer
  241. Passing values between 2 subs ?
  242. How can I update the userform?
  243. It was SLOW, now is FAST!
  244. miscro excel
  245. how to get to Miscrosoft excel
  246. Excel main window close event
  247. macro and wildcard
  248. Deleting Files From VBA
  249. Update Region, Anyone?
  250. Creating a pivot table from different sets of data using a macro
  251. Excel Textboxes
  252. Command Button Problem
  253. Using Arrays as Data for a Chart Series
  254. running VB code
  255. Start Macro / Stop Macro / Restart Macro
  256. Pivot Table: Complex printing issue????
  257. Cell Change activating macro. How do you make it happen?
  258. Tools-Options
  259. Replace Loop
  260. GetAttr giving unexpected results
  261. Form Button with 3 Userforms Help
  262. Book on how to write VBA code in a fast/efficient manner?
  263. Formatting number in VBA
  264. Getting Copy From Range
  265. Dropdown from 5 years ago question
  266. Sheet locked by owner
  267. Printing Form Component information
  268. VBA / VB Numeric base changing function
  269. reference to .dll file
  270. Find OnAction property
  271. "AfterPaste" event
  272. Office 2003 Registry Installation?
  273. Re: Quarter date format
  274. Macro
  275. sort column A with "strike-through" values come first
  276. Hide all toolbar buttons
  277. Using Time Criteria
  278. formatting cells (borders, patterns, etc.)
  279. Exporting data directly from Excel to an un-opened Access database using VBA
  280. Excel 97 VB Print Tray commands
  281. Adding a custom function to the default excel function list
  282. ChiInv function
  283. Can you check the last update property of a file?
  284. Progress Bar Help
  285. Disabling looking for link file
  286. Variable Button Name based on Data? Can it be done?
  287. Multipage programming
  288. Modification history
  289. double quotes around string in formula craeted in vba
  290. Change formula based on color
  291. Show blank and not zero
  292. NT Domain Users
  293. select and delete sheets
  294. Who has used CIS with RTD?
  295. Instant messaging
  296. truncate text using VBA Excel
  297. Sharing a workbook
  298. commandbar
  299. Pivot table -conditional formatting (color)
  300. Mandatory cell check before closure
  301. Clipboard data at closure of a workbook
  302. making toolbars with a macro
  303. Delete macros in another macro
  304. Explanation of code
  305. Unable to save workbook within WorkbookBeforeClose
  306. Countif function
  307. RTD with DCOM and CIS
  308. Procedure too large
  309. RE: Apply conditional formating to color pivot table cells
  310. Autofilter help
  311. Create a Pivot Table based on From and To Dates
  312. How to Copy & Paste selected Range in Excel (MFC)
  313. Font color
  314. Can't Exit Design Mode because Control can not be Created
  315. Conditional Checkbox Creation on a UserForm
  316. Worksheet Function COUNTIF
  317. Help
  318. Compare values in 2 workbooks
  319. Percent Format
  320. Protecting Cells
  321. Speedup choices from a long list
  322. Want to move records
  323. Brackets in Excel filenames
  324. Print Area vs Print to fit
  325. How to Programmatically Insert a Page Break Every Nth Row in a Range
  326. best way to add worksheets together
  327. BeforeClose, Auto_Close, and ActiveX Server
  328. Changing Customer Styles in Code
  329. How to open a workbook from a template without hardcoding the path
  330. Investment performance tracking
  331. Very specific invoice auto numbering for the gurus
  332. Follow up with sound question- need more help
  333. Bolding some words in a MsgBox message?
  334. Publish Sheet AND Chart
  335. logo to top right of printed page
  336. Making certain a cell contains numerics
  337. countif(Range, Criteria) > 0
  338. can i have VBA & forms etc load then unload?
  339. How to extract data through ODBC with date criteria?
  340. Countif
  341. Determine which button
  342. Excel VBA Bugs
  343. A function that returns a Range with entries reversed
  344. Building a dropdown from a worksheet
  345. Help with AdvancedFilter method
  346. CSV String to consecutive cells
  347. Active Cell
  348. OLE switching <-> Apps
  349. How to open workbook from template without hardcoding
  350. Evaluating cells for items in list
  351. editing cells...
  352. Disabling the minimise button in Excel workbook
  353. Extrapulating Information on current population from a worksheet
  354. Current consecutive streak
  355. array filling: cell addresses
  356. TRACKING CORRECTLY LINKED CELLS!
  357. Code Needed - new user
  358. User form question
  359. Validate text box entry on user form
  360. Tolerances Logic for Excel
  361. link a vc application to excel
  362. Automating PP from XL
  363. Passing a value and getting results
  364. Automatically Sorting Columns into Worksheets
  365. Macro Buttons
  366. Toggling worksheet tab names
  367. Control Project From Excel
  368. SWITCH BETWEEN APPLICATIONS
  369. MSCOMM
  370. XP saves differently than 2000
  371. Cell Value Depends on Other Cell Value
  372. Workbook is saved on close - why?
  373. What does an ampersand mean in VBA?
  374. SaveAs Filename Help
  375. Unlocking a locked Spreadsheet
  376. ADP to Excel and Formatting
  377. Exclude AM/PM from time format
  378. EMAIL MESSAGE ONLY
  379. HELP!!!! -- (Method Range of _Worksheet failed) ERROR!
  380. How To Hide Code?
  381. Creating a tournament program in Excel 2003
  382. MACRO FILE
  383. Creating a function to test for the filters applied...
  384. Return Information from Functions
  385. Userform control
  386. range setting
  387. Excel Work Books
  388. conditional format depending on time
  389. Benchmarking: 3rd (and last) try?
  390. Command Button Tip
  391. Summarizing data in multiple excel files
  392. Macros on protected sheets?
  393. Form Letter in Word from Select Excel data
  394. Grouping Shapes
  395. Shortcut for Paste Special Values
  396. Print one page per row
  397. Restoring Toolbars
  398. Summing inv in list
  399. Identifying cells with external links using VBA
  400. MsgBox Help!
  401. Excel - RTD file wont save
  402. How does a macro access its OWN workbook?
  403. changing the title of an 'application.dialog(xldialogopen)'
  404. Macros
  405. why can't 'Do While Each Cell in Range...'?
  406. Formula Help!
  407. User Defined Functions
  408. grid control
  409. Functions
  410. Declaring Variables
  411. ADO-Excel link to iSeries
  412. ListBox question
  413. truncating and rounding
  414. Add-in Error , code help
  415. locked vb projects
  416. MoveFirst
  417. unable to save current workbook within WorkbookBeforeClose
  418. Re: using visual basic to access a protected DB
  419. Toolbars and Crashing
  420. Re: Is this a macro or a function?
  421. Is this a macro or a function?
  422. Hämta uppgifter från flera dokument
  423. Error with Excel Solver Add-In, Need Help
  424. macros for calculating a new average after inserting a new row
  425. Intersect Excel 2003
  426. Does a book like this exist?
  427. Evaluating a range
  428. A Simple Timer
  429. Intersect with decimal
  430. AUTO START
  431. Passing Variables
  432. Oblect not found in macro - bypass
  433. Copying a cell to another cell using a macro
  434. FormatSSN
  435. Refreshing data from ODBC automatically?
  436. Getting Excel password using vba
  437. Sequential Sub Procedures
  438. Sharing a workbook
  439. Comparting two excel sheets ...
  440. Is this possible?
  441. Filters on Protected Worksheets
  442. Is there a last update property of a file.
  443. Dialog box on the fly.
  444. icon in menu toolbar
  445. Using VBA to Protect sheet(s) with Autofilter
  446. Copying cell value to clipboard to paste into adobe pdf maker
  447. Launch Excel in another instance
  448. how to open workbook without hardcoding path
  449. Moving cell values from sheet2 to sheet1 using UserForms and ListBox
  450. Cell Protection
  451. sheets(count) code
  452. Re: Changes are saved to workbook even though I chose "No" when selecting close
  453. Small macro
  454. Pivot Table
  455. MACROs involving scrollbars
  456. error handler
  457. Delete Entire Rows
  458. Re: Changes are saved
  459. Do Until ? I think
  460. Goto next used row
  461. How do you get a Selected Range address into a variable?
  462. IF statement Help
  463. sort based on color in cell/column
  464. Hiding "work" taking place on a worksheet.
  465. Can I create a msgbox that is asking for a string to be typed in?
  466. How can I protect my work?
  467. Re: delete rows without numbers
  468. Re: Downloadins Access to Multiple Worksheets
  469. PasteSpecial - Comments and ColorIndex
  470. printing multiple report
  471. Compare Worksheet Values
  472. msgbox
  473. Range Variables
  474. Hiding and Unhiding work sheets
  475. Protect Forms
  476. A range of values transformed
  477. Downloadins Access to Multiple Worksheets
  478. Delete rows with text and blanks in column A
  479. Changes are saved
  480. Combo Box & Unhide Rows
  481. Adding calculated fields
  482. test a cells type
  483. VBA? VB? C#? Which to use?
  484. One worksheet into two worksheets
  485. Combo box issue when attached to projector
  486. Copy&Paste and Selection Change
  487. Filling a combo box from another workbook
  488. AutoNew
  489. How can I track down where a value is getting lost?
  490. Scrolling in VBA
  491. Conditionally Bold a row
  492. Insert data into a seperate worksheet
  493. What is causing a #Value!
  494. Opening Open File Dialogue box from Excel97
  495. Oracle to Excel to Eudora/Outlook
  496. named cell value from closed workbooks
  497. Problem with invoking project specific Sub in Excel????
  498. Old report suddenly not running
  499. Programming a console application
  500. Cell Updating with formulas
  501. Array Problem
  502. Help with Vlookup code
  503. Counting names thru code
  504. Inserting Columns...Redistributing Program
  505. Programming IDE
  506. XL97/Win2K - lookup and return listing
  507. Passwording Macros
  508. Incrementing dates by one hour returns bad result
  509. Create main switchboard and forms
  510. Invoking "#REF!" without hardcoding it
  511. Increase/decrease decimal code
  512. Favorite Error Handling Mechanisms?
  513. Another basic question... CASE with a range
  514. Coordinated Auto_Open/Close
  515. Autoscaling of axis on Excel graph
  516. Vlookup Conundrum
  517. VB.NET and Excel2003 COM Object and PIA
  518. MsgBox question
  519. export/deletingdata from Excel to access
  520. Picking data from another workbook
  521. GetOpenFilename Folder specfication
  522. Basic question: how do I change these in to functions?
  523. Code ends subroutine in error
  524. Command Line Arguments
  525. Error in loop
  526. Vlookups
  527. Removing Duplicates & Summing Quantity
  528. how shall i define the path when using export?
  529. DisplayAlerts property is not changing to False
  530. syntax
  531. search and replace within macros across workbooks?
  532. xla question
  533. How do you replace an existing file, saying "yes" in a macro?
  534. Active Cell Position Using Go To Or Hyperlink
  535. References
  536. Graying Out Some Rows
  537. Copy data where some cells exceed 256 characters
  538. Calculate average pay from highest five consecutive years
  539. supress Solver message
  540. Advanced Conditional Formatting
  541. Launching Excel
  542. Does sheet exist?
  543. Formulas
  544. context sensitive help
  545. Convert reference style
  546. Benchmarking
  547. How to change resolution of monitor/screen
  548. Selecting range
  549. Remove opposite/almost matching entries?
  550. Opening a Worksheet Dependant on Date
  551. Automated cell copy depending on cell content?
  552. Why Can't Unprotect and write value into worksheet before close.
  553. formula troubles
  554. open Access DB that is password protected
  555. Unprotect VBAProjects using VBA
  556. Updating Links in Excel
  557. Auto_Close() needs help
  558. Excel Formulas
  559. Cannot Paste into Textbox
  560. create wizard with Excel
  561. Array multiplication addition
  562. Extract data from different webpages
  563. how select block w/unknown last col and last row?
  564. Disable 'Add or Remove buttons' functionality on a toolbar
  565. Common Dialog Error
  566. Hide worksheet
  567. CommonDialog Error
  568. CommonDialog Error
  569. to textbox
  570. Tolerances Problem
  571. ActiveWorkbook.ProtectSharing
  572. Could Not Load an Object
  573. Unique generated Alphanumeric No.
  574. export a text file which more than 65536 rows into excel
  575. Warning prompts disabling
  576. Giving the String expression for Numeric Values....
  577. Replacing DirectPrecedents in a Formula
  578. Help! I can't figure this riddle out
  579. macro clearing cell content
  580. Execute a Macro when specific value is selected in a Range
  581. appending to second worksheet from a Master Sheet
  582. using hyperlinks to navigate around a protected worksheet
  583. Control Exit event
  584. how to tell which hyperlink was clicked
  585. Report Generation
  586. Macro to randomize a range
  587. Having a macro interact with a dialog box.
  588. VBA Password prompt on file open - 1 machine only
  589. code for creation of multiple pivot tables
  590. Using Filtered values as values for a chart
  591. Time Capture cont...
  592. ADO
  593. Create formulas with $Rn1Cn2:$Rn1Cn3 format
  594. Macro to convert specific Numbers to Letters...
  595. Open Webpage and then Run Code
  596. Updating from another spreadsheet
  597. Message Boxes.
  598. Subverting autocomplete
  599. vba - format
  600. userform
  601. Time events to trigger VB (corrected)
  602. Tim events to trigger VB programs
  603. Re: Time Capture...
  604. Formatting Dates
  605. Re: Time Capture...
  606. Cleaning Text
  607. Color Code
  608. Obtain memory usage?
  609. Time Capture...
  610. prompt when saving as .txt (Tab delimited) format?
  611. special formatting (for social security numbers)
  612. Code not Working - Help please
  613. find and copy data from one sheet to another
  614. Using VB.NET w/VBA
  615. AUTOMATING CHARTS W/VBA
  616. Copying Worksheets from 1 Workbook to another
  617. Exposing a function to other workbooks
  618. Option group and Combobox
  619. vb code to export data into existing Access table
  620. Find and Replace in XP
  621. Combo Box in userform
  622. How to Open A File with Visual Basic
  623. Add ins
  624. Programmatically Format Comments
  625. Programmatically Format Comments
  626. i really need help w/ this please...
  627. Re: Search acrross Workbboks & Worksheets???
  628. remove unused Rows (with 0 qty)
  629. Capturing user name
  630. Searching for VB Code to Link to Program
  631. Find row of date of previous year
  632. Writing to a excel spreadsheet is slow.
  633. Counting Days
  634. Pivot Table Connection
  635. Sorting worksheets alphabetically (code)
  636. edate function in VBA
  637. Programming to go between Access and Excel
  638. OnAction command failure
  639. Using Message Box to Open/Import Text File
  640. TEMPLATES
  641. Cycle thru & format all columns
  642. how to set activecell?
  643. Copying Row Data From Multiple Sheets To Master
  644. VBA from Excel 97->Word 97 tables
  645. SaveAs
  646. Deleting Macros
  647. Correlate selection row with worksheet row
  648. Macro Line Inoperative
  649. Macro button
  650. How do you add arguments to an OnAction event?
  651. dynamically creating check boxes
  652. click cell and open matching value in next sheet
  653. Find Method doesn't work
  654. Cell Referencing
  655. Getting a handle on Userform controls
  656. Open Ms Access database with excel macro
  657. Passwords
  658. Selecting Columns
  659. Cell Tab Order
  660. Autofilter More than One Worksheet
  661. FillDown
  662. Chart Names
  663. Sorting worksheets in a workbook
  664. Diff. btw Open [path] For OUTPUT vs. For INPUT
  665. ThisWorkbook.Saved does not work!
  666. Exporting data to access
  667. plotting
  668. plotting
  669. Sorting and delete records with macro
  670. Passwords and protection: wordtlengths?
  671. Crash upon using RefEdit
  672. Column heads for list box - how to do it
  673. Columncount
  674. Getting a file name using a built in dialog box
  675. Excel 97 & Pivot Table
  676. Autofilter contains vba strDept
  677. How do I count occurences of data entered in a column??
  678. formula for changing cell color
  679. Short VB code for PasteValue
  680. Testing for existence of range
  681. Printing Chart and UserForm on same page
  682. busy screen
  683. securing your vba program
  684. Copy Modules from One workbook to Active Workbook
  685. webbrowser control error
  686. How to number unique entry values in excel
  687. Deleting a file on C drive using VBA
  688. sheets.range and adding cells that are out of the range
  689. selecting a cell in sheet1
  690. Web page to worksheet
  691. Auto Filter and Criteria1 variable
  692. Picture
  693. How do I get a filter to "UPDATE" the rows selected?
  694. After Close Event?
  695. Referencing a cell for a value in VBA code
  696. worksheet collection issue
  697. Clipboard Data Within Macro
  698. Make a directory on the fly
  699. Onkey
  700. how to open a url in a new window from VBA on Excel
  701. Return the number of Sheets in a Workbook
  702. Line Chart Macro
  703. commandbar hunt
  704. adding and removing style properties
  705. This can't be the best way to do this
  706. QueryTables Interrupt if URL is Down
  707. Copy from active workbook to new workbook.
  708. eliminating "newer version" message when saving
  709. RE: Cell Referencing
  710. Re: Color Cell if range values
  711. XLA calls dll
  712. Selecting Active Cell before Text Import Routine
  713. Color Cell if range values
  714. History Archive
  715. Concatenate from J to Q column using VBA
  716. build dynamic table
  717. Delete/Replace Newling Charecter from all cells.
  718. Is it possible to change the Input Range of a Form Control programmatically?
  719. Cell Referencing
  720. format social security number as XXX-XX-1234
  721. How to get the highest average from a database-type list
  722. Passwords on macros's
  723. Cell Formating
  724. Macro
  725. math question Excel 2000
  726. Excel Worksheets
  727. cell values copied!!
  728. Help with some code please
  729. Adding Custom OCX to Excel in Add In
  730. Delete entries that match second sheet.
  731. HIDING ROWS
  732. Compile error in hidden module
  733. QueryTable with Copy/Paste Functions
  734. Format Problems using Copy/Paste with QueryTable
  735. worksheet loop
  736. Re: Differentiating Text from Hyperlink Data type
  737. VB Editor module
  738. Screen Update Dilemma
  739. Exporting to Excel using ASP Problem
  740. Selection is too large
  741. dynamic graph data series
  742. List box
  743. VBA to trigger a sound effect
  744. How to open workbook in the same Excel app
  745. subtotal
  746. vba: isempty
  747. Graph Excel Selection, Open Word File, Embed Graph Into Word
  748. Change default police size on a workbook
  749. How can you hide the macros ?
  750. Changing link to textfile in Pivottable
  751. Deleting Macros
  752. Toolbar button To Run a Macro?
  753. macro for order forms
  754. Excel workbook size random evolution
  755. A macro to export a sheet as UTF8 encoded Unicode file
  756. Using Copy/Paste and QueryTable Operations
  757. Synchronize network login/password
  758. Using VBA Copy/Paste and QueryTable
  759. Chip, I solved it
  760. Grouping Option Boxes?
  761. web search with excel data
  762. How to add 0's in time cel
  763. vba: setting font color to entire sheet
  764. Re: List Open Workbooks in VBA
  765. Syntax for using the full path to get a value
  766. Cell Changes in Excel - How Do I Capture Them ?
  767. modify formulas with dropdown
  768. Disable Cell
  769. how to automatically insert blank lines in between non-blank lines
  770. Saving GIF images from worksheet using VBA
  771. Formula Modification
  772. change of button properties upon activation
  773. Arguments and brackets
  774. how can I ..... ?
  775. On error goto 0
  776. pagenumber
  777. Check if more than one font is used in a cell?
  778. excel calculate problem, (try to refer to defined names?)
  779. VBAProject Protect
  780. Create a marcro that changes number of decimal places in a field according to specified criteria
  781. Lost Personal.xls Workbook for Macros
  782. Asking user to print and error message
  783. e-book on vba
  784. conditional written statement
  785. OR function
  786. Userform & Excel window
  787. Function to extract element of a complex delimited string (Pick D3 database)
  788. Reference a Column in Code
  789. stuck on final prat of spreadsheet "macro copying cells"
  790. Disabling Print Preview but allowing Print
  791. Stopping the use of enableevents
  792. autofit function in excel
  793. how to specify the no. to print?? (possible? how?)
  794. secure your worsheet using vba
  795. need excel macro
  796. Last Row As Range
  797. Can you build in a delay...
  798. Excel 2000 / Graph
  799. Conditional Formatting.
  800. Problem with Merged Cell Line Height Macro
  801. Add Attachment
  802. Excel as a development Platform? pros and cons?
  803. Sending emailswith CDO
  804. Counter linked to Registry
  805. Links to other worksheets on another workbook
  806. Problem getting a msoButtonDown status
  807. import outlook task to excel
  808. Inserting from a list box?
  809. refferencing named range in different workbook
  810. Running a macro if msgbox is yes
  811. Sending Email using CDO ERROR
  812. Array Problem, Help Please.
  813. Macro or script
  814. Dynamic Text boxes in UserForm
  815. Change ReadOnly State
  816. Browsing to URL and reading contents
  817. How to pass ListBox into a Sub?
  818. Focus on combobox
  819. More on VBE syntax line question
  820. Extract file names last save info from a Folder
  821. VBE syntax line question
  822. Folder Nanes
  823. DIsabling Escape Key while dialog active
  824. Recalculation Speed After Editing Macro Code
  825. formula help
  826. Quitting Excel without saving
  827. Disable controls on spreadsheet
  828. How do I create a summary page?
  829. place an embedded object into an RTF e-mail message in Outlook 2003
  830. Creating a Toolbar with a macro
  831. Last cell in a range
  832. User name & password access to Excel files in a folder
  833. Emailing Sheets Code Edit
  834. Vasant - Thanks for your quick help
  835. Calling a Custom Function within a Procedure
  836. value of variables do not show when I hover.
  837. syntax
  838. Spinbutton grays out toolbars
  839. Is there a way to get a portion of a WEB
  840. How can I ensure a message to the computer user is aknowledged?
  841. VBA for applications help files are incomplete
  842. Saving sheet as a UTF8 file
  843. how to read multiple workbooks, collect a few cells from each?
  844. CommandBars
  845. Excel97, VBA menu programming by ID Number.
  846. Worksheet Name
  847. Emailing Sheets
  848. Prevent Excel creating new instances of Excel
  849. Problem with formula in VBA
  850. Automate Access
  851. How do I delete rows and columns in With With End Loop?
  852. Worksheet Selection Change
  853. Poking Excel data into a Word Documnet
  854. Copy chart sheet without links
  855. Calling a Fortran dll from Excel
  856. I could really need your help on importing contacts into Outlook (Please?)
  857. Filter Function
  858. worksheetfunction.match
  859. Command Bar
  860. Macro
  861. Workbooks(). close intermittent failure
  862. SQL combo
  863. Import multiple text files into excel
  864. VBA Long data type overflow
  865. web site on excel VBA
  866. A count function or macro needed
  867. textbox result to label
  868. Merging duplicate rows
  869. Copying Visible Cells
  870. DateLastModified property date extraction
  871. Listing html Title tag in a spreadsheet.
  872. Copy Cells from columns to rows
  873. Insert HPageBreaks
  874. wait
  875. Playing a sound base on cell value
  876. activate control
  877. shortcutmenu
  878. copy, paste and save file
  879. xlMaximized from excel spreadhseet in LotusNotes
  880. MAX of Multidimensional Array
  881. How to use VBA
  882. Help with Combo Box code
  883. Auto Filter in a macro
  884. Goto next empty cell in a range
  885. delete empty column in VBA
  886. Command Button not working once sheet is protected
  887. Equivalent Method to Control + END
  888. Iterate columns
  889. How to toggle
  890. Textbox number formatting
  891. Add-in query
  892. Variables in headers
  893. Deleting Files from Within an Excel Macro
  894. Loop macro help.
  895. Loop macro help.
  896. Landscape Orientation when Footer set using mso-footer-data Disappear
  897. Printing problem with terminal server
  898. I want to read data from WEB-pages into EXCEL
  899. copy a range of cells (a row) to the bottom of a "list"
  900. VB question on ComboBox
  901. Dialog Box - User hits cancel
  902. Index of Cells in a selection
  903. Index of cells in a selection
  904. running a VBA sub from a hyperlink
  905. Excel Slowing To A Crawl
  906. save failure
  907. Popup message
  908. resizing an image on a form
  909. Userform Help
  910. Using ActiveWorkbook.Names.Add Name:=
  911. XML and Pivot Tables
  912. err
  913. Bizarre Behavior referencing a sheet.
  914. Worksheet change
  915. Entering functions in code
  916. Excel.exe
  917. Using a Public Variable in a cell formula
  918. Worksheet Change Sub problem
  919. TreeView control
  920. Automate the 'Camera' function in Excel VBA
  921. Missing Reference
  922. Comparing two worksheets
  923. VBA macro step-by-step
  924. XLA Link Issues
  925. cells with formulas
  926. CSV Files
  927. AutoFill Question
  928. getting a macro warning, even through there is no code
  929. Ranges in VBA
  930. Converting text to value
  931. Excel 2002 Spin Button
  932. Spin32.ocx control tab not visible
  933. Distributing a VBA app across different systems, help please
  934. Transfer multiple columns items form listbox to range
  935. subtotal at the end
  936. Navigating
  937. MS Excel macros on Pocket PC?
  938. How do I get the sheet name?
  939. How do I get the sheet name?
  940. insert row and range changes problem?
  941. xls Cell reference in an SQL statement
  942. copy data from a list to another sheet
  943. Custom Add-In?
  944. Querying dynamic web content in excel
  945. Chart range
  946. Count data per row and more ?
  947. Query Parameters
  948. Re: Row deletion debug
  949. Macro to open a file
  950. Distributing a VBA app to clients... licensing?
  951. referencing different workbooks
  952. vba pastespecial
  953. Macro for Customer response time
  954. Highlighting a Block of Cells to Define the Print Area
  955. password madnes
  956. Is it possible to include Excel worksheets/workbooks into COM Addins ?
  957. What type of script???
  958. Macro Calls
  959. macro
  960. Change date format to text format
  961. Macro to display a menu item - possible?
  962. hyperlink onto an msgbox
  963. Personal.xls
  964. Cancel button in Inputbox method
  965. Add text in am macro bellow the already entered text
  966. Status display
  967. running a sub when found
  968. undoing a VB action
  969. Before_Close problem
  970. What is brest way to flit between two spreadsheets
  971. Setting row & column sizes
  972. VBA building stand alone application
  973. Creating a printers list
  974. macro to send data from word to excel
  975. Batch file in Shell Function
  976. Complex Combobox problem .
  977. Pasting to Sheet
  978. Reminder in Excel 97
  979. Plot where mouse clicks
  980. Use sheet name as search string or autofilter criteria
  981. Can't access to a WorkBook
  982. Cleaning up excel & Digital signatures
  983. Multiply range
  984. Help needed !
  985. Stopping screen tips from displaying for Excel hyperlinks
  986. Automatically moving a chart range at the beginning of the next month
  987. RE: VB help please!
  988. Discussion: VBA Project Code Protection
  989. deleted item
  990. Conditional Row Deleting
  991. Deleting unwated control characters at the end in a particular column
  992. combo box
  993. Re: File list
  994. Re: The Error That Stumps Me
  995. A mouse with a mind of its own
  996. Re: VBA charting Question
  997. Re: Use excel as a searcher
  998. Re: Help with dumping data
  999. Hiding Columns
  1000. Opening a sheet at a certain time