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. Assigning click event to OleObjects checkbox
  2. VB Macro
  3. Re: cell copying
  4. Re: Named ranges
  5. Customizing buttons VBA
  6. Macros i xla-files get incorrect path
  7. help.. want write a simple marco
  8. execute a text as a formula
  9. Excel VBA, VBS and Network Security Issues
  10. Make this the active workbook
  11. Please Help!!!
  12. User Defined Function: Format Output
  13. Label, Text and Form controls in Excel 97
  14. Anybody see anything wrong with this
  15. Macros and IF Functions
  16. ctrl/shift/enter thru VBA
  17. Need help with userform....please....
  18. Secondary Axis
  19. Macro shortcut keys not work properly
  20. HELP With search
  21. Return value from calendar to a label...
  22. Re: hide print box
  23. Excel Coding Problem
  24. Adding a macro to a button.
  25. Re: Userform w/ Multiple listboxes that link
  26. Re: copy data range
  27. Exclude cells from calculation?
  28. Problem in SQL Query
  29. Loop Through worksheets
  30. Lookin Property.
  31. Opening workbooks in sequence
  32. How to find out country-dependent Format Codes
  33. Copy a macro
  34. Error handling in vba function
  35. Problems integrating Excel VBA application with frontpage
  36. Bold Msg Box
  37. MsgBox With Multiple Lines?
  38. Re: Problem in ODBC Query
  39. Error 7
  40. Creating worksheets and auto listing them
  41. Excel ComboBox
  42. Merging duplicate data across multiple columns
  43. How to Insert MSchart picture into excel.
  44. MultiSelect ListBox in Excel
  45. Bob phillips??
  46. Whats wrong with this code
  47. 'Esc' handling
  48. Can RefEdit Contrl be Used on a Modeless Userform?
  49. To: Paul B and Brian B
  50. copying data from csv file
  51. Print sheets in a worbook.
  52. Using Excel and Query--copy workbook
  53. Re: Macro Error Please help
  54. MAPS + Excel
  55. Re: Hide password in the InputBox
  56. Help: Looking for the replacement of RefEdit control
  57. changing a text value to a number value in a textbox?
  58. opening multiple excel worksheets
  59. OnKey trapping SHIFT+ALT+Spacebar? Possible?
  60. Cell colour
  61. File size increases by 300kb
  62. Calling of simple function in Excel 97
  63. Excel VBA: Renaming a workbook
  64. RE: Excel macro error when opened in internet browser
  65. How to save the Current Excel file to FTP server
  66. Automatically Answer YES for Pop Up Msg Box
  67. How to load a PDF using Excel VBA
  68. Can the X to Close button on a workbook be disabled?
  69. Control name values.
  70. Is there a 'frequency' function??
  71. Re: Worksheet and workbook name question.
  72. A newbie question re: Forms - Input and Output from an Excel Worksheet
  73. Populating a userform 3 col listbox
  74. Problem with this code
  75. Excel Conditional statement
  76. Comparing 2 Columns for duplicate data
  77. Re: Worksheet and workbook name question.
  78. Comparing 2 rows for duplicate data
  79. relative reference
  80. Protect/unprotect sheet with password with VBA?
  81. Run Macro every 30 minutes
  82. Function to lookup Counties in another list
  83. resize worksheet
  84. Disabling refresh data changed PivotTable prompt
  85. User cannot print form object after worksheet sent not as attachment
  86. Statement works in one scenario, not in other
  87. Range won't Unlock
  88. Chart Labels
  89. changing cells from function
  90. Get a cell's previous value
  91. Getting task response
  92. excel extensions
  93. Parameter Query executed from a Macro
  94. specialcells method errors when criteria not found
  95. Charts in copied worksheets
  96. Tab order with "enter" key on a sheet form
  97. how to calcurate work hours? Please?
  98. Database question clarification
  99. Images off of a worksheet
  100. Recommend Book w/ Good OVerview of Obejct Model ?
  101. Can this be done???? Please help!!
  102. Lookup
  103. Web Query/Cell Reference
  104. Truncate
  105. Is it possible to set a reference to a library in another file using VBA in Excel?
  106. texttocolumns
  107. create module
  108. Null date in VBA variable
  109. linking Worksheets
  110. create module
  111. Avoiding duplicates
  112. Copy filtered rows to a new worksheet
  113. Count by the Text
  114. Select and move range throughout workbook
  115. XL2k: ActiveX Controls on sheets.
  116. Locking spreadsheet
  117. SheetActivate event
  118. Converting hours & minutes to whole minutes
  119. Macro to bring up Other Program
  120. Error
  121. Adding to AutoComplete programmatically
  122. disable save
  123. Use XL 2 Edit a .txt File?
  124. insert selected rows problem
  125. Re: Excel "If" function
  126. Using Hidden data for a chart
  127. sorting a #name?
  128. Change Key Mapping
  129. Re: Excel "If" function
  130. Roll Once
  131. how view a WS code/properties
  132. Connection Obect for Two Paths
  133. Pivot Charts
  134. Confirm deletion
  135. Formatting times
  136. Pivot Tables
  137. Automation from VB - slower than from Excel
  138. pop up menu
  139. Please help with AddItem method
  140. saving fcell contents in a separate list
  141. Jumping back to a cell
  142. Special string formatting
  143. command bars
  144. Activate Other Workbook
  145. How to use TrimMean as an agregation function
  146. Making some rows uneditable
  147. Selecting a row with a variable ?
  148. Last column in selection
  149. Excel VBA - loop columns named AA, AB..etc
  150. Eliminate formula Query
  151. How to clear the contents of COmboBox?
  152. Copy sheet from addin
  153. inserting row...but the formula is not affected
  154. Adding a Timer Control
  155. importing access mdb in to excel
  156. last occurence
  157. Allocating "Don't Move or size with cells" property in code
  158. A couple annoying VBA add-in things
  159. List Box and personal.xls
  160. calling cells from other sheets and listing
  161. Excel VBA - Updating of data problem
  162. Problem with .Background Query option of ODBC Query
  163. Unwanted Double Quotes produced by Excel
  164. Checking for the Existence of a Folder
  165. Alter existing code
  166. Build macro to draw lines between multiple points
  167. Cell highlight
  168. transfer cell range
  169. Change the 'Read-Only' Access for Non-Shared Files
  170. Switching from InputBox to UserForm?
  171. How to URL-ize a string
  172. One more step...
  173. last piece of the puzzle...controlsource in textbox
  174. Database question
  175. VBA input box MSG
  176. Checking Entry
  177. Rounding Error
  178. Archive Macro
  179. extracting a subset of an array with VBA.
  180. extracting a subset of an array with VBA.
  181. Calculating days of week
  182. Adjust a Scroll bar to fill in a range perfectly
  183. Names
  184. Finding missing links.
  185. Please Help!
  186. Excel Programming in VB
  187. Programming to search for a cell with certain value
  188. Problem with auto count...
  189. Re: Programming to search for a cell with certain value
  190. Set dropdown programatically
  191. a program is trying to automatically send e-mail
  192. Assigning names to a route
  193. Copy-Paste Special-linking problem
  194. Starting VBE at EXCEL Start
  195. Random with Number And Probability [very long]
  196. Excel VBA - Userform Textbox Manipulation
  197. Validate Textbox entry
  198. Change fonts of chart legend - different results on 2 computers
  199. User forms
  200. Edit DialogSheets
  201. User forms - blank fields
  202. Monthview AxtiveX
  203. PIVOT Table Display
  204. Allow only 12 entries in a column
  205. Evil virus-generator
  206. simple excel formula
  207. Named Range cell content getting deleted
  208. Manipulating PowerPoint Files from Excel
  209. Error 1004 in Excel 2000
  210. Re: Convert from WrapText
  211. Re: Application.DisplayAlerts in IE
  212. Convert from WrapText
  213. Excel/SQL Query Quandry
  214. Excel is an evil virus-generator
  215. Help with Uninstall Event
  216. Error not trapped - please help!!!
  217. Pivot DataRange BackColor
  218. Hide / Unhide Dialog Box
  219. Print dialog code trouble
  220. How to get the activecell of inactive worksheet ?
  221. Replace destination cells
  222. Registering an OCX with VBA
  223. Help with Textbox formatting
  224. formula or method needed
  225. TCP/IP and Excel
  226. Re: barcode printing
  227. Worksheet_SelectionChange
  228. Chart placement
  229. add worksheet to group
  230. Manipulating Charts with VBA
  231. question about the ControlSource of a ComboBox
  232. Print the results of the combo box
  233. class modules beginner
  234. re-enabling macro under menu item
  235. Pivot Tables and VBA
  236. Visual Studio Tools for Microsoft Office
  237. test
  238. Mouse scroll wheel doesn't work in VBA
  239. Months and Dates
  240. Opening the modem ?
  241. Copy Paste Special Value using Code over Several Worksheets
  242. Visual Studio Tools for Microsoft Office
  243. why did the macro stopped working?
  244. A searching query
  245. Help!
  246. Newbie VBA Question; Deleting minimum value row
  247. unprotecting sheets
  248. Determining the Name of a Caller Macro
  249. Fetching a VBA Macro's Name During Execution
  250. Visual Studio Tools for Microsoft Office
  251. Getting data into Access
  252. Links and Chdir
  253. Selecting dates from ListBoxes by using RefEdit Control
  254. Copy Value to a Row with Date that is specified Query
  255. Learning from the masters
  256. VBA - running scripting dictionary (error!)
  257. VBA question - Set reference to run Scripting.Dictionary
  258. counting weekends
  259. Macro for LOTO Drawing!
  260. CorruptLoad param of Workbooks.Open
  261. Reading an excel file in SPSS
  262. counting filters?
  263. Text Conversion
  264. Re: Code is working in one file but not in another.
  265. Activesheet protection
  266. VBA question - autofilter combobox
  267. Percent Totals by Dynamic groups
  268. Chart on Userform
  269. Percentages by dynamic groups
  270. Search for subtotals
  271. Business Objects: Fad or Lifesaver?
  272. File Information??
  273. Tracking changes issues
  274. VBA question - Type Mismatch
  275. msgbox data
  276. VBA question - Calling txt file from userform
  277. Activate macro1
  278. Min & Max w/o formula
  279. Textbox change event
  280. Ghost image
  281. Subtotal Macro weird actions
  282. Determining the Selection on a non-active Sheet?
  283. returning Excel sheet with ASP
  284. date and time questions
  285. More Toolbars questions - 2
  286. Maybe this isn't possible to match name and copy?
  287. More toolbar questions
  288. Pie Chart
  289. autofilling out a form by referencing a list
  290. Using the Lastrow variable in a Count/Countif formula
  291. vba error
  292. Something Challenging
  293. Command Button problems when printing
  294. Question about the .move option
  295. A better way
  296. Tab Order Code Problem
  297. Graphic object as a result of a formula
  298. Proper case code not working right
  299. Re: Excel cell Validation
  300. re: Format within a cell
  301. Range Names and hash maps.....
  302. More toolbars questions
  303. VBA question - Combo box showing result of filtering
  304. format within a cell
  305. VBA - Object Variable or With Block not set
  306. Undocumented Excel key-bindings.
  307. Run Time Error 75
  308. Re-bind built-in Excel functionality to new OnKey event.
  309. toolbars
  310. Control sizing problem
  311. getting runtime error when trying to delete records
  312. Importing multiple text files into one work book
  313. Custom Function-sum based on multiple criteria
  314. Out of Memory Problem
  315. Excel VBA - input box text display
  316. excel VBA making a program generate a graph
  317. Trying to F9 sum of random numbers until certain value is reached
  318. creating a drop down list of pricing
  319. Problems with dates entered via userform
  320. VBA question - Getting las active row number
  321. paste into filter criteria box running macro
  322. Macro to automatically install ODBC data source
  323. Programmatically determine if a control is .VISIBLE or not.
  324. Userform Can't seem to work right
  325. How to run a scheduled macro and Log Off system???
  326. Lookup Macro
  327. Excel Filename prgramatically
  328. merged cells
  329. If Then formula for excel
  330. Populating txtboxes
  331. Re: Format Cell
  332. Convert Macro into an Add-in file
  333. Use XL 2 Edit a .txt file?
  334. "Save As" cell reference in a macro
  335. Macro to open MSN Messenger
  336. Very simple
  337. Excel XP 2001 vs Excel XP 2002
  338. Excel Format Cell - first letter upper case
  339. Excel 2003 .net, sql server
  340. Code Problem
  341. DateDifference Question
  342. Command Button slides when sheet is redrawn
  343. Problem concerning working with an uncertain # of rows
  344. Select a random cell <> 1
  345. Screen updating
  346. Screen updating
  347. highlighting the text of a textbox
  348. Problem with using dates entered via UserForm
  349. Last Row
  350. Macros with AutoFiltering
  351. Excel button
  352. Deleting macros that are available in personal.xls!
  353. Re: Pivot Table - Object variable or with block variable not set?
  354. Not sure if I need a formula or some code....
  355. Cell Value
  356. Saving a workbook into the desktop
  357. checking if an access database is open from excel macro
  358. Open en close a workbook with password
  359. Template Save As retains existing name!!
  360. Question on custom formating cell
  361. Using SQL in Get External Data
  362. Re: Format Cell
  363. VBA SPLIT FUNCTION
  364. Graph Macro
  365. Re: Format Cell
  366. Type Mismatch Error
  367. ChangeLink
  368. Return cell address value
  369. path of workbook
  370. VB - turning cells specified colours
  371. Is there a diferent "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
  372. Replace based on combobox value
  373. Re: Problem is adding options to ComboBox
  374. Importing Code into 'ThisWorkbook'
  375. Formula to figure average efficiency based on criteria
  376. I'm trying to integrate Sharepoint PS with Excel 2000
  377. Problem in adding item to a checkbox
  378. Refresh Data
  379. Problem with ODBC Query
  380. Open password protected workbook.
  381. Change the code to copy whole row
  382. Shape Marcro with Parameter
  383. Hiding a sheet
  384. user-defined fct/macro
  385. Rename sheet
  386. how they do that?
  387. Disabling Excel X Application Button
  388. How to interpret cell references from formula to vba?
  389. Hyperlink doesn't work - need a macro....
  390. Search a value in particular range
  391. Excel Formula
  392. Followup to "search range for duplicates"
  393. Find fastest way to do lookups
  394. Excel Chart Datalabels
  395. Re: Trig in degrees not radians
  396. Find records between two dates & check a box for each positive result
  397. Create appendix
  398. Follow up on this
  399. search range for duplicates
  400. How To: create a form for a user to enter data
  401. Copying Cells from Sheet2 to sheet1
  402. Save as .txt then close
  403. Windows 98 desktop icons disappearing
  404. Pasting on next empty cell
  405. Shared workbooks, advanced filters, and refreshing pivot tables
  406. How to make a timer in Excel 97
  407. Filtering from multiples and writing to new page
  408. Combobox Help
  409. Help on Macro
  410. Tricky AutoFormat problem
  411. Borders in Columns
  412. Help With loop macro??
  413. Difference between a Service Release and a Service Pack?
  414. Can't fill XL Formula in VBA
  415. VBA: How to detect whether two cells are currently merged
  416. Problem Creating a Date Range
  417. hidden VBA
  418. Easy Userform question
  419. SQL Query Quandry
  420. Open file dialogue box
  421. Login needed for open workbook and then run some VBA
  422. Refresh combobox after inserting new sheet
  423. custom Header-Automated
  424. Is it possible to copy a code module using VBA?
  425. Auto Insert Rows
  426. placing controls
  427. Edit Macro to work for other Workbooks
  428. Password protect macro
  429. Code to copy range vs Copy Entire Worksheet - can't figure it out
  430. users and DAO with access database
  431. Whopper If Statement and Formula to Long
  432. How to have macros enabled at start
  433. Combining 3 macros to 1
  434. programatically accessing Macros in worksheets
  435. Autofill
  436. macro not found
  437. History
  438. Re: Checkbox with OPtion buttons
  439. Divide data into portions
  440. Hard-Coding a File Location
  441. Importing Access data
  442. Edit MACRO for all SHEETS
  443. xlPasteValuesAndNumberFormats
  444. automatic refresh of formula that seeks data from an add-in
  445. If-Then in VBA
  446. Application.Displayalerts wont get me past this!
  447. copy a changing formula???
  448. Re: Referencing a sheetname to a combination of two cells
  449. Fill Label Text
  450. How many rows on a Worksheet
  451. error with user defined
  452. Enable toolbars at close
  453. Re: Adjusting for Different Display resolutions
  454. Saving a Workbook: Forcing User to Rename before Saving
  455. cant have a range of 30 different cells ?
  456. Date format in textbox
  457. Addin Not Installing
  458. wsNew.Name
  459. Formula for first three characters
  460. Preventing Duplicate Entries Across Sheets
  461. Excel Vba Problem - Validate Data in cell
  462. ComboBox Triggering Resourse Warning
  463. comparing two fields in an excel spreadsheet
  464. HasLeaderLines not working
  465. RE: Is it Possible to add a Wave file to VBA
  466. Go to lastrow using other column's lastrow
  467. Re: Is it Possible to add a Wave file to VBA
  468. please advice
  469. Re: Is it Possible to add a Wave file to VBA
  470. Deleting a read only file?
  471. continuing code on another line?
  472. Re: Is it Possible to add a Wave file to VBA
  473. xml to excel
  474. C# IMdcCheckBox.Value problem
  475. Locating lowest/highest cell value in an array
  476. ComboBox programming not working
  477. Lock access to a worksheet depending on user name
  478. Connect to Oracle Database through ODBC with VBA
  479. Counting Controls in a sheet
  480. WordWrap in textbox
  481. RE: Sync - Bob Phillips
  482. Is it possible to password protect an OLE object on a sheet?
  483. Copy Modified Worksheet 1 Data to Worksheet 2
  484. Can't get code to work properly. Please Help!
  485. Checkbox behaving strangely
  486. Automating the "Oval" Object
  487. Newbee help
  488. copy formula to the last used row
  489. Saving a Workbook
  490. Findjjing the range that triggered worksheet calculate
  491. Urgent
  492. changing range reference
  493. Xml
  494. Clearing Memory agter an update
  495. Copy ranges
  496. Count result output to other sheet
  497. How to Clickbuttons on internet Explorer pages with Excel VBA
  498. goto a particular cell
  499. VLookup
  500. Sendkeys VBA and command line
  501. Help required with Macros
  502. To protect the program
  503. Problem using outlines
  504. cannot copy formulas only
  505. when change value of cell
  506. Auto Expend Range Using Macro
  507. Lots of Frustration - Lots of Arrays, Dynamic Ranges Don't Work, Help With Options
  508. How to change row color when select a cell in this row?
  509. creating a e-mail macro
  510. How to put in a warning?
  511. Pivot table toolbar
  512. What to use other than .Select
  513. open two files with the same name concurrently
  514. How not to fixed cell address in Macros
  515. excel vba - COUNTIF syntax
  516. Show progress in a user form while code runs
  517. Cell shading won't show on screen
  518. delete columns with 0 in single row
  519. Reminder
  520. Rounding numbers to whole thousands
  521. Converting code to R1C1 format
  522. Trying to give a cell a formula
  523. Custom Addin, Excel Shutdown Problem
  524. hide sheet tab
  525. Easy one: absolute cell reference in VBA
  526. listbox works in form; not imbedded???
  527. VBA question - getting name of workbook
  528. Saving a file with todays date on the end
  529. Command button macro query
  530. sum cells
  531. Re: want several userforms to remain on screen
  532. Excel: Relative formula to new sheet?
  533. RE: ComboBoxes
  534. synchronize 2 combo boxes in Excel
  535. RE: CommandButton
  536. refer to a formula for use in a loop
  537. Making the minimized Excel window icon flash
  538. Invisible Contents
  539. Call/Start Macro
  540. Cant find project or library
  541. Please HELP !!! Converting .XLA to .XLS
  542. VBA question - Copying Sheet from Workbook to another
  543. VSTO Excel Addin
  544. Drop bown lists
  545. Protect My workbook, what's my computer's Finger Print name??? and how to access it, from vba!
  546. Pivot Tables and list boxes
  547. Disable Macro Option
  548. leading or trailing quotes
  549. Summation
  550. VBA question - calling Procedure from userform
  551. Sync Code
  552. Excel through SOAP to a webserver
  553. Combobox setting
  554. Opening Excel remotely
  555. CommandButton
  556. Re: runtime error '1004' delete Method of Range Class Failed
  557. Probably missing something simple in loop macro...Please help
  558. cannot copy formulas
  559. Function to cnvrt Phone to State w/out cell ref
  560. association of hot key with subroutine
  561. Re: Replacing formulas in Excel
  562. pivot table drop list
  563. Help (please, please) copying and pasting issue
  564. Create a Macro with Starting Cell as a Variable
  565. Re: Getting the Sheets Name
  566. Inserting Sheets and Naming
  567. UDF to give position of item If list was Alpabetic
  568. Searching In a Column
  569. Rename File from list
  570. MsgBox execution sends program into design mode
  571. Prompting a macro to run on change of cell content
  572. Excel Parameters
  573. inputbox msgbox error
  574. Copy address from one sheet to other sheets
  575. Copy Paired Info into Diff # of rows
  576. 3 range criteria for Loop
  577. How to detirmine the target row
  578. Controling the list in a combo box
  579. Newbie Excel User Needs Help!
  580. Password Boxes from xl95 to xl2000
  581. Re: Please help...I need a looping macro at a specific time
  582. Copy row
  583. Excel VBD DDEInitiate problem
  584. Counting files in a folder
  585. Case Statements
  586. selecting the last non blank row.
  587. Re: Replacing formulas in Excel
  588. Limits on Case Statements
  589. Re: Pop Up Screen
  590. Make a particular cell the active one
  591. How to get average with deviation
  592. Row and column header
  593. Grey out
  594. Re: Pop Up Screen
  595. OLDEDB alternatives for pulling data from Excel
  596. Totals
  597. Sum IF function - linked to external worksheets
  598. Summary of Multiple Date Ranges
  599. Arrays
  600. Data Tansfer Between Worksheets
  601. ToolBars and Custom Menus
  602. find the last row number
  603. Need Code to Populate Cell Range
  604. Thanks Bob!
  605. userform question
  606. Using reviewing tools in macros
  607. Object required when formatting
  608. Basic macro ? I'm new to this.
  609. Screen Updating
  610. pivot table question
  611. Centering Toolbars
  612. Macro to copy and past selected rows only...
  613. Counting Code
  614. LinkedCell Update does not always respond
  615. Path/File Access Error
  616. Quick Question
  617. Use the .NET Library in VBA?
  618. Search using Autofilter
  619. userform
  620. Delete Duplicate rows in a range
  621. UserForm Label & Format Problems
  622. HTML Tags in Excel sheet
  623. fill A1 when open xsl file
  624. What is maximum length of URL?
  625. run a macro in excel from an access vba
  626. IfThen
  627. disable formatting
  628. Place selected object names into array
  629. Filter 2 columns onto Sheet 2!!
  630. pivot table
  631. Excel Saving and No changes made!!
  632. Add a sheet using a template
  633. Help needed for ComboBox
  634. Documentation 4 Excel Web Component
  635. Restoring application settings at end of sub
  636. Problem with using formula
  637. Looping in Excel XP with C# -- Ranges and SpecialCells
  638. how to have a module to repeat itself at a certain time interval?
  639. Chart sizing inconsistant
  640. How to soft a selected range of data in Excel by using VB.Net
  641. Saving workbook
  642. Find values in table and return correpsonding data in array
  643. Why won't this code connect to ODBC
  644. Textbox in userform
  645. DLLs
  646. online course
  647. Choose Function Macro
  648. Re: Public variable usage!
  649. Looking for function similar to Access "Group By" queries
  650. Code to insert text
  651. Re: Working with ADO to connect to SQL database
  652. Re: Rnd (Random) in VBA
  653. Bad External Link
  654. Excel Timer with Sheet Toggle Help
  655. simple VBA question
  656. Cell protection
  657. From Sheet 1 to Sheet 2!!!!!!!
  658. Code
  659. Strip chr(13) from Comments
  660. Bug on macros!
  661. Copy Paired Info to Different number of Rows
  662. Loop a long formula through range
  663. Script or Tool to Update Excel Links
  664. getting a macro to run when a change is made to a specific row
  665. Add-in functions when starting Excel programmatically
  666. A unique ID for protection?
  667. Averageing a collection
  668. RE: Public variable usage!
  669. RE: Public variable usage!
  670. Display mail application either in Outlook, or Outlook express
  671. Returning to activecell
  672. Trying to get/set contents of embedded file using Excel OleObject
  673. Re: Searching for a unique charater in a string, vb
  674. Re: Public variable usage!
  675. Disable entire row delete on certain sheet
  676. UDF showing full Path of Worksheet or Worksheet Name?
  677. Button won't call macro
  678. Updating price of securities in Excel
  679. need help with a timer
  680. Newbie question about publishing VBA project to the web
  681. formula validation
  682. Text box in userform
  683. Rnd (Random) in VBA
  684. Excel Macro Help.....
  685. Error trap the renaming of a sheet to an existing one
  686. Dialog For Choosing A File as a string
  687. Query Data from a Sheet
  688. Query Data from a Sheet
  689. Sizing a Picture (a .gif) to fill a worksheet, for any resolution
  690. Delete a sheet
  691. ComboBox Population of Cell Range
  692. Preventing shortcut keys from working on disabled toolbars
  693. VBA Execel Macro & Check Box help
  694. App using OWC 2003 Deployment - How to ?
  695. Rename the sheet just added
  696. Put Excel data to text file????
  697. Re: Range("rng").calculate causing problems?
  698. Date ??
  699. unable to get original cell value from a "number stored as text"
  700. Looking for matches
  701. Printing Each Sheet
  702. using create object and sendkeys from excel to FTP
  703. Workbook reference error
  704. Open file from Cell
  705. Trim Blanks
  706. Saving it as read only?
  707. Global variable declaration!
  708. Application visibility
  709. textboxes
  710. Validation lists
  711. Call Function in Different Spreadsheet
  712. Open workbook with designated sheet
  713. Code is great, except for one thing ...
  714. SocketWrench
  715. Workbook file password protection - forgotten
  716. Help with randomn blank cell in my data
  717. Re: Range("rng").calculate causing problems?
  718. MS Excel Audit Trail Software
  719. Get points in a worksheet using mouse click
  720. opening an excel file from another excel file
  721. compile error
  722. Trouble recreating Pivot table changes in VBA
  723. Here is an interesting question
  724. Problem in VB help in Excel
  725. Combo Box font color
  726. Cell
  727. Problem with excel linking to Access query
  728. delete empty rows
  729. Getting a row number of the last row?
  730. Application.Run with multiple workbooks
  731. assign a clickable macro to a cell?
  732. shortcut macro keys
  733. Excel 2003 v Excel 2000 info please...
  734. Protection and filters?
  735. MsgBox
  736. FileCopy and read-only
  737. Help with Selection Property
  738. VBA problem, works fine as formula but not in VBA
  739. Reference Addin Module from sheet code
  740. Excel VBA - "IF Answer = Problem"
  741. AutoShape - Text Update
  742. Back button Macro?
  743. On Error GoTo : How to use multiple?
  744. Sheet msgbox
  745. Excel Encoding
  746. VBA question - Inputing data to txtbox in userform using short date formart
  747. Updating a Data List
  748. Worksheet Menu Bar
  749. help required with placing command buttons in Excel
  750. UDF: how to get value of the argument's adjacent cell?
  751. online course?
  752. Unsharing a workbook
  753. Date Selection Userform
  754. Strings that have quotes in them
  755. Activate Userform (run macro?) from cell value
  756. EXCEL VB Macro Run Time Error 1004 - Setting ColorIndex
  757. Moving XL Data over By one Column (*Same Row)
  758. searching a list box for a filename match...and highlighting the match
  759. concatenating strings to call a variable
  760. dll's and performance
  761. Excel Error Message when loading
  762. Change a chart's series using VBA...
  763. Class Modules
  764. Simple ?
  765. graph\spreadsheet on form
  766. Excel VBA - Changing a template in an Add-in
  767. Retrieving data with SQL from ODBC source
  768. Multiply All values by a cell
  769. ComboBoxes and Tabbing
  770. How to do a line break in a text formula
  771. Open file from vba
  772. opening and closing files in order with vba
  773. PASTE INTO JUST VISIBLES CELLS
  774. Same Results - which is better?
  775. Create and write a simple text file in Excel/VBA
  776. 12th root of two
  777. input box , msgbox, formula
  778. Error Trap Not Working
  779. Exporting to Notepad
  780. Declaring As Variant, Changing to Double?
  781. RefreshData Method in RTD Server
  782. Saving Changes
  783. protected cells
  784. XMLHTTP proxy settings.
  785. MsgBox help
  786. Import Queries instead of Tables (ADO)
  787. Changing Text into Numbers, using VBA
  788. Menu
  789. Import Queries instead of Tables (ADO)
  790. Intersection of records in two spreadsheets
  791. Programatically set ref to my DLL
  792. Counting in ranged intervals
  793. Worksheet_Change Event
  794. Enabling help on code
  795. Error when running macro in Excel
  796. Lock out a portion of spreadsheet based on a condition
  797. fastest hardware for excel
  798. Summation of last (DD) days
  799. Excel VBA question - showing userform when opening workbook
  800. Maximum Count
  801. Pass array from Project to Excel
  802. Public Variable
  803. Using VBA write a mail to some one and Send it
  804. Set the size of a chart object
  805. Sending Appointments via Outlook
  806. List/Combo Box Setup Problems
  807. linking multiple workbooks - UPDATED
  808. Pointer Color
  809. Get Average in Subtotals
  810. Chart Size
  811. value vs. formula
  812. ValueBox? or force TextBox to read/format value
  813. VBA question involving an InputBox
  814. Re: FINDing data only in one column
  815. VBA question involving an InputBox
  816. Re: FINDing data only in one column
  817. Re: FINDing data only in one column
  818. Array Type programming
  819. Execution Error due to file location
  820. linking multiple workbooks (VBA)
  821. excel vba : how to split characters in text file into cells?
  822. Loop Problem
  823. Transferring custom function
  824. Opens Workbook and not Query
  825. Not sure of what to call it accept (Un - concatenating)
  826. Indian comma style above 99 crores with -ve
  827. find across multiple sheets
  828. Disable Button
  829. Indian Coma Style
  830. Save TextBox Entry after WorkBook is closed
  831. Excel Probel
  832. automation
  833. Aborting from a "Before Print" Event
  834. Server
  835. Help with formulas (Sum)
  836. Excel: workbooks.open problem
  837. ASAP Utilities - free!!
  838. Updating from external file & keeping previous data static
  839. with selection speed
  840. Re: Edited Data Imported into Excel
  841. Edited Data Imported into Excel
  842. Processing all worksheets simultaneously
  843. Deleting a sheet
  844. Clearing Data ranges from Multiple Worksheets
  845. ATPVBAEN XLA [Number casual]
  846. XML Data Binding
  847. IF function with Array Formula
  848. excel graph with vba
  849. protecting the workbook through a macro
  850. Find generates error message
  851. Reading Textfile into a variable
  852. How to enable macro
  853. Excel VBA - Excel crashes when macro button re-assigned problem
  854. Open a log file
  855. Use of Command Buttons to Move Through Worksheets
  856. Is a file already open
  857. Save As issue
  858. sumif or countif based on font color
  859. Comparing values in two columns
  860. worksheet synchronisation and other one
  861. VBA Excel problem - including sheets in Add-in worksheet to link to
  862. valuta
  863. one-tenth of a second delay
  864. VBA digital sign
  865. UserForms
  866. Excel VBA - Multiple Issues for a newbie.
  867. Change minimumscale with the change event of a combobox
  868. transpose to matrix
  869. Error with code... ".Visible"
  870. Two questions
  871. Re: Print Row
  872. Sometimes macro does not run
  873. Print Row
  874. Where Macros Are Located
  875. Getting External Data
  876. excel VBA - for loop for several sheets
  877. Why does this fail with an invalid type error
  878. Deleting all HTML coding while keeping text
  879. Resizing a cell vertically to insert text
  880. excel VBA password
  881. Protecting all sheets in a workbook
  882. Running a .bat file via AppActivate
  883. Digitally Signed Excel Sheet - can someone send me one?
  884. Excel and web browser
  885. running a batch file
  886. using spaces instead of underscores
  887. Workbook Name question
  888. User defined data type
  889. Save Excel chart to file with given dimensions
  890. Returning control to form
  891. Shortcut Keys
  892. Excel VBA - deleting populated folder problem
  893. Quick Date entry revisited
  894. saving single worksheet
  895. Can't recreate A Macro
  896. ComboBox changes text when switching tabs
  897. VB msgbox exit
  898. Testing for Identical Cells
  899. Digitally Sign Macros
  900. conditional formatting
  901. Function
  902. RE: Hyperlink Code will not work in XL2002
  903. Object required - run time error 424.
  904. Object required.
  905. vba code to find ssn and move two columns
  906. restricting data when other cell is empty.
  907. Formating Data Labels
  908. Re: Need (perhaps non-existent) Formula Help
  909. showing current date as part of file name
  910. Subscript out of range
  911. Calculate time worked
  912. Change references ALL at once
  913. Row Select
  914. Disappearing Text in textbox
  915. ADO or DAO, or odbc query from xls sheet, to xl sheet?
  916. Findcontrol
  917. Fancy tricks in Listbox?
  918. pivot field size (column field)
  919. Excel Data Validation - copy command overwrites
  920. Absolute changes w/copy
  921. Export the worksheet background image as an image file - possible?
  922. Why doesn't this range work?
  923. How do you say "If, Or, Then, Else" in VBA
  924. Retrieving data with SQL and ODBC selected by key values in cells
  925. This drives me nuts
  926. Finding Procedure which generated error
  927. Program an autofill
  928. RE: Comparing worksheets (extra info)
  929. Re: Assign a name to worksheet tabs by code
  930. Re: Copy Value, but not Formula
  931. Scoll button in VBE editor; How make work?
  932. Need help
  933. WORKING DATES.
  934. PictureBox control in VBA Excel form?
  935. Find in a range
  936. Convert string to range?
  937. Word document from template
  938. Disable/Turn off
  939. Baffling, yet curious
  940. Re: Comparing rows of data in two worksheets
  941. referencing another sheet
  942. Delete records by comparision
  943. Returning Error from Functions
  944. Options when Protecting Worksheet
  945. Auto Run and Installation privileges
  946. Mailmerge in Excel?
  947. hiding formulas and defined names in a worksheet
  948. Excel VBA - Clearing Shapes and Cell Contents
  949. Excel VBA - Remove Shapes and Cell Contents
  950. Get user selected range into RefEdit
  951. Move to SELECTED Cells
  952. macro warning box
  953. Re: CopyFromRecordset Bug with Office XP
  954. Save As help
  955. RE: Increment a variable
  956. Pulling value from cell to complete path name
  957. Please help (need a code check)
  958. How to copy data from excel to power point screen by screen?
  959. expire workbook
  960. Late Binding question - newbie
  961. Converting time from hrs + muntes to whole minutes
  962. Strings
  963. Displaying XValues.
  964. Out of Memory Error on Excel XP
  965. run until mouse moves?
  966. Email Excel form
  967. Validating entered data as date
  968. Change Criteria in Code
  969. days, GUARANTEED- RETRACTION..PLEASE READ
  970. Wow can I switch to R1C1 mode?
  971. macro
  972. Multiple IF 's
  973. How do I do Auto_Activate Macro?
  974. don't let the user disable macro's in Excel
  975. VLOOKUP
  976. Solver reference problem
  977. Workbook_Open problem
  978. "Rounding" error
  979. Controlling Input
  980. Macro stops before beginning.
  981. Restrictions on Excel in-place activated in Browser?
  982. Getting Table data from HTML page
  983. Is there any onLoad kind of function for Excel
  984. Changing Pivot Table Range
  985. complex looping problem
  986. range problem
  987. setting the auto row height using vba
  988. Row split not working
  989. Special Formula
  990. send keys
  991. Adding file name and path to to footer of all workbooks in a folder.
  992. Question about Formulas
  993. Tom please respond..it works but but not completely
  994. Ideal Code deleting rows/based on bold text
  995. Remove rows with dates
  996. VBA- SeriesCollection(1).Value error
  997. output text
  998. Re: Solver in VBA
  999. Naming Worksheets With Leading Zeros
  1000. Copy pages from one worksheet to another