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. putting validation to TextBox in the userform
  2. Textbox problem
  3. Using Range inputs in functions
  4. How come my macro works if I pause and play again?
  5. addins
  6. How to count rows in a user-defined AutoFilter or AdvancedFilter is active?
  7. SaveAs without copying Macro
  8. Need a little help in my macro please
  9. Coloring a cell with if statement ...
  10. how to delete unselected columns in a table, thanks
  11. numers extracting??
  12. How to catch copy/paste & cut/paste ?
  13. Creating an Absolute Reference Macro
  14. Copy only the numbers from cells
  15. using Sub's with checkboxs
  16. combo box
  17. Help with Do Loop
  18. Applying background color to cells
  19. Applying background color to cells
  20. Using selected ranges
  21. Chronometer in cell
  22. Set Excel margins from MS Project
  23. Textbox in Userform not recognised by Module
  24. excel not installed
  25. replacing varaibles in formula
  26. Another Quick Simple VBA question (if...then statement)
  27. Macro and Edit query help
  28. skip code
  29. functions
  30. avoiding #N/A when using vlookup
  31. Quick VBA code question (if...then statement)
  32. stop annoying cell selection change
  33. Simple VBA Code Question (UserForm)
  34. nested "with .../end with" statements
  35. Re: Auto Filter Subtotal
  36. Filter column using criteria from a userform
  37. problem selecting entire column
  38. Ignoring text and spaces ???
  39. SQL query
  40. Finding a sum
  41. Sub to make text bold
  42. Floor Plan Sketch Add in
  43. VBA code to
  44. Outlining Limit
  45. Macro trouble
  46. .NET application does not release Excel
  47. Protect cell
  48. help!! please with formatting excel to labels
  49. Re: row archive and auto email
  50. Commandbutton
  51. Copy row marco
  52. Looking for COM Add-In example in VC++
  53. clearing arrays
  54. Enable Close button
  55. List box with multiple selections
  56. "Invisible" Command Bars Reappear
  57. Cannot open my files!
  58. Two VBA/SAP R/3 Questions
  59. Re: Re: instr isn't finding all the matches
  60. referencing ComboBox
  61. DATE = 1ST OF MTH
  62. putting validation to TextBox in the userform
  63. SQL.Request from Oracle Database
  64. get excel to automatically add fill color
  65. Deleting Rows based on text in cell & formatting cell based on text in column beside it
  66. Re: Sending Mail using Lotus Notes
  67. arrays - module to module
  68. Re: how to set pivotitem.visible property to true
  69. Row Height
  70. "Unable to Open File" - excel output of Datagrid <-help needed
  71. Screen savers
  72. How to clear a selection
  73. Detecting whether Caps Lock is set
  74. Re: Auto Filter Subtotal
  75. why macro slow first time
  76. Highlight the entire row of a selected cell
  77. Text box invisible scroll bars
  78. Save a copy of Excel in Access???
  79. Public Variables with UserForms
  80. Re: Exporting multiple worksheets as CSV
  81. Fundamental use of Round
  82. Re: Help Please
  83. Clear Clipboard in VB
  84. Re: format cell
  85. Explain Parameters for a UDF
  86. How do you change button color by moving over it?
  87. Customizing toolbar buttons
  88. Deleting Excel Message/Dialog Boxes
  89. Disappearing listbox entry
  90. VBA Problems
  91. How do you use "except" in a for next loop
  92. Setting cell background color based on value
  93. problems with .xml and Excel 2002
  94. vlookup works sometimes
  95. AddressOf / Windows API question
  96. Re: Disable File-Save menu item in macro?
  97. Tab Between Active X Controls on Worksheet
  98. Using "Like"
  99. Problems using VB.Net OleDbDataAdapter and Excel
  100. help with links needed
  101. Test for shaded cell?
  102. how to add search criteria in VBA, EXCEL
  103. How to get relative range?
  104. excel addins have reference to wrong file
  105. Deleting Hidden Files
  106. How to make a new table based on selected result in listbox
  107. Multiple excel spreadsheets in one HTML file
  108. AddIn with Tables
  109. Re: adding text to end of cell
  110. Subtotals
  111. Caps Lock
  112. What is quicker? Nested or non nested ifs
  113. Multiple VBAProjects in Excel File
  114. How to get the RGB values
  115. Question regarding an activex control button
  116. computers are not logical
  117. question about creating a message box
  118. Re: Code modification to accomodate scaling and print areas.
  119. Running 2 Excels simultaneously?
  120. toggling a chart on and off
  121. help with string functions
  122. excel vba- userform problem
  123. Importing Excel data
  124. Call Private Function from ThisWorkbook module
  125. Convert
  126. VBA - How to Write to Specific Worksheets
  127. Refresh listbox on userform1
  128. Re:Help with time VBA
  129. Setting ranges
  130. range
  131. Enable Macros
  132. lenght of a number
  133. Associating Comboboxes
  134. Help! Application Error >_<
  135. "rows" syntax
  136. Active sheets
  137. Large scale
  138. Re: I need a macro to convert my date formats into a custom layout.
  139. Macro to Autofilter
  140. Re: I need a macro to convert my date formats into a custom layout.
  141. Re: Pivot Tables....
  142. Help with time VBA
  143. Set Range in one macro to range in another
  144. using 'enter' on a textbox to activate a command button?
  145. VB Editor compiles before I finish typing
  146. Macros for emailing
  147. Object Library 11.0
  148. Protecting a macro
  149. Access control on a worksheet - help!
  150. Combo Box using Key Input
  151. Macro help
  152. Application Security Loses Control
  153. Excel 97 - Common Dialog Control Help
  154. looping to End
  155. Calling an Excel Doc from Internet Explorer
  156. Re: Can Names refer to Collections?
  157. Re: Re: instr isn't finding all the matches
  158. Re: DoCmd.OpenReport problem
  159. counting cells
  160. Re: deleting content in cells
  161. winzip in macro
  162. Printer error building Excel workbook...?
  163. format cell based on value
  164. Identifying blank rows
  165. adding numbers macro
  166. Stuck!
  167. Excel 2000 importing huge ASCII files into different sheets
  168. Finding blanks in dynamic ranges
  169. Search based on comparing several values in the same row and column
  170. How to extract number from cells in excel (function in Excel or VBA?)
  171. RE: Sum a column
  172. Re: Sum a column
  173. Unique ID/Name for a computer?
  174. Can I use "Unicode" numbers to specify a font?
  175. Do not copy buttons or macros
  176. Re: Sum a column
  177. Re: IndentLevel
  178. Excel Prg to retreive numeric values
  179. Symbol font with Times in Data labels
  180. Time Stamping
  181. Insert forms created in excel's visual basic into a worksheet or at startup
  182. Get a cell's name in VBA
  183. cancel dialogue box automatically in program
  184. Problem identifying with Checkbox's status
  185. VBA and comments in Excel2002
  186. day and date in cells
  187. Export multiple datagrids on web page to Excel
  188. best approach? or select last row before page break
  189. Selecting Contiguous data that contains many empty cells
  190. new to Excel-have problem
  191. cell formatted for current day
  192. TextToColumns
  193. Run Time error
  194. Function Calling Subroutine
  195. EXCEL AND OLEDB
  196. conditional formating
  197. ??
  198. Create Folder / Copy Folder / Replace
  199. Resizing list boxes in a form
  200. Macro to Delete Rows
  201. Re: 'Application.Goto Reference
  202. Blank lines
  203. Active cell plus 1
  204. help on select case
  205. Protected Sheets suppressing object usage
  206. Linking...system locking up
  207. conditional formatting >syntax
  208. Macro to prevent saving
  209. Macro & Tool Bar Sharing
  210. Counter
  211. ole
  212. Format and Convert
  213. Default Value For Functin
  214. cut & copy line...
  215. Deleting duplicate entries
  216. Macro not executed Excel --> PowerPoint
  217. Macro Sharing
  218. workbooks.open and appliciation.screenupdating
  219. Get output Path
  220. Count rows On error MsgBox
  221. Selection Failed
  222. Changing the behavior of the "tab" button
  223. Select method of Range class failure
  224. Re: SaveAs Dialog Arguments
  225. Converting currency
  226. Create Workbook
  227. Long Time to Enter Cell Values
  228. Re-Post: Long and Varying Worksheet Save Times
  229. Problems ignoring error message
  230. Textbox & Barcode Scanning
  231. If a called sub exit, how to the caller exit right away?
  232. ISNUMBER
  233. Save as
  234. Save as
  235. Changing the Cell Background Color when a keyword is entered
  236. VBA Editor not showing list of properties & methods
  237. moving to aparticular view - SOUNDS SIMPLE?!
  238. variable = current cell in VB
  239. Protected Worksheets
  240. pastespecial
  241. How to perform allocations, planning and budgetting in Excel
  242. turn on sharing
  243. How to handle hierarchy processing like this
  244. Multiple combobox association
  245. read this
  246. better search method
  247. Copying a Worksheet from an AddIn into an empty Workbook
  248. Automation remote saveing help needed
  249. Macro to assign a printer to a workbook
  250. Add add number
  251. Add add number
  252. Excel VBA - Executing external programs in an excel macro
  253. I meant this to be for word, sorry, can you still help me?
  254. Live link from the Web?
  255. Copy & SpecialPaste same cell
  256. Range Resize property
  257. VB Form to populate spreadsheet.
  258. Seqentual number save
  259. Graphic Visualization of an ORACLE data on EXCEL
  260. Pop-up menu with valid values
  261. How to select cells?
  262. application.inputbox
  263. Excel error when opening a file from ethernet
  264. Case sensitive sorting in Excel
  265. Previous Excel Question
  266. Excel VBA - Exporting values to a txt file
  267. Creating folders with VB
  268. GetSaveAsFilename - how to code the arguments
  269. Import *.asc file into excel fixed width
  270. Can A Named Range Be A Variable?
  271. publish excel as web page
  272. VBA Vlookup External Reference
  273. How to "Set alias for worksheet in other excel file"
  274. Printing Diagonal Cells Problem
  275. Searching for the Odd ‘Fudged’ cell
  276. Need to search workbook for NEW worksheet
  277. Replace Function
  278. Err.Number 1004 with various Err.Descriptions
  279. help: Activesheet.save error with XL 2000
  280. Newbie : Sum Cells Part 2
  281. Getting App.Path in VBA?
  282. Save date in filename
  283. Sort column
  284. lookup, cut, go to named worksheet and paste complete rows
  285. SmartDocument events
  286. Finding Non-Blank Cells
  287. How do I test when a vaule is not found?
  288. SaveAs another file name, then keep working
  289. auto copy and past
  290. cell to textframe using characters object
  291. Automatically running macros
  292. Next Cell Question
  293. CopyAndPaste Object w/namechange
  294. Conditional formatting formula is evaluated repeatedly
  295. Question on Positioning Bar Chart Labels
  296. Wraping text to next line
  297. restricting fonts
  298. Forgotten share & protect password
  299. cond'tnal format 4 date changes
  300. Entering Dates and auto-completing
  301. tabular questionable
  302. reference to Comments
  303. stop in cell
  304. Exporting multiple worksheets as CSV
  305. Open an Acees Form from Excel
  306. Newbie : How to sum cells via VBA code.
  307. Filters on with worksheet Protection on in Sharedworkbook
  308. XL 2002 vba on an XL 2000 machine
  309. account format in excel
  310. Catch File>Save/Save As/etc...
  311. VBA VLookup Reference Problem
  312. Summing Duplicate Entries in Excel 2000
  313. SetActivePrinter
  314. Variable Autofill Range
  315. Pivot Table Formats in Excel 97
  316. Saving filename same as import filename
  317. User Defined Functions
  318. Re: VBA to prohibit changes to scale setting in page-setup
  319. Method 'Range" of object'_Global' failed
  320. validate an option is chosen
  321. Formula Length
  322. Error Message in VB
  323. Multiple worsheets
  324. Combobox
  325. How to save each worksheet as seperate file?
  326. worksheets collection... find...
  327. Variable Autofill range
  328. Date Calculation in UserForm TextBox
  329. Userform text & combobox population help required please
  330. Application.NetworkTemplatesPath Not Working
  331. Find the two lowest values and subtract them from a total
  332. Auto Print
  333. Assign Formula to Variable
  334. Calculating the minutes between two times
  335. Hoping a guru can help this novice out with a simple macro
  336. Value from Registry
  337. Set range as multiple columns
  338. Clear Clipboard on Workbook Close Event (Excel XP)
  339. Toggle custom button caption
  340. setup
  341. Datagrid to Excel - error - rendercontrol
  342. Paste Function in Macro
  343. Web Query
  344. date format ??
  345. Notify without opening workbook
  346. Re: Frame Index
  347. Concatenate and copy in VBA
  348. Concatenate and copy in VBA
  349. formula error
  350. Repeat Multiple Page Headers using VBA
  351. Using Send Keys to unprotect and protect VB project
  352. Cell Alignments using a reference worksheet
  353. ODBC connection for insert into SQL Server
  354. Dynamic execution of a loop
  355. Re: Paste text only
  356. Workbook's BaseTemplate
  357. Save sheet without links
  358. Paste text only
  359. Showing Worksheet Range in Userform
  360. beginnersproblem copy formulas to cells
  361. define cell for autofit of merged cells
  362. Don't want to SEE macro working
  363. convert number format to time format
  364. changing values acroos worksheets
  365. macro won't pull up list's data form
  366. range: question
  367. range question
  368. range question
  369. Create a help file for VB functions
  370. Row Height equivalent to xlColumnWidths?
  371. FormulaArray
  372. Excel question
  373. Reformatting of cells on requery of sql source
  374. Display set area
  375. Getting data from SQL Server into Excel
  376. Excel 2002 Workbook Opens Very Slowly
  377. save photos from a worksheet
  378. excel application does not shut down after program exit
  379. Pasting Data into a worksheet
  380. problem with resize property
  381. Reference styles and local/non-local formulae - international problems.
  382. Unselect Filtre ....
  383. Not sure if this is possible!!
  384. Keyboard Shortcuts
  385. random text generator- urgent help
  386. Analyze timescaled data in excel
  387. Showing Loop Status
  388. Search and replace by page break
  389. referencing values in adjacent cells to selected cell
  390. Disable Window Right Click
  391. Problem with comma seperated list
  392. Referencing a Subprocedures Name
  393. '$' sign in the form window
  394. VC7.1++ Excel add-in sample code? Visual Studio 2003
  395. keep formula after typing in a value in a excel cell
  396. Edit Textbox using KeyPress vba code in Access
  397. Combobox
  398. access a cell by it's name
  399. Choose file for query
  400. reading a value from an autoshape 'oval' ?
  401. checkbox to remove recipient from email
  402. auto filter
  403. RE:count time format as decimal
  404. Do Until Code
  405. Email - Outlook no Closing Session
  406. Count by fiil color
  407. VBA ComboBox
  408. Use of Templates??
  409. Creating a Button to add to existing values while subtracting range
  410. set range question
  411. funcres.xla
  412. CopyIntoFirstEmptyRow
  413. Prevent Access To VBA Editor?
  414. count time format as decimal
  415. Run Macro on Worksheet Activate
  416. Ckear Clipboard
  417. Office C# code behin : CommandBar Class Problem ?
  418. Quote in filename causes problem with Application.Run
  419. Formatting text in a textbox to show separate lines
  420. Response
  421. countif with second if?
  422. Use function in xll in conditional formatting
  423. If/Then help in returning value
  424. Disregard last posting
  425. Max WorksheetFunction
  426. Changing a Chart on a Protected Sheet
  427. Tom I Know You Can Do It...
  428. Dynamic LastCell
  429. Hiding a toolbar
  430. C# Excel Automation Add-In
  431. Format Concatenate Entries
  432. Maximizing width of graph
  433. incorrect results when working with doubles or singles
  434. Subroutine Arguments
  435. Insert Row and copy formulas
  436. Pivot Error: Thanks Dick Kusleika
  437. VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN
  438. number of rows in spreadsheet
  439. Printing one or more pages?
  440. Extra save
  441. Excel pictures - saving to a file
  442. vba filter code
  443. Loop through files
  444. repeated question: how to protect sheets from within VBA?
  445. Using user form to change cell value on worksheet
  446. Distributing secure ('er') Excel workbook
  447. Nested If(and(...
  448. Using Data Form
  449. Scrolling in Multipages
  450. Listbox questions
  451. menumaker.xls
  452. UserForm Events
  453. Sorting issue
  454. Selecting cells which do not meet a formatting criteria, and assigning a Range object to these.
  455. Indicating worksheets are hidden
  456. Checkbox to remove recipient from bulk email
  457. Checkbox to remove recipient from email
  458. Conditional formatting in a cell formula
  459. Create Add-In
  460. Close WorkBook with CommandButton
  461. Speed of SpinButton
  462. Determined if filtered range is empty
  463. Import .txt files into XL with time fields-need to calculate
  464. Can't find project or library
  465. Selecting a range in a different worksheet
  466. Q: How to change tab color based on cell value
  467. Before and After Print macro
  468. Formatting Number & Text in same cell
  469. Finding last sheet
  470. Run macro in another workbook with arguments
  471. dropping prefix '0's when creating a spreadsheet in code
  472. Time in combo boxes change to decimals when printing
  473. Re:backup warranty tracking system
  474. return row number
  475. Macro works fine in xl2002 but does not in xl 2000
  476. date formating help
  477. numbered labels
  478. Userfrm Lookup Works For text not Number
  479. Excel VBA problem
  480. "Cell"
  481. Amend a macro by macro
  482. move content line to column
  483. Cell Change Event
  484. Compare worksheets
  485. Get active cell?
  486. Remove last characters
  487. Explain Macro?
  488. Assign code to button
  489. Button from Control Box
  490. Consolidate Data
  491. (Probably) simple question
  492. Run macro on certain day and time
  493. Forcing a macro to (semi-) automatically run
  494. Broken References
  495. Problems with referring to workbooks
  496. Excel 2000 Hanging while reading large file with Line Input
  497. Floating Toolbar Questions
  498. Screen Flicker while processing
  499. Problem when trying to convert one column with multiple rows to one row with multiple column
  500. File Exists Killing Workbook_Open()
  501. Is It Possible To Make A Cell Blink..
  502. Split Function
  503. 1 Question (no work involved)
  504. SpecialCells and a Special Character
  505. Control of Listbox Colors
  506. Invalid use of Null
  507. Help with Visual Basic
  508. TextBox 'ShrinkToFit' oddity ???
  509. Converting strings to Sum worksheet function and control variables
  510. Copy formulas, not values
  511. CONTAINS SPECIFIC TEXT OR NUMBER
  512. Removing external links in Excel
  513. Trouble setting variable as filename with date
  514. Removing "external links" in Excel
  515. Is there a "Before" Open event?
  516. JE McGimpsey & Frank Kabel
  517. Office automation application which will work with any version of office C#.NET
  518. I have an error when a start my macro
  519. Web Access Timeout
  520. Get rows which match selection criteria
  521. Filter columns in Excel
  522. Macro doesn't run on another computer
  523. Transpose
  524. Auto open macros in Excel
  525. Macros
  526. problems with DataForm macro #2
  527. combobox update
  528. Timed Tab Rotation in one Workbook
  529. File Name Exists Error Trap
  530. Moving a row to new work sheet/book if order=yes
  531. excel.exe error when adding controls to userforms
  532. Compare worksheets
  533. Using sheet codename problems
  534. user form StartUpPosition
  535. Variable Reference in R1C1 format
  536. macro stops midstream
  537. Datagrid to Excel problem (ASP dot net)
  538. Chart Series
  539. Universal Macro
  540. Getting results from VBA calculations into cells
  541. Simple Copy & Paste
  542. Save exact copy of workbook
  543. STATUS BAR
  544. Date Calculate
  545. Importing Data
  546. Workbook.Variables?
  547. Add-in functions (some work, some don't)
  548. Adding a toolbar on a form
  549. can i link a cell to jump to a worksheet?
  550. .OnAction with arguments
  551. Opening all txt files in a folder and saving as excel
  552. sheet totals
  553. Query Hangs or Slow Performance after 2 updates
  554. Recreate a macro menu
  555. Button Faceid
  556. Entering data between existing data
  557. List Files as HyperLink through VBA
  558. problems with Data Form macro
  559. Unexpected error (336)?????
  560. Remove data with listbox
  561. Calling SUB
  562. Parsing Text Strings
  563. Key modifier for double-click event?
  564. Retrieving external data
  565. Open File
  566. File Size Increase Controlled, Question
  567. event in worksheet switches to VB code window
  568. For each next choking.
  569. E-Mail Question
  570. Delete entire row if A1,2,3... is empty
  571. Truncating a cell value AFTER the decimal place
  572. Empty Cell Question.
  573. Re: Can I reset an array to myarray()
  574. Excel Instance
  575. Re: Can I reset an array to myarray()
  576. Naming Workbooks and Sheets
  577. copying cells with formulas, but to keep it alike in destination
  578. Worksheet_Change /ActiveCell.CurrentRegion ?
  579. activating excel from VB
  580. xl2002 workbook wont open in xl200
  581. PivotCache memory resource Problem
  582. opening a workbook
  583. Change Excel workbook icon
  584. vba filter
  585. how to sign Excel 97 AddIn
  586. how to protect sheets from VBA?
  587. Excel VBA/Macro - Textbox
  588. Selecting & Displaying An Array's Contents
  589. Excel Web Queries
  590. Re: Dump of all variable contents
  591. stepping down rows
  592. Pivot Table Pain!
  593. ActiveSheet.PrintOut - problem
  594. even/odd returns 1 0r 16
  595. Open dialog in macro
  596. converting date from a textbox to a date format
  597. Embedded command button doesn't respond in new window
  598. Deffinatly need help!!!
  599. Combo/List Box
  600. control in user defined function
  601. Re: Data Validation Prompt Message
  602. Re: I want to *beep* *beep*!!!!
  603. Re: I want to *beep* *beep*!!!!
  604. Excel Chart Event Coding
  605. Trouble with copy and paste
  606. For loop question
  607. FileSystemObject Error
  608. Close Window
  609. Can't Group or Ungroup in Protected Cells
  610. Repost- problem with calender control
  611. string passing to DLL
  612. VBA code in "Data" menu
  613. .additem
  614. no tab index property in VBA for text fields
  615. Save file without prompting
  616. Excel 2000 Protect ... But Free Filter
  617. Open file in directory
  618. vba event
  619. timeformatting and colored cells
  620. Only allowing one open workbook in excel
  621. Dynamic GUI
  622. Problem Reading Delimited File
  623. Hatched page break lines
  624. Excel VBA - clock in buttons problem
  625. Life of a variable
  626. Looking to subtract one list of values from another
  627. Pivot table source data question
  628. New Macro
  629. How to get rid of a VBAProject?
  630. Macros assigned to buttons do not work when copied to CD
  631. on cell entry
  632. Little task
  633. Extract data from SAP to Excel?
  634. Create Object
  635. Best Solution / Ranges
  636. Sub Total Method URGENT
  637. Saving cell content externally.
  638. Refresh Problem
  639. How I can compare numbers in one book to another book
  640. E-mail using Lotus Notes
  641. Macro - code for ranges urgent!!!
  642. Combobox update
  643. Don't update Links
  644. Counting number of lines in a CELL
  645. Run a Macro over a Closed Workbook??
  646. hide and restore personal display settings in excel menu
  647. Web interaction
  648. Use ListIndex to set Sheet order?
  649. ListBox Procedures
  650. survey for the unemployed
  651. How do I make Macro Buttons Transparent ?
  652. Excel VBA Backwards Compatability Problem - 2002->97
  653. Using VB to auto print documents to pdf files
  654. FileDialog Folder selection spec
  655. VBA Code
  656. back up tracking system while we change software
  657. Protection
  658. Command text syntax and comma
  659. Status Bar
  660. VBA Code Help
  661. problem with calender control
  662. Cell Alignment
  663. Extract alphabet from string.
  664. Excel VBA - Delete entire row if all values are 0
  665. personal.xls...attention Robin????
  666. Display the Hyperlink Dialog when inserting Hyperlinks
  667. new to VBA
  668. VBA InternetExplorer ReadyState loop
  669. filling
  670. Problem passing by reference
  671. Problem importing a txt file
  672. Renaming worksheets!
  673. Macro Button To Modify A Cell's Contents?
  674. Excel.Ink missing
  675. Working with FedEx electronic invoicing
  676. dbase
  677. Send Outlook Attachment within Excel
  678. Round to numbers in a list
  679. check for running app
  680. Disable Button when no workbooks are open.
  681. ListBox with hidden and visible sheet names?
  682. How to tell if a range or cell is dirty
  683. Locking down columns
  684. Home Made Conditional Functions
  685. Updating a database query from XL
  686. limit or deny opening other files
  687. Log Password Entry Attempts
  688. Conditional cell lock?
  689. date of update
  690. File association to Excel spreadsheet
  691. converting dates
  692. SQL Queries in VBA
  693. Compile error in hidden module error
  694. Inserting a row
  695. reading statements
  696. Combine sheets into one sheet - Urgent
  697. How do I tell excel to export graphs to ppt and only have to update excel?
  698. Hide details
  699. Conditional Formatting between different workbooks (see details..)
  700. Code writing:Where to start ?
  701. Web Link - multiple instances
  702. Type mismatch
  703. Apply more than one filter in macro/vb code
  704. RE: Ron Helped Once Can you do it again?
  705. Import of Database VB app into Excel Spreadsheet
  706. Is there is a way to tell conditional formatting is on?
  707. Excel VBA - Delete rows within a date range
  708. reference missing?
  709. Re: Excel VBA MID Function
  710. Public variable is reset after addin macro completes - thread/focus pblm?
  711. Inputbox
  712. Re: Excel VBA MID Function
  713. Re: Excel VBA MID Function
  714. TIR function
  715. sheet name as cell : link?
  716. Re: Excel VBA MID Function
  717. Export from Excel to Access ADODB
  718. Re: Find and copy in macro
  719. Need Quick Fix... Find macro Issue
  720. Conditionally inserting blank rows using macro
  721. Copy/Paste
  722. Show Record Macro Toolbar
  723. Will setting Saved = True in Workbook_Open have a negative effect?
  724. Calendar Control
  725. Pivot table: Adding dynamic columns
  726. Excel VBA Form problem
  727. How do I get cursor position and text being typed?
  728. Sort on two columns in two dimensional array
  729. serial port data acquisition
  730. Pivot Table - Page List
  731. MS Query: Break data into separate sheets based on value?
  732. Sort row values descending
  733. Turning Filters ON in a Protected Shared Worksheet
  734. lookup
  735. Dim cell AS range....
  736. Creating a Checkbox inside a cell for each line
  737. tab order in frame control
  738. Get NT Username
  739. Re: Ron Helped Once Can you do it again?
  740. Odd behavior with SaveAs
  741. Re: Ron Helped Once Can you do it again?
  742. pagebreaks
  743. Copying Data into another worksheet using macro
  744. ChartCalculate code causing error when saving workbook
  745. Excel VBA - Check for Duplicate Records
  746. meaning of Dynamic?
  747. Active X Support for Excel
  748. URL too long in Excel (VBA).
  749. Can't change font on conditional formatting
  750. Reset New Collection
  751. Copy method fails in IIS
  752. Hair Pulling Problem...
  753. Forcing Events to happen
  754. Distribute Excel Workbook with licence?
  755. Anyone can help
  756. File kill help
  757. Help with Date checking code
  758. Database Export to Excel
  759. Excel VBA Code
  760. Re:"Insert LineBreak-Macro"Thanks BOB!
  761. login to worksheet from command button
  762. help in selecting cells , VBA in Excel
  763. Need help with an array
  764. Window;1 doesn't display
  765. Displaying a specific worksheet on opening application
  766. Selecting Filtered records only when AutoFilter is on
  767. save worksheet as new workbook
  768. Question number Two
  769. need to disallow pasting into cells directly
  770. SubTotals
  771. Applying two or more filters through VB
  772. curious sheet behaviour
  773. Difference between NEW and CREATEOBJECT?
  774. show all rows containing a date between x and y?
  775. Problem number One
  776. set a default value on textbox
  777. How can I control RefreshAll
  778. UserForm as a Jpeg Image
  779. Range Names From one sheet to Another
  780. data transfer automatically in the evening 6:00 P.M
  781. using autofilter to search 2 columns
  782. "Path/File Access Error" on Sheets.Copy
  783. Comment to the Left
  784. populate chart array
  785. Execute program (macro?) upon opening a workbook
  786. Sequential Record ID for Excel Template
  787. Macro keeps locking up Excel 97
  788. Macro w/filter, copy, paste,& sort isn't working consistently
  789. Protecting sheets
  790. HELP!
  791. Change colour if cell is locked
  792. wats the best way for learning Macros, vba's etc
  793. CopyIntoFirstEmptyRowHorizontally
  794. How to do a function that alters the format of the cell when it is applied?
  795. Download from the Web "MACD" Number into Excel
  796. ASCII Conversion
  797. Combobox
  798. Function for optimization
  799. changing selected label on userform w/ a variable
  800. Macro to run when file is created from a template
  801. Printing Worksheets thru VBA
  802. APR Formula
  803. Command Button Visibility Problem
  804. Samples/Tutorials on Excel Statistical functions
  805. Shifting data down
  806. Renaming all files in a directory
  807. Filling selected cells
  808. Create Excel Document from a Dataset using VB.Net
  809. row number
  810. Import Unique Web Data
  811. Is it to prevent a workbook from being emailed?
  812. Setting File Attributes and Windows versions
  813. Form Controls on a worksheet and Macro
  814. Macro-password
  815. using array to copy formats as well...
  816. A Macro to Do Find and Replace
  817. Multiple Workbooks to a Single Sheet
  818. Re: Excel VBA - Delete Rows with certain text...
  819. Reseting A Spreadsheet
  820. Error trying to set the name of series in a chart.
  821. Re: Excel VBA - Delete Rows with certain text...
  822. Adding Header to multicolumn ListBox
  823. Get Outlook UserProperties
  824. macro virus
  825. Insert a row
  826. AND Headache (with dates)!
  827. Excel and VB
  828. Create UTF-8 file
  829. Macro for Solver
  830. Pivot Table Group by Month Beforehand
  831. Inserting rows
  832. Do I need a two dimensional array for this?
  833. Sending user selected daa from cmblistbx to sheets of destination
  834. Long and Varing Worksheet Save Times
  835. Saving JPEGs Automatically Using Hyperlinks
  836. color function causes save dialog?
  837. Need Help With CODE!!!
  838. ODBC SQL Query give type mismatch in where clause
  839. Inserting Data: Multiple Sheets
  840. How Do I Trap #VALUE!
  841. User Defined Worksheet Functions?
  842. delete garbage from worksheet
  843. Visual Basic Macro For Solver
  844. Visual Basic Compile error in XP
  845. ReDim to store values so they are not used again
  846. How can I set PivotItem.Visible property to True?
  847. Delete characters from a string
  848. commandbuttn ? in 'ThisWorkBook'
  849. Still playing with the "Check" macro...
  850. Changing Cursor in Excel Charts
  851. Compile error when closing excel
  852. Column Number/Letter
  853. Type mismatched in Listbox
  854. Navigating with a macro
  855. runtime error ....object required
  856. why can't i have my VBA XLA post?
  857. Multiple Workbooks
  858. autofilter true/false
  859. Using Filters, Copy and Paste in a macro
  860. Creating Com object for excel using vb.net
  861. macros
  862. Store variable value for Chart
  863. Looping Macro
  864. password problem
  865. Moving one cell over to the right
  866. Protecting/Unprotecting Workbook
  867. creating checkbox through form
  868. How to replace this character ...
  869. How to avoid error 2015 when using ActiveCell.Offsett in own function
  870. TOM O , sample is sent
  871. correspondent in vba...
  872. Excel97 - Worksheet Protection Question
  873. VBA - Passing a FUNCTION as an Argument
  874. Shell to MSAccess
  875. Shell to MSAccess
  876. Shell to MSAccess
  877. Macro or VB to apply filter in spreadsheet
  878. First Question
  879. remove toolbar without excel opened
  880. Problem with optional parameters in Excel Automation Add-in worksheet function
  881. Hiding Drop Down menu
  882. Win32 Registry function usage
  883. Move File When The ...
  884. Nth Root
  885. Passing Values From Command Buttons
  886. A constant update
  887. Efficient STRING search with SpecialCells
  888. Delete references
  889. What type is vbCancel?
  890. Excel 2000 and 2003
  891. Popup Menu
  892. Combboxes and Testboxes
  893. AddIns.Count
  894. userform summary
  895. For Each statement
  896. Changing cell values between columns with macro
  897. Sizing row height automatically
  898. Column Precision Settings
  899. Application.usermane
  900. Saving Recordsets
  901. Returning a string from a function
  902. Crono with excel
  903. Problem updating a ComboBox using VBA
  904. Columns Precision Settings
  905. control toolbar
  906. Re: "Insert Line Break-Macro"-Thanks Bob, but..
  907. xml parser in Excel
  908. Taking Combobox data...
  909. Hyperklinks - passing values
  910. Deselect of Cells
  911. Checking a cell
  912. Finding the current date
  913. 1160 Max Chars per cell ? Workaround ?
  914. Help with Macro
  915. A better way to create this function. To long for Data Validation.
  916. Inserting a Listbox in a cell
  917. How do I reference the cell address next to Active cell - Try 2
  918. Error Handling and Cleanup
  919. Excel programming
  920. Excel 2003 Activex
  921. Protect a Cell in an Editable Range
  922. Path command
  923. How to ask user for file to open
  924. Hide/Delete XL Menus
  925. help with transpose-like macro
  926. A little more effort...
  927. Excel VBA - Macro & ShortcutKey Copy
  928. Making excel macros run Word macros
  929. Finding and retrieving info
  930. macro works separately but not together...
  931. Using DateAdd with a text string
  932. Find Used area of a range
  933. Selecting sheet after Userform
  934. developing an app for the Mac on a w2k box with office 2k
  935. VB error using EXCEL XP
  936. CreateEventProc for OLE button crashes Excel
  937. Array question
  938. a macro problem with a lot of sheets in a book.
  939. VB.NET and Excel Range data
  940. Concatenate with multiple lines in same cell
  941. Desktop Saving in VB
  942. For..Next loop problem
  943. Go To combobox
  944. How to return to selected cell?
  945. losing arrays
  946. User Functions Compilation?
  947. Excel 97 pivot table VBA problem - why has microsoft built in these random limitations?
  948. 'Pulling' rows into sheets
  949. Multiple Col. Selection
  950. scheduling macros for excel
  951. Date validation
  952. Problem incrementing rows
  953. File formatting!
  954. complex cell formatting using VBA
  955. VBA5.dll for Version 6.3
  956. Find active cell
  957. Cell Question
  958. Looping and Filling Info
  959. Sheet count
  960. Step through a Word macro called from Excel?
  961. XL add-in dilemma
  962. Using a collection class to implement mutliple find/replace strings in cells
  963. how 2 launch user form ..
  964. Custom Diaglog Box
  965. tom oGlivy: Linking data ?
  966. Web query question.
  967. Recognizating worksheet name
  968. Increment row change by two
  969. Save As Macro
  970. disabling a command button
  971. Formula/Text?
  972. hello :)
  973. List box data
  974. Iterating through Cells .Net/Excel 2003
  975. hyperlink function verification
  976. Multiple Lookup in VBA
  977. variables in formulae
  978. total populate date
  979. Re: Clearcontents
  980. NetWorkDays in VBA?
  981. pausing a macro
  982. Cycling though all sheets in the workbook
  983. Easy code!!!!
  984. If Statement help
  985. Optimize Slow function
  986. Excel's VBA <> Word's VBA?
  987. Make name Generic
  988. Trying to Open Multiple WorkBooks w/ same beginning FileName
  989. Can't get parameters on macros working...
  990. Using the Excel TEXT function within a VBA program
  991. Determining if two ranges overlap
  992. Removing Addin Buttons on Toolbars
  993. Find
  994. Pivot Table - Hiding Rows
  995. Help needed with writing a formula
  996. Filter and copy entire row
  997. Date Problem
  998. How to automate a macro to run on all sheets in a workbook
  999. VBA help screen
  1000. Import .prn file to Excel