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. Re: Creating a header with non-contiguous rows
  2. How do I get this VB Call to work?
  3. Problem with Help file in VBE
  4. Status Bar and Column/Row Headings Help
  5. strange error message following INSERT INTO statement
  6. Test for exact match in string
  7. How to reference # of copies in print menu?
  8. Error 91, Object var or With block not set
  9. Siple but what was the formula for splitting names?
  10. Two Questions
  11. Drop down lists
  12. Can you make a cell on a certain page constant on all pages?
  13. Preventing User Access to VB code
  14. expandable listbox
  15. Identify CD-Rom drive
  16. Eliminating Duplicates
  17. Closing
  18. Re: finding the last column and referencing it by letter
  19. Vba - generating button into worksheet
  20. Auto close excel without saving
  21. My program uses up resources
  22. Moving VBA scripts to new workbook
  23. Stupid End(xlup) problem
  24. Code is not working....please take a look!!!
  25. creating a drop down list
  26. GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
  27. Toolbars
  28. Modifying FindNext and Copy Code
  29. Run Macro w/o Opening Excel
  30. Array question
  31. Re: Macro to find name of sheet tabs
  32. Merging two or more workbooks
  33. GETTING DATA ON TO SHEET2
  34. SHDocVw.InternetExplorer
  35. Sheet Group & Formating in VBA
  36. Passing Variables
  37. Problem with format()
  38. loop through form objects
  39. Get table names from access through vba in excel
  40. Can I Group Form Check Boxes?
  41. Moving objects on a form
  42. An efficient find function
  43. Picking the latest entries from a column
  44. Deleting Duplicate Rows
  45. Is it possible to teach ones self VBA?
  46. Re: Only allow certain users access to specific sheets within a workbo
  47. Validatio Problem
  48. Re: FindNext and Copy Help (Urgent)
  49. How to paste cells from Excel into Outlook email body?
  50. Highlighting cells with vba function
  51. Save problem
  52. Open all files in a folder
  53. Re: FindNext and Copy Help (Urgent)
  54. Running Code From Controls On Other Forms
  55. recovering linked values in macro
  56. For Each Next
  57. Re: Virtual Memory Error when running Excel
  58. Re: Hide VB Source Code
  59. VBA - Flexible Sort Macro
  60. Inserting Rows Macro -- please help!!
  61. Togglebutton with the triplestate turned to True
  62. Saving Range of Cells as Image File
  63. Macro for Custom view
  64. Invalid Use of Null
  65. textbox & tab
  66. Web query & Passwords & Java & HTML
  67. Re: Personal xls will not open automatically
  68. combination of numbers
  69. Auto New macros?
  70. How can i get the value of the AsktoUpdatelinks form ??
  71. Create Barcodes in EXCEL 2003?
  72. Need Comments on Code
  73. If statement in VBA
  74. Range.calculate debug, Excel 2000 VBA compatability with Excel XP
  75. Sheet properties
  76. Worksheet Function using VB code
  77. Command Bars
  78. Starting Easy
  79. Extra feauture to the following code
  80. I have a Function Call that won't cause calculation.
  81. TypeConverter Excel-Automation problem
  82. User Form to display more than 1 reslut
  83. Check if clipboard is empty before .PasteSpecial xlPasteValues
  84. problems with XL 2000 files in XL 97
  85. Setting ComboBox ControlSource in code
  86. How can you make an array of objects?
  87. PRINT AREA IN PROGRAMMING
  88. Qn: Date Format in TextBox in UserForm?
  89. Help File
  90. solver.xla fails
  91. how to get onkey macro to fire while another macro is running
  92. Excel – Macro Problem – Appending Data
  93. Get the list of data inside AutoFilter list
  94. appactivate
  95. EXCEL 2002: How do I user/simulate a Timer event in Excel form
  96. appactivate
  97. Pivot Table - Subtotal of 3 columns
  98. Don't want to insert a partial row
  99. Looking for faster method for Copy & Paste
  100. Question about removing Web formats and content
  101. Filtering data out of access database
  102. Changing only source file of pre-existing text import QueryTable?
  103. 2003 Secutity Issue
  104. Select an item in a listbox using code
  105. cursor position
  106. MS Progress Indicator Mimicked. Thank you.
  107. Excel 5 macros
  108. Copy a range from a CSV file in a webpage to my local worksheet
  109. Adjusting screen layout?
  110. Relative time in SQL
  111. How to launch excel spreadsheet and load xml file from cmd line?
  112. Replacing keystrokes
  113. Fax
  114. list of extended properties for use with ADO connection strings
  115. Vba - User email direction
  116. Protected File
  117. Copy cell without border
  118. How to declare variable as Excel constant?
  119. Loops in a range for a more than one ocurrence of samevalue
  120. looping and copying from onesheet to othersheet
  121. How to do Cut and paste
  122. creating Toolbar on Word 2000 using built-in Visual Basic Editor
  123. XP upgrade and old 2000 macros
  124. Triple Lookup Formula!
  125. Lock Commandbars
  126. the anatomy of a nestled condition
  127. Comments
  128. Vba - automaticaly closing userform
  129. Excel VB help
  130. properties of object on another sheet
  131. How to hide rows?
  132. Counting Days of The Week Only In a Formula
  133. Hiding Formulas
  134. Prevent save when content change?
  135. IsDate Function
  136. OnAction Variables
  137. Importing text from webpage into excel and then loop?
  138. Using Dates in VBA functions
  139. Double Drop Down List & Corresponding Text Info Disply
  140. How to input a range in a logical test?
  141. I want to compute this formula: =IF(Q48=Protected!C27:C35,+Q48,"".
  142. Delete Folder
  143. Comment box sizing
  144. Using Hidden Sheets to populate listbox
  145. Confirm formula change
  146. Application.run Macro Code Problem
  147. File in use open read only
  148. enter todays date
  149. transferring data between two workbooks
  150. Mimick MS Progress Indicator?
  151. Format Cells
  152. Extracting Global Address List (GAL)
  153. Copying row data to another worksheet
  154. Sharing a workbook
  155. Tabs
  156. Delete menu
  157. Add large ammount of formula
  158. Change Multiple chart source data
  159. count cells if >""
  160. Which PC has workbook open?
  161. problems closing excel
  162. Should I keep Trying INSA - VLOOKUP?
  163. Help Please - User Database
  164. Is this possible?
  165. Re: Highlight Button...
  166. convert cell contents into a comment
  167. Run time error 70 permission denied
  168. How to total Items in a List "not that easy"
  169. Path in footer
  170. Address Book - Outlook
  171. Picture or Object Blanking out??
  172. Qn: Define a variable in Initialize for Userform
  173. apply conditional formatting
  174. Manipulate user permissions in a worksheet using VB
  175. Qn: Plot a position on a Chart??
  176. Re: Long Text in merged cells not copying correctly with sheet
  177. Advanced Conditonal Formatting
  178. Re: Relative referencing
  179. Qn: Checkbox Enable??
  180. Help needed
  181. Still having a problem checking cells
  182. Virtual Memory Error when running Excel
  183. Excel 2003 Commandbars
  184. Excel in network
  185. LTRIM Problem
  186. making a timer
  187. Bypass Replace File
  188. Excel VBA -Custom function sumproduct
  189. Copy Array pointer rather than entire array
  190. Insert Row when data is different
  191. Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003)
  192. Formatting using VBA
  193. Simple way to add a reference to a cell
  194. Custom Menu
  195. finding duplicate entries
  196. Toolbar Buttons and Macros available always
  197. align a picture/shape in a Range!
  198. MsgBox2
  199. Declaring one bidimensinal Array
  200. Multiple ThisWorkbook's Causing problem
  201. too many conditions! what to do?
  202. writing macros to hide rows
  203. Help with checkboxes
  204. MsgBox Title
  205. Update Alert
  206. Renaming a Worksheet with a macro... but...
  207. Copying formulas, formats, and sheet names across workbooks
  208. Countif Error --- Please Help!!
  209. .Textbox won't word wrap. Why?
  210. Re: updating charts
  211. labels and comboboxes
  212. Protecting / Hiding the Code
  213. Re: Naming an Excel Workbook
  214. Re: Quit Application Without Saving
  215. Re: Quit Application Without Saving
  216. Is this possible
  217. Control Toolbox buttons
  218. Userform doesn't recognize other user form upon re-load
  219. Excel data to Access?
  220. Does SUMPRODUCT work with "INDIRECT"?
  221. q. Using a macro to transfer data from Excel to Word
  222. Re: copy & paste macro
  223. paste as value
  224. Searching for cell values
  225. Unsupported methods for XL macro in IE
  226. Re: Naming a newly added sheet
  227. Re: Naming a newly added sheet
  228. Pivot Table Name Reset
  229. haha
  230. Re: Getting PrintForm to print all Frame Captions
  231. Re: How to save as a semi-colon delimited file
  232. Decimal portion to a seperate cell???
  233. cursor problems
  234. Lookup Help
  235. Filling a selected range automatically
  236. Change Shortcut Key Programatically
  237. Userform does not show on startup over LAN - problems
  238. Excel comments field
  239. Can't stop Excel help autotile :-(
  240. Cell color change on mouse over
  241. AutoFilter Criteria VBA
  242. Custom Menu Bar
  243. Excel formulas
  244. Excel VBA - Printing Seperate Graphs
  245. Becomming an MVP
  246. Consolidate - Relative Reference
  247. Signature lines in footer with "No Dupes"
  248. Prevent Workbook_Open macro
  249. Urgent help with nestled condition is needed
  250. J-walk face id menu - Problem
  251. Excel Mergefield?
  252. Date/Time Stamp Macro Button Problem
  253. Removing extended dash
  254. Footer Memory leak
  255. how do i copy a formula with different cell reference?
  256. How to keep a running total on a col that has frequent new entires
  257. Send mail from Excel
  258. msoControlEdit
  259. can it be adopted for a 16 team 4 group?
  260. script for a form
  261. Worksheets Add & Naming
  262. Inserting a variable number of rows in a worksheet
  263. Count of characters
  264. Pivot Table - show 0s in empty cells
  265. The value of a ListBox Item
  266. Newbie's question.
  267. Workbook comparison results in subscript out of range error
  268. SetFocus Question
  269. Macro Fails to Run Correctly
  270. Macro/Command Button
  271. followhyperlink method issue
  272. Excel menu toolbar hyperlink issues
  273. Correct Syntax - Collection Key
  274. How to use Digital Signatures
  275. "!" at end of variable
  276. Problem with formula: need rolling average of 10 months
  277. Macro for "close w/no save"?
  278. finding non-standard years in a dataset
  279. Do loop to add a new worksheet
  280. Excel to select a row based on previous rows
  281. Excel 2000 VBA date format changes in subtotals
  282. UpdateLink Question
  283. RE: Edit Text Import
  284. QueryTables Error
  285. MsgBox - Don't Show Again
  286. Automatic Macros
  287. control excel from Agilent VEE with ActiveX
  288. multiplying data
  289. Time format behaviour
  290. Validation
  291. Is Active Workbook ="ABC"
  292. Creating an installation file
  293. Automating Fill series Function Multiple times ?
  294. File Search
  295. Assigning global macro to keyboard shortcut in Excel 2003
  296. Automated export from Excel to Outlook
  297. Load 2nd form - second one not working after hide - help pls
  298. Set a cell to blank (Null)
  299. What does this message mean?
  300. Default Menu
  301. Re: Trendline Data
  302. Macro to delete duplicate entries
  303. Re: Easy Array Question...
  304. Re: Easy Array Question...
  305. Re: Easy Array Question...
  306. Read Only Wrkbook Sheet
  307. Re: Trendline Data
  308. ClearContents Not Clearing Query
  309. Re: Trendline Data
  310. formulas for pivot table data
  311. Re: Copy Formula loop based on number of rows w/ data in a col B.
  312. Sendkeys and wait variant
  313. updating Excel from DotNet
  314. Re: copy sheets selected on user form
  315. sending email with commandbutton
  316. Re: copy sheets selected on user form
  317. Qn: Ensure Number is valid for a circle??
  318. Class module in VBA
  319. Retrieving a value from a cell
  320. Exception Access Violation (0xc0000005)
  321. Setting up default chart properties
  322. Code Execution has been Interrupted
  323. Listbox Problem
  324. RE: VBA-XP-Excel 2000-2003
  325. Set print Range
  326. code for converting data format in another format
  327. Adding columns with dates -
  328. Re: Put the value of a cell in a variable
  329. Time format behaviour
  330. Time format behaviour
  331. Re: Time format behaviour
  332. Re: error handling off??
  333. Textbox
  334. Any fast method to parse a string into row & col information
  335. Re: RandomNumber Generator
  336. Exporting & Importing Macros
  337. Range
  338. Adding columns - with tech info
  339. EXCEL Checkboxxx Props.
  340. excel VBA problem - setting workbook as variable & opening/re-opening
  341. q Using a macro to paste data from Excel to Word
  342. string length
  343. VBA - find double quote (") in string
  344. Macro fire at given time, through command prompt
  345. Excel cannot complete ......... when screen saver is activated.
  346. Re: Running Event Procedure When Cell Updated on Excel Worksheet
  347. cell-fill-macro again
  348. export form??
  349. Make a built-in toolbar permanently not visible
  350. UserForm events
  351. Help with Do Loop that names rows as ranges
  352. Data from Excel to Access
  353. cell-fill-makro
  354. Delete
  355. Adding columns to get correct results
  356. Class module to filter textbox entry
  357. Print Macros
  358. Read only mode
  359. finding text
  360. Loop until underlined border??
  361. Filter
  362. code to select a column down to last poplulated row
  363. Web query on password protected page
  364. .GetOpenFilename assitance
  365. Calling Solver from an Excel 2003 Macro
  366. Disable Customize in Excel 10,11
  367. Need for Application.Volatile?
  368. Open wrkBook (auto_open) programmatically
  369. Offset Range
  370. repositioning aging categories in a pivot when present
  371. ChartObjects
  372. Excel 97 to XP problem
  373. Merging data from several sheets
  374. How to use function CELL(Infotyp;Ref) in VBA?
  375. Excel Validation Help Needed
  376. Difficult project using arrays
  377. Commands fail on different PC's
  378. another lookup!
  379. Check box - checked or unchecked?
  380. (Disable macro's while) using the GetObject
  381. Excel automation through .NET Interop: NumberFormat property looks like NumberFormatLocal
  382. Move ? spaces to the right
  383. Macro for comparing 2 values (number and date)
  384. web page object reference
  385. [variable] definition
  386. search for one column values in another col ?
  387. Device I/O Error
  388. save w/o prompted and activate a file
  389. MsgBox position
  390. Using If Statements to change colours
  391. Save without prompted and activate external file
  392. Save without prompt and Activate a file
  393. Customize Pivot Table
  394. Pivot Table - Code Optimization
  395. Find the last Row in a Range
  396. using a macro to copy cells from one sheet to another
  397. Convert *.Xls to *.csv
  398. Disable Macros when opening workbook
  399. A VBA code that clicks a checkbox
  400. How could I run my macros in a protected with password worksheet
  401. Excel error after using macro
  402. Filling a textbox with text in another cell
  403. remove help icon from inputbox
  404. Find...FindNext Problem
  405. Formatting &[Date] in header Excel 2000
  406. vba/macro for loop-based summing?
  407. User Input
  408. Missing coefficients in multiple regression
  409. forward and back buttons in EXCEL
  410. Quick n' dirty code to delete rows?
  411. Excel Macro question? Column position
  412. Summary on one page
  413. Merging cells text
  414. remove drop down arrows
  415. Excel 2000 / How clear drop-down list in Pivottable?
  416. Template behaving like .xls file
  417. Help with a macro
  418. Negative numbers
  419. Auto Edit HTML Page
  420. Re: Conversion from currency value to currency text format
  421. Excel calculation
  422. Closing Excel from VBA
  423. How to automaticaly hide all toolbars in in workbook when another workbooks are open?
  424. Tracking changes
  425. workspace
  426. RE: Adding Macro Button on Standard Toolbar
  427. Adding columns
  428. Link multiple spreadsheets to one central spreadsheet using a macro
  429. entering formula using variable in Excel Macro
  430. Control Button stays on screen
  431. Remove First Row from Variant Array FAST?
  432. Excel 2003 blows me right out sometimes
  433. converting dates
  434. Pivot Table Vba Automation In 2002
  435. Adding two columns to determine number of days to pay
  436. Return value of Property Get when using enumerated type
  437. VBA - Lookup address
  438. Macro File Help
  439. Re: Is it possible to get cell contents from another sheet?
  440. apoligies:changing excel icon
  441. VBA - Lookup cell address
  442. Is it possible to get cell contents from another sheet?
  443. Re: Is it possible to get cell contents from another sheet?
  444. Hide Sheet If....
  445. Sound when running macro
  446. Updating Data to Access Error
  447. right
  448. referencing previously selected cells after macro execution begins
  449. specify the exact size of a chart through microsoft script editor
  450. MS Query problem
  451. problem evaluating custom functions
  452. What is wrong in this Sub?
  453. Opening an HTML doc - inconsistent results manual vs macro.
  454. Re: Upgrading to Office 2003
  455. Splash screen on opening excel
  456. choose the right volume
  457. passing reference arguments to VBA function
  458. mouseclick events
  459. Re: File specific Auto correct entries
  460. Excel spreadsheets formatting
  461. Qn: Position of Cursor in UserForm1
  462. Qn: Load Data into UserForm1??
  463. passing criteria via Get External Data from a macro
  464. Qn: Paragraph or LF in ONE Cell??
  465. Excel macro recording problem
  466. Qn: Sound in MsgBox??
  467. Protecting Cells with macros
  468. Qn: Display Text in TextBox in Userform
  469. Shortcut keys for buttons on forms
  470. Excel Template Wizard?
  471. Opening an external file
  472. Opening Recovered Sheet - 3rd Post
  473. How do I count in Excel?
  474. Make 1 row into 4 rows
  475. need to copy row above but different thoughtout data
  476. Lost the 'Help' menu, urgent!
  477. VBA Primer
  478. Suspend code
  479. New Line Character
  480. User Defined function - second posting
  481. How to see if the opened workbook is opened by another user ?
  482. Removing Dialog Box
  483. code for select a group cut, paste and delete
  484. Automatic Activation of Design Mode
  485. Error Handler
  486. Automatically Close Excel
  487. Saving
  488. goal seek problem
  489. Reducing File Size - Turning VBA into txt?
  490. How to suppress the prompt from merging cells
  491. Refresh Multiple Pivot Tables
  492. adding new data on new sheet
  493. cell displays formula instead of value
  494. Like Sumproduct() but using values from a list
  495. PUT data in closed workbook
  496. Visual Basic Text Functions
  497. I try again with auto tab
  498. Please help with this filter
  499. select alternate rows - quickly
  500. Executeexcel4Macro?? (Dave, I need some help)
  501. Workbooks.Open not functioning properly
  502. Autofilter global Show All function disabled in protected worksheet
  503. Selecting first cell in a colmn after a filter has bee applied
  504. how to save only one sheet as workbook
  505. Excel 2003, problem with UK date format, using OLE
  506. calling an MS Access query from within VBA for Excel
  507. Get Pivot Table count of rows in VBA
  508. Timeout problems
  509. Disabling Right Click Menu
  510. Worksheet That Works Like Pivot
  511. difference between 2 times
  512. excel
  513. selectfile control
  514. excel
  515. Help with applying function to cells
  516. EXCEL 2002: How do I user/simulate a Timer event in Excel form
  517. Inputs.
  518. Re: HowTo Count number of replacements
  519. Chart question - Walkenbachs book
  520. Is absolute security for Excel VBA code possible?
  521. Open a TXT file from WEB ?
  522. RE: Worksheet as file
  523. Re: Still can't get it right
  524. Re: Calling a procedure in a procedure
  525. Color Text
  526. Passing data to an open workbook from Lotus Notes
  527. MsgBox - How to display In Other Instance of Excel
  528. coloring cells
  529. Re: Calling a procedure in a procedure
  530. How to open an html file from within a macro
  531. Re: Calling a procedure in a procedure
  532. Running an Access Query From Excel
  533. Macros incompatible for different versions?
  534. Populating data from an external database
  535. Open a Spread Sheet In a Mdi form In Vb.net
  536. Select a row, copy and repeat on the next row
  537. dYNAMIC Array declaration, a small correction in my last thread!
  538. Declaring variable as a dynamic array?
  539. Macros incompatible for different versions?
  540. Autocalculation settings when multiple spreadsheets open
  541. Saving files
  542. msgbox title
  543. Re: HowTo Count number of replacements
  544. Advance Filter problem
  545. Re: how to open a Workbook and activate a specific sheet
  546. SELECT ... INTO ... IN ...
  547. Re: how to open a Workbook and activate a specific sheet
  548. find location
  549. Deselect top row in pivot table
  550. Macros incompatible for different versions?
  551. Cut and Paste to A Seperate Worksheet
  552. So close and yet... (Pros Only)
  553. Verify Totals
  554. can it be done without using code?
  555. Combo box help
  556. Need to do a SQL-like functions within Excel. Need HELP!
  557. Re: Could not set the RowSource property
  558. Text Boxes / ctrl-f
  559. RE: Insert method of range class failed
  560. Insert method of range class failed
  561. Divide up Worksheet
  562. Save file with fields within quotes and comma separated
  563. Creating a chart (Getting the correct input and output)
  564. range data type
  565. Save takes seconds vs. SaveAs/Save As takes minutes
  566. User Form Template???
  567. ComboBox Values
  568. Apologies: access/excel ado via vba - forgot a line
  569. access/excel ado via vba
  570. Copying Worksheets from one book to another
  571. Opening with a password with VB
  572. vlookup from VBA on a closed workbook
  573. VB programming interactive macroes
  574. Conversion to Text file
  575. Hourly calculation
  576. Excel VBA- If Then statement
  577. Dynamic Validation Lists
  578. Problem populating a multicolumn listbox
  579. Adding add columns and not getting duplication
  580. Inputs into equations withwout having to repeat the equation every time.
  581. Hiding Excel Menus
  582. Hiding Excel Menus
  583. Hiding Excel Menus
  584. Counts
  585. irrational problem
  586. can i add a row for (x,y) values and perform its maths?
  587. How to eliminate any new pivot Items
  588. Adding - Thanks - in reversing the formula it worked
  589. Re: VBA To Replace Duplicate Values with Zero (Complex)
  590. ParsingCellData
  591. Read all -- Adding columns for paying
  592. User defined function
  593. Help with Pop up screens and Error Pop ups
  594. Need Help With A Loop To Copy
  595. Windows Explorer Right-Click Extension
  596. Make Option Compare Text the Default??
  597. Adding columns for purpose of payment
  598. Update cell selection of embedded worksheet in Word
  599. Print Array in Cell
  600. Repeated validation lists in several worksheets
  601. How to use QueryTable with insertion sql
  602. Userform cannot return any values
  603. Test if Clipboard is empty
  604. programming the VBE for a new event procedure
  605. Can I attach a toolbar to an add-in?
  606. Find Method
  607. Find Linked Cells
  608. Using cell references in Excel Macros
  609. running a webquery after every 5 secs
  610. Searching text lists
  611. Password protect excel code
  612. Colouring cells
  613. Difficult returning result !!!!
  614. Search for criteria and count
  615. TextBox Controls--tabbing
  616. Insert a heading
  617. deleting row using macro need help
  618. Additional feature to code given on August 6th
  619. Tab Name same as Cell - PART 2
  620. Naming A Table Array in Vlookup
  621. Naming A Table Array in Vlookup
  622. Naming A Table Array in Vlookup
  623. VBA execution stops at ActiveSheet.Copy -- but only sometimes!
  624. Help with some code please
  625. Excel VBA question - Running a autofil
  626. RE: Access and retrieve data from network workbook
  627. MDB add-ins for Excel 97
  628. read text file
  629. read text file
  630. Cannot suppress an ErrorMessage
  631. How can I use web query with a password protected page?
  632. Read text data
  633. validating macro
  634. screenupdating workbook open
  635. Countif with row criterion
  636. Autofill
  637. Sort options by Excel VBA
  638. Activate button when row selected.
  639. Recognising cell values
  640. Paste special to the active cell
  641. SQL Query Headache
  642. Switching Names Around
  643. a faster method in changing cell value?
  644. How to parse the comma seperated strings into the excel sheet
  645. Cell Comparsion (a bug?)
  646. countif usage ?
  647. Moving between Worksheets
  648. Re: Cancel return on keyboard
  649. Excel Math Bug
  650. Re: Okay, Let's ask this another way
  651. Combo Box initial set up
  652. Row Height
  653. VLookup question in a macro
  654. AutoLoad Custom Tool Bar
  655. select row in userform listbox with right-click?
  656. Changing a text entry format
  657. Searching an Array
  658. How to include a double quotation character in a string?
  659. Animated charts showing change with time
  660. Variable sheet name in formula
  661. next empty row
  662. RE: Formatnumber
  663. Copy Worksheets from one book to another?
  664. Display initial value in combobox
  665. Converting Excel Worksheets into PDF
  666. Relative Range in a Formula
  667. code to insert add'l code ???
  668. selecting worksheets
  669. Tab Name same as Cell
  670. Excel - VBA Macro Not Found
  671. Copy file while in use
  672. Removing Personal Information (Author etc)
  673. creating a new dataset
  674. Cells = Worksheet name
  675. Reordering with Multicolumn Listbox
  676. Network Workbook (access data, etc.)
  677. Week to date
  678. Need to print different sheets conditionaly
  679. Input Box Question with Code
  680. Need help with this reference problem
  681. RE: Input Box Question with Code
  682. Re: Input Box Question with Code
  683. Re: Numerical Input via an inputbox method
  684. Re: Numerical Input via an inputbox method
  685. Re: Input Box Question with Code
  686. How to run an excel Macro in VB?
  687. Excel on the web using .NET
  688. Formulas and making info invisible
  689. Access and retrieve data from network workbook
  690. exporting categories - excel
  691. Unloading UserForm not working
  692. PasteSpecial Values
  693. Re: List boxes - help
  694. Searching for mutiple items in txt files
  695. Editing Code - Help!!!
  696. Editing Code - Help!!!
  697. Filter blanks and populate with a series
  698. Re: Toolbars
  699. RE: Toolbars
  700. error message in Vlookup
  701. Improving data retrieval system
  702. moving mouse pointer
  703. moving mouse pointer
  704. Active Directory? (reposted in case it was missed after a quiet weekend)
  705. Enabling Line/Column number in code
  706. CommandButton
  707. Rename worksheet
  708. removing words/phrase from sentences
  709. Multiple personal.xls files found!
  710. User Indicating the Arguments while code is running
  711. Add an exception rule
  712. Running macros in the background
  713. Multiple persional.xls files making macros NOT work!
  714. Re: Macros in HTML
  715. setting the focus using VB
  716. Can Excell 2000 do queries
  717. Delete empty array columns
  718. Currency formatting
  719. Another Reference Problem
  720. Checking for Open Files
  721. Re: Volatility With Comboboxes?
  722. Change pivot Table color on Condition
  723. Returning Range Total in VBA
  724. Delete Password protected macros
  725. Converting <b> to bold in excel
  726. Command Button
  727. set ToContact Outlook security workaround - help
  728. Numberformat vs string question
  729. Subtracting dates to come up with number of days
  730. Excel VBA - go to cell problem
  731. Error Handling when database not available
  732. error 50290
  733. chart problem
  734. Accessing Server Date
  735. Userform does not always show on startup over LAN
  736. Run-time error '91'
  737. Problem is using any method of Range Object
  738. PDF converter to xls
  739. Problem in using Advanced Filter
  740. Workbook_BeforeSave()
  741. Open Files by Clicking on a Cell
  742. Code - Repost
  743. Memory Leak When Copying Charts
  744. Problem with removing qoutes from string
  745. Printing
  746. Printing
  747. how do I get data into my *.xlt from my *.xls
  748. Save As.....
  749. Clearing Combo Boxes.
  750. Cell Reference in formula increment
  751. Active x Calendar control error (-2147417848 (80010108))
  752. Code snippet storage
  753. error
  754. Adding to Chart Popup menu
  755. Converting From DAO to ADO
  756. (no subject)
  757. Need some events...
  758. Navigation Tree
  759. Excel 2000 V Excel 2003 and Pivot Tables
  760. conditions in Excel
  761. Effecient way to check, add, delete duplicates
  762. Detecting Applications Run using Excel
  763. Excel VBA - delete hidden column in mergence status
  764. How to reset Worksheet Menu Bar in VBA???
  765. Tony Barla
  766. Mail merge issue - ghost Excel process remains after closing application
  767. How to stop having to re-assign macros every time you open a workbook???
  768. copy data to another sheet
  769. Display Excel file in Internet - an interesting question
  770. Charting with VBA
  771. Userform with Formula
  772. Insert Rows after text appears in column
  773. Mail merge issue - ghost Excel process remains after closing application
  774. Forcing "Macro Enable"
  775. Populating listbox
  776. How to leave a combo box?
  777. Forcing "Macro Enable"
  778. Delete Rows
  779. Clear vaidation
  780. Newbie question
  781. button to activate userform
  782. save as loop
  783. Daily Automatic Transfer of data from one ws to another ws
  784. Pivot Table SQL Query saving
  785. What are XLL Add-ins?
  786. Creating Add-in with library of functions
  787. Print userform
  788. working by column name
  789. using vba to copy from excel to embedded word doc
  790. Date change macro between worksheets
  791. Copy textbox contents
  792. Display sum of selection with SelectionChange procedure
  793. Data Validation
  794. Three short questions regarding importing of data. See code
  795. active directory?
  796. hiding / displaying the excel application window
  797. ADO recordset returns -1
  798. Workbook_Open Question
  799. combining two cells
  800. Suppressing Pivot Table totals
  801. Availability of fonts in VBA
  802. VBA programming textbook/reference
  803. Occurances of value
  804. if its open...close it
  805. auto no save
  806. Transparent subform
  807. Why does this code not create a button when called???
  808. Create new sheets from data in either of two columns
  809. Passing IP address from Excel to a Web site Locator
  810. putting ' in a column of cells
  811. Workbook VBA not recognising half the new worksheet!!
  812. Vba - Opening Outlook with Vba
  813. VBA code for automatic download
  814. Help with Excel
  815. Collection Variable
  816. number format
  817. variable in a formula
  818. Lookup Mail Contact
  819. insert two text values
  820. re:loop through controls
  821. looping through userform controls
  822. startup a userform
  823. VBA to create PDF using Adobe 6.0
  824. Hide Worksheet
  825. ActiveX properties in VB and VBA
  826. Worksheet as file
  827. Send a range in Excel as the body of an Outlook Express message
  828. Macro to sum up the amout?
  829. Assign Sub to Custom Button
  830. Dynamic Range Chart Macro Question
  831. Can Excel use as a VB form creation?
  832. Insert Text at Bottom of Last Page
  833. wildcards with sumif/countif in macro/vba
  834. looping through userform controls changing enabled and locked properties
  835. Adding in data from another database
  836. Fox Pro Data Base
  837. Re: QueryTable's
  838. opening another workbook
  839. ordering
  840. Extracting sub arrays from a 2-D VBA array
  841. newsgroups
  842. Not exactly a programming question
  843. cursor position
  844. Mouse Over
  845. Rounding
  846. Chart Tab Name & Worksheet Reference
  847. Help with error 1004 in database query
  848. Data Validation Lists - drop down.
  849. inputbox Auto response
  850. ok... but not a solution to my original post...
  851. *.xlb file missing!
  852. clarify
  853. excel.application.run macro1 --> added code to respond "yes" to a inputbox
  854. Re: Future Value of Increasing Payments
  855. clarification
  856. clarification
  857. A way to create a Command Bar without code???
  858. Filtered counts
  859. 2 questions : ordering and placing
  860. macro problem
  861. Code for Tom and Frank
  862. For Each Worksheet Problem
  863. Opening Recovered Sheet - 2nd Post
  864. Edit userform
  865. *.xlb file missing?!
  866. MSFT Encounters Error
  867. ODBC/OLE DB to access Excel file and get weired table name Sheet$_
  868. links update
  869. Data types Questions
  870. Clearing all items in a collection
  871. Run Time Error 1004
  872. How to imput " " (quotes) in to your cells
  873. Re: Passing value from Hyperlink
  874. Need code
  875. inputbox and application.run macro1
  876. Re: Populate cell values with sheet names
  877. Excel Macro Help
  878. Re: Populate cell values with sheet names
  879. Erase Arrays
  880. Changing text color
  881. Values run out of range
  882. CopyFromRecordset does nothing
  883. consolidating records
  884. How to rename a picture?
  885. A variable in VB
  886. Newworkbook
  887. Code and thanks for/to Tom and Frank
  888. Save As... prompt
  889. Re: textarea
  890. Re: textarea
  891. Countif in VBA
  892. Maximum Unique Records in Pivot Table
  893. IF THEN ELSE STATEMENT
  894. protect cells
  895. Macro to force delete tabs
  896. Automating MS Query
  897. Paste
  898. Attaching toolbars to spreadsheet, but macros do not follow?
  899. Code
  900. text box reference
  901. Imported Text File Worksheet Tab Name
  902. command button color
  903. Finding Files on a server
  904. Excel Pivot table on the web
  905. VBA - Writing in XL XP, executing in XL 97
  906. Reading data from a database
  907. worksheet protection
  908. Trigger an event when a cell's value is changed.
  909. What next!!!
  910. VBScript to Change pivot table layout
  911. Object Required Error
  912. Need help on blank cells
  913. GammaDist Worksheet Function
  914. autoshapes round 2
  915. Fullscreen
  916. ActiveWindow.ScrollColumn Sort
  917. Help Please
  918. How to use "Transpose"?
  919. autoshape
  920. Returning the result of an SQL/Query to Excel
  921. changing user name on windows system folder
  922. how to capture data
  923. Sort a range randomly
  924. Excel macro to extract information from MS project files
  925. Speed - or lack of it
  926. Synchronise 2 dropdowns
  927. How do I create a user form in excel?
  928. Selecting autofiltered cells
  929. Restrict the user from ADDING/DELETING column/rows
  930. Macro sending Excel template data to database
  931. Appears that HotKeys have been used, but where in Excel 97?
  932. Performance Issue with Database Connection
  933. Find range in one sheet, then paste in the other (one by one)
  934. Protect Macro
  935. Lookup Help
  936. Re: ??Names ranges, charts, and SERIES function arguments
  937. Populating data from an external database
  938. Macro that cut and pastes
  939. Re: Help with VLOOKUP
  940. Excel Security
  941. add a reference manually
  942. Another Outlook question
  943. Re: Limitation on controls/objects?
  944. Re: Find last filled cell in a column
  945. Macro to upload tasks to the Outlook Calendar
  946. speed up macros
  947. Open Folder - Ogilvy code
  948. public macros
  949. Re: VLookup with VBA trouble :-(
  950. Help with MS Graph
  951. VBA Errors Through Webpage
  952. Excel PivotTable C# problem
  953. macro that sends email with attachment and address
  954. RE: InputBox code
  955. Re: Recordset object loses validity in call between function & subrout
  956. Convert to military time - part II
  957. Excel macro script to copy only formulas and not values from one sheet to another
  958. Re: Help sending mail...
  959. Data type conversion
  960. Excel Characters
  961. Menu/toolbars/macros defined in Excel 2003 not working in other versions?
  962. calling excel macro
  963. Re: copy outlook contact information to excel sheet with macro
  964. Formatting Zeros
  965. Excel Spreadsheet using SQL.REQUEST - System Requirements
  966. Data Label Object Position not working
  967. Sorting multiple range using a macro
  968. Remove UserForm
  969. Need help with writing variant back to sheet
  970. Autofiltering Makes Button Control Disappear
  971. Re: Recording page set-up macro
  972. unique copy
  973. Can a function return two values?
  974. Vba - Generating Micr Outlook Alert from excel
  975. URGENT: Alan Beban - SubArray not working - any thoughts?
  976. Alias FROM: when sending mail in Excel
  977. SOme problem on VBA Userform
  978. new worksheets based on list
  979. URGENT: Comparing Ranges, Selecting Values, and blah blah blah
  980. Note to Bob Phillips
  981. Trouble with Workbook_Open()
  982. VBA and SAS
  983. An MD5 Hash with a single quote = grief in SQL query
  984. Writing Macros in Excel
  985. vba - counting different items
  986. Data Validation
  987. Browse for folder - Jim Rech's
  988. Syntax
  989. Re: Help sending mail...
  990. Assigning range to array not working
  991. Display Alerts
  992. Re: InputBox code
  993. VBA date in function
  994. RE: Pivot Table
  995. This should be an easy one for most programmers but im having some trouble...
  996. period of sum of sine waves
  997. Automate Embedded Word Document
  998. RE: Using Access DBs from Excel
  999. RE: Find last filled cell in a column
  1000. Returning number of blank cells