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. insert rows
  2. Macro to increase cell value by 1 each time button clicked
  3. Buttons
  4. msgbox
  5. Creating a CommandBar - what's wrong?
  6. URGENT!! macro for moving data to different spreadsheet
  7. Finish this sentence
  8. Break monitoring workbook
  9. Userform - Populate Listbox2 based on selection in Listbox1
  10. List Box and Fonts
  11. Range.Select
  12. If statement in Auto_Open
  13. Got code?
  14. Protecting and Locking a Mail Merge List
  15. Automatically saving an Excel spreadsheet with today's date in the filename
  16. Border style of Excel forms
  17. Conditional cell reference
  18. Error 2015 from ConvertFormula
  19. Protected Workbook
  20. Date formatting
  21. Addition to code
  22. Re: Setting Toolbar height & width
  23. List Fill Range Property
  24. Having problems clearing a row.
  25. bullets
  26. Changing page orientation with pagesetup
  27. Wild card in if then statements
  28. Print Screen
  29. Multi-row data to single line data
  30. Error Trapping Options Change in Excel 1997
  31. Worksheet_Change problem
  32. Multiple If Formula
  33. Used Range
  34. Re: cant stop OnTime initiated macro, etc
  35. Updating VBA Modules and Forms in User Workbooks
  36. combobox exit event
  37. clinka32.dll
  38. Slow operation
  39. duplicate a user form?
  40. Minimize Excel When Running a Macro
  41. Selection object in Excel 2002
  42. drop down boxes and if then statements
  43. Code Reference Problem
  44. How to create Excel workbook from VB6?
  45. Hide a workbook
  46. How to enter a Range of TextBoxes?
  47. Using concatenate to create a multiline with references to cells
  48. Help - Deleting rows from data tables via a check box
  49. Best way to paste a variant array into a range?
  50. excel macro - macro initiation upon hitting the ener key
  51. Pass Parameter to Access Query
  52. Re: Can I use XML instead of an Excel Web Query?
  53. counting the number of ticks
  54. Conditional Formating
  55. Format Macro Message Box
  56. Query result and formula
  57. Random selection of items from a group (AQL sampling)
  58. Simple calculatation
  59. Need help w/ self-cert in XP
  60. excel formula
  61. How do I create a plain text email?
  62. Function variables
  63. Combo Box Fill Range
  64. Importing Data
  65. Validateing a txtbox from form
  66. VBA...How do you state a carriage return?
  67. last resort!!! please help
  68. ComboBox and Set Focus
  69. Control Source
  70. last resort!!! please help
  71. lIST dIRECTORY
  72. Code that retrieves values from a closed workbook
  73. Bit to Bit Compare of Files?
  74. Cell Reference in a Macro
  75. Printing? Worksheets not printing the same on multiple pc's!
  76. help moving info from one sheet to another automatically
  77. Trying to return Range from InputBox
  78. Re: excel defined name change event
  79. Shell command stopped working: is it part of Excel 95 , or Windows?
  80. vba for PowerPoint Charts
  81. Selecting consecutive rows in VBA
  82. Workbook Builtin Property - display in Windows Explorer?
  83. Re: excel defined name change event
  84. Excel. My Cell Must Contain An '@'
  85. Re: Attaching a buttom with an event on VBA
  86. Re: Add_in's Data & Forms
  87. Re: Attaching a buttom with an event on VBA
  88. How to prevent copying in Excel
  89. RE: Attaching a buttom with an event on VBA
  90. Code or formulas, not sure which
  91. Multiple Button Creation
  92. Checking for duplicate data
  93. Rescale the Chart Dynamically - I have briefed my situation.
  94. Placing a 'find'(ctrl+F) button in a UserForm
  95. Variable Cell Refs
  96. Querying Access through Excel
  97. User Form With Doc Word
  98. printing/importing problems
  99. Macro Loop, Find, and Total
  100. application/object defined error
  101. copy & paste from other worksheet - but not allow to cut
  102. carriage return macro
  103. Add-In...form call
  104. VBA to add a new chart into a PowerPoint presentation
  105. Deleting workbook names w/ VB
  106. Saveas with name of another file
  107. Importing Access mdb to Excel
  108. Re: Adding a text box to a toolbar
  109. saving file based on network login
  110. List Box
  111. WHere can I find a list of ColorIndex colors?
  112. If then .... else
  113. Hyperlink to open a common dialog on a msgbox
  114. Excel macro - Opening a sheet in accordance with the value in a particular cell
  115. Pivot Table Layout
  116. Help recording a macro to define print area
  117. &nbsp in Excel
  118. Function GetActiveWindow Lib "user32"
  119. Worksheet / Workbook Change Property
  120. formula not being put into new row
  121. Import data from a Outlook mail in excel
  122. Calculations
  123. Help with looking up mileage table
  124. Is not equal to... in VBA language???
  125. Excel/Text to HTML using ASP
  126. Macro to look for worksheet
  127. hide TASKBAR in Sub Workbook_open()
  128. Open Excel file on a remote server
  129. Can Vba Help With Auto-checking My Spreadsheep?
  130. Unhide sheets based on a cell value
  131. Macro for Excel / Outlook
  132. Displaying a message while a macro is running
  133. VBA Problem
  134. Which function is use?
  135. delete
  136. VBA and determining which sheet the code is running under
  137. Copy Sheets
  138. Question correction
  139. Calendar Add in
  140. Calendar
  141. copy rows
  142. Format Value Paste Button
  143. UserForm possition
  144. Printing Excel doc.
  145. Using add-in functions on a form
  146. Help: Macro to to sum across selected visible worksheets
  147. Disabling normal printing
  148. grouping sheets
  149. Accumulate data in pivottable
  150. File name
  151. Objects and Variables
  152. Left and Right function is not working
  153. Rescale the Chat using VBA
  154. check whether worksheet's there or not
  155. Error message
  156. Verify that the vbe is active when using sendkeys
  157. Turning off all the mac ros and code in an Excel Workbook
  158. urgent. looping thru all records and applynig formula to get new results
  159. Excel and Progress
  160. turning off unwanted warnings
  161. 2 sets of option buttons on one user form?
  162. Auto Close function in Excel
  163. Event proceedures
  164. reformat numbers
  165. copy named range
  166. find and replace macro need help
  167. Differentiate between cell colours
  168. Making a query from a web page using VBA.
  169. Adding worksheets
  170. Random Sample with proportions
  171. Browsing for a folder name?
  172. Auto-Click Save on Clipboard
  173. Entering Query Parameters by UserForm
  174. Error updating pivot table source data
  175. How to name a chart for referencing in VBA? And move it.
  176. group rows in a range based on criteria from another range (vba)
  177. VBA - graphics
  178. conditional format limit code
  179. how to supress clipboard notice?
  180. problem excel 2000
  181. How to use macro to rename worksheet with date +"text"
  182. tab in userform locks program
  183. #NUM!
  184. # added to number in function procedure
  185. referencing worksheet as a variable
  186. Macro selecting blank rows/columns
  187. Re: Printing Slow Down On VB Repetitive Use
  188. Loading images
  189. asp.net Office Automation - in or out of process
  190. Help on file and folders Please
  191. Print Macro - Printing out of Order - 2nd Post
  192. Call MS Word envelope printing routine?
  193. Looking up two entries in a listing.
  194. Read only
  195. How to make a button conditional
  196. Pivot Range Name
  197. Border VBA
  198. Userform Question
  199. Combobox ItemData
  200. Re: Verify Data Format via VB
  201. AutoFilter help VBA
  202. Change cell color if data present excel 2002
  203. Interrupting a loop
  204. Find Cell Value and Activate
  205. red Color for same value cells
  206. VB6 to VBA conversion. Form vs. UserForm differences. Object variable types
  207. Wrapping text in VBA Code
  208. Problems with User-defined Function
  209. Update filename
  210. Addd Net Connect Win98 vs W2K
  211. Querying sheet of unknown name
  212. Active workbook
  213. Re: formula to sum LAST five (5) values in column
  214. Deleting rows based on cell criteria
  215. Select Range of sheets
  216. ParamArray
  217. Sort Sheets Procedure
  218. Need Help creating multiple graphs through coding
  219. Syntax error.
  220. Repaint causes form to flicker
  221. Rundll32 & user error
  222. Re: copy-paste error
  223. lost double click ability to open files
  224. Help! need some adjustments!
  225. Re: Loop through open workbooks
  226. Re: formula to sum LAST five (5) values in column
  227. Error with For Next
  228. Buttonless MsgBox?
  229. Format Event Trigger (XL2002)
  230. Setting value of a public var from a form
  231. RE: Error Handling
  232. Using XMLMaps from VB(A)-Code
  233. Validation (Drop down list vs simple text length validation)
  234. Re: Validation (Drop down list vs simple text length validation)
  235. Re: Validation (Drop down list vs simple text length validation)
  236. Hide Row Based on cell value
  237. converting VBA into a com add-in
  238. Copy each control & rename
  239. Web Farming
  240. Naming a range with VBA...
  241. Copy Sheets
  242. display a set of data as a calendar
  243. web query w/login and password
  244. Clarification: using excel to send data to ethernet device over TCP/IP
  245. control a network device based on web data
  246. Which button was pressed?
  247. Help needed starting a macro
  248. QueryTables Error
  249. If integer is text???
  250. Filtering or linking Page Fields in an Excel Pivot Table
  251. Newbie: How to define the font size in the status bar window?
  252. Is there any method to remove...
  253. Re: Password protection of an Excel Add-In
  254. Refer to the cell in which a function is entered.
  255. Re: Password protection of an Excel Add-In
  256. saving file as personal.xls
  257. Re: Password protection of an Excel Add-In
  258. Trapping and preventing a form from being e-mailed before validation
  259. New Formular Needed
  260. Dynamic hyperlink reference
  261. Problems with date format in userforms
  262. Range help
  263. Not Enough Memory
  264. function help
  265. Macro : seeking max value after an Autofilter
  266. Last Cell
  267. Update Chart in Pivottable
  268. Protecting worksheet
  269. Multiple simultaneous macros and userforms
  270. RE: How tp query a spreadsheet table?
  271. Sending variable data to a web site to be computed then brought back to Excel
  272. Desktop Shortcut
  273. Saving data in an add-in
  274. Printing Multiple Worksheets
  275. Saving a very tricky code
  276. open work book to current date
  277. Changing what is displayed in an image control programatically
  278. Having trouble importing CSV files with a macro
  279. Average of 2nd/3rd/4th/5th/6th last cells
  280. Conditional macro execution
  281. Cell Formulas vs. VBA
  282. pls help
  283. Run time error 28: Out of stack space
  284. VBA Copy & Paste_Pt II
  285. Indirect not the correct solution???
  286. Save .csv with overwrite
  287. Code suddenly won't run on XL2002
  288. Protect cells
  289. Formula Assigned To Variable
  290. Commands at the line prompt using Shell
  291. Excel VBA - Solver conflict?
  292. Pulling Array from InputBox
  293. Complete a "helpsheet" code
  294. Need help with the Like Operator
  295. Re: Parameter Dialog Box
  296. Multiple Selection from COMBOX or ListBox
  297. Set smallest cell in row,col as BOLD
  298. Can't add a reference to specified file
  299. vba or formula help?
  300. PasteSpecial Error
  301. using code from an addin
  302. AutoFilter & UserForm
  303. UserForm Wont Load
  304. Manual Input During Macro Execution
  305. AutoFilter Values + DropDown Boxes VBA
  306. Pivot Table Grouping
  307. Pivot Table Grouping
  308. Detect macro's parent workbook or worksheet
  309. QueryTables Object Variable or With Block Variable Not Set
  310. "><" formula needed
  311. Copying spreadsheet out of excel with formulas (pressing)
  312. Min function
  313. Retry - Find and Replace Macro
  314. Problem with populating textboxes in relation to drop down list
  315. ColorIndex
  316. Exporting Graph
  317. Referencing a fixed cell in VBA using an IF statement
  318. Offset from new name based on what's checked in Userform
  319. automate 2500 cut/paste/format from internet to EXCEL worksheet
  320. Hide all images on userform
  321. Create a "helpsheet"
  322. Excel to Access question
  323. Problem with a defined variable
  324. Need new approach on forms I set up
  325. Help with perplexing form problem
  326. Code to halt a macro
  327. macro terminates with no error
  328. Capturing Print and Print Preview events
  329. Re: Userform Question
  330. UserForm | Incorporate a calendar
  331. Left Side of Excel Screen Turns Gray
  332. Finding Matching Pivot Datafield
  333. Increasing a range in a loop
  334. Finding cells and values
  335. Re: populating a multi-column Listbox
  336. Re: populating a multi-column Listbox
  337. Problem with Autofill Macro
  338. Re: Concatenate
  339. IF Statement
  340. Deleting multiple rows within a spreadsheet
  341. Tidy up data
  342. Extracting duplicate data from two lists
  343. Re: Concatenate
  344. Re: Concatenate
  345. TCP/IP
  346. Read Range Data into Array
  347. Simple Question
  348. ListBox Multiple Selection
  349. Wheres the bug
  350. Wheres the bug
  351. VBA Copy & Paste
  352. Undo with custom Paste function
  353. vba function
  354. vba function
  355. calling a function
  356. vba function
  357. What Is "Me.Worksheets(..."
  358. vba function
  359. Lookups in arrays
  360. Populate list or text box
  361. Workbook Formatting
  362. Listbox Index Problem
  363. storing an equation in a macro
  364. SheetSelectionChange
  365. lat long conversion
  366. Return MS Word word counts in Excel?
  367. Navigation Buttons
  368. run out of memort
  369. DIm Variables
  370. How to show a userform using excel macro in multipage
  371. an off topic question
  372. array of rows
  373. Text too long
  374. Desperate for help with VBA List Box
  375. Passwordchar Example
  376. Price look-up
  377. Multiline edit list box
  378. Items in a Listbox
  379. Temperature dependant variables - can excel do it?
  380. update access mdb ...
  381. Defining a Range
  382. How to avoid clearing undo stack after macro?
  383. is there a maximum size of parameter for a (Fortran)DLL call from VBA
  384. How to open a zip file from the code?
  385. Selecting rows in a spreadsheet
  386. Ranking 'off sheet'
  387. Concatenated Formula
  388. REPOST:Need help moving XL2K to XLXP, please
  389. Refresh
  390. processing message
  391. Comparing Spreadsheets to find information
  392. click event for changing cell color
  393. select X first/last columns of a pivot table with VBA
  394. Delete Sheets
  395. Copy before hidden sheet
  396. Halting the Worksheet_Change event
  397. Using Variable in RANGE
  398. Using Variable in RANGE
  399. Re: Comparing rows of data in two worksheets
  400. Turning off Active-X properties
  401. current row - VBA
  402. Re: Comparing rows of data in two worksheets
  403. Any Visual Basic Users Having Mouse Scrolling Problems?
  404. pdf to excel?
  405. References to ADO library for ACCESS connection
  406. Finding the Last Day in the month
  407. need formula to set value based on a date
  408. Getting Excel to update Outlook Calendar
  409. Macros
  410. unable to open excel file
  411. Why system asks me to save change even after I call save method(VB.NET)
  412. How to get last row used in sheet DATA
  413. deleting last 4 characters from file name
  414. Signed workbook depends on physical location of AddIn - Digital Signature Invalid - workaround?
  415. Validation lost on advanced filter copy
  416. Data Validation Criteria
  417. Macro to copy down specific number of rows
  418. array formula in Name Definition.
  419. Shared Addins
  420. AcitveX only runs with admin rights
  421. copying all formulas, except sum
  422. copy protection
  423. xls file size / memory errors
  424. Search a column for the last five cells?
  425. Saving with date in filename
  426. How to plot chart in VB program
  427. How to restrict the excel sheet containing Chart
  428. Copying Cell Using Macro
  429. UDF tooltip
  430. How to replace a macro with an addin??
  431. Undo change
  432. HTML HREF Opening in Browser
  433. Help with Workbook_Open
  434. Help with vba coding/userform....
  435. How to lookup hyperlinked cells
  436. Using Macro & offset to put in formulas
  437. making a userform work ,oops
  438. making a userform work
  439. Copying across VBE
  440. RE: Searching zip codes
  441. macro connect to Sage DSN
  442. Automation Code Problem from Access to Excel
  443. Re: how do you have one cell alter another cell
  444. Simple Macro
  445. Sort Orientation
  446. Adding up values of textbox in Userform
  447. Macro to save worksheet
  448. Control Toolbox grayed out in Excel Spreadsheet
  449. Date Change
  450. Thanks
  451. Importing Text File
  452. Selection and Areas
  453. Activate Chart
  454. Printout Code Problem
  455. I need some help here
  456. where is the workbook_open event handler???
  457. Tab go into the editing text box not next object
  458. multipage question
  459. userform
  460. Userform to spreadsheet
  461. verify open windows
  462. Excel macro problem cursor down
  463. Tab-key
  464. ([([([ Page Breaks Problem ])])])
  465. Variables not showing value
  466. Running a macro every half hour
  467. How Do I Expand A Set Range In The Match Command
  468. Auto Duplicating Worksheets and Insterting Data from Different Worksheet
  469. Macro to hide rows containing no data
  470. external reference
  471. Excel Version
  472. Golf Statkeeper
  473. Excel 2003
  474. Setting References in VBA
  475. Test
  476. Excel 2003
  477. Does CoGetInstanceFromFile work with worksheets?
  478. Opening A File From Excel VBA
  479. Executing a Macro From a Desktop Icon
  480. format a listbox
  481. Column
  482. Relative Macro Assignment
  483. userform macro button problemo
  484. Excel 2003
  485. Looping Text
  486. i have a really long problem,
  487. delete items from a column
  488. Problem with Office Developer XP in Excel 2003
  489. run time error
  490. preventing closure of active excel window
  491. Licence help wanted
  492. username
  493. hiding rows
  494. Excel VBA Beginners problem
  495. makes a new list
  496. Summation of cells tied to Checkboxes
  497. counting formatted cells in vba
  498. Excel end user reports and preventing changes to users excel settings?
  499. Protection options through VBA
  500. FTP FILE TRANSFER PROTOCOL FROM VBA?
  501. Functions
  502. **HELP** Can This Be Done
  503. Copy/Paste based on cell content.
  504. stillcheckbox remains a pain Frank
  505. Getting Windows user (Account) from a VBA routine
  506. Calling Access Program from Excel
  507. Formula to return Friday's date: m/d/yyyy
  508. Excel 97 vs. Excel 2003
  509. Excel 97 vs. Excel 2003
  510. userform data to spreadsheet
  511. vlookup, with more than 1 result
  512. Match & Indirect
  513. Clarification please...
  514. vba code to reboot
  515. Help: Profit margin
  516. test
  517. Automatically Assigning a Macro to a button
  518. Automatically Assigning a Macro to a button
  519. vba weird messages - "catastrophic failure"
  520. Open Event Code Bug
  521. Last cell
  522. INSTERING A ROW
  523. Macro command to open a file
  524. Variable with value before being assigned?
  525. Overflow when translating from C++ HELP!!
  526. Hide the DisplayPasteOptions
  527. Order in which add-ins load
  528. On error
  529. Can this procedure be made more efficient?
  530. Password protect data entry to cell
  531. Resizing a Range
  532. Ranges using offset
  533. Re: code doesnt work
  534. Opening new workbook
  535. UserForm Problemo
  536. Creating Macro's
  537. macro to email excel files
  538. Msg boxes
  539. Can a graph use array data instead of ranges?
  540. Help
  541. Re: code doesnt work
  542. opened workbook (not resolved question)
  543. changing a Word doc to Excel
  544. Formulas for...1. Counting unique cells 2. Display unique contents
  545. Re: code doesnt work
  546. Ignoring cells with no value
  547. Re: Clearing the contents of merged cells
  548. Copy Sheet
  549. RUN Time error 9
  550. GOTO another sheet
  551. User Form
  552. Print header change
  553. Excel VBA - Storing text in a variable, and "'Cells' of object _Global failed"
  554. excel VBA: input boxes
  555. Re: unable to hide the "ask a question box"
  556. macro
  557. Macro to search, compare, copy and delete
  558. Seperating Letters from words using character
  559. re:enter button in vb
  560. Change a positive value to a negative value
  561. How do I get a reference to a control on a sheet?
  562. Userform inside another userform
  563. Pivot Table Names
  564. RE: Making macros available on lan in Excel 2000
  565. If criteria not met then message box
  566. User form keeps getting smaller...what the ???
  567. Printing Marcos
  568. Attaching a similar forms to many templates
  569. RE: Selecting/Printing a Named Range via VBA
  570. Exporting Data Question
  571. Converting numbers to column letters
  572. data validation
  573. Excel - get address of cell
  574. Count days
  575. Need help with Macro
  576. Populate Column Header on ComboBox
  577. Custom paste macro
  578. Using vb to launch a shortcut
  579. HELP! XL2K to XP -what reference am I missing?
  580. Pad with leading zeros?
  581. recalculating advanced filter?
  582. Copying to another Workbook
  583. Worksheet Password Protection in VBA
  584. Mode Function
  585. VARIABLE SUBSTITUTION
  586. Name not recognised
  587. Date macro
  588. Aligning lists
  589. Copy and Paste hidden cells?
  590. inserting latest picture file
  591. Will Excel create a checkbox?
  592. File Conversion
  593. ActiveSheet.Printout or Page Setup?
  594. My problems with simple addition ...
  595. don't bother
  596. blank cells
  597. How tp query a spreadsheet table?
  598. Formatting part of Cell
  599. Exiting a VBA Macro by user intervention
  600. error on oXL.Workbooks.Open
  601. Excel VBA event trigger problem
  602. if function prob
  603. enter value, calculate, in same cell
  604. UserForms and Variables and Types of data
  605. Copy before sheet
  606. calculate the average of a column then move it to excel
  607. VBA to number worksheets?
  608. Re: When saving add automatically contents of a specified cell in document properties
  609. Can an advanced filter do this...??
  610. How does msgbox stop the OnTime event?
  611. Problem with SendKeys + active window
  612. Delete Multiple Worksheets
  613. Active Directory
  614. Add library in vba
  615. Complex Match problem
  616. Excel filename into cell
  617. Maximum length of a line?
  618. extracting part of string value
  619. Refresh Browser with vba
  620. wraptext is not updating when using references to another cell
  621. Variable scope
  622. Thanks, This works perfectly
  623. Help with e-mail macro
  624. Excel VBA - Last Author properties
  625. Loop code problems
  626. Excel in batch mode
  627. Sheet Name not accepts special characters
  628. Code for Case & Number format
  629. automatic text insertion in preformated spread sheets
  630. VBA question about Variables
  631. Hide zero column in Pivotreport
  632. A good book on using Powerpoint VBA to drive macros in Excel ?
  633. Excel Web Query
  634. Printing
  635. Printing
  636. openning spreadsheet
  637. Using the result of autofilter and performing tasks on each value
  638. Hiding sheets with macro disabled - with a big twist!
  639. for next with web query
  640. How To Copy Sum of Cell Values vs A Single Cell Value
  641. Non contiguous to contiguous
  642. How to disable Visual Basic Editor in Excel file
  643. Create a separator line using conditional formatting
  644. While reading excel file i am getting null values
  645. Macros to run in any workbook
  646. Highlighting only cells with data in them
  647. Highlighting only cells with data in them
  648. Pie charts in Macros
  649. Looping though *.xls files except for the main consolidation file
  650. New to VBA from VB6
  651. How to disable Ctrl+Break
  652. Select Cells with VBA
  653. Array Functions
  654. Spin Button...
  655. Problem on the ASP using the Excel.Application Object
  656. ssfHistory & ShellSpecialFolderConstants
  657. Run macro in Excel when new data is on the clipboard
  658. xlDialogActivate to Select Sheets?
  659. Getting "compile error" "method or data member not found" on reinstall
  660. Change from 2K to XP and Excel.xlb toolbars
  661. Powerpoint and Excel
  662. Intelimouse scroll wheel
  663. Control Box Option Buttons
  664. textbox options
  665. No debug box
  666. protect print_area?
  667. First empty row after last used row
  668. code to terminate access after certain time
  669. telling Excel to go down relatively
  670. Command Button
  671. LegendKey modification Error
  672. Changing backcolor of commandbutton
  673. Help with Menus
  674. Problem with setting Pivot Table data orientation
  675. How to make the "Save As" prompt appear with vba?
  676. Formula to search cell to see if it Contains a value.
  677. Programatically saving XML file as Excel spreadsheet
  678. Auto-Formatting in Excel: changing values
  679. Print Area when subtotals are on.
  680. Save at start of month
  681. User form
  682. Search Using Autofilter - Field
  683. else if code
  684. Virus Warning
  685. Easy one (I hope) Using Sheet Names to reference sheets in other Workbooks
  686. Conditional formatting & interior color
  687. Circular Reference Conundrum
  688. excel vba - spreadsheet code "apply to all" problems
  689. Pastespecial and cut
  690. Column Sort (VBA)
  691. Re: Active Cell
  692. Recall a variable referring to a worksheet name?
  693. Re: Active Cell
  694. Need program to ask me to save changes when closing
  695. Make "BeforeSave" event supply a default path and file name?
  696. Slow Macro on Page Margin Change for all sheets
  697. Solver
  698. Excel column widths change on different machines
  699. Finding Max Within 3 Columns
  700. Print Macro - Printing out of order
  701. If Range("C1") is in MyArray
  702. Custom Worksheet Function not updating
  703. dynamic subtotal %
  704. Add-in conflicts
  705. Control Properties Not In View
  706. Lock down a new instance of Excel App
  707. how do I create a checkbox?
  708. Does anyone know why this won't work?
  709. Using an Excel "object" with my VB DLL
  710. Problem- Recording macros for "file save" and "File open"
  711. Re: Executing an older excel 4.0 macro
  712. MyBar doesn't run automatically
  713. Re: Running Macro when value in spreadsheet is true
  714. Creating a action for a defined object
  715. Email distribution list
  716. Not found objects
  717. macro function is too slow!
  718. a round of applause to frank kabel
  719. Date Validation
  720. oh, and another thing
  721. Strange PrintOut Behavior
  722. Thanks!
  723. save conunderum
  724. Copy cells from other workbooks
  725. For Next & Hidden Sheets Issue
  726. remove reference via code
  727. 2D array lookups
  728. Find loop
  729. does textbox contain a number
  730. PRinting two many repeated lines
  731. Accessing selected cell from modal dialog
  732. lock customize bar
  733. Search form
  734. I want to protect a cell but allow formula values only
  735. Late Binding
  736. Using Add Method of QueryTables gives error
  737. Special Action on E-Mail Error Condition
  738. Try again: VBA to automatically install ODBC data source
  739. Obtain a Process ID
  740. Using For Next to reset Pge Brk Preview on all sheets
  741. hide a page on a multipage control
  742. Make an unsaved file copy in memory?
  743. User defined Spreasheet Functions - How to add "help/ assistance comments"
  744. CSV to TXT: how to
  745. While reading excel file i am getting null values
  746. VBA References - when is Office Object Library Reference set? Best practice re. Early/Late binding ...
  747. Return to Original File
  748. Restrict Population to MS Query by Cell Ref.
  749. BIFF8 Sample
  750. Object Variable or With Block Variable Not Set
  751. Getting sheet name
  752. Remove Close button
  753. How to check output folder has been created in the network path?using VBA programming
  754. Trying to run MS Excel 2000 macros on MS Excel 2002
  755. Loc and LOF functions
  756. error in sorting
  757. Cells.find restricted to a single range??
  758. Compare two ranges and display equals in list
  759. "Excel - Get Date"
  760. Clear Contents Of A Text Box In User Form
  761. Hide and printout area conditions
  762. Combox box question
  763. opening diff. worksheets in opened workbook
  764. getting external data
  765. select distinct row
  766. finding empty rows and deleting
  767. divide and conquer --- help!
  768. find next blank cell
  769. Suppressing Enable Macros QUestion
  770. Saving time
  771. Add sheet and rename with cell contents
  772. Userform w/ Multiple listboxes that link
  773. Vertical Entries for VBA.Array
  774. Can VBA log into SAMBA
  775. Copying data from different sheets
  776. Anybody want a job?
  777. Sort of Data
  778. Excel compile
  779. weird problem with PivotFields CurrentPage
  780. Conctenate
  781. Outlook from Excel
  782. Re-post of existing problem
  783. Compile Error: Procedure too long
  784. Finding first (end of range) empty cell
  785. Digital signature on workbook/addin invalid when files moved?
  786. HyperLink Windows
  787. Lookup and Select Row
  788. Referencing an Older Version of the Excel Library for Development
  789. Mouse drivers that work with VBA & horiz scrolling?
  790. sending a cell to a textbox?
  791. Copy Selection to new sheet
  792. if macro
  793. Referring to Microsoft Excel array in VBA
  794. change password
  795. Editing text within a cell
  796. Simulating a synchronous process
  797. Range selection not working
  798. need form to initialize without closing
  799. Find Help
  800. sortingproblem
  801. Copying unlimited range of data and closing the file
  802. Problems with Excel 2000 from 2002
  803. adding text for a specific range
  804. Time to learn to find the right folder *sigh*
  805. Capture scrolling event
  806. Delete Rows
  807. User Form/Input box problem
  808. Visual Basic
  809. Fill a ListBox with items using VBA
  810. Count Cells with text a specif color
  811. moving automatic vertical pagebreak
  812. Re: Help with VBA
  813. Cell size format
  814. recursion depth, 'Out of stack space' in Quicksort
  815. Message Box Question
  816. GetOpenFilename - How can you filter files starting with a letter...
  817. Excel filter range
  818. VBA - closing without saving changes
  819. Find and Replace HELP!
  820. Pivot Table PageField
  821. Get the GAL in excel
  822. Field in Access
  823. Mileage Chart (I'm a beginner)
  824. Download data from website
  825. Read a current footer value
  826. Using a "File-Open"-Window in a Excel Macro?
  827. Linking files together
  828. Creating and closing CSV file
  829. movable formula
  830. clinka32.dll
  831. make the parameters show up when you create your own functions
  832. Make toolbar buttons appear only in specific files?
  833. How play a wav file
  834. Finding unique sets of numbers that total 200
  835. Problems with Personal.xls
  836. find and insert missing values
  837. Shortcut Ket after the fact
  838. Argh...layering object problem in userform
  839. access sheets in another workbook
  840. Macros
  841. the "Procedure too large" error
  842. Not Enough Memory!
  843. Notification when Filter is selected
  844. Workbook Open event
  845. sub to create a sub
  846. Combobox Item Number
  847. Link Combo Box to Autofilter argument
  848. excel vba array problem
  849. Excel VBA-Personal Budget: Identifying text in a column...
  850. Beginner question (I hope)
  851. Excel2002 autoformats dates,
  852. Help please- user selectable image
  853. Excel VBA - Setting Print Area in VB
  854. subtracting ranges?
  855. Formulae In User Forms
  856. Save file, refer filename to cell and change directory
  857. Last Time Updated in Footer
  858. Status of sheets in a workbook
  859. Select rows after finding last cell
  860. Annual Percentage Rate & ARM
  861. How to Format a ListBox column
  862. monitor small/large font code
  863. Start excel from DOS?
  864. Restricting access to OLAP cube data
  865. Prorating calculations in Excel
  866. identifying which cell calls my VBA function.
  867. Excel AddIns VBA Locking v Unviewable
  868. Excel VBA Locking / Unviewable
  869. WorkbookOpen code not executing properly
  870. Re: Vision Objects as Controls?
  871. Re: sumif not working if using different rows
  872. RE: AddItem Method - Combobox value
  873. Using Outlook Object Libraries V8 & 9
  874. Concatenate a strings range.
  875. Certifying Macros in a Domain
  876. Printing
  877. Creating Custom Toolbars
  878. Inactivate message boxes
  879. Recognise value not formula
  880. AddItem Method
  881. Re: Tom Ogilvy
  882. Formulas not updating when add new inputs
  883. Re: Tom Ogilvy
  884. Save As
  885. Save As
  886. problem with buttons
  887. Streamline macro code.
  888. How can you determine if a cell is formatted as a percent?
  889. Changing Pivot Table Fields Programmatically
  890. Blank grey toolbar after code !
  891. Solver constraints not added
  892. Available serial numbers...
  893. Sheet construction on server security issue
  894. Prompt for new folder
  895. Formula for finding text
  896. import of txt list to Excel
  897. Help please, what Function?
  898. Count used cells, in a specific range...
  899. Strange borders
  900. Opening and closing a picture dialogue box
  901. RE: Anybody want a job?
  902. How Format a List Box
  903. Arrays
  904. suppress warnings
  905. Multipage & Spinbutton controls on a form
  906. Macro to remove all names from workbook
  907. Pass an argument to Excel workbook
  908. Find File doesn't work properly
  909. Help please!
  910. Ranges / Loops
  911. drag and drop cell group into textbox
  912. Getting value from closed workbook
  913. devide the whole column...
  914. Import file dialog
  915. VBA, Impersonating other user
  916. Outlook AutoSignature
  917. Prevent formatting Cells with Protection
  918. Copypicture method failed
  919. Open Access database(DAO) with password protected
  920. Printing using VBA
  921. Cell Transfer
  922. Qualifying sub names
  923. Moving a range between workbooks
  924. Funny function problem with add-ins...
  925. How to get a range of values into a combo placed on USERFORM?
  926. insert linked chart from excel to powerpoint
  927. Creation of a range with no specified address
  928. Hide subtotals of rowfields in a pivot table
  929. Sub checker
  930. Excel VBA- Error Accessing the system registry
  931. PrintOut_Method Outputs (Win 2000 Pro and XP Home)
  932. sumif with different rows won't work!?
  933. Copy Files
  934. RE: Toolbar
  935. storing global macros
  936. Insert into existing code
  937. Code Error - Run Time Error 5 (Disable Cut, Copy & Paste)
  938. Workbook crashes after renaming a worksheet - References problem?
  939. Array of OptionButtons ?
  940. Saving spreadsheets as delimited text files
  941. PrintOut_Method
  942. Paste button greyed out So I can Not not paste between Excel
  943. textbox ,problems?
  944. Re: Toolbar
  945. RE: Anybody want a job?
  946. Re: Cut & Paste
  947. Stored Procedure call and passing parameters
  948. Help Deciphering a Lotus Macro Snippet
  949. printing using vba; listbox/command button
  950. Re-Name a Worksheet..... with a Twist
  951. Selecting Distribution List when Mailing from Excel
  952. ChangingPivot Table programmatically
  953. Unserform with a varible
  954. Variable in a Formula
  955. RE: Tom Ogilvy
  956. fit to te left
  957. calling from one workbook the classes and functions in another
  958. VBA and Different Lotus Notes versions
  959. Re: GetOpenFilename returns a string rather than an array
  960. VBA MsgBox() Text
  961. How to know if a sort is finished sucessfully?
  962. Page Break Problem
  963. on what page a cell is located
  964. Lotus Macro Commands to VBA equivalents
  965. Excel 2003
  966. Column
  967. For..next.. help to fill listbox
  968. CheckBox in VBA
  969. Single Digit Entry
  970. Re: Inserting rows based on another cells value
  971. Print a number of rows per page
  972. Question On Formatting cells
  973. Inserting rows based on count
  974. divide multiline text cell across several rows
  975. Find item and delete rows
  976. Before Save as Event needed
  977. web query based on cell value
  978. Help WNetGetUniversalName ... in vba
  979. Re: How to find the position of last ":"
  980. Re: GetOpenFilename returns a string rather than an array
  981. Add a cc to this code
  982. Re: Macro Error Please help
  983. Need Code to Set Scaling Zoom in PageSetup in Auto_Open Sub
  984. Fast way to insert data from database
  985. Re: Named ranges
  986. File size increases by 300kb without any changes?
  987. Column width units
  988. Re: See who's quickest at solving this
  989. data extraction / cleansing a string column in a workbook
  990. E-MAIL
  991. Help with IF statement
  992. Comparing spreadsheets
  993. Compare two working files
  994. Copying text as a formula?
  995. Copy cells with unspecified values to new sheet
  996. Frank Kabel
  997. Calculating weekly avegage efficiencies on a weekly basis
  998. Directory Contents
  999. Re: Named ranges
  1000. Re: Named ranges