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