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: Delete VBA code in worksheet through a macro
  2. Re: Delete VBA code in worksheet through a macro
  3. Prevent User from Deleting Drawn Object
  4. Macro to copy text to a specific cell reference
  5. Insert Rows in Protected Worksheet
  6. Problems populating an array
  7. Creating Custom Menus
  8. boo boo
  9. Disable menu items with VBA
  10. observation on .filldown method
  11. Complex numbers in VBA (Excel(
  12. formulas - multiple reference sheets
  13. Re: Nested If Then
  14. Re: listbox
  15. MSCAL.OCX
  16. Re: Nested If Then
  17. Re: writting a macro for the sum function so I can use it as a keyboard shortcut
  18. Internet Explorer Automation with Excel VBA
  19. Cannot insert object when I update version
  20. MSCAL.OCX
  21. Re: Nested If Then
  22. Formatting Cells
  23. Re: Function to extract and return the first and last cell from addres
  24. Non-consecutive numbers in Macro
  25. Actual row of a filtered row
  26. Commandbar frustration.
  27. change datestamp from yyyy-mm-dd to yymmdd
  28. How to find a column
  29. control of dialog macro dialog box. on open
  30. Re: Replace() Range Function
  31. sendmail error
  32. Row Referencing
  33. Novice VBA question...
  34. Excel 2000 versus Excel 2002 question
  35. Why am I getting the Copyright Sign instead of the Letter C"
  36. Re: Open webpage
  37. Re: use of Macro in If statement
  38. Re: usgin a macro within an IF statement
  39. Password Protect Worksheet Viewing
  40. send macros with file
  41. Trouble getting the OFFSET fo work
  42. Programing Outlook using Excel
  43. Sort filtered rows in VBA
  44. sendmail message
  45. exel macro to eliminate duplicate record
  46. Re: Associating Cell with Background Image
  47. Distribute Excel Addin
  48. Changing Row Referencing
  49. macro code doesnt work in command button
  50. Auto-Hiding rows based on cell in seperate worksheet
  51. Exporting pictures object from Excel
  52. Problem with 'For' loop execution [VBA,Excel XP]
  53. Re: Totalling across sheets
  54. Re: writting a macro for the sum function so I can use it as a keyboard shortcut
  55. writting a macro for the sum function so I can use it as a keyboard shortcut
  56. Totalling across sheets
  57. Find Non-consecutive numbers in list
  58. How to create text file from selected excel data
  59. Crack a VBA password?
  60. Cell formatting changes on export
  61. Automate this code
  62. Cycle thru worksheets in a workbook
  63. Unhiding a sheet
  64. VBA complex numbers
  65. help with command bar positioning
  66. runtime error 1004
  67. Do Until VB Macro
  68. button control on Forms toolbar
  69. User Info
  70. Evaluating Week No.
  71. Re: Prevent multiple cell select
  72. How2 Delete "Not exist" charts/sheets?
  73. Re: Copy range content as picture - truncation problem
  74. Cell Reading Problem
  75. Removing a reference
  76. DLL
  77. sheet orderings
  78. MS Query - Parameter Bug
  79. Re: Alternative to updating 300,000 links in Excel 2000?
  80. Hide Formulas
  81. loop through columns
  82. Moving Directories
  83. re Alternative to updating 300,000 links in Excel 2000?
  84. Import data into seperate sheets
  85. Automatically Confirm Deleting Charts
  86. Re: Data loading more than once into excel columns
  87. Data loading more than once into excel columns
  88. Check image availability on userform
  89. Saving Userform as Gif
  90. Help on Disabling Save & Print Options
  91. Excel VBA - Timer
  92. Excel VBA - Timer
  93. Macro
  94. Make all empty cells in columns = 0
  95. updating spreadsheet
  96. Entering Date via SQL Query
  97. Screenupdating is always true
  98. Automatically paste cells that return a value, otherwise maintain existing formula.
  99. Thanks
  100. Excell Macro help
  101. Determine page which row will print on
  102. compiler error in calling Exell functions
  103. Selection of non-empty cells
  104. cell conditional formatting
  105. give me a hand,About printpreview
  106. Re: command bar question
  107. Different text format on a listbox entry
  108. Excel VBA - determine location of a keyword
  109. Re: Auto Open macro not performing as expected
  110. Re: Check Box weird problem
  111. Re: Thanks.
  112. values from other workbooks.
  113. Macro to send HTML email...
  114. Help: Iterative Operations for Election 2004 Project
  115. Macro Debug
  116. converting VBA scripts to stand-alone exe files
  117. Number format in CSV file
  118. parameter queries in macros
  119. a for selected sheets print named page macro
  120. Re: msinet.ocx
  121. Font Changes on Embedded/Linked objects in Word
  122. Conditional Format ?
  123. sendkeys method - question
  124. file name reuse
  125. Outlook Question
  126. Report All Column Widths In Active Worksheet - Corrected
  127. Selectively Unprotect an object
  128. Delete rows based on comparison criteria
  129. Assistant Balloons hanging on
  130. Re: Many Rows to One Row based off of first column
  131. dividing report by region
  132. Help with automatically running procedures when an Excel file is accessed via web
  133. Userform Comboboxes - need a quick how to..
  134. Open Multiple Workbooks or Worksheets
  135. create my own "table"
  136. Alternative to links for updating worksheet?
  137. Re: Current time Current date.
  138. Creating Borders with a formula
  139. Re: VBA Challenge - Flag Missing Info
  140. activeX
  141. Returning The Column Number ?
  142. totalling across pages
  143. HELP: need to find number and sum another colmn
  144. Can I use a VBA function I write myself in a formula?
  145. Referencing password protected Workbook
  146. send mail with MAPI problem
  147. Re: Real time countdowns
  148. Getting a String Path from a browser...
  149. Excel VBA - How do I make a bar chart
  150. Re: VBA Challenge - Flag Missing Info
  151. Pop-up calculator?
  152. printing ranges ina macro
  153. Shrinking Listboxes
  154. Help with copying 46000+ Rows from Excel to Word
  155. Setting Range Command
  156. How Do I Run A Macro When Excel Is Resized?
  157. Convert two times to "Hours Worked"
  158. Anchor points in Excel, for web use
  159. Filtering records
  160. Showing and hiding columns
  161. Running a macro when a cell value changes
  162. can't get code to Run
  163. Report All Column Widths In Active Worksheet - an example
  164. Split Workbook part 2
  165. Re: Macro in VBA: Setting a variable print range HELP NEEDED!!
  166. Re: Put Info from Clipboard to Textbox on form
  167. Re: Many rows to One row
  168. Re: Put Info from Clipboard to Textbox on form
  169. Dynamically changing filename referenced by day
  170. Macro help needed...
  171. Copy Filtered Rows
  172. Changing Pivot Range Programatically - header row issue
  173. current row of user-defined function?
  174. tree view
  175. Re: Active application
  176. Using VBA to intercept PDF's Save file dialog box
  177. launch any file type from excel macro
  178. Hey Frank,info needed
  179. Removing preceeding spaces
  180. Conflicting Code?
  181. Count/Frequency in Pivot Table
  182. Re: Array Length.
  183. Re: Array Length.
  184. DECIMAL PLACES DISPLAYED
  185. xlLineStyle
  186. Re: Count/Frequency in Pivot Table
  187. Re: SpecialCells(xlCellTypeLastCell)
  188. Enter the same value for a group cells.
  189. dynamic userforms
  190. Save Over
  191. Protect a group of cells
  192. Re: Is Range Between two Ranges
  193. Re: SUMPRODUCT using data from multiple worksheets
  194. SUMPRODUCT using data from multiple worksheets
  195. Don,Rollin,Tom, and all others...Cud u help me in this (Urgently needed)
  196. Re: VBA - Printing a frame
  197. Making Tabs
  198. Re: msinet.ocx
  199. Re: Disabling Excel Prompting when it detects a circular reference
  200. compile error: out of memory
  201. Re: Check Box weird problem
  202. Re: Making Tabs
  203. Command Translator
  204. Multiple .dbf File Import Help
  205. Re: Thanks
  206. Lock userform position
  207. Sorting the contents of a cell
  208. gegevens zoeken
  209. Re: Last Row
  210. Repetitive task macro
  211. How certify my xls file
  212. which command?
  213. header of portrait page in left margin
  214. Sorting data using merged cells as keys
  215. Prolem with recalculation
  216. Excel XP 2003 changes from Excel 2000
  217. e-mail range from excel
  218. Hyperlink
  219. editing listbox
  220. Visible Button If.....
  221. highlight row
  222. Re: hide rows with any dates
  223. How to enter data in row in popoulated column
  224. Re: highlight row
  225. Re: Disabling Excel Prompting when it detects a circular reference
  226. pivot table series problems
  227. List and Sheet Create Macro
  228. Outlook Signature after Attachment
  229. Product Catalog
  230. Product Catalog
  231. Find & Replace w/ Name Changes
  232. Re: Creating Formulas That Accept Multiple Ranges
  233. I only want to grab specific cells
  234. How to Mute/Enable Windows Sounds whilst running VBA code
  235. Deleting Columns
  236. Floating Total row
  237. Newbie Question - Moving text from one cell to another
  238. is there such function
  239. lookup on 2 valus
  240. Access table exported to Excel does not preserve blank cells
  241. Getting Excel to not try to coerce numbers to Date
  242. Run Time Error 1004 Unable to set hidden property
  243. Find & Replace w/ name change
  244. Re: Code doesn't go past first IF statement
  245. Re: run time error 13 type mismatch
  246. Re: Document properties
  247. Looking up information
  248. Re: Document properties
  249. Copy and paste in VBA
  250. Split workbook
  251. getting a range of cells from calculation
  252. Re: "Loading..." Splash Screen in Excel
  253. Module to set Page Breaks based on criteria through code
  254. Conditional Formatting - more than 3?
  255. Calculating number of items
  256. Excel 97 error
  257. Re: "Loading..." Splash Screen in Excel
  258. Re: "Loading..." Splash Screen in Excel
  259. onkey help
  260. Defaulty directory
  261. calendar
  262. Using " | " Character
  263. Clipboard Question
  264. Displaying Cell Data on a Form
  265. Accessing Active X command button properties
  266. Using quotation marks
  267. worksheet_change event when multiple cells changed (pasted)
  268. Determine the class of an object
  269. Urgent Help needed !
  270. Copy Sheet w/out Formula's, JUST values
  271. User defined functions - parameter descriptions
  272. vlookup
  273. Opening a file
  274. Macro Help - Suppress warning box
  275. unlock workbooksin hundred of excel files
  276. tree view control
  277. A chart that allows for new data to be entered
  278. ListBox and arrays
  279. Exel VBA- userform startup problem
  280. Re: run time error 13 type mismatch
  281. Down Arrow
  282. Font settings in Excel
  283. Cell Search Function
  284. vlookup again
  285. Thanks again,but another query
  286. AutoFilter & Hidden Rows
  287. Problem with "On error resume next" with "custom VLookup"
  288. range that spans two worksheets
  289. Automatically Run Macro
  290. Problem with references to OCX control
  291. onclick event for cell
  292. Excel Formula Paste
  293. Excel VBA Problem- Using Find Function
  294. Combo box copy and paste
  295. One button - Excel to word?
  296. Excel function macros
  297. Can someone help me with this code
  298. Consolidating cells
  299. Get filename only
  300. Empty but persistent toolbar
  301. Assistant.NewBalloon test
  302. Excel automation in MFC
  303. Textbox Properties questions
  304. Pivot table printing
  305. Copying hidden rows
  306. VB password protection??
  307. eXCEL vbA : Copy n' Paste data and counting
  308. Problems with vb.veryhidden
  309. Shared Workbook
  310. Re: Talking to a Perl script
  311. Programmatic Access to Visual Basic Project is not Trusted
  312. CreateObject Question
  313. Fill sequence down cells
  314. label with continually updated time
  315. Re: Save and Close Excel using OnTime
  316. Reset System Time
  317. Save data in template from a form. Please Help!
  318. Out of Memory Message
  319. Combo Box Data
  320. SaveFileAs
  321. Open a connection to dbf file
  322. Undo row insert from macro
  323. Select a random value from a column of values
  324. Solver Record Macro Function
  325. Pivot Table 2003 refresh Client Saftey Options
  326. Faster alternative to Dir() ?
  327. Message--MEMORY COULD NOT BE READ
  328. V Look Up
  329. Re: Quick Question on Hyperlinks
  330. Re: Need help with identifying values and changing formats.
  331. Do Loops
  332. SQL Update
  333. Search Comment Text
  334. generating a rank order on two variables
  335. Pivot Table
  336. Locking a sheet...
  337. Editting Formulas Using a Macro
  338. If...Elseif...End If
  339. MS Query
  340. formatting function?
  341. Urgent Macro help needed !
  342. MS Query Using Vairable From A Cell
  343. unticking a tick box within a macro
  344. Share Macro
  345. Re: combine text and number with preceeding zeroes
  346. Set Print Area with a macro
  347. Winzip - Shell Execute
  348. Help With Forms
  349. How to permanently delete a custom toolbar
  350. Protection problem macro
  351. Copy And Paste From Excel To Word
  352. Error Message
  353. Help Needed...
  354. Help with save as coed
  355. format variable to 3 decimal
  356. trying to get column values to line up...
  357. Combobox
  358. Cell ForeColor
  359. importing data
  360. Redefining Styles
  361. Inserting blank columns
  362. countdown
  363. copy Transpose range data
  364. C0dŁ !!!!
  365. Excel 97 error
  366. E-mail from excel
  367. Sheet settings
  368. Move data from on sheet to another based on month
  369. help with summarizing
  370. calling macro in excel from VB program
  371. Delete Entire Row If Column C is Blank
  372. textbox value validation
  373. Format function 2000 > 2002
  374. Network address not Local Address
  375. Hide a row based on values
  376. Userform
  377. Sub to change formulas in a col
  378. Closest-to function
  379. How to check if a worksheet exists in worksheet collection
  380. CopyFromRecordset for Oracle ?
  381. VBA for the case when web request returns nothing.
  382. Da xla a xls
  383. Page totals
  384. Socket Programming in Excel
  385. sure but...
  386. Time function in Excel
  387. Problem with ADO connection fm VB6 to Excel
  388. Check file open status
  389. Getting a macro to perform a function on a certain day every week.
  390. Problem with Ado connection fm vb6 to xls
  391. VBA UserForm Question.......Help!
  392. (de)activating a device
  393. protecting macro VBA
  394. Listbox 3
  395. Saving attributes
  396. Autofilter a range in a different instance of excel
  397. Pics
  398. Program Excel 2000 With Vb.Net
  399. Creating vectors of numbers
  400. add an inventory item to a word doc if there is a Y in column C
  401. Exporting data to new instance of excel - created but not visible?
  402. Problem after removing digital signature
  403. Planning system
  404. Macro with protected cells.
  405. Macro Help...
  406. How to load these XLS files
  407. [Excel][DLL] Writing a DLL custom function for Excel with Delphi
  408. How to clear all item from a combo box?
  409. EXCEL-ACCESS DEVELOPER AVAILABE
  410. Function to convert string
  411. send to mail recipient
  412. Cosa ritarda l'avvio di excel (anche di un'ora)?
  413. Re: Optimization Problem
  414. cosa blocca avvio excel
  415. Is Indexing Possible in VBA/Excel?
  416. A hard DO loop for me
  417. Pivot table calculation
  418. Macro to open SaveAs... and change filename to cell value
  419. Macro to Print All Files in a Folder
  420. adding reference "can't find project or library"
  421. Maximize & Minimize where are you ?
  422. VBA editor hangs when changing font
  423. excel web query distribution
  424. returning values from a User Form
  425. Crreating an Object
  426. Using Arrays to select Shapes
  427. taking average of each set of all possible combinations
  428. User-defined data type; Error: Only User-defined types...
  429. Help
  430. Displaying Excel chart in C# application
  431. How to cycle all possible permutations
  432. Excel VBA - Add Sheet Change Event at Run Time
  433. Send values to "calculator" and answer back
  434. Replacing Tab with commas
  435. General question: how many controls allowed?
  436. Copying Rows on Text Colour?
  437. User form list box refering to another worrkbook
  438. Re: filtered recodset to pivot table (or not)
  439. Maximize & Minimize buttons where are they?
  440. Disable PDF in Excel
  441. Toggle calculation
  442. 'go to' macros
  443. Not recognizing a Const
  444. Macro problem. Need a vague not absolute reference
  445. locking use of the file.
  446. using ADO on an excel spreadsheet
  447. Excel macros help me ! very very urgent
  448. Toolbar Buttons (macros) fail after filename change
  449. ThisWorkbook module question
  450. Height + Width of a Range
  451. indirect copy protection of Excel files
  452. Is it possible to do that using excel formulas ?
  453. Private forms and sheets
  454. Re: Running out of memory - changing links and updating Access from xl
  455. API for TaskBar options
  456. Button
  457. Re: Scheduling Worksheet
  458. Checklist
  459. Problem with finding dates in Excel Macro
  460. 'LastRow' Function not working
  461. unprotect worksheet
  462. Re: VBA error 1004
  463. rendering in browser
  464. Dir() function to return either List of files or folders
  465. Urgent Macro Help Needed
  466. Re: VLOOKUP
  467. Issues with solver
  468. Userform blinking label
  469. RE: Set Focus Problem with Multipage Control
  470. RE: Set Focus Problem with Multipage Control
  471. Re: Calling procedures in .xla projects
  472. RE: Macro to lock in 14 views on a worksheet
  473. Error message:"Compile error modul 1"
  474. Method SaveAs with no overwrite YesNoCancel dialog
  475. formula
  476. A Marco Delete Question
  477. VLookup pulling data from wrong cell
  478. Password Macro
  479. Set Focus Problem for textbox control on multipage control
  480. file retrieval
  481. VB macro code for SQL Query
  482. Named Range
  483. EXCEL multiple criteria in countif function
  484. Macro to match output from 2 columns...
  485. Date question
  486. Something Very Strange, possibly a Flaw?
  487. Cell selection in non-active sheet
  488. Excel on the web
  489. Protect charts AND allow to copy them?
  490. One button to open and re-select
  491. Open sheet once 1st time xl is open
  492. use vb to delete marked rows
  493. Different Solvers.xla in Office 2000
  494. Re: Can't find links button to place it on toolbar
  495. formatting function?!
  496. Adding and subtrating from rates.
  497. vlookup function
  498. Urgent problem saving a file read only
  499. xl97/xl2k events in pivottables
  500. Excel user-defined Function: definition/help of arguments
  501. Removing rows featuring certain words
  502. How hide cells when print out?
  503. Error 1004 HELP
  504. Finding cell that a user click?
  505. autosave add-in settings
  506. Excel sheet......help.
  507. Excel sheet ...... help.
  508. Convert from seconds to mm:ss within a cell
  509. onClick action from cell selection
  510. Displaying a picture
  511. Problem with IE menus after installing excel macros
  512. Protecting different ranges with different passwords
  513. How to add a PivotItem ?
  514. MS Access Database Connection problem in Excel XP 2002
  515. Reference multiple Instances of Excel
  516. *.gif images
  517. workbook to be protected
  518. Pivot Table
  519. Fastest way for comparing columns?
  520. Workbook Properties
  521. Reset userform
  522. How to Close the entire Excel File
  523. Opening a file using VBA
  524. Help Required By Relative Newcomer
  525. attributes for MsgBox & InputBox objects in VB ?
  526. Eenie meenie minee......
  527. Change CommandButton Caption
  528. How to copy a range to a closed workbook
  529. Communicating down RS232
  530. Auto insertion of date and time
  531. combobox missing between excel 2000 and xp
  532. switched date format opening dbf file
  533. GetOpenFileName with network
  534. digitise graphical information
  535. chr(32) vs chr(160) ??
  536. Excel equivalent to Word Variable
  537. RE: Help with forecasting future values based on a current value?
  538. External Data Source Questions
  539. Excel XP
  540. Help: Election 2004 Project -- iterative operations
  541. matching numbers with images?
  542. Finish one section of code before continuing
  543. Program no longer work on Excel 2003
  544. Re: VBA error 1004
  545. Re: checkbox hell
  546. Re: checkbox hell
  547. Calling workbooks with apostrophes in name?
  548. Excel VBA - Search record with multiple criteria
  549. Avoid to reopen a working Workbook
  550. Re: Trying to add a Pie Chart
  551. decimal places in currency
  552. Custom function does not work from an addin
  553. numbering items in a column based on a condition
  554. Adding text to first empy cell in column A
  555. simple macro
  556. Simple macro help
  557. Re: Automatically applying a macro to many workbooks
  558. lost Courier New font in the VBE but it's in my machine
  559. Re: VBAProject Scope
  560. Re: VBAProject scope
  561. Re: VBAProject Scope
  562. Format Vlookup column with Text
  563. VBAProject scope
  564. Conditional move rows to another sheet
  565. Protecting buttons with VB code rather than protecting sheets/books?
  566. Re: Write Command Output
  567. Re: Write Command Output
  568. Excel VBA Macro
  569. Autofilter
  570. Memory per Sheet
  571. If open, go to, else open
  572. Re: User Defined Type
  573. Chart Name
  574. Re: Displaying Web Page
  575. Re: Displaying Web Page
  576. Re: Inserting a filename into a cell
  577. Autocomplete in VBA turned off
  578. How to call out object's text w/o selecting
  579. What Key
  580. suming across sheets
  581. Trying to save a worksheet
  582. conditional formatting
  583. Re: Visual Studio Tools for Excel problem
  584. Application Level Events Question
  585. Repost with code - Runtime error '1004'
  586. Reformatting a cell using VBA
  587. Run-time error '1004'
  588. Comparing a range with text
  589. Emails data from each row in a sheet
  590. Pivot Table
  591. Animation
  592. Selecting ranges to copying and Paste
  593. How do you automatically update criteria in MS Query
  594. Alternate Worksheet printing
  595. IsEmpty and bookmark help with excel 97 and word 97
  596. UserForm
  597. Re: Range("F83").FormulaArray
  598. setting a command button to be a hyperlink
  599. Rounding up decimals
  600. Do you want to replace existing file?
  601. Copy/Paste From Excel To Word Macro
  602. Combo Box
  603. Conditional Formatting on Time
  604. What workbook is calling the function
  605. Public Const on a Drive
  606. Protect file on a shared Network drive
  607. Transfer value to cell
  608. how to delete rows that show no value but contain formulas
  609. Excel VBA not counting colored cells
  610. Problem with Excel using a .Net rich text box
  611. Message with RoutingSlip
  612. Create New Worksheets in VB
  613. Input data from one worksheet to another
  614. Formats many sheets
  615. Using macros to cut & paste rows to a new worksheet
  616. Copy error with Autofilter
  617. Force minimum text box entry
  618. Visual Studio - Office 2003
  619. How to overide spell check blocking in protected sheet
  620. Keeping track of Global variables
  621. Totals
  622. Dates in TextBoxes
  623. Locking range for view of Excel Sheet on button click
  624. Opening Notepad from Code
  625. Hide Rows and Columns
  626. Excel
  627. opening file with worksheetfunction
  628. Help Delete Rows based on the macro in this message
  629. message box pop up for a given value in a cell
  630. Why is my Workbook Open procedure not working
  631. how to extract the row number of a cell with certain value
  632. Rename file
  633. Application.Inputbox acting strangely
  634. Paste to Multiple Selections
  635. Deleting a Menu Bar
  636. For Each - Range Cell
  637. COM Addin in C#
  638. How to make a spreadsheet as popup?
  639. CAE macro for green screen updates with Excel data
  640. Large file size problem...
  641. Tabs in Excel Spreadsheet
  642. Re: filtered recodset to pivot table (or not)
  643. Re: Data Interpolation
  644. Expand Range
  645. detect empty cell
  646. Placing a Form with multi-tables into Excel
  647. ExcelApplication
  648. Update Dates
  649. Excel 2002 Macro to Execute SQL Statement
  650. Excel Marcos
  651. Using Sheet names in formulas
  652. Finding Folders
  653. Re: Running MS Queries
  654. VBA Project Password
  655. Tool tip for controls
  656. How To....
  657. All Caps
  658. FieldInfo
  659. Re: Why I got this 1004 runtime error
  660. Using Columns().Row() To create a range
  661. Copy method of chart class failed
  662. (Urgent) If col D= value, avg col G
  663. Escape On Error methods in Subs
  664. Create subfolders in a folder
  665. convert excel worksheet to binary array
  666. Checking if a worksheet already exists...
  667. Auto unique numbering
  668. start a macro everytime excel opens
  669. Re: Trigger Event - Frank Stone
  670. Macro works in 2003, not in '97
  671. Macro within Macro
  672. Can't get FindNext after deleting row?
  673. Search/Find in any worksheet
  674. Deleting workbook
  675. VBA - Status Window?
  676. Runtime Error 424
  677. Re: Checking entire row for duplicates
  678. ColumnWidth
  679. Using SELECT...CASE with comparison operators?
  680. Excel 2003 Additional Workbooks After Excel Crash
  681. Re: setting chart axes
  682. Open Unique excel.exe
  683. Re: Checking entire row for duplicates
  684. Display a range fullscreen
  685. Re: Inserting Formula
  686. Trigger Event
  687. [UserForm]: *.gif
  688. Tutorials?
  689. Getting data from several worsheet/books
  690. Key Identifier for Sheets?
  691. Initializing a Form with multiple forms embedded
  692. Whats wrong?
  693. Updating of one file and prograte to others files
  694. Calling to a specific cell
  695. Re: adding Activex control through code works BUT... Cannot access ob
  696. Open then Close
  697. Comparing Two Cells in Excel
  698. when would you use "new workbook"
  699. Re: Deleting workbook
  700. ListBox.ColumnHeads Property
  701. Macro crashes excell from remote location
  702. password protect
  703. Excel VBA - How do I programmatically change source code in another file?
  704. Renaming Files: Take 2
  705. comparing values in excel with vb6
  706. Error
  707. Re: Createobject (repost)
  708. Re: Jim Rech's Browse for Folder
  709. Calculations in a pivot table data set
  710. Traversing two named rages of unequal length
  711. Project Name vs. Workbook Name
  712. Outlining works in XP not in 2000
  713. save as...
  714. Renaming VB Form Causes Macro Corruption
  715. Protecting an Excel Sheet name from being changed
  716. Difference b/w 2 worksheet
  717. Cell contents in Excel??
  718. Array formula with =sum
  719. Iterative Macro
  720. VBA Auto Cell Formatting Uppercase
  721. Copy image of UserForm to a clipboard
  722. VBA
  723. creating Databases and tables
  724. Percentage code
  725. Combobox Value
  726. Improvement to sub: Detect data extent and convert to values
  727. creat and transfer data sheet1 to sheet2
  728. Can not open excel workbooks from the file manager
  729. Importing cell info from closed workbooks into new spreadsheet
  730. right click menu reset?
  731. setting chart axes
  732. Using macro to add data in specific cell within a table
  733. FAO : Bob Flannagan
  734. Lookup / Vlookup ??
  735. Calculations in a pivot table data set
  736. Calculations in a pivot table data set
  737. using one macro to set a variable in another
  738. Save .txt file as .xls format - HOW??
  739. block scrolling
  740. check if worksheet is protected using code
  741. excel vba.........
  742. Returning Dates - Lead Times
  743. Returning Dates - Lead Times
  744. VBA to copy
  745. Macro to sort Worksheets
  746. Newbie Question: Returning the value from a cell on another sheet
  747. Filesearch with disregard of Case
  748. Starting with command
  749. Ask for help of Excel
  750. Super Easy Question -- "
  751. ActiveX Property Pages are not visible
  752. Property Pages from my ActiveX are not visible
  753. Increment array for debits and credits
  754. Coluring cells in a Range
  755. VBA - Drop down; list range
  756. Option Button Macro (Forms Toolbar)
  757. Moving Cursor once set number of characters are entered.
  758. Trying DROP TABLE in SQL from Excel
  759. Hyperlink
  760. Shrink Formula
  761. Pasting formulas without copying file ref.
  762. Color constants in VBA
  763. Help Me!!. can not set the string with len more than 255 character to the value cell
  764. Retain, restore selection?
  765. Question on Custom Sum Function
  766. loop
  767. 16 digit Credit Card #
  768. new to excel help me
  769. Re: Pivot Tables: counting columns and matching
  770. Range question in VB
  771. Find & Replace Macro from external spreadsheet/db?
  772. How to verify a cell is in a named range
  773. Error in code opening Outlook
  774. Deleting new control button on auto_close??
  775. counting device
  776. Loop expression to calculate return
  777. Naming a range versus formula in Excel
  778. Running a Command Button from a different sheet
  779. calculations in large data set and in pivot table
  780. Calling a sub with a variable...
  781. Swtiching the focus of Textboxes
  782. Workbook Open
  783. Database Query
  784. Re: minimum scale error code
  785. Rename Files
  786. Populating a cell with numbers without numbers being formula-based??
  787. Please help with vba code question
  788. Hiding the sheets my macro works with...
  789. Open pdf without converting
  790. Re: I want a msgbox when the contents of cell change
  791. How do I set a default path when using Application.GetOpenFilename
  792. Copy data from an external application into Excel
  793. Column question
  794. Internet printing problem using hyperlink from worksheet
  795. Wild Ideas
  796. How to check for password in an excel file.
  797. Why this 1004 Error message?
  798. Null?
  799. Data Validation
  800. Text Files
  801. Merging part of one field with another field
  802. Re: where is my record button?
  803. How do I add a Password?
  804. Modifying text files with VBA?
  805. converting architectural units
  806. Re: Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor???
  807. Totals
  808. Re: Click event unhiding sheet
  809. How do I set a default path when using Application.GetOpenFilename
  810. Office/Excel 2003 - Stop toolbars automatically opening
  811. Stacked Column VBA
  812. Numbers
  813. Re: Creating a custom toolbar in VBA
  814. Searching with Macros
  815. Excel VBA from Excel 97 to Excel 2000 errors
  816. Re: Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor???
  817. Testing for content in Range
  818. Dynamic range
  819. run time error 13
  820. Count Pages
  821. Netsend or another type command
  822. To: Bob Phillips
  823. Bold certain text in textbox
  824. Inserting a line....
  825. Excel Macro - Save Function Problem
  826. Sending multiple emails using SendMail
  827. =sum formula using arrays
  828. VBE Custom menuitem not calling OnAction macro
  829. Control Toolbox
  830. Formula to name tabs in excel worksheet
  831. Re: rounding a formula in a cell, then replace the formula
  832. Global vars
  833. Re: rounding a formula in a cell, then replace the formula
  834. Creating Buttons and assigning code
  835. Re: Selecting a Range inside a range
  836. labels, comboboxes, etc
  837. Non-contiguous selection
  838. DragAndDrop_event doesn't exist - any substitute?
  839. Looping through to stop on pie charts
  840. Compare Current Date
  841. Yes No dropdown box
  842. Delete duplicate cells
  843. Connection to notes
  844. Avoid user to access first two rows in a sheet
  845. Relative path
  846. Altering Textbox Colour
  847. Can anybody help please? Urgent
  848. Active Workbook Properties - comments
  849. Forms and sheetranges
  850. To: Dave Peterson
  851. Hosting XLS files within IE 6
  852. Re: Delete Duplicate Records
  853. Copy From Recordset
  854. Reference to a variable in windows(???).Activate
  855. Creating a worksheet with values based on a control cell
  856. How to make Excel feel switching application?
  857. change all instances of Queensland to QLD
  858. Variable Value
  859. Events and values and Ranges
  860. Re: Where do macros go?
  861. Error 1004 - Out of Memory
  862. Error 1004 - Out of Memory
  863. Auto refresh and DDE update is not work when running macro
  864. Is worksheet protected?
  865. Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet
  866. Header & Footer
  867. Re: Comparing rows of data in two worksheets
  868. Format of textbox on userform and correct result
  869. Using solver in macros - Help
  870. A simple question -- Evaluate()
  871. Re: Importing a text file using ftp
  872. Look for numbers in a cell
  873. Unable to add user-defined data types to a collection
  874. Data transfer macro
  875. Range and Cells
  876. Re: ? about the VBA code
  877. Re: "AND" statments in Excell 2000
  878. FileServer with GetOpenFilename
  879. Auto_Open and Workbook_Open
  880. Re: "AND" statments in Excell 2000
  881. Excel2000: How to copy data validation using VBA
  882. Re: OnAction menu item property coding
  883. Help Me! Exporting Excel 97 to Excel 2000/2002
  884. Calling macros from a VB app
  885. Exporting Excel 97 to Excel 2000/2002
  886. Re: PSW for Macro & Codes
  887. Spaces in sheet names
  888. keeping buttons from moving
  889. Hard Return in large textbox
  890. formulas in code error
  891. Re: page setup via code
  892. How do I Insert a row that includes copied formulas
  893. Color Code Duplicates
  894. Can I automatically populate my dropdown with all available macros
  895. Browse for folder
  896. Can I automatically populate my dropdown with all available macros
  897. Reading the contents of an inserted picture
  898. Paris Hilton has an Excel question
  899. Copying Macro to Several Workbooks Fast
  900. Remove all Listbox items
  901. selecting a row by header row in VBA
  902. Clear a textbox
  903. dates
  904. Newbie Post - Clear All Button
  905. Re: How To: Page Fields
  906. Automation COM Addin with Excel
  907. bizarre "invalid procedure call" error
  908. Index or Match?
  909. Re: Digital Signature issue in Excel files
  910. How to access Excel-Sheets from outside Excel ?
  911. Excel97 (w/ VBA) Template won't open in Excel2003
  912. Dropdown box of macros
  913. Function unable to return Collection object
  914. Re: Activating Worksheets and Importing Data from them
  915. Find
  916. True/False Checkboxes
  917. Applicaition Default File Path
  918. Embedding of graphs/charts in forms possible?
  919. Print to .csv file
  920. Help with creating Excel Macro
  921. How do I find out my row number
  922. Macro won't execute when "For Each 'range' in 'range'" is added
  923. Probelme with coding...
  924. sql querries
  925. Changing range name in loop
  926. Searching for specific text
  927. Controlling java applet
  928. Deleting entire rows based on certain criteria
  929. Compile Error
  930. Returning From VBA Event Code Called From Excel 4.0 Macro
  931. Re: Run-time Error '1004' Unable to get the findnext property...
  932. Re: OPEN WORKBOOK WHEN EXCEL OPENS
  933. Opening File Browser
  934. Error Checking Option
  935. Certificate Problem need solution
  936. Automatically print in Excel
  937. Excel 2003 / IE 6 bug closing workbook
  938. excel to powerpoint via macro
  939. VBA ?
  940. Need help with creating a special copy and paste macro
  941. Display set range
  942. Doing it's own thing - Jim R - Check here
  943. disable mulitple select on pivot page field
  944. Override error code 214154 - max embedding
  945. sql querries
  946. Building COM Add-in in XL2003
  947. Docking windows in the IDE
  948. Re: Disable Format Painter?
  949. Date/Time Picker Event Won't Fire
  950. Printer Dialog Box
  951. Save= False Question
  952. Zip workbook
  953. Excel Crashes When Copying Multiple Sheets in VBA
  954. Counting a range of cells based on 2 dates?
  955. Sum depending on cell background color
  956. Links from Word no longer updating
  957. Searching within excel
  958. Apllication.OnTime
  959. #NUM!
  960. Change and update contents of a dropdown combo ....
  961. Integration between VB and Excel
  962. Searching a column
  963. Find & replace with VBA
  964. Protecting VBA Project
  965. what is wrong with creating pivottable ?
  966. Deleting rows based on multiple criteria
  967. Excel200: Strange behaviour for Name when referred from VBA
  968. How to define a Range with variant?
  969. Protect/Unprotect function options
  970. UNDO in EXCEL97 macro
  971. Sheets Name into array for form dropdown
  972. Row Height for merged cells
  973. Macro to create worksheets base on name
  974. Dates
  975. creating a routine to help memorize
  976. Repost: ListBox Headings - customized! Class Module (warning: long post)"
  977. Analysis Services accelerator for Excel deployment
  978. Extra rows in csv file
  979. Multiple ComboBox Lists
  980. importing data from multiple excel spreadsheets
  981. From Excel to VBA and back?
  982. InputBox: Display Cell Content not Cell Ref ?
  983. Followhyperlink - How do I disable IE launch?
  984. An advanced email question.
  985. ADO & CopyFromRecordset performance
  986. Error handling
  987. save into file while user is entering values in cell
  988. Updating Access Database from Excel need help
  989. FORMATTING CELL CONTENT !
  990. Auto_Open and Workbook_Open in Addins
  991. Automatic Updating
  992. Macro link issue when saving as new filename.
  993. How do I solve this (Part II)
  994. Word Control in Excel
  995. Inserting Picture from Camera
  996. Capture Custom View in a Variable
  997. Attaching Custom Menus
  998. SaveAs works on one PC, not another. "Save" not really an option. What to do?
  999. Listbox 2
  1000. #N/A