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. Macro Toolbar Button
  2. How to use macro?
  3. "unexpected error" when running solver from a macro
  4. On entry
  5. screen updating
  6. Determining path to document template
  7. Function to display a cell containing an underlined number
  8. VBA Array Formulae
  9. Work sheet function -average
  10. Dynamic controls
  11. saveCopyAs
  12. problem Excel VB Macros
  13. Convert no. to time
  14. Worksheet_change Target Address is Reference Cell
  15. Word from Excel
  16. How to Rewrite these Code?
  17. Worksheet code if-color-statement
  18. Active printer
  19. Check File Name before Save Event
  20. Searching a range and copying values into a new range.... **Please help** :(
  21. change colour on value, 4+ colors
  22. Worksheet_change Target Address is Reference Cell
  23. Random Sorting
  24. Problem in setting Cell Interior Color filling.
  25. Using the sum function with a blank total
  26. Hox to control Comment Shape Sizes?
  27. VB vs VBA ??
  28. Worksheet_change Target Address is Reference Cell
  29. Copying Worksheets
  30. ComboBox, referring to content
  31. html markup to add comments to excel cell
  32. Copying Worksheets
  33. password protecting macros
  34. Query on the Use of Absolute References
  35. Add-In
  36. How to cycle through a series of similar objects with a for-next loop?
  37. Date
  38. Search and Replace With Formatted Text
  39. How to Rewrite these Code?
  40. Access to Excel Automation ADODB Problem
  41. VB Programming, trying to save as lower version
  42. Excell FileOPenDialog from another App, and listbox multiselect problems
  43. how can i retieve stock data in an excel worksheet?
  44. Defined Name
  45. Open all files question
  46. How to Rewrite these Code?
  47. Query Automatic Refresh
  48. Edit Excel TextBox using C#
  49. Combine .textorproperty and select case
  50. Use variable across workbooks
  51. Using rng.Value & RefersToRange to pass data between worksheets - SLOW!
  52. Error# 11004, Unable to set the property error
  53. XP activesheet.paste error on VMware servers
  54. Prevent control & break
  55. How to Rewrite these Code?
  56. reference to a cell within a string
  57. Re: OptionButton
  58. placing formula in cells
  59. Finding an underlined character among several characters in a cell
  60. Union across multible worksheets
  61. Autofilling from one sheet to another
  62. Delete row macro/VB
  63. Copying files in VB
  64. Find, Copy, Paste Into Different Workbooks
  65. MDX Query
  66. textbox not updating when controlsource cell changes
  67. File created with VB is hidden
  68. Re: OptionButton
  69. Windows message text font
  70. Paste Problem
  71. Sheet Formatting
  72. Comment Font Size
  73. Calendar Control
  74. Preserve Formatting crashing excel
  75. sugestions
  76. Combo Boxes and Tick Boxes
  77. Run Macro
  78. pastespecial
  79. conditional formatting
  80. Please, help! Anyone? ImageCombo’s BorderStyle OR images to ComboB
  81. Beginner programmer problem
  82. get cell's print sheet number
  83. HELP, dont know how to describe this in a subject line
  84. Adding a table to an excel form
  85. unique values
  86. web query data post to ASP
  87. Listbox Properties totally blank
  88. Worksheet_Change procedure question
  89. Value translation
  90. how to remove double quotes?
  91. Data Consolidation
  92. no puedo
  93. email shortcut to active workbook as an outlook attachment
  94. change Company property
  95. protect add-in after workbook closes
  96. Import and run Macro
  97. aligning a form on the screen
  98. Need a Special Sort Routine
  99. If Then to Add Row
  100. check to see if sheet exists
  101. Passing a string aray as an argument to a function ?....Help!
  102. Using the VLOOKUP function
  103. help with vba please
  104. Page Headings
  105. vba to count
  106. The equivalence of EQUIVALENCE
  107. File Open Dialog
  108. Changing Default Module Location
  109. help with vba please
  110. multiple sheets into 1 pivot table
  111. Find data in Column D, add L in Column A
  112. User Defined Functions
  113. Mouse Position
  114. "unexpected error" when running solver from a macro
  115. Visual Basic for Dummies
  116. Generating content on the spreadsheet from an Add-on issue
  117. token/type count?
  118. change colour on value, 4+ colors
  119. copy and paste
  120. coding question
  121. Code to add today's date in subject line VBA
  122. Programming A formula
  123. Formula help please
  124. Check File Name before Save Event
  125. Who has read/write
  126. Worksheet activating
  127. controll and skip duplicate...
  128. Special printing
  129. Execution speed for UDF
  130. Help with macro!!
  131. Check boxes
  132. User defined functions
  133. Excel causing exception error upon opening the document
  134. Excel causing exception error upon opening the document
  135. Programming A formula
  136. Macro buttons disappear when I print
  137. select method of range class failed
  138. Find Command
  139. Please, help! Changing ImageCombo’s appearance or alternative. Tha
  140. Need help with file opening formula
  141. Worksheet activating
  142. Populating column N where is is blank or null
  143. Passing Solver a Macro
  144. Comparing cell values
  145. Sort Routine VBA
  146. Ron, Send Mail, Desperate
  147. Shade a region in a X-Y plot!
  148. Event class doesn't fire in embedded VBA
  149. Pivot Table help
  150. Help with Array compare
  151. Problem with post-style web query
  152. Common Controls Color Dialog Box ...
  153. Default File Path
  154. Excel, VSS & VBA ... = problems
  155. MFC Automation
  156. Saving an array
  157. Add file name somewhere in worksheet?
  158. select method of range class failed
  159. Reverse link ComboBox?
  160. Creating a Function
  161. Run an excel macro when a cell value is changed
  162. Use "Data Validation" after data are entered
  163. Stopping the screen drawing
  164. Stopping the screen drawing
  165. Seeking example code
  166. select method of range class failed
  167. take Active Sheetname
  168. stubborn macro
  169. Macro to select Quantity Printing
  170. Clearing Clipboard
  171. Modeless for in Windows XP
  172. Jump to next sheet if not found
  173. Spell Check Within a UserForm?
  174. Stop until Calculationstate = xldone
  175. VBA to "answer" spesific msg box
  176. Data Consolidation
  177. Excel Print Macro
  178. Excel Print Macro
  179. Unprotect and protect sheet in a macro
  180. Retrieve File Name before its saves
  181. Unable to use the function Left in VBA
  182. Populating column N with a formula if column A is Null or Blank
  183. Spell Check Within a UserForm?
  184. Prevent Particular File Name during Save
  185. XL2002 / XP : Crashing problem
  186. Compile Error
  187. Private Sub Worksheet_Activate()
  188. sendkey problem
  189. CopyFromRecordset method
  190. Stop until Calculationstate = xldone
  191. Excel and MapPoint
  192. Calculating and copying data into new sheet
  193. Compare 2 cells in 2 worksheets, rewrite one of the cells
  194. Jump to next sheet if not found
  195. looking for autofilter with code
  196. Public variables and separate library files
  197. Worksheet events - when are they triggered!
  198. XP activesheet.paste error on VMware servers
  199. How can i write TSR code
  200. DBL click over an excel file
  201. Range.delete method
  202. How to password protect several excel workbook pages using a macro
  203. date range vba code
  204. The TEXT function in Excel 2000 VBA
  205. Put file name in column
  206. The TEXT function in Excel VBA 2000
  207. Transparent user form
  208. Command Button OnClick
  209. Print Excel Form In Landscape Mode?
  210. VBA (or other) worksheet function parameter insight
  211. Store text file in workbook?
  212. conditional copy data from workbook to another workbook
  213. Parse database into several files based on column D
  214. Help with OnTIme Event Issue
  215. How to create a macro
  216. Removing (trading) an item in a listbox
  217. Excel Query
  218. Save a Range of Cells as Gif???
  219. If, Then, Cut, Paste, Delete HELP
  220. Help with code
  221. Test if Active Cell is in a named range
  222. Colour shade an area in an Excel graph!
  223. Add-in toolbars
  224. FR - Reprendre le format d'une cellule
  225. Need Help
  226. Find and Delete Blank Cells Formatted as Text
  227. need help in writing a statement
  228. How to deal with an error question
  229. Shade a region in a X-Y plot!
  230. Using a VB.Net interface to turn excel spreadsheets into a working
  231. Finding Real Worksheet Name After Access Export
  232. Using a user form in various workbooks
  233. Urgent - Pl help code for assigning a shape to cells
  234. AutoFilter and copy
  235. Stop message to UnProtect
  236. Re: ListBox filter
  237. HELP, dont know how to describe this in a subject line
  238. conditional formatting & a loop
  239. VBA code not working...
  240. Counters
  241. please help simplify
  242. add worksheets
  243. Excel causing exception error upon opening the document
  244. Remove duplicate rows and sum cells
  245. Runs fast then slow
  246. Hyperlinks in Excel
  247. listbox question
  248. Vlookup in Multiple columns
  249. Clipboards Overloaded?
  250. Data Consolidation
  251. Macro to list files
  252. Removing references
  253. Move worksheet
  254. Calculating and copying data into new sheet
  255. Calculation bug or is it me
  256. exit sub after insert row
  257. Delete Filtered Rows - without deleting column headings
  258. How do I code a "self-destruct" triggered after a certain date?
  259. Calculating and copying data into new sheet
  260. Changing button appearance on custom toolbar.
  261. Re: for next loop not working
  262. Conditionally Delete Cells From Named Range
  263. Macro programming
  264. Converting Excel Formula to Macro
  265. Linking graphs with macro
  266. worksheetfunction
  267. Calculating and copying data into new sheet
  268. Pivot table help needed
  269. storing / appyling pivot chart formatting
  270. Duplicate value with blank space
  271. Export to MS Project
  272. Entering static Date/Time
  273. OLEDB Help Excel 2002
  274. Macro to activate all cells in a range
  275. Calculating and copying data into new sheet
  276. Entering static Date/Time
  277. Variables From TextBoxes
  278. please help simplify
  279. Entering static Date/Time
  280. Spreadsheet web component
  281. How do I automatically change currency depending on another cell .
  282. Setting cell borders
  283. File Path Macro
  284. Restrict Sort on a Particular Sheet
  285. Using a macro to populate a cell with a formula
  286. Dick K - Move e-mail to different folder
  287. An 'event' of zero activity?
  288. Hyperlinks
  289. Automating the summing of columns
  290. Error Message "Formula is too long"
  291. Calculating and copying data into new sheet
  292. Link to Pivot Table with specific page value
  293. Series Collection Points
  294. Remove Userform Deactivate Button
  295. How do Macro to EDIT cells?
  296. Redraw Application Window
  297. Expected:= ???
  298. Expected:= ???
  299. graph
  300. Is this possible ?
  301. [VBA]Inserted value does not get formatted
  302. Collection does not work with strings?
  303. Sub, not function!
  304. Sub, not function!
  305. Sub, not function!
  306. Options
  307. Hyperlink TexttoDisplay
  308. advanced summing
  309. Delete rows from activecell
  310. paste as device indep. bmp in powerpoint
  311. excel truncating leading zeros
  312. ActiveSheet.Protect
  313. Is it possible to automatically run a macro upon a spreadsheet
  314. Save Macro
  315. Copying Worksheets
  316. How to insert an address from Outlook 2003 address book ?
  317. Problems with auto_open
  318. Save a Range of Cells as Gif???
  319. Create a menu to List the Name of worksheets in a Workbook
  320. Sub, not function!
  321. Spaced out
  322. Can it be Done ??
  323. Data (entry) form - expose properties?
  324. fileformat not working with Object
  325. error!
  326. Macro within a Macro help
  327. error!
  328. Sorry for the vague question
  329. RE: Replacing cells that have 2-3 letters: Sorry for the vague question
  330. Replacing cells that have 2-3 letters
  331. activating the cancel button on Input boxes
  332. ClearContents not clearing :(
  333. Replacing cells that have 2-3 letters
  334. Accessing VBProject Property
  335. ClearContents not clearing :(
  336. Convert Cell References in Formula to Values
  337. List Data to Single String
  338. Suspending MAcros
  339. ClearContents not clearing :(
  340. Returning actual page field changed in pivottable
  341. returning pivottable object from a range object
  342. interest rate when compounded daily for 5 years
  343. Finding Values Too Slow
  344. Stop 'Disable Macros'
  345. Move a row to the centre of my sheet Excel 2002
  346. Assigning a shape to cell
  347. Simple Macro - I Think?
  348. Need Help with a Menu Item .OnAction property
  349. Excel97 Userform to be system modal/equivalent
  350. Date Problem
  351. Sloooow loop
  352. Copying Temp List to cell
  353. Writing a .txt file
  354. HELP, dont know how to describe this in a subject line
  355. How are Marco Stoaged
  356. Bank Formula for CD that is compounded daily for five years
  357. HELP, dont know how to describe this in a subject line
  358. UBound not in Intellisense. References problem?
  359. identify the name of the activecell not its address
  360. Error on printing
  361. Excel case
  362. Clearing DropDown Lists & Removing External Links
  363. Looping through text boxes
  364. Excel case
  365. Retrieving data
  366. inserting a date in a form
  367. Re: Calling subs from different workbooks
  368. workbook_open
  369. keeping track of a range of cells in another spreadsheet or access database
  370. Late binding with VBIDE
  371. OnAction procedure
  372. web queries
  373. Excel case
  374. Cutting Data from cells changes Cell Formatting
  375. VBA Security
  376. Excel - Protection
  377. referenced file
  378. Inserting Picture into protected Sheet
  379. Looping through text boxes
  380. Looping through text boxes
  381. saving files
  382. Ant ideas?
  383. Close a userform
  384. Creating my own undo
  385. Showing a calculated Date as a string
  386. Please help me with this email from excel
  387. How do I hide an Excel module or macro from other users
  388. Sort & Subtotalling isn't working?
  389. Extracting Data from CSV files
  390. all chr()
  391. MArgin in printform
  392. Alphabatizing Combo Boxes
  393. Macro that copies range to new sheet
  394. setting Select (Un)Locked Cells in Worksheet Protection
  395. Need macro to set duplex option
  396. Looping through text boxes
  397. Comparing Two Columns?
  398. Ant ideas?
  399. Can't get userinterface variant to work on mac.
  400. UserInterfaceOnly on the Mac
  401. How do I set up an Excel file to save automatically and give a fi.
  402. Run time Error 1004
  403. Re: Formatting code for a spreadsheet
  404. Excel should calculate and display numbers properly, but doesn't.
  405. Interdependent flow scheduling
  406. Shapes question
  407. Runtime error 13 type mismatch ?
  408. CheckBox1_Click()
  409. Runtime error 13 type mismatch ?
  410. Runtime error 13 type mismatch ?
  411. hr,min,sec
  412. Range objects in a collection
  413. VBA Help Problems
  414. Runtime error 13 type mismatch ?
  415. UserInterfaceOnly on the Mac
  416. Extracting Data from CSV files
  417. Moving Code
  418. Football Predictions Spreadsheet formula problem
  419. Runtime error 13 type mismatch ?
  420. commandbuttons on worksheet move to the left
  421. Macro or excelfunctions
  422. Looping through text boxes
  423. Email
  424. Username
  425. Copying multiline textboxes from userform to worksheet cell
  426. remove excel-icon
  427. Header Row 1 is displayed in split screen - Way to keep
  428. Copy values to multiple destinations
  429. Outlook vs Outlook Express
  430. OnTime function
  431. HELP, dont know how to describe this in a subject line
  432. reading data from com port into excel spreadsheet
  433. Email from Excel
  434. macro help
  435. Newbie needs help with if statement
  436. HELP, dont know how to describe this in a subject line
  437. Newbie needs help with if statement
  438. Extending Named Ranges
  439. HELP, dont know how to describe this in a subject line
  440. Looking for a way to run a macro when the workbook is opened
  441. Re: for next loop not working
  442. 2 things
  443. Windows XP default path for temp file
  444. HELP, dont know how to describe this in a subject line
  445. using the Find method in a VBA macro
  446. last cell on row
  447. Assign macro to toolbar custom button?
  448. Splitting cell contents
  449. Supress certain 'cells in Pivot Table
  450. Summing loop for multiple worksheets
  451. removing duplicate rows
  452. ?Application.Evaluate("max(len(A1:X20))")
  453. Range question
  454. Converting Excel Formula to Macro
  455. data feed text delimited
  456. Tom Ogilvy or anyone that can help
  457. Help with macro!!
  458. Conditional Formating of cells based on value in another cell
  459. update links (ignore previous post same title)
  460. Link updating
  461. VBA Excel - changing series source.
  462. VBA Excel - changing series source.
  463. Opening a workbook if not opened, going to it if already opened
  464. How could it be?
  465. Inserting Picture into protected Sheet
  466. Excel replace text.
  467. change event procedure
  468. Problem with .CreateField in DAO
  469. Checking if value is a number
  470. Re: wait for user action in VBA code
  471. Count of results in AutoFilter
  472. prevent duplicate results (database query)
  473. How maximize open excel workbook
  474. Re: Checking if integer
  475. ListBox selection
  476. Checking if integer
  477. How can I do this?
  478. Re: Calling a procedure in a protected VBA Addin Project
  479. Mission Impossible
  480. Excel replace text.
  481. need help
  482. Dynamically setting Print Area
  483. On error End Sub
  484. Opening a workbook if not opened, going to it if already opened
  485. What's Wrong?
  486. Re: copy to another wb and name the target sheet (XL2000)
  487. Newbie question: function call
  488. Userform List Boxes Load Very Slowly
  489. Summing Cells with a BLUE font (or any other color)
  490. Error - End If Without Block
  491. RE: Looping through Sheets
  492. RE: Looping through Sheets
  493. It worked!
  494. It worked!
  495. Programmatically detect a syntax error in a macro?
  496. Re: column hint
  497. Re: Trapping Insert Row
  498. Opening a workbook if not opened, going to it if already opened
  499. Re: sumif question 2
  500. Re: Find Command
  501. Excel replace text.
  502. sorting code problems
  503. quick question on a checkbox
  504. sorting code problems
  505. Filename changes daily, anyway to link to most recent file
  506. sorting code problems
  507. Userform data to Excel sheet.
  508. RefreshTable vs PivotCache.Refresh
  509. Value of a cell
  510. XL remoting issue...
  511. ListBox drag & drop
  512. sumif question
  513. Why "Worksheet_Change" dont work under DDE link?
  514. how to delete cells without shifting and rows/columns
  515. Find Command
  516. RE: Why doesn't this work?
  517. keeping rows together after query
  518. look up
  519. DISABLE CLOSE MSGBOX ON CLICK "X"
  520. sorting code problems
  521. number ZERO in a cell
  522. Adding TextBox to UserForm via code
  523. Moving a range to end of list
  524. quick question on a checkbox
  525. Macro to save as using two cell values inside worksheet
  526. Inputbox "choose password"
  527. Add a column to a selection
  528. sorting code problems
  529. Excel2003 and xlListSeparator...
  530. Master to Report Tabs
  531. find open workbooks
  532. Serious Crashing Problems in Excel 2002
  533. Delete Empty Rows
  534. copy to another wb and name the target sheet (XL2000)
  535. can you hide macro code??
  536. VBA Error Message
  537. help with rowsource
  538. Removing item from combobox with vba
  539. sorting code problems
  540. VBA and FormulaArray Runtime Err <is not more than 255 Char>
  541. carraige return within a cell & capitalization
  542. Macro protection
  543. Removing item from combobox with vba
  544. Remove .xls from selected files
  545. Data from listbox to Excel sheet
  546. disable or hide the close window icon 'X' in the corner of a userform
  547. Removing item from combobox with vba
  548. Minimum route from two nodes
  549. Can you get a Merged Cell with Text Wrap to Autofit?
  550. copy only from a cell with data in it
  551. Can you get a Merged Cell with Text Wrap to Autofit?
  552. Minimum route from two nodes
  553. Minimum route from two nodes
  554. Disable Right click
  555. Run code after entry
  556. Insert a line in word from excel
  557. Conditional Formatting adjacent cells
  558. How to go to a predetermined sheet on opening
  559. Userforms/Macro search
  560. looking for autofilter with code
  561. Email Excel File Automatically using Outlook 2000
  562. Serious Crashing Problems in Excel 2002
  563. row reference from selection
  564. Looking in 1 list and copying from another lfile
  565. IF referance multiple criteria Formula Help
  566. open workbook
  567. Add Menu to a VBA Form
  568. Enter a "checkmark" in an AutoFiltered cell
  569. Need help please
  570. Re: VB solver
  571. VBA help file not found.
  572. Help! Overflow Error 6
  573. copy only from a cell with data in it
  574. open workbook
  575. transfer data in listbox
  576. To include Depot
  577. To include Depot
  578. data entry with userform questions
  579. Unprotect via prompt
  580. Word VBA Code to Excel Code
  581. Apply Macro on Multiple Worksheets in a Workbook
  582. validate a directory or file exits
  583. looking for autofilter with code
  584. Call from a Main program
  585. prompts for the user defined functions
  586. copy only from a cell with data in it
  587. Check for any data changes in a form with multipage object
  588. SUMIF
  589. In Excel 2000 can you write VBA code to pull data from a webpage?
  590. In Excel 2000 can you write VBA code to pull data from a webpage?
  591. Gross Faults/Errors With Put and Get
  592. Change from Numeric to Alpha
  593. Scanning Text files for specific words
  594. Call up Powerpoint using Excel 2002
  595. find command using variables
  596. Error with Activecell.paste
  597. How do I get my Excel to act normal?
  598. Need xlodbc.xla in Excel 2003
  599. Worksheet change sub procedure
  600. Pl help - Graphical Indicators in Excel reports
  601. What are the cells in a Pivot Table range?
  602. help with choosing and calculating time data
  603. Executing sub procedure when Excel starts
  604. Selecting Last Worksheet
  605. help writing macro
  606. Pivot Table from VBA or VB6 - Field Settings
  607. Why does sort always default to include a header row. I want the.
  608. Max worksheet exent width
  609. Info Only: Formula Freeze Module
  610. How do you Sum the range of two lookup values?
  611. cell ref w/ varaibiles
  612. Master to Report Tabs
  613. web query
  614. Iterating through Page Fields of a Pivot Table
  615. how can I write ascii code in Excel?
  616. Initiating a macro from a control button
  617. validation date
  618. Recommended Read-Only Property
  619. position mouse cursor in msg box
  620. Web page
  621. RE: External Queries - Excel 2000
  622. Printing PDF from Excel Error
  623. Enter Key
  624. xls filename with a number in brackets
  625. Waiting for OLE action
  626. VBA auto fill problems
  627. Import Access records to excel (parameter is a called funct) v.20
  628. custom menu bar doesn't work
  629. blank rows macro question
  630. Late Binding help, Please
  631. select populated cells
  632. help with code!
  633. Choose several sheets in VBA
  634. Data Validation Question
  635. Templates
  636. Collapse Dialog Box
  637. View previous cell value programmically
  638. Export Entire Excel Sheet with headers, footers, etc, to Word
  639. Replace conditional formatting to use 4 conditions
  640. View previous cell value programmically
  641. How do I define the same name to a number of different worksheets.
  642. Object Name
  643. Object Name
  644. Userforms/Macro Search
  645. insert lines into CODEMODULE gives error
  646. Object Name
  647. Rotating a Table
  648. Can't seem to create a Pivot Table with VBA ?
  649. Apply Macro on Multiple Worksheets in a Workbook
  650. help! code for a cell
  651. Object Name
  652. How do I resize a named array in Excel from a MxN array to a mxn .
  653. Copying files from PC to PC
  654. Date selection loop
  655. Macro to Search and Replace
  656. Validation
  657. Help Please! Macro Error on Select Worksheet
  658. Help! Animated gif-image in form does not show animation when form loaded
  659. Help please! Animated gif does not show animation when form displa
  660. Excel Copy/Search/Paste Help Needed ASAP!
  661. Validation data
  662. Wild Card Path
  663. increase the size of a worksheet
  664. Serious Crashing Problems in Excel 2002
  665. Excel should let me change format of the cell when it contains for
  666. How do I automaticaly update the current day's date each day?
  667. copy Excel worksheets into one text file
  668. Moving a range to end of list
  669. viewing code
  670. Copying meaningful data only into new worksheet - VBA
  671. vba routine in Excel 2002 to create varying size email in Outlook
  672. RE: OWC version control
  673. Need help with loop to import data
  674. Re: Master to Report Tabs
  675. Master to Report Tabs
  676. Need help with loop to import data
  677. Date.
  678. Macro's Flicker
  679. 2,560 cell limit???
  680. Save & Install AddIn with VBA
  681. Need some help
  682. count the number of times a value updates in excel?
  683. VBQ and macros executable in Pocket Excel
  684. validate phone number
  685. Sorting data automatically
  686. combine two records
  687. Save CSV File without prompting
  688. Simple Paste Question
  689. Deleting columns based upon the value that appears in column A
  690. UserForm code help needed.
  691. VB Is a workbook open
  692. Visible Property Pivot Item
  693. Userform to be always on top of all Applications?
  694. Remove reference from code
  695. PivotTables/VBA
  696. Convert -1 and 1 formula
  697. UserForm code help needed.
  698. Error loading DLL
  699. preventing use of F9 (recalculate)
  700. If Statement based on Alpha or Numeric
  701. Change the properties of a non selected cell?
  702. Looking up two conditions
  703. Pivot Table problem
  704. VBA - Insert new sheet as the last sheet
  705. Vlookup on named range
  706. 10% Match
  707. Copying spreadsheet data to WORD
  708. some final help
  709. VBA - Insert new sheet as the last sheet
  710. preventing use of F9 (recalculate)
  711. simplification problem (only for expert!)
  712. timer
  713. Deleting columns based upon the value that appears in ROW A
  714. Automatically Add Foorter with full filename in Excel
  715. communication with MS Project
  716. Activex control security message
  717. Sorting data automatically
  718. color index
  719. Caption
  720. finding a cell
  721. UserForm code help needed.
  722. Re: Extract a table from Crystal Reports into EXCEL
  723. Adjacent Cell Value Theorem Help
  724. finding a cell
  725. Using defined names in VBA...
  726. Using Excel softwware to draw construction mappings
  727. VBA Help
  728. Using a variable file name
  729. vlookup
  730. determine row reference from button
  731. Sarbanes Oxley 404
  732. RE: fill randomly cells that verify contion
  733. Setting WEEKDAY function to Exclude Friday in Calculation
  734. vlookup
  735. Copy visible rows with data to new file
  736. Ignore Blanks
  737. Change Form Size after Click
  738. New Workbook
  739. getting value of range problem
  740. Unprotect via prompt
  741. fill cells, merge cells
  742. fill down to next change in value
  743. texttospeech
  744. texttospeech
  745. excel formulas to count and sum
  746. Re: datalabels collection crashes Excel 2003
  747. mismatch error in returning concatonation of numbers and characters
  748. Incorrect code...
  749. copy only from a cell with data in it
  750. fill cells, merge cells
  751. Draw Buttons
  752. Calculate the time difference in minutes
  753. check if item exist in olap cube
  754. mismatch error in returning concatonation of numbers and characters
  755. Selecting Sheet1 by index rather than sheet name
  756. Apply Macro on Multiple Worksheets in a Workbook
  757. looking for autofilter with code
  758. Hide font in formula
  759. How do you round to 0.5 in excel
  760. Test if Sheet Exists - Tom Ogilvy
  761. Row # of active cell
  762. Writing strings to a text file ?
  763. Apply Macro on Multiple Worksheets in a Workbook
  764. Open File Read Only
  765. Help with VBA
  766. To their respective sheet.
  767. VBA Code to identify contents of a cell
  768. Re: how do you combine worksheets
  769. automate sending graph/pivot report in body of email
  770. how do you combine worksheets
  771. Path to a dll as a variable
  772. RE: Find method
  773. RE: Why doesn't this work?
  774. ? for Ron de Bruin
  775. Conditional Formatting
  776. Re: Find method
  777. Selecting a worksheet from a macro in a different workbook
  778. RE: Find method
  779. Why doesn't this work?
  780. Re: Find method
  781. Password window popping up when saving
  782. Find method
  783. Why doesn't this work?
  784. RE: Run Array.. run array... (Which to use?)
  785. DSN UserId and Password Prompt
  786. Control Deletion of Range Names
  787. Task Scheduler
  788. Creating connection documents
  789. Conditional formatting
  790. Re: Workbooks.Open(URL)
  791. RE: VBscript
  792. Cell selection code
  793. Workbooks.Open(URL)
  794. Properties information
  795. VBscript
  796. blank rows macro question
  797. Userform text box query??
  798. OnTime problem.
  799. OWC version control
  800. Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook
  801. Return MS-SQL database names to excel?
  802. Function not visible
  803. Re: How do I show number of hours as a negative using formula?
  804. blank rows macro question
  805. Re: Absolute cell references
  806. RE: Run Array.. run array... (Which to use?)
  807. Re: Application.Match problem
  808. Date question over 3 years
  809. Is it possible to update XMLMap's schema?
  810. Re: Run Array.. run array... (Which to use?)
  811. RE: Creating References To Excel Objects
  812. DSN UserId and Password Prompt
  813. Timestamp from Outlook
  814. VBA calculate manually
  815. Re: Auto Fill Option button
  816. Comment créer un TreeView dans une Toolbar Excel ?
  817. Application.Match problem
  818. Run Array.. run array... (Which to use?)
  819. a challange for the "real" programmers
  820. Deactivating Insert/Delete Row/Column
  821. fill randomly cells that verify contion
  822. Auto Fill Option button
  823. Workbook Open Event
  824. macros create temp files
  825. Error Handling driving me crazy. Please help
  826. Creating References To Excel Objects
  827. How Do I Make multiple Pie Charts
  828. Trim function in VBA
  829. Saving question
  830. Moving a range to end of list
  831. Display Clipboard in Excel
  832. Need some help
  833. Inserting 10 Rows
  834. Error in Excel 97 when running Excel 2000 macro
  835. Creating connection documents
  836. distributing xl with vba code - how to know what's needed
  837. RE: Absolute cell references
  838. How do I show number of hours as a negative using formula?
  839. Absolute cell references
  840. Why this don't work
  841. Getting a Proxy Class into VBA
  842. How do I show number of hours as a negative using formula?
  843. VB UserDocument on Excel sheet
  844. Updating High/Low Values from a set of streaming data
  845. Help in saving a formula.
  846. How do I get rid of my form from the screen?
  847. Multiple criteria Filesearch function
  848. timer
  849. Moving Columns only
  850. UserForm code help needed.
  851. list date in the form and vlookup
  852. That "out of memory" error
  853. RE: Extract a table from Crystal Reports into EXCEL
  854. Error in Excel 97 when running Excel 2000 macro
  855. code to convert date from TEXT format (03-02) to DATE format (200203)
  856. copy range on every worksheet (diff names) to a master worksheet (to be created)
  857. Error in Excel 97 when running Excel 2000 macro
  858. Re: Exporting excel worksheet to access table
  859. VLookup Not Picking Up Entire Phrase
  860. Re: Userform text box query??
  861. VBA coding
  862. Re: AutoFill of empty cells
  863. Userform text box query??
  864. Multiple criteria Filesearch function
  865. OnTime problem.
  866. VB message
  867. Protected cells
  868. Subscript Out of Range
  869. stopping an excel application from vb 6.0
  870. copy range on every worksheet (diff names) to a master worksheet (to be created)
  871. Error in Excel 97 when running Excel 2000 macro
  872. AutoFill of empty cells
  873. Add a category to the Insert-Function category list
  874. Group Dates with Code
  875. Re: What is the Visual Basic command to select an entire row in Excel.
  876. Re: What is the Visual Basic command to select an entire row in Excel.
  877. Re: What is the Visual Basic command to select an entire row in Excel.
  878. Re: What is the Visual Basic command to select an entire row in Excel.
  879. Re: Cannot Query MDB!
  880. Re: What is the Visual Basic command to select an entire row in Excel.
  881. Re: Task Scheduler
  882. What is the Visual Basic command to select an entire row in Excel.
  883. How to change worksheet direction
  884. Chart properties
  885. Conditional Formatting
  886. Excel - using VBA
  887. Showing built in dialogue boxes
  888. Re: Pick Lists
  889. looking for autofilter with code
  890. error message
  891. VB command in the "Control" file
  892. RE: Pick Lists
  893. Fine tuning if statement....
  894. Re: insert page breaks
  895. Pick Lists
  896. random number generation
  897. What are ....
  898. Pivot table doubt
  899. Date in Pivot table
  900. insert page breaks
  901. How to creating certificate for the compagny only
  902. Control Deletion of Range Names
  903. Numeric data being ignored
  904. Excel 2000 - Files corrupt after saving via VBA
  905. ActiveChart.ADD Fails
  906. fill cells, merge cells
  907. auto open text files
  908. copying and renaming a worksheet
  909. Re: debug
  910. how to copy entire row into next row
  911. How to copy entire row into next row by macro
  912. RE: Print problem
  913. Need some basic help
  914. Deactivating Insert /Delete Row/Column
  915. debug
  916. macros and pivot tables... help please!
  917. Working with Pivot Tables in VBA
  918. Help: VBA macro for worksheet formatting
  919. Hide font in formula
  920. User form upon opening
  921. Add click event with code
  922. Draw Buttons
  923. excel office web components
  924. Hide font in formula
  925. Excel 2002 closing by itself???
  926. Opening Multiple Workbooks
  927. How can you create a Pivot Table using vbscript
  928. Error Handling with Nested Loops
  929. Custom Function on Personal.xls
  930. VBA Help File search not working
  931. Re: calculate weekdays only
  932. Find cell and paste data
  933. Plotted data changes in XY Plot if first cell is in X data is blan
  934. find a path
  935. Simple Macro - I Think?
  936. Nudging controls in UserForm Design Mode
  937. image edit control
  938. Re: calculate weekdays only
  939. Re: Print problem
  940. Re: Sorting with Drop-Down Menus
  941. RE: Print problem
  942. Building an Array
  943. How can one test against merged cells in VB.NET?
  944. Sorting with Drop-Down Menus
  945. Cannot Query MDB!
  946. Re: HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
  947. Re: 1st line is the header, how do I have it print as the first line
  948. calculate weekdays only
  949. XL2003 "paste method of worksheet class failed"
  950. Re: calculate weekdays only
  951. Missing Data in a Range
  952. Re: HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
  953. Re: 1st line is the header, how do I have it print as the first line
  954. HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
  955. 1st line is the header, how do I have it print as the first line
  956. GetSaveAs Method
  957. Searching for keywords
  958. Preserve formatting setting in VBA crashing Excel
  959. Problem coding a Sort
  960. VB error message
  961. Cycle through a folder of excel files
  962. calculate weekdays only
  963. Sending e-mail - Ron, you still there?
  964. Re: Custom Views based on sheet name
  965. X bar chart in Excel
  966. Comparing two lists
  967. Custom Views based on sheet name
  968. Check to see if sheet exists
  969. Re: Trying To Store Shapes/Objects to an array ??
  970. Parse Data - Bernie
  971. Form Error & Q's
  972. Underline font not reporting properly
  973. Importing data
  974. export/import excel data to word doc. properties
  975. Re: Excel Freezes
  976. Trying To Store Shapes/Objects to an array ??
  977. Print problem
  978. e-mail links follow up T.Ogivly
  979. Variabel and caption in userform
  980. RE: Variabel and caption in userform
  981. VBA deleting Macro
  982. Need to make this simpler.
  983. Re: Variabel and caption in userform
  984. Macro help
  985. Variabel and caption in userform
  986. e-mail links
  987. Task Scheduler
  988. RE: Exponential Growth
  989. RE: Exponential Growth
  990. de-select range in other workbook?
  991. Re: =Why AddIns.Installed can be out of range=
  992. CSV Excel 2000
  993. RE: Code instead of foumula.
  994. RE: Please help me with this error
  995. Enter simulation-related HLOOKUP formula in cells
  996. Re: How do you sum values in a coloumn when it contains #N/A in a ran.
  997. Please help me with this error
  998. Re: Can I use ISERROR with VLOOKUP function?
  999. Re: Update SQL db directly from Excel
  1000. =Why AddIns.Installed can be out of range=