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. Not changing from "City" to "1-City"
  2. Programing help
  3. Moving to next row below a selected range
  4. filling a simple combobox
  5. VBA runs very slow on a Apple Computer
  6. How do i select yes or no in a system didlogue box.
  7. Simple Copy & Paste..Confusing??
  8. Another way to suppress print besides Cancel = True?
  9. Help.. need to change sheet name to whats in a cell?
  10. Determining hard drive space remaining
  11. Series Trending
  12. rounding off numbers with excel
  13. Capital letters in names written by lower case
  14. How to create graph from data in Access tables
  15. Add a label at runtime
  16. automatically insert new row
  17. printing on 3 x 5 cards
  18. How show value of variable by mouse-over in debug single step mode
  19. Select range & copy
  20. Expand All Column Widths
  21. Scroller Incrementation
  22. How to count number of items(cells) in range?
  23. Searching formular
  24. Wish List--Messages on Images
  25. How to Do this Test in VBA?
  26. Syntax Question
  27. Dynamic variables in .WebTables
  28. upload excel file into sql server
  29. X-axis trouble
  30. Copy with ComboBox
  31. Trouble with "target.value" when cancelling...
  32. formulas
  33. write email subject
  34. Multiple If Arguments with Multiple Conditions
  35. syntax for to upper case letters?
  36. Calendar Control
  37. Loop Code
  38. Converting column letters to numbers
  39. Macro that shows a cell address when pressing the down or up key
  40. Locking all cells
  41. VBE Options: Disabling Debug Option on All Errors
  42. Unprotecting Sheets with VBA and IRM
  43. Locking cells
  44. Display text and use a formula in 1 box
  45. Get Macro to work on MAC
  46. Terminate Excel with a Macro???
  47. complicated sum formula question
  48. Checkbox control on userform
  49. Showing a userform
  50. VBA date errors
  51. How to fetch rows of data across sheets dynamically
  52. Formula for counting customers waiting to be served
  53. Need Help
  54. run a macro automatically upon opening an XLS file???
  55. Delete named ranges beginning with a string
  56. Data Validation between open Workbooks
  57. vlookup question
  58. identifying errors
  59. Syntax for multiple if statement
  60. Change a cell's color based on return value of a formula
  61. Removing section of a string in VBA
  62. Change Event Endless loop :-(
  63. an excellent time waster
  64. Automatically Format Range of Cells
  65. If statement syntax to see if Worksheet_Activate code exists
  66. How to read from a closed workbook?
  67. show and hide a picture
  68. Formula Set Up Needed
  69. lookup klient address
  70. User Form Initialize Event Issues
  71. Selecting the Second largest number
  72. What am I missing here
  73. Re: Autofill datasheet using filter
  74. Reduce picture file size, KB's, with VBA
  75. Change Routing Message...impossible to figure this one out
  76. How can I make the print icon trigger customized macro?
  77. sql query in excel
  78. How can I speed up my VBA simulation??
  79. Does VSTO 2005 support mailmerge?
  80. To find empty cell
  81. RE: I am looking for a date add-in using a calendar
  82. ADODB Connection Problem
  83. is there a way to save pictures in worksheet as graphic filse elsewhere?
  84. How do I make a macro call on different macros
  85. Changing VBE WS-component name in code craches excel 97
  86. Import Text Issues
  87. VBA Apllication.run and macros when spreadsheet name changes
  88. TextBox and Time
  89. Run a sheet's activate code when entering it's workbook
  90. Conditional select and paste
  91. Disable Cut, Paste, Drag & Drop in Protected Workbook
  92. Prime Numbers
  93. How to move records from one folder (tab) to another
  94. Last Selection from MultiSelect Listbox
  95. checkbox on form reset from checkbox on sheet
  96. excel presentation template that has company info, financials etc
  97. Adding a "1" in front of everything in column A
  98. Count duplicates in an array?
  99. VBA - Formula Update Assistance
  100. VBA - Formula Update Assistance
  101. i want to add up numbers from different pages
  102. InputBox to capture user selected sheet names?
  103. Left Function in VB
  104. Delete rows from a protected sheet (write macro)
  105. Wierd variable values problem
  106. Determine whether a character is Upper or Lower case
  107. Forecasting/Estimation using arrays
  108. counts rows in data
  109. Calling workbook and worksheet
  110. Name a cell as a number in Excel
  111. OLEObjects.ADD causes excel vba project to stop / reset / go dead
  112. If a cell value is today's date, than increace cell value by one
  113. slecting data???
  114. A Faster Way to Write Values
  115. Saving a template as a worksheet
  116. Copy to different workbook without opening it
  117. Create a new Worksheet
  118. On Click Event
  119. Covert UTC date
  120. Confusing Macro and references....
  121. User Form and Database Queries
  122. Set PivotItem using counter
  123. Daily new data input
  124. UserVal default value
  125. Code somewhat works. Please help?
  126. Trouble formatting Row Height while using a Copy/Paste Macro
  127. Sub ConvertCellFormulaToUseOffWorksheetNames()
  128. Retrieve Data from SQL database Programatically using Excel VBA
  129. Input box
  130. textbox on user form
  131. Setting Background Color RGB (Always goes to closest index color)
  132. Write formated excel values into text file
  133. Error “This operation requires the merged cells to be identically
  134. Email Copy and File Not Found Message
  135. date problem using .xls in Access2003 via OLE DB connection
  136. Subscript out of range
  137. Similar to VLOOKUP?
  138. Transfering data from sheet1 to sheet2
  139. Unwanted duplicate styles created
  140. application.wait help
  141. Macro for Changing Cell Background Color
  142. Appending to fields
  143. range calculations
  144. Search Excel files for text and keywords?
  145. Sorting Named Range
  146. Excel as an email client
  147. Get text from clipboard
  148. macro for all open worksheets?
  149. Change event occurs
  150. group rows
  151. workbook searching
  152. Simple on/off swith to turn macro on/off?
  153. Excel and ODBC
  154. VBA How do I set a value in a cell?
  155. File signature
  156. Macro to update contents of cell
  157. Working with ActiveX DLL
  158. Inserting new column between the columns
  159. simple help with comparing dates in excel
  160. transfer data between sheets
  161. Excel XP and WorkbookBeforeSave
  162. visual studio
  163. Speed up Excel execution
  164. create file for excel format and api needed for it
  165. create file format using vc++
  166. Columnbound?
  167. How can Excel vba detect if Caps Lock or Num Lock is on?
  168. Append Records to a Text File
  169. Public variables and scope
  170. needs to run faster
  171. Insert row here ... or not
  172. Functon to fill cell with color
  173. Time tracking
  174. Excel color palette on user form?
  175. Fetching rows across sheets dynamically
  176. adding formula in empty row
  177. another combobox question
  178. how can i export information from an omniform database to excel?
  179. wildcards in replace
  180. Convert to number
  181. Type mismatch using rnge as Range with Type 8 Input Box
  182. vlookup in combobox
  183. Creating multiple sheets - new to programming
  184. How do I set a number cap for a cell?
  185. a on_doubleclick statement is not working
  186. Autofilter macro
  187. How to insert a page break in Excel VBA
  188. compact MS Access while list box connected to database in spreadsheet
  189. Copy form field value to another form (calendar)
  190. Convert text to hex
  191. userform question
  192. E-mail Multiple Attachments
  193. If Statement
  194. Automation Error when upgrading from 2000 to Office XP
  195. Command line switches.
  196. add a formula to one cell by entering text in another cell.
  197. Copying range to variable number of rows
  198. How do I send a xl-sheet as a mail using a VBA-script?
  199. Copy & Past from multiple sheets to one
  200. Find variable cell text in another range
  201. Pivottable Qtr's
  202. Provider Issue with Version Change?
  203. Locate Excel files by searching for key words?
  204. Inserting a list of numbers then retrieving an output
  205. Please Help with this Macro.. Urgent...
  206. import data from close excel file
  207. Cell formatting through VBA
  208. Runtime error 424 object required on Set Statement
  209. Assistance with variables defined outside of macro
  210. Setting values by row color
  211. Web Access
  212. combo box help
  213. Comparing ranges
  214. List box to data list
  215. Would like to select more than one item in a list
  216. Add Comment Problem
  217. how can I execute stored procedure to download data
  218. lookup
  219. DAO recordset Call to SQL Stored Proc
  220. Autofilter in a userform
  221. How to get Excel to retrieve aggregate data from Access
  222. Range Name in Data Validation
  223. Column Restrictions
  224. Export to Access
  225. How do i translate OLE error messages in Excel to Access?
  226. Format when sending a range as parameter to a custom function
  227. Macro Special Paste - Value
  228. named range problem
  229. convert a List from a range to a single text cell
  230. IF formula with subtraction
  231. Help with taking formula to vba code
  232. Could you tell me the AdvanceFilter where is error?
  233. Add data to comment more than one time
  234. Coping Contents of one Sheet into Another Workbook
  235. IF Function - formula creation
  236. Controllling Display Updating
  237. Populate combobox from external source
  238. Home or Ctrl-Home
  239. how can I force excel to insert row after with my macro
  240. Sort and Copying
  241. Need formula to calculate lenght of a roll. I have all info.
  242. Run Macro On Multiple Closed Workbooks
  243. Help with this macrosheet
  244. Selection type
  245. Paste into opened notepad file
  246. Help with creating a formula
  247. refresh data from a intermediate excel data file (not opened)
  248. 500m, 500b, 500t, function?
  249. Macro Command
  250. VBA Formula Question
  251. Simple cell reference not blank
  252. My VBA Function Won't Recalculate
  253. Problem With this macro table
  254. moving State Data
  255. Copying records from sheet1 to sheet2??
  256. Programming Keyboard Commands in VBA
  257. Delete rows between two dates
  258. Automatically moving rows
  259. Importing Data from Access
  260. How to Disable the Design mode of EXcel Sheet....
  261. Moving Files
  262. Need advice : consolidating data from multiple CSV files in Excel - External data handling
  263. Capturing Formatting from an Excel Template--Can It Be Done?
  264. Autofilter - =string in selected cell
  265. Can the title of columns be stationary?
  266. array questions
  267. Questions on passng data between UserForm, Module
  268. file append & opposite #2
  269. Excel crashes when program changes VBComponent name: Excel bug or what?
  270. Replacing part of a cell text
  271. VBA, SQL, and multiple versions of Excel
  272. Importing data from multiple closed workbooks
  273. writing a formula
  274. Excel VBA - Compressing a Workbook
  275. AppActivate - workaround if app's title bar not known 100%
  276. How to change the value in different rows using the same cell to e
  277. Copy Workbook
  278. How do I display a description in the function wizard for custom .
  279. Any Help with a Simple Function?
  280. Workbook Open/BeforeClose Problem
  281. Final Value, For / Next Loop
  282. how do i maintain named range addressing after deleting row?
  283. Can I start a macro based on cell input value
  284. Filling a WS from a UserForm
  285. How can you split an Excel file
  286. Creating event procedure on worksheet
  287. Creating event procedure on worksheet
  288. Printers
  289. Cycle through data validation field and print
  290. Re: How to retain collection in function?
  291. Offset based on column heading
  292. Edit Query
  293. Template for 40-year quarterly cash flow mixed with some monthly flows
  294. Help with macro!
  295. linking spreadsheets
  296. Re: Date Calculation from a Due Date
  297. SAP BW Report - Putting the Unit of Measure or Currency in another Cell based on Format Cell
  298. Any parameterized queries for Access from Excel VBA examples available???
  299. Do Loop Until
  300. How to Calculate Peak and Off Peak Hours
  301. Re: Macro sends Excel file by Outlook - works in debug - not realt
  302. Error handling.
  303. RE: Date Calculation from a Due Date
  304. excel 2003 having problems pulling top table from web query
  305. use the contents of a cell in a function ... ??
  306. Error “This operation requires the merged cells to be identically
  307. conditional formatting:highlight row based on blank or non-blank c
  308. An easy one: Help with some VB funct about list and filter
  309. Password - hyperlink or macro?
  310. Validating cells left blank
  311. d
  312. calendar control 10.0
  313. incorrect displaying of "alt-enter"
  314. VBA for Clearing data from the worksheet
  315. Listbox value return from search
  316. Any way to get new instance of Excel on double-click?
  317. Do I have to use VSTO to program Excel2003?
  318. How do I create a new table below the last one
  319. Return Cells With Border Only
  320. Hide or unhide one or two autoshapes
  321. mutiple formulas .
  322. Selecting Columns by Title
  323. loop through autofilter dropdown
  324. Update Adobe form from Excel
  325. loop through autofilter dropdown
  326. how to get a list of entries onto a form listbox
  327. Organizational charts
  328. userform validation?
  329. Pivot Grand total on Selected columns only
  330. Auto Open Macro
  331. Error Handling
  332. unable to get the Interior property of the range class
  333. How do I copy a table from Excel to Word or a chart to Ppt in a ma
  334. Initialize an array
  335. Multilevel Ranges
  336. Add-in with Solver Reference Issues
  337. Need VB Code Help
  338. C# programming - Getting number of last non-blank cell (column) in a row.
  339. Creating Column Headings from XML Categories When Linking Data Wit
  340. Help with Macro
  341. RE: Transferring Excel Spreadsheets into Access
  342. Is there a way to find all the XPaths in an XML file?
  343. Problem setting Charttitle in VB
  344. Get cell string to text file
  345. Remove blanks from text
  346. Quick Form for updating a range?
  347. Calculate the total amount by date
  348. Tab name into a cell...
  349. SaveAs with special conditions
  350. Saving a workbook within VBA without executing events
  351. RE: Copy a Range from sheet and paste the next blank line in anoth
  352. RS232 probs, help needed!
  353. Named ranges wont expand after sort??
  354. date and time entered when a cell contains data
  355. How to view the dimension of an open array in VBA ?
  356. Coding a splash screen to require macros enabled
  357. Display large amount of text in form
  358. Dictionary object: Error assigning user defined data type to item
  359. Multiple change events on same sheet
  360. Unprotected cells becoming protected
  361. Excel Dropbox Help
  362. select Range Code
  363. Save File with the current date and time.
  364. syntax to go to a named range
  365. Run a macro at a cretin time of day
  366. Macro to Print several worksheets
  367. chart secondary axis crossing with x axis
  368. Adding times
  369. VB code help
  370. last entry from selected area
  371. Stopping formula computations during entering data...
  372. Update PivotCache
  373. Database problem
  374. How to know which user is having permissions on the different system folder.
  375. Creating Page Break in Print Statement
  376. Index/Lookup problems
  377. Pivot bloat?
  378. Problem following hyperlinks
  379. How to Protect my code without anybody seeing
  380. Re: Command Button Macro Sheet>New Workbook
  381. Month View control to disabled specific days
  382. Fetching row data across sheets dynamically
  383. File Append & Opposite
  384. Windows API to get network username of person with file open
  385. Windows API to get network username of person with file open
  386. using EVALUATE to change text to uppercase
  387. Fill cells with x's between 2 specific columns
  388. Importing macro during run time
  389. Insert Textbox values to seperate rows/columns
  390. unable to get the excel app event trigger for for window resize
  391. Break apart in long excel spreed sheet
  392. How to trim a character from a cell ?
  393. simple copy column works but ERROR!
  394. Re: updating a list
  395. Conditional Formatting?
  396. Excel 4 macros to VBA?
  397. Syntax for Select Case
  398. Set color of data in unprotected cells to blue
  399. Calculate
  400. RE: macro code for grouping adjacent cells into one multi-line cel
  401. PivotField select all
  402. RE: macro code for grouping adjacent cells into one multi-line cel
  403. hnjk
  404. Using excel to insert autocad blocks?
  405. Re: Transferring Excel Spreadsheets into Access
  406. Re: VBA cell ref problem
  407. VBA Code to query Access DB
  408. Re: Error 448 - OOps ... herewith the code
  409. references
  410. transfering from Excel to Access
  411. having probelms getting my loop to terminate on an array value read from an empty cell
  412. select columns by variable
  413. Using condition to extract data by matching values from 2 different Excel files
  414. Forecasting with arrays
  415. Max size of variable?
  416. Basic question for blank column
  417. Problem: Excel drops significant digits in copy value function...
  418. spreadsheet range selection
  419. Looping Question
  420. Range text vs Range value
  421. Select filled cells/rows in a spreadsheet
  422. Conditional Addition
  423. Conditional Addition
  424. stop running code
  425. multipage - option buttons disappear from frame in Excel 2003
  426. 2000/03 Compatability Problem
  427. edit the contents of a cell using a macro
  428. Can someone help w/a simple macro?
  429. Replace using Do loop
  430. Excel 2003 file opend in Excel 2000 - Compile error in hidden modu
  431. pivot table field dropdown list
  432. macro to open a cash register drawer
  433. Activate workbook
  434. VBA for Data Validation
  435. Verify Active Cell
  436. Minimum Scale on Chart
  437. "Unable to Record" error
  438. Ending a macro?
  439. array problem
  440. Statusbar messages stop updating
  441. Create my own Class Object for Ranges, having trouble assigning name property
  442. Ping Server Excel Macro
  443. Entering Data on each Sheet in Workbook
  444. Printing a sheet with macros..
  445. Excel in Visual Basic
  446. 2D variable array
  447. Selection of Range Class Failed??
  448. 2000 / 2003 Compatibility
  449. Named range not expanding with insertions after sort??
  450. If then statement causing value issues in Macros
  451. Excel with ASP Error
  452. do ... until loop issue
  453. Simple Copy-Paste logic not working
  454. combobox in a menu
  455. saving a sheet in a new workbook
  456. Multiple Listboxes - Listbox2.value doesn't get set
  457. Multiple change events on same sheet
  458. Importing spreadsheets
  459. Launch Acrobat from Excel?
  460. pass an excel cell value to a web query
  461. removing unwanted VBAProject
  462. Applying a Workbook's Names to Another Workbook
  463. Web Screen Scraping
  464. Distributing a UDF
  465. No screen updating in Workbook_BeforeSave event after ActiveWorkbook.Save
  466. Using VB to type something into a cell
  467. Systematically Importing Data to Excel
  468. file removal before Excel closing
  469. Print Macro in excel
  470. How do I compare data in 2 workbooks
  471. "File Error: data may have been Lost"
  472. Opening a Word and/or PDF document from Excel
  473. Searching for Boolean Cells
  474. QUERY: auto clean VB code editor?
  475. Deleting a workbook from Disk
  476. TextBox Font
  477. Help with writting macro
  478. CTRL +BREAK
  479. Pivots
  480. inputbox info = filename
  481. Do anyone know to validating rule for checking the Hong Kong Identity Card no
  482. Vlookup
  483. Text to Columns with multi-character delimiters
  484. How do I ignore a character in a cell?
  485. Spell Checking a String
  486. Zoom in out - Increment 10%
  487. Averaging Error
  488. comboboxes, userforms and class modules
  489. Copy enabled / Pasted disabled
  490. Access Cell name in VBA code
  491. Buttons and Sheet Protection?
  492. How to use VBA read entries from a Wrod file into Excel
  493. scrolling panes to the right
  494. Macro to open *.dat files and save as .txt (comma delimited text files)
  495. Sending an email from Excel attaching the workbook they are in
  496. Office 2003 Compatability Problem (I think)
  497. Sql Query
  498. download web content into excel
  499. how do I create event-activated macros that check every cell?
  500. Compatability Problem with Office 2003
  501. RE: Get path of open workbook
  502. two things at once?
  503. How to get x,y coordinates of point from scatter chart in VBA
  504. Format Cell Colour/Font with VBA
  505. Display tips in function wizard
  506. XP problem
  507. What's wrong with this
  508. Macro Problem
  509. remove beginning of data
  510. Error send mail with CDO
  511. Macro to copy into Comments pop-up
  512. Write a Listbox list to a dynamic range
  513. PDF TYPE DOC INTO EXCEL
  514. live link
  515. Excel 2000: VB code for changing caseof text
  516. skip some code
  517. Copy/Rename XLS and Macro References
  518. Printing-But not showing the page
  519. Error on submitting an Excel Sheet using Outlook
  520. Filter problem
  521. rounding
  522. References in VBA (Tools - References)
  523. VBA to name worksheet
  524. Error 91
  525. How to remove the row totals in pivot table?
  526. Updating links display
  527. syntax question
  528. How can I read a gif file?
  529. hiding sheets
  530. organizing procedures
  531. In Excel 2002 macro, go to cell in current row.
  532. vba code protection
  533. filisystem again
  534. amortization schedule with mo. pmts, but interest calc daily
  535. sort problem
  536. new excel vba functionality
  537. What has changed?
  538. Opening Powerpoint file from Excel
  539. How to disable a button picked from the Forms list.
  540. smtp server
  541. Replacing Text in a Cell Reference
  542. Macro for new column
  543. Copy worksheet values and formats into another workbook
  544. Declaring variables
  545. Read Only Notify Option
  546. Choose two numbers
  547. Updating Function
  548. Add message box to confirm run macro
  549. How to disable annoying "Enable Macro" popup
  550. Macro to edit text string data input
  551. Macro to find a range that varies.
  552. Visual Basic New Project dialog box
  553. Function is not available on a protected worksheet
  554. use the current time to return a value
  555. Pass variable to macro
  556. Code to see if Comment Exists
  557. Remove Blank Lines
  558. Speed up pivot table VBA code, avoid multiple recalculations
  559. Can it compress to be equal size?
  560. Importing Data Via A Macro
  561. Assistance with LASTROW function in VB
  562. excel.exe is not terminating from task manager
  563. error code while opening a workbook
  564. Conditional Calculation
  565. Loop in sheets
  566. Count Value And Blank Cells Value.
  567. [Excel, VB6] Encode text before sending to Linux server
  568. Cell Charecter Limit
  569. need an income statement forecasting worksheet for future years
  570. where does it go wrong?
  571. Can I import a calendar into excel 2002
  572. Excel Columns Autofix
  573. macro read xml file
  574. clear column
  575. highlighting cell
  576. Message - Selection contains empty cells
  577. code an input field that asks for current date
  578. VBA - Worksheet Subtraction
  579. WANT TO CHANGE EXCEL
  580. About form messsage
  581. How show value of variable in single step debug mode?
  582. Match font color works ... but
  583. Late Binding to Outlook Web Apps 2003 from Excel 2000
  584. Data Query Problem - PLEASE HELP!
  585. Excel VBA via ADO connection
  586. what is microsoft-excel
  587. cell adressing
  588. Check if a worksheet exists
  589. Much help needed on conversion!
  590. General Protection Fault
  591. macro to send excel sheet to specific email address
  592. Print Function
  593. Newbie question!
  594. Date format issue
  595. Constructing a path to open file
  596. Single or Multiple Cell Selection
  597. Global Variable
  598. VBA Printing
  599. Commandbutton
  600. Simple DDE from Word to Excel
  601. Loop through specific worksheets
  602. Not the right place for this Question
  603. Opening a CHM file
  604. Date and time entry
  605. New to VBA - Multiple sheets
  606. Modify to ignore the first row.
  607. For Each not workig correctly
  608. Posting Data To Excel Spreadsheet
  609. if cell value matches then copy another cell
  610. vba - output Selections from worksheets
  611. Excel 2000 - Microsoft Investor Stock Quotes.iqy no longer works?
  612. Global Variables
  613. Error Message in Loop
  614. VBA - Hex Number Thinks Its Scientific
  615. Lock Project for Viewing..HELP ME
  616. VBA - xl Prefix
  617. Placing data on worksheet
  618. digital signature parameters
  619. Obtaining Checkbox Name
  620. Custom function does not fire
  621. Data Entry-Cell selection
  622. Data Entry -Cell selection
  623. Data Entry Form : Cell selection
  624. Find second blank row
  625. Hiding tabs and menus, toolbars, etc.
  626. Data Entry Form
  627. Excel QuickBooks workBook
  628. data entry - cell selection
  629. Selecting a cell
  630. Data Entry form
  631. Asigning a variable to the Name of a Label in a UserForm
  632. How to limit access to sheets ?? HELP ME
  633. XLS - HOW Do I use the results of a formula to create NAME to vlookup
  634. How to get the last cell within a selection range?
  635. Can I identify a number from text in a list?
  636. NEWBIE QUESTION
  637. VB code gone missing
  638. input box date type mismatch
  639. remote reference update
  640. copy values from one column to another with criteria
  641. Sort Problem
  642. vba language
  643. Search based on TextBox
  644. Excel QuickBooks workBook
  645. immediate window
  646. Can I automatically select the number of pages to print?
  647. Pasting TextBox values
  648. How to find date in a range?
  649. Calendar Control
  650. Date last modified macro
  651. Late binding issues with Excel and Outlook
  652. Whether unknown does VBA achieve?
  653. Month and year programmatically in a cell?
  654. Formula in only one of many cells not updated when row programmatically inserted above
  655. Lookup & return data from ascii text file
  656. microsoft query formula for date
  657. check if file with generic name already open
  658. OnAction problem
  659. Validation add method fail when programming Excel with VBA
  660. Excel macro
  661. Is this possible??
  662. web query in excel
  663. Nth_Occurence User Defined Formula
  664. Combobox
  665. Disable selection on a new workbook remotely?
  666. Ideas" to convert Horizontal to Vertical
  667. How to:
  668. Macro in Excel 2003
  669. Retrieve value using vb6 from an excel workbook - precision question
  670. Variables
  671. Application level events
  672. Counting
  673. Finding a value and copying the formula from an adjacent cell
  674. can you help me set up a macro
  675. Run-Time error 462
  676. chart your data automatically
  677. Inventory Cards
  678. getting access data base into cells of excel
  679. Across application pastespecial
  680. Interop and VS Behavior
  681. pasting to sheet without actually going to the sheet
  682. Date Format....more questions from a beginner
  683. Autofill Macro
  684. Creating hyperlinks to network files
  685. How can I change the type of data
  686. Convert a UDF to it's value when copy sheet
  687. help file?
  688. How to Eliminate the first 2 digit out of 10 digit number
  689. If cell = cell +/- 1.5
  690. How to add one digit "0" in the front of a number
  691. XML Function
  692. How to know Autofilter is on
  693. VBA - Timing A Block Of Lines
  694. Worksheet_KeyPress event ??????
  695. Location of Add-in's
  696. Please help a beginner....
  697. Event procedure on program restore
  698. macro over range, deleting blanks
  699. Private modules and global variables
  700. VB.Net and Excel Object
  701. select cell rather selecting entire row
  702. Moving changing data
  703. How do you run macro automatically each time workbook is saved?
  704. GoTo from a form button to a macro
  705. Excel 2002 test please
  706. Validating in VBA
  707. How to automatically change number of pages to print?
  708. Re: Sorting the order of sheets by the name
  709. Sorting the order of sheets by the name
  710. Date Formatting
  711. Delete rows based on Cell name
  712. XL2003 Macro Visibility
  713. Textbox date
  714. Help with userform
  715. Problem saving to network drive
  716. How to display =x/y result in a user form
  717. Merging files
  718. How to start a VB6 program form Excel VBA macro code ?
  719. Excel crash - bug macro?
  720. The RPC Server is unavailable.
  721. Code runs in wrong workbook?
  722. Modify Paste Special to choose absolute or relative references
  723. Increase Fotter Caracters
  724. Advanced Filtering
  725. Format text - Event
  726. Implementing Binary Comparisions for a class objects
  727. Optionbutton help
  728. selective sheet formating
  729. is there any function to convert the numeric number to words
  730. If Value in Range then Delete Column
  731. pivot chart suppress zero value
  732. pivot chart
  733. Sum of value if column contain specific value
  734. all user defined cell format del using macro
  735. Importing Text to Excel
  736. Help With Range Names Please
  737. all user defined cell format del using macro
  738. Email Workbook w/o MS Outlook
  739. position() in XmlDataQuery
  740. Using position() in XmlDataQuery
  741. From Column D to D:G
  742. Don't want date to update
  743. sETTING A SPECIAL FORMAT
  744. Calculating 30 hours in a day.
  745. Create meeting in outlook from Excel vba
  746. can do it with vba?
  747. Stopping blank cells with formulae in from printing
  748. Immediately jump to next cell?
  749. Problem displaying a calculation result in a user form
  750. RPC Server Unavailable
  751. programatically selecting columns
  752. Write code to Write Code
  753. How to Past an Image from Excel 2000 into MS Outlook 2000
  754. Eliminating Cut-Copy/Paste Options
  755. Language accents
  756. Can any one help me out vbeditor for excel
  757. purge all names
  758. Error with OLEObjects
  759. Exit an entire task ?
  760. assigning values to array
  761. Works as Macro but not in code
  762. assigning values to an array
  763. Selecting a number of rows based on the content
  764. what is happening whit my controls
  765. Getting a List of File Names
  766. Help needed with macro: Writing contents of two cells to two new columns
  767. To run marco at a specific time in the day
  768. Excel.exe is not Closing
  769. Could this be done??
  770. Cell Tabulation
  771. Display Goto Special Dialog
  772. Convert time to running pace per mile
  773. comparing data
  774. Moving Changing Data to New worksheets
  775. Macro taking out all external references
  776. Code only runs once
  777. Web Component Scrollbars
  778. Grrrrr
  779. ListView Question
  780. compare delete and copy lines
  781. Userdefined Function and recalculatiing XL 2k3
  782. Hiding specific column on all worksheets
  783. Separating Business Logic from User Interaction (Userforms)
  784. Add attendees from excel vba
  785. Migration from Excel 2000 to 2003
  786. Control the Series Sorting of 10 bar charts?
  787. save automatically 1st sheet only
  788. Coulmn Fields delete.
  789. Hyperion Essbase add-in macro
  790. autoupdatesavechanges doesn't work
  791. Input box fields
  792. prevent warning message from appearing
  793. How do I create list validation from code without the text being converted into date format?
  794. lastcell in thiscolumn function error
  795. share + macro
  796. Using Tab-Stop in between textbox components
  797. Insert row on change of field - with input selection - not whole column
  798. Find last row in column D then Sum
  799. Find next without activating First cell Address
  800. Selecting a cell based on a criteria
  801. Run-time error '1004'; Method 'Export' of object'_Chart' failed
  802. Rename Sheet Event
  803. Moving data from SQL Server to Excel
  804. VBA visible property
  805. macro to enter variable in combobox
  806. Excel 4.0 parser
  807. Using position() in XmlDataQuery
  808. Set curser to Same position on open
  809. Data Tables
  810. Why doesn't ths VBA Code work?
  811. Write Listbox selection to Multiple cells
  812. Checking/Setting a reference on open
  813. If Then not working
  814. Paste if criteria met
  815. Updating Name References in Sheet
  816. .Foundfiles Question
  817. Data navigation macro
  818. copy worksheet to a different workbook
  819. How do I code a print module to duplex?
  820. Worksheet_Change even code will not run
  821. DLL c++
  822. VBA: move to the next cell down from anywhere in the sheet
  823. Run time error on Userform Show
  824. How to count the number of cell changed since yesterday?
  825. Error opening files from a list in a spreadsheet
  826. Printing 3 sheets with VB and new to this
  827. Add-in recommendations please
  828. Moving Data to new tabs within a workbook
  829. Merging Two Codes Into one code
  830. Help with a Macro
  831. Auto cursor advancement in Excell after numerical entries - acros
  832. Need advice - creating html pages
  833. Using an Excel 2003 Macro on Excel 2000
  834. Syntax to define sheet name to use in VBA
  835. selecting a column in XL
  836. Data series and LegendEntries order reversed in clustered bar chart
  837. Remove Duplicate Array Items
  838. data validation?
  839. How can I change sheet tab color based on cell value in sheet?
  840. Capture Pivot table filter count
  841. GetOpenFilename ERROR
  842. copy sheets in workbook to new workbook
  843. =INDEX(on Range Name,match1,match2)
  844. playing a sound in a macro
  845. Prevent user from customizing menus in Excel.
  846. HELP: compile error message
  847. Disable Save under Excel 2000
  848. Set the security level to high
  849. HELP! run-time error 424
  850. modify without unprotecting the sheet, Unsolved question
  851. delete and shift up
  852. determining datatype
  853. IF-THEN to skip portion of macro
  854. Clean Up Phone and Fax Numbers
  855. Identifying the Selected Cell
  856. Auto Select from Data Validation but allow override
  857. End Macro If Cell Formula produces "#VALUE!"
  858. TOGGLE BUTTON on userform problem
  859. Help with ComboBox
  860. How to use VBA to set "update changes" automatically every 5 min on a shared file?
  861. Advice on Approach to Convert List of Dates into a Calender format
  862. Moving the cursor position
  863. Deleting code at run time
  864. Uploading data from Excel to Access
  865. Forms menu button question
  866. Excel error when updating a workbook.
  867. SUMPRODUCT - NO SUMPRODUCT!
  868. Entering formulas via VBA
  869. VLookups data updating before WorkBook_Open event.
  870. Error -2147417851 - Excel 97 - Windows XP
  871. Accessing data on Excel Spreadsheet
  872. Textboxes
  873. Visual basic excel application
  874. Don't open Personal, but keep macros available?
  875. Formula to return initials of a name
  876. Automatic Numbering of Job Card, Insertion of Date and Time into Selected Cells
  877. HowTo add a period to front of EVERY text cell in a Excel column
  878. Find in another sheet
  879. Accessing same cell in multiple worksbooks
  880. Problem with Evaluate
  881. Break up strings into separate cells
  882. Finding values
  883. opening files with vba
  884. Putting a space in an R1C1 formula
  885. Excel Name object bug
  886. Sporadic errors when saving to network drive
  887. Event Macro
  888. Searching for a string and then performing an action if present
  889. vb code - automatic transfer of data from one sheet to another
  890. Auto Serial Number Using VBA
  891. complicated... not for the faint hearted
  892. Send a fax from VBA
  893. I want to place excel file in some other domain.
  894. Searching Cells in Excel
  895. Deploying a application which uses Excel primary interop assemblie
  896. Listbox Headings
  897. Printing
  898. ListBox display bug
  899. Import structured data from Word
  900. Problem with matching pasted cells
  901. Remove Defined Names
  902. Geodetic functions with English documentation
  903. List files in a folder
  904. Strange problem with formulas...
  905. cant add a column in vb code
  906. Call Sub from Function?
  907. Lunar or Chinese Calendar
  908. Counter in Excel template
  909. sumproduct or sumif in vba
  910. checking file already open status
  911. Auto Populating/ formating Fields
  912. I am looking for a good golf tournament program for excel
  913. Transferring Word table data to Excel sheet
  914. Problems using Add-in
  915. How can I include a cell's value in a worksheet header?
  916. How to clear clipboard content programatically
  917. Copy entire row if....
  918. Macro - Set Print Area for Changing Data Area
  919. Getting error 1004 trying to write formula in cell
  920. Last row - Selected Column
  921. Method 'OPEN' error on some PCs
  922. Excel and Works should add hours and minutes over 24, no seconds
  923. Can you instantiate classes without hard-coding class names??
  924. Change Sheet Name
  925. Counting checkbox values
  926. Can I get the inserted picture's original filename.
  927. Email VBA Code
  928. Retrieving Cut/Copy Border Address
  929. Password Crackdown
  930. Problem with Msgbox Code
  931. Macro If statement to go to a specific cell in another worksheet
  932. Checkbox from toolbox
  933. .AddDataField: is there a similar "replace" data field?
  934. How to end loop after two loops?
  935. Forum for C++
  936. Input data in an excel table
  937. using =month(c2) if c2 is blank returns a 1, which messes up data
  938. modify without unprotecting the sheet, array with wrong format
  939. Print out a "Help" sheet included in an addin
  940. Error when entering a formula
  941. Workbook protection and Pivot table on the fly
  942. Books for learning VBA
  943. Creating an Excel Add-In
  944. Using forms to store data
  945. Exporting Excel
  946. Setting a sum formula
  947. Making and Outline
  948. Page Break Macro
  949. Page break Macro
  950. Copying multiple sheets to another workbook
  951. macro to create a pivot table
  952. how to get my button on a for mto change color
  953. modify without unprotecting the sheet, array with wrong format
  954. Excel to Access SQL problem
  955. New at VB, need help implementing simple commands...
  956. blinking button
  957. Want Help Converting Excel Links to Named Cells (i.e. 1 cell Ranges)
  958. VB protection problem
  959. Separate Variable Range of Data into Different Worksheets
  960. Pivot Auto Refresh Help Needed
  961. database in excel problem
  962. Save range from one workbook to a new workbook
  963. Load anther microsoft application from excel
  964. VBA for deleting a sheet
  965. Open an Excel file automatically
  966. Trim Function... does not work?
  967. Drop-down list triggering the wrong routine
  968. Converting excel currently in english to spanish
  969. SQL Millisecond date to usable excel timestamp
  970. Sort a Range in a Hidden sheet
  971. Move data from rows to columns in Excel
  972. powerpoint into excel
  973. Cannot show, import, export userform: error &H80004005 / component is not corretly installed
  974. Add or Delete row as per enter
  975. Recordset's RowID as part of Recordset
  976. Type Mismatch Error when using InputBox Method
  977. trendline equations inserted directly to a cell
  978. create master worksheet
  979. retrieve text from table in .doc file
  980. calendar control for excel 2002
  981. Delete Rows - Must be dynamic
  982. Need More Help for Searching Textboxes
  983. How do I move values from excel to the word equation editor?
  984. Excel/VBA: cannot import, show, export userforms
  985. To Check Errors for a range of cells
  986. Web query.............query
  987. Function Question
  988. How do I prompt a user with a dialog box
  989. I have a formula challenge
  990. Define worksheet as variable, then call in macro
  991. save data in another workbook
  992. Checking for named ranges in a workbook
  993. Using Named Range to Set DataSource in Chart
  994. Variable that retains value after closing excel
  995. VBA is odd function
  996. Searching Textboxes on worksheets
  997. VBA Code execution delay
  998. Help with this formula
  999. hyperlinks in drop down menu
  1000. workbook.saved property