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. Legend entries dissapear
  2. Using the Match Function?
  3. Is there a way to do this without using notepad?
  4. Check cell for comment
  5. Status of Focus
  6. Remove excel macros from a file to be sent
  7. Using ImageList1
  8. Excel User Conference - Last day - Early Bird pricing
  9. Not allow to open file it do not accept macros
  10. Macro in Excel deleting specified rows
  11. Control Toolbox - Combo Box not working
  12. Macro VBA help needed
  13. Search String within String
  14. Concatenate a selected Range?
  15. ComboBox Date Format Problem
  16. Color Cell throw macro
  17. combobox filling problem
  18. how do i prepare reports for tasks completed
  19. stringtype returned
  20. QUERY: Excel's SaveAs so slow..
  21. Unique Formulas in Excel 2002-2003
  22. Excel 2000 printing 'issue'
  23. Adding to a range of cells for validation from a cell
  24. Using Excel Solver in VBA
  25. tricky excel formula question
  26. print preview enablechanges = false
  27. Need help with looping function
  28. Excel 2002 to 2003 problem
  29. Find Method
  30. What's in your Extension Menu?
  31. Face ID on main menu?
  32. AutoFilter
  33. stop a macro
  34. A formula or macro that determine the correct month
  35. Screen Resolution
  36. References
  37. Two different views
  38. Prevent multiple instances of Excel from starting
  39. Password field display in Cell
  40. MS Query imbedded Queries
  41. Counting Occurences
  42. Worksheet Scrolling
  43. Formula offscopy and offset
  44. Retrieving data from a ComboBox
  45. Help with print screen
  46. Code stops prematurely unless VB Editor open...
  47. Excel 2000, 2003 crashes on opening
  48. Can I disable a macro in "Thisworkbook" with true or false?
  49. Custom Menu Add Problem
  50. Private Sub Workbook_Open() event won't fire if workbook is hidden?
  51. Error Trapping
  52. still need help
  53. VBA Count most current 6 months
  54. Using cell name to call userform
  55. Custom Command Bar Erroring out when distributed
  56. hidden comment position
  57. Know when .cmd has finished
  58. If statement question
  59. Find last value in range
  60. Find Value searching UP
  61. Excel to Power Point slides
  62. Generate list in separate workbook
  63. Show range names in background
  64. Use a cell's content as part of Header
  65. inserting columns and pasting
  66. Assign button to clear all, "except"
  67. Export spreadsheet data into MS Outlook Calendar
  68. subtotal with vba(urgent)
  69. change code to work over multiple sheets
  70. Alert message in MS Query
  71. Do not save a checkbox value when saving or close
  72. single Email address from one sheet - multiple data from another
  73. use average in a userform
  74. Advanced Filter Question
  75. Screen view/Print techniques
  76. message box sometimes not being called
  77. ;;me
  78. Assigning a variable a value from a Cell in VBA
  79. Autofit issues
  80. Macro won't open original file?
  81. Excel VBA Selection.Delete Shift:=xlToLeft
  82. auto fill simple data
  83. Locate last row containing ColorIndex 35
  84. Streaming an Excel document to a client
  85. Modify range variable passed through Function
  86. Excel User Conference - Last day for Early Bird Registration
  87. Removing Single quite (') in character data
  88. Get IP address for a remote computer based on its hostname
  89. Passing Objects from Excel VBA collection to a VB6 DLL
  90. User form with looping doesn't start at right place.
  91. Sound Volume control
  92. Cleaning Data into easy to view report
  93. Looking for blank
  94. Need help running SQL commands in a Excel VBA Macro
  95. Application Event in Class Module
  96. importing a csv file into Excel
  97. input box text formatting
  98. Vlookup in a macro
  99. Workbook_Open event not firing for Excel2K
  100. Pb with textboxes font size in a UserForm
  101. Format Question
  102. Worksheets in an Add-In
  103. compare 2 sheets and extract only new rows
  104. Need an auto update formula macro
  105. Add-In Public Function Recalc Problem
  106. Why "object variable or with block variable not set" error?
  107. I would to create a drop down txt box in a cell. can you tell me
  108. CDO.Message seems to remove formatting from Excel file
  109. Only with a formula, how do I increase the months?
  110. Problem in excel macro
  111. VBA code to switch to other application
  112. How do I use the excel function ATAN in a module used in excel
  113. Deleting another workbook through code
  114. Crossing applications with macros
  115. Left Justify Rows of Numbers
  116. AutoSave before close
  117. Autofilter using a second column
  118. Autofilter using a second column
  119. 3 issues in excel
  120. Convert merged cells to centered across
  121. how do I get a page 2 with inseted text box
  122. DDE (VBA Excel) behaves differently in Windows XP
  123. Extracting time from strings
  124. splitting string in 2 parts
  125. Calculate Cells - Time consuming!
  126. Log Cell data
  127. Hiding Macro warning
  128. Control panel detection
  129. How to change Titlel of Dialog Box?
  130. Clipboard
  131. Delete last row in Macro
  132. Date Doubleclick Event
  133. Autofilter with 3 conditions
  134. Autofilter with date field
  135. Using a News Reader to Access VB/Excel Discussion Group
  136. Shortcuts for mneu created from an add-In
  137. VBA vs. VB vs. C++ vs. C#
  138. Using a listbox/combo box to show two values
  139. SheetCalculate (F9) does not reach the excel-addin
  140. really basic (pardon the pun) problems
  141. Join text
  142. Set condition of button on click
  143. Macro in 2000
  144. Populating multiple cells on other sheets via data validation
  145. Populating data to other worksheet via data validation
  146. Range Name from Another Workbook conflicts with INDEX and INDIRECT
  147. Macro
  148. VBA - 300 Columns Of Text
  149. MS Query changed Datasource
  150. how can I get the appeared value from the cell?
  151. How to get a cells' range name
  152. Images and use in excel
  153. Inserting a date when cell is changed
  154. compare 2 dates and give the date conditions are met
  155. VBA Stops Before competing the program
  156. Which folder - good practice?
  157. Impossible programming!?
  158. How come ?
  159. making toggle button in xl menu
  160. How to get range name inside fuction
  161. Scroll filtered sheet to top
  162. Save File without VB Module
  163. User Form calculator
  164. Auto Update in excel
  165. If Statement
  166. Run Macro until a condition is met
  167. Date Inserted in header
  168. Generate document folders for Excel list.
  169. Change Display Icon
  170. Display diff text based numbers in another cell
  171. NOT WORKING..Getting XLA files to work with Excel
  172. show different text in cell based on range of #s in other cell
  173. Changing Display Icon
  174. How to go through a series of folders without using "folder"?
  175. Summary All Worksheets With links
  176. How to not show save dialog after reading from excel file.
  177. Difficulties with a large formula
  178. Group, Outline, Protected Worksheets and Protected Workbook
  179. Delete blank rows in selection
  180. RE: Delete blank rows in selection
  181. formula to lengthen named range
  182. RE: Delete blank rows in selection
  183. OpenText
  184. RE: Delete blank rows in selection
  185. Saving as .pdf
  186. RE: Can I have a box appear to select the number of pages to print
  187. RE: Difficulties with a large formula
  188. ?macro help-insert copy-w/o overwriting what is already there
  189. need help to create multiple copies of sheet for different sales reps
  190. Dynamically create userform
  191. Opening an existing Word File from within Excel
  192. roleover my totals
  193. unlocking problem
  194. UnProtecting Many Worksheets in One Workbook
  195. Protect VBAProject from within the code
  196. VBA IRR and errors
  197. If function with text
  198. Change directory before File->Open
  199. Menu manipulation
  200. Display Zero Values in Only Select Cells
  201. Creating an Excel Database in Separate Workbook
  202. How to use function that returns array of variable size?
  203. Calling Function
  204. Decimal problem
  205. How to know
  206. Still Having Trouble with Combo Box
  207. FIND or SEARCH worksheet function
  208. Macro in File halted All Visual Basic Settings?
  209. vba to move and renaming data within a workbook
  210. copy multiple rows from a database
  211. Calender Pop-up
  212. if function
  213. vb SUM OF DUPLICATES
  214. vb SUM OF DUPLICATES
  215. Need help with delay/timer (milliseconds)
  216. Code for making a cell chage color by dbl clicking, with either a
  217. MERGE MULTIPAL WORKBOOKS INTO ONE WORKBOOK
  218. Count statement with several contingencies
  219. vba problem with non writable chart height property
  220. Drop Down List..
  221. beforeSave autorecover
  222. Set Visible Range
  223. Intercepting the file save prompt before close?
  224. Step down a list
  225. VB 2005 and Excel
  226. Need help with Time Stamp Code
  227. New at this...need help please.
  228. Extracting matching data
  229. Using footer to display a "document expiration date"
  230. problem regarding date conversion
  231. Last days for Early Bird Registration - Excel User Conference
  232. Enable add-in automatically
  233. Excel Links
  234. Removing Links
  235. Worksheet function
  236. Locating Query Errors in a Sea of Queries
  237. Hiding E-mail ID
  238. Problems with reading / writing ini-file
  239. Import long string (modified Tom O snippet help!)
  240. Short dates coming up in US format if day is less then 13
  241. update cell colour
  242. password protecting sheet when workbook opens
  243. copying rows using macro
  244. How to unhide a column after printing
  245. c# & InterOp & OptionButtons
  246. GetOpenFilename, MS Access 2k
  247. Change Label1.Caption
  248. Calling Cell (or ROW() and COLUMN() in VBA)
  249. macro copy problem
  250. Office 12 VBA
  251. Splitting a String
  252. find the number of unique formattings applied to an workbook
  253. VBA Excel/Access Find function (Ctrl+F) not working
  254. Delete worksheet without confirmation
  255. Named Range Refers To
  256. Macro Showing Formula and Result
  257. SumProduct problem
  258. Keeping a named range between two dates?
  259. Hide Pages
  260. Top 25 in a filtered list
  261. RE: Run-time error '1004': Method 'Range' of object '_Global' failed
  262. Dates using Data / Validation
  263. Problems using MS Query to access an Excel file
  264. Temporarily turning off the keyboard?
  265. search 2 Columns Please
  266. Copy Rows that have a Green font color to another worksheet
  267. Do Until macro that renames workbooks and keeps the original workbook open
  268. Qualifying Commandbars - Excel 2000
  269. Creating a Dynamic Named Range Using Sheet Name and Column Header
  270. Summary All Worksheets With Formulas - Ron De Bruin modified
  271. Compile error
  272. It's doesn't work with EXECL 2003 (it's OK with 97) why
  273. Change value in a string
  274. in object browser classes panel is empty
  275. Load multiple image with same form
  276. Matching athletes and scores
  277. ISERROR and UPPER
  278. Add in module problems
  279. Use vba to fill in matrix in excel.
  280. Usinf function in macro
  281. merging several files into one
  282. Re: Copy Sheet from One workbook to another EXISTING workbook
  283. Protected sheets - change error message
  284. select range from a value
  285. Format in a combobox
  286. Disable Cells- Protection
  287. Variable Question
  288. Message Box for Duplicates
  289. CSV formatting problem
  290. cells interior/color index
  291. msoControlButton to "Worksheet Menu Bar" ?
  292. Re: Run-time error '1004': Method 'Range' of object '_Global' failed
  293. Re: get these to work together....
  294. excel db, but because password
  295. custom commandbar questions
  296. Simple subtraction and color coding ?
  297. Problem with loading a template
  298. Personal.xls
  299. Convert Function key on Keypad
  300. About chart with a macro
  301. validation of textbox entries
  302. Conditional Formatting contains?
  303. Format word created from Excel VBA
  304. transparent button on custom commandbar
  305. Macro to Open the Menu Data,Refresh Data,filename,import
  306. Assign Macro to Command Button
  307. getting the adress on the last row
  308. Pivot Table
  309. Faster opening of Word files
  310. Faster opening of Word files
  311. Selecting a cell in a row just inserted in a range.
  312. Extract folder names only
  313. Printing Problem
  314. multiple list boxes
  315. Printing Problem
  316. Range in a row
  317. Conditional Printing
  318. Getting the columnmeads
  319. How to find a running Excel instance and access the worksheets in it.
  320. Copy data
  321. Can anyone show me how to do the logit model over excel?
  322. Parsing data
  323. transfer name from date filed into new column and than subtotal
  324. Run-time error '7': Out of memory
  325. Run-time error '7': Out of memory
  326. Userform Help
  327. Using Multiple Interfaces for a Single Class
  328. Comparing two spreadsheets
  329. Case Of Statement
  330. Cells.Find woe
  331. How do I unprotect/with password to run marco and protect
  332. Verify Active Cell is within a Range that changes as cell is delet
  333. List Box can you colour code items or make bold
  334. Getting Users Name
  335. How to replace vba code in one excel workbook from another workboo
  336. Copy formula - Tom Ogilvy
  337. Macro now opens up VBA editor - not intended
  338. How to approach defining where macro looks?
  339. "sneaky" way to set tab order?
  340. If(and) help
  341. access query/excel.exe problem
  342. RE: File sized in inexplicable way
  343. Protect sheet but still allow use of grouping
  344. Saved a workbook using xlDialogSaveAs, now it has a password ?!?
  345. Need to make things simpler
  346. Loops
  347. Need to insert line-feed in Excel concatenation (VB)
  348. A rather complicated Macro needed.
  349. formula after running a macro
  350. Random Number Generation
  351. Help with xlReadOnly
  352. Counting using a form
  353. Is there a reset shortcut
  354. comparing and painting cells
  355. Excel Automatically Clearing The Clipboard
  356. formatting headers/footers
  357. Activate Cells
  358. Select Listindex from column A on selected row
  359. Hide Range of Cells
  360. change cells
  361. Trying to move columns based on heading text, PLEASE HELP
  362. Playing a sound file from Excel
  363. Need a calendar plug in, to help populate a cell with date
  364. Selecting last row?
  365. How do excel document to xml document by programs
  366. how do excel document to xml document by programming
  367. Formula and data?
  368. Saving files. Please wait.
  369. Combo Box to Combo Box Selections
  370. Password protect not working
  371. Format dates again
  372. Please Help?????
  373. Save as not working
  374. Compare 2 columns for unique values
  375. Defining range for Advanced Filter
  376. can't print excel sheet using wsh script
  377. Excel User Conference - Reg. drawing
  378. Anonomise data
  379. Next Row
  380. loop question trying to bring excel into autocad text not starting in correct place
  381. Copy, delete, print in one step
  382. Function like =HYPERLINK(xxx) - Mouse interaction - "On Click Event"
  383. Restoring ToolBars/Commandbars
  384. Re: File sized in inexplicable way
  385. Getteing the collum name
  386. Variable into new file name
  387. Return Range Address from Active Range
  388. New value in a row
  389. Creating Macro code dyanamically
  390. draw shape based on cell values
  391. Delete rows Macro
  392. How to give the numberformat the systemdefault date format?
  393. Dynamic combobox
  394. saving custom macros & toolbars
  395. Run a macro with date/cell change
  396. Please help with this chart
  397. Can EXCEL show the picture from the database ?
  398. HELP ME?
  399. Cascading Combo Boxes
  400. Time to save a workbook
  401. Worksheet_change event multiple
  402. Dynamic chart
  403. Excel formula to increment the month by 2?
  404. generate a chart with asp.net
  405. Averaging dynamic cell data over a one hour period?
  406. Get data from few worksheets together into a new worksheet
  407. selecting row data meeting countif criteria
  408. get part of a file name from a cell value for use in a macro
  409. Loop row selection copy with blank spaces
  410. Select Method of Range class failed
  411. How to read Rows within a Column through ADO ...
  412. Unrecognized functions in *.XLA
  413. Disable toolbar drop down
  414. Selecting An Entire Row.
  415. Selective formatting of text on Label caption
  416. IF statements
  417. Generic n in For n To xxxxx
  418. Toolbars
  419. Search Cells
  420. how can I put a word doc with dropdown boxes into excel
  421. code to match and sort
  422. Date Ranges
  423. If...then
  424. Hyperlinks getting changed on save
  425. hyperlink macro
  426. Save Excel book as Html Page Using Macro
  427. Macro to open files using cell reference
  428. Cursor position after enter
  429. Determine Point Size of Text
  430. Determine Point Size of Text - Take 2
  431. Avoid any input from user
  432. Find And Replace
  433. Excel Page Setup on selected worksheets
  434. timestamp comments
  435. Save range in a new workbook as .gif
  436. autofilter colored cells
  437. find and replace
  438. Summary Sheet
  439. Linking Autofilters
  440. append only new SQL db records via XLS qry
  441. Maximum length Prompt in Application.InputBox
  442. Formula Creation via Add-in problem
  443. Systematically Identifying Duplicate Records
  444. Sum Fields with #NA ?
  445. Copy Worksheet Not the Macros
  446. RE: QUERY & HELP: so slow executing VBA code... :S
  447. New value in a cell
  448. data validation and forms
  449. Accessing Remote MDB Database from Local Computer
  450. Wait for FTP
  451. Setting Max Value
  452. ADO command.execute with a loop - only runs once
  453. Macro 'Code execution has been interupted' error after print?
  454. display data based on a combobox
  455. Range Selection
  456. Options and Combo Boxes
  457. changing image based on pulldown
  458. Highlight
  459. Error Handling - On Error GoTo doesn't trap error successfully
  460. Print PDF-files
  461. Access Database
  462. Copy and Insert Using VBA
  463. Generating, changing PowerPoint slides from Excel
  464. Delete Picture Objects
  465. copy different columns from sheet to other sheet
  466. Multiple VB Conditional Formats for Numerical Ranges
  467. Activeworkbook.save
  468. Pupulating Worksheet from word Using Word VBA
  469. import and search datas from different Excel Sheets
  470. not clearing second pulldown
  471. Copy and paste
  472. stop excel automated zooming
  473. Find first blank cell in single column named range
  474. pseudorandomization using macros
  475. Multiple VB Conditional Formats for Numerical Ranges
  476. Hot key to stop a LOOP
  477. creating validation list in VBA
  478. Update links in closed file
  479. Help with VB code - average of numbers over specified weeks
  480. Comparing data of two sheets
  481. Create Right Click Option to Copy Cell Address
  482. Copying a worksheet
  483. Broken Array?
  484. Extract data from String
  485. Copy range from 600 spreadsheets
  486. Path in formulas
  487. Excel 2003 Screen View
  488. Can somebody help me with this code?
  489. Weird issue with cell spacing
  490. Code for bring up the file->open dialog box
  491. transfer name from date filed into new column and than subtotal
  492. How do I link a macro to a customized icon button?
  493. Sorting issue
  494. Checking for workbooks
  495. Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a)
  496. Sumproduct with Range Names
  497. Multiple lines in single cell
  498. Dim sheet objects
  499. Macro--userinput
  500. Record Pivot table Macro
  501. Find All Embedded Objects in Workbook
  502. Save files to generalized location?
  503. how do you read a visual basic program codes
  504. Using Split Function on String with no spaces
  505. Running URL using VBA - but not displaying IE window
  506. Data Validaton Ignore Blanks
  507. Need a Dynamic Chart
  508. Random Text in a userform textbox
  509. opening csv files
  510. Error in VBA Coding in Macro
  511. function
  512. Format text in a textbox
  513. VBA programming
  514. finding values from duplicates
  515. Writing a program to archive information
  516. match and copy data
  517. Password setting syntax
  518. ListFillRange challenge
  519. How to handle passwords via VBA to Yahoo Quote Server?
  520. make sharing module
  521. How to set programmatically focus on specified Excel row?
  522. Creating new entries
  523. Stop from moving cells
  524. Auditing protected worksheets
  525. Serial Number
  526. Obtain domain name
  527. Macros not displaying under Tools>Macros
  528. Protection error when running VB code
  529. Multiple VB Conditional Formats for Numerical Ranges
  530. How to read CSV lines into different Worksheets depending on a date field?
  531. implicit file reference
  532. Reading txt file into the buffer
  533. Excel to Word
  534. Excel FTP
  535. ThisWorkbook/ActiveWorkbook
  536. Data Validation Limitation
  537. Programmitically accessing WSS via Excel 2003 Data Ret
  538. Current File
  539. assign value to range in VBA function
  540. using a variable in a function
  541. Using variable in a function
  542. example using DSUM worksheet function in a VBA function
  543. Pass function as argument to UDF
  544. Authorization for each worksheet
  545. Calling Oracle Stored Procedure
  546. duplicate listbox selection to range of cells?
  547. CommandText Property of importing external data
  548. Get value of "Zoom" on "Standard" Toolbar
  549. import xml using xmlmap WITHOUT linking to list
  550. data entry cell when viewing as a web page
  551. API calls, an Event handler, custom menu bar and modal
  552. xlstart
  553. Can this can be done???
  554. Customs views won't copy into new workbook
  555. setting DSUM criteria in a VBA function
  556. copying an array from workbook a to workbook b
  557. Selecting Cells
  558. Max value in Pivot Table
  559. howto click button using .net
  560. Help with syntax on IF-Then for CellComment
  561. call external macro
  562. Fonts in cells sometimes grow huge
  563. Signature object
  564. URGENT, help needed.
  565. Calendar
  566. Advanced Filter to another sheet
  567. Web Query imput/return data problem
  568. Problems with user created command bar
  569. to remove a custom Toolbar Button & macro
  570. Backup/Restore Clipboard
  571. Delete Code
  572. Determining Worksheet Edit Mode
  573. Excel Macro - Auto Update Links
  574. Absolute or Relative reference - no longer a choice!
  575. create a macro for copying certain data in cells
  576. Worksheet name syntax question
  577. General programming help
  578. Merge two column in one
  579. Close without saving
  580. Importing External Data - Selecting Table question
  581. Excel to Access extraction
  582. Why are macros creating so many "Activecell" words??
  583. Populating a combo box
  584. VBA to extract sheet name
  585. Progress Bar
  586. Combo Box shink and grow
  587. Newbie - Help with a macro
  588. copy columns to other tabs based on searched value
  589. The ultimate Reference Guide to VBA in Excel
  590. switching between modes
  591. Offset Method and Interpreting Absolutes in Range Objects
  592. Split field based on number of characters and space
  593. Converting Decimal Ft into Ft & In
  594. Dynamic Seach Values
  595. Selecting a range
  596. Best way to identify the "version" of your Add-in code?
  597. Parameters.Refresh
  598. 2 windows open when i click F1 in VB code
  599. Using WSH to populate a pivot cache with an ADO recordset
  600. lookups based on more than one column
  601. Don't understand why I'm getting an argument not optional
  602. Possible Macro Timing Overrun generates Excel Exception
  603. 2 Private Sub Worksheet_SelectionChange?
  604. Delete a macro with a macro
  605. Code in Excel macro to get all open Word docs?
  606. Fixed length file import??
  607. Two problems with userforms
  608. VBA Form MS Treeview Control v.6
  609. Macro still wont run
  610. Selecting a Whole User Defined Row Using VBA
  611. Fast export large 2-dim array to worksheet
  612. "Advanced Filter runtime error"
  613. Office 97 override commandbar /menubar events
  614. European vs English Issue
  615. External file VBA Vlookup code
  616. Error using CommandLineA
  617. CreatePivotTable error
  618. Bug in multiselect listbox?
  619. Copy cols from one excel file to another.
  620. More chart problem Excel 97 - unable to set propert of series class
  621. List of printers
  622. open image file from cell value
  623. Using a Macro to copy a formula into last active row
  624. Variable Storage
  625. Selecting random rows
  626. Selecting Rows
  627. sheet export removes custom toolbars.
  628. Week Numbers
  629. Item List in Excel
  630. Deleting a protected row
  631. Changing chart colours using VBA
  632. Macro to delete row with protected cells
  633. Exit Event with a single textbox control
  634. How to macro: 1.Search for string -> 2.Copy row -> 3.Paste in new sheet
  635. Store clipboard before "vba do cut&paste" then recover stored information to clipboard?
  636. Importing External Data Locks Source Workbook
  637. Any utility for joining two or more Excel or CVS files
  638. sum matrix cells based on value in a separate cell
  639. How do I isolate my Excel Server from the user's general Excel environment?
  640. DAO library
  641. Entering Chinese characters into VBA source codes
  642. Tab's in a multiline text box
  643. Variable Print Range
  644. Copy a specific of data of texts containing "IT"
  645. Copy data when enter text containing the filename
  646. How to do a line feed in a Text Box
  647. excel to check emails automatically.
  648. CheckBox
  649. Splitting String into Consitiutent Parts including spaces characte
  650. Image in Comment in Excel 2000
  651. Need help with VBA Macro
  652. multiple text colors in a cell
  653. Passing Variable length Space Characters to Variables
  654. Making sure users enter phone numbers in a particular format
  655. unmerge cells
  656. max row and max col
  657. Stored Procedures - First Attempt
  658. Creating a macro
  659. If statement for a combo box
  660. Formatting Question
  661. Using a macro to perform a mail merge
  662. VBA to make columns within a cell (99)
  663. how to unhide a hidden row in a pivot table?
  664. Stepping Problem,
  665. Data Validation Question
  666. Custom button on toolbar
  667. Evaluation of Conditional Formats
  668. Using macro to convert single level BOM to Multi Level BOM
  669. Macro Not Working Properly
  670. Populating a combobox within a form with concatenated data
  671. changing prices in multiple colunms based percentages
  672. vbModeless Question
  673. formula help
  674. Stepping through Code
  675. how to get the index for a two diemnstional array..
  676. 65000 Row limit - splitter help!
  677. set worksheet name to a variable ...
  678. Selecting Ranges
  679. Excel to Outlook VBA giving my Calendar Fits
  680. Formatting conditional on absence of comment
  681. Comparing dates
  682. Simplify this code
  683. Vb to set print area for dynamic pages
  684. Determining number of Outline levels
  685. Sort not working
  686. Counting SubStrings and thier starting positions within Main Strin
  687. Last Row - Select to end of sheet
  688. Error Box
  689. Form Err.Raise error not trapped by entry procedure error handler
  690. Dyn Named Range update from userform
  691. CheckBox check marks save
  692. Move from a function statement to VBA code?
  693. Another VBA Chart problem Excel 97
  694. Sum Column on Array of sheets
  695. Stop Macro if there is no data
  696. Dropdown
  697. Run Macro through an entire range
  698. Creating new Excel Application problem
  699. launch an embedded spreadsheet object
  700. List Box Value To Worksheet Cell
  701. Seperating Data from a cell to a row
  702. Pdf PrintOut and SendKeys
  703. error 1004 - application defined or object defined error
  704. delete sheet if it exist
  705. Passing multiple strings to variable in Replace Function
  706. Tracking Changes to Columns & Flagging Cell
  707. Version Control for Excel Add-in
  708. Just can't get the LEN/MID thing quite right...
  709. Loop with activeX optionbuttons.
  710. Update Only Specific Columns
  711. Formatting Excel Cell to a text field
  712. Think Tank; I Need Your Help!
  713. How do I auto-fill dates that are not consecutive across a row?
  714. insert dates
  715. Dynamic programming in Excel
  716. Dyamic Ranges
  717. Problem with assigining a macro.
  718. Pivottable Names
  719. Assigning multiple shapes to macro.
  720. Chart using text?
  721. Case sensitive and single character in cell
  722. Match and VLOOKUP from open workbook, storing values in Active wkb
  723. Text to columns by format type???
  724. Importing Long String - String Manipulation (EDI EANCOM 96a)
  725. Sort an array
  726. May I ask for a formula please?
  727. excel vba problem
  728. How do I set up an excel application for use over the internet?
  729. URGENT!!! RTD updates maximum frequency
  730. need to add string to txt file
  731. Inserting a column using C# and Excel 2000
  732. Question: Can an excel macro interact with acrobat?
  733. passing parameter to a ms query
  734. I need documents on VBA conversion from excel 97 to excel xp
  735. ADD,NAME, and COPY UNIQUE ROWS FROM UNKNOWN WORKSHEET
  736. Find missing dates in a sheet
  737. making a timeline
  738. How to retrieve value from MSSQL table into a cell
  739. Excel98 to Excel3000 pivot table differences
  740. Locating Invalid Web Query Data
  741. Need Help!!
  742. Combo Boxes
  743. Newbie TextBox problem - Please help.
  744. how in excel do we create aggregates of the sort an olap tool crea
  745. can an excel cell be given a number of values say 2 or more ?
  746. Grouping controls
  747. Templates not loading as xls version
  748. Object invoked disconnected from its clients.
  749. How to insert array into range
  750. Global array data got erased after removing reference in VBA
  751. How to calculate number of month from 2008 in Excel?
  752. look up a set of values,copy a range of data into 2nd file
  753. is it possible to covert formula commands from english to german?
  754. copy data when enter the file name
  755. VBA WebBrowser1 Scroolbars
  756. Extract 1st name & middle initial
  757. How to tell if multiple sheets are selected?
  758. get value from a database
  759. Identifying controls on MultiPage Pages
  760. Excel VBA job
  761. Excel VBA
  762. Naming cells using VBA
  763. HasFormula
  764. Putting decimal values in a cell.
  765. How to use ADODB in Excel 2003
  766. Find a Cell Value (Revised)
  767. auto update one spreadsheet with another that creates a file.
  768. Workbook_BeforePrint
  769. Extracting data from a closed workbook
  770. Excel 2000 subtotals with matching names
  771. Setting print areas
  772. Rename Files according to Excel
  773. Creating New Worksheets for identical cells
  774. How can I use a cell value to reference a row?
  775. help needed with multiple values
  776. need some select case guidance
  777. Message Box if sum is above 30
  778. How to delete a web query when it's no longer needed?
  779. constant reference to an xla function
  780. How to read external cell?
  781. Custom sorts - Multiple Keys
  782. AutoFill Formula with code
  783. RTD data source
  784. Chart "Name" Property
  785. BeforeSave and Close help
  786. Two double click events?
  787. change csv files
  788. =Count(two "n" in a row, c3:ad3)
  789. Quick menus not working
  790. PT.Format (xlTable2) removes data from pivot table?
  791. erratic listbox behavior
  792. Triggering a macro after Printing
  793. Excel 2003 SP1: CopyFromRecordset error if field above 911 charact
  794. Macro on cell click??
  795. RE: Runtime error 1004- application defined or object defined erro
  796. Runtime error 1004- application defined or object defined error
  797. RE: Runtime error 1004- application defined or object defined error
  798. RE: Triggering a macro after Printing
  799. RE: Macro on cell click??
  800. SpecialCells in Worksheets Functions
  801. autogenerate multiple rows from single entries in different sheet
  802. formulas
  803. RE: autogenerate multiple rows from single entries in different sh
  804. RE: SpecialCells in Worksheets Functions
  805. sort 2D array
  806. Macro Help
  807. Record Set To Sheet
  808. RE: Runtime error 1004- application defined or object defined erro
  809. RE: Macro on cell click??
  810. RE: Runtime error 1004- application defined or object defined erro
  811. RE: Macro Help
  812. Find a Cell Value
  813. sort 2D array
  814. trying to get formula in cell
  815. Guidance with creating a bespoke .txt
  816. Anyone familiar with BPCS?
  817. runtime 1004 on save as
  818. multi color background in graph
  819. Excel Performance Problems
  820. Suppress printing using button
  821. Validation data on exit Excel or save
  822. How to set named range in macro?
  823. Copying a formula
  824. Perform action on every workbook in a directory
  825. Search for "text" in description - if certain text - display "text" in another row
  826. Denies certain characters.
  827. Hide columns in multiple sheets
  828. public or global array
  829. Disable a cell in excel
  830. Remove all empty rows in a worksheet
  831. Ensuring Excel start macros complete before terminating
  832. import multiple files to excel
  833. Clipboard
  834. Why does this not work?
  835. Excel VBA Last Empty Row VBA paste Array elements
  836. vlookup, true false issue
  837. Return position of a sheet in a workbook
  838. refresh Query table using own password for each username
  839. VBA Forms - Add In Utility
  840. Hii All!!!! does anybody knows how can i cancel the save and the save as commands
  841. Ian
  842. Macro
  843. Excel 2000 -> Excel 2003 now throws 'runtime error'
  844. Minus signs after number
  845. Merged cells Value2 property
  846. Excel SaveAs() method
  847. Close Switchboard Form
  848. VBA vs VB vs VBA.Net
  849. emailing a text file
  850. Format(Now) will not work for Feb.+
  851. Help with Macros
  852. TextBox Validation - Time Format
  853. Macro Error message
  854. Changing the default print settings in Excel
  855. Excel 2000 to 2003
  856. Registration Giveaway - Excel User Conference - April 19-21st
  857. Write formula with code ...
  858. VBA Needed to remove graphs
  859. Reject Manual Input
  860. Public variable lost...
  861. adding email addresses to auto email
  862. Forms - Loop thru text boxes
  863. Override "Send this Sheet"
  864. Spooling and printing each name
  865. Inserting line numbers into the first column of an excel worksheet
  866. Re: Copy a record before deleting
  867. identifying range
  868. visual basic Mid() does not work with swedish version of excel
  869. scroll bars
  870. change linked cells to black, hardcoded to blue
  871. Restore formats in merged cells ...
  872. Oracle Connection Problem
  873. Adding custom graphics to excel chart
  874. Macro cannot be found
  875. Deleting a row
  876. Code that references the name of a cell
  877. How to add data Range property at runtime to excel sheet
  878. Reading Forms in Sheets...
  879. External web query from ASP
  880. Referencing date and worksheet tab
  881. Adding WorksheetData to a ComboBox on a form?
  882. If there is missing data???
  883. Missing optional controls in toolbox
  884. how to shut the hps i open in vba
  885. how to set an interval
  886. Re: script to change filename
  887. Calculate time difference and convert
  888. Variable not defined comple error
  889. sort an array
  890. How can I make a cell mandatory?
  891. Who is using my excel file
  892. Type mismatch in look up function
  893. Hide the selected range highlighter
  894. Writing Data to a Existing Word Doc.
  895. Finding a Workbook's Location
  896. Summary sheet
  897. Beats me!
  898. File to keep track of World Cup 2006
  899. clipboard full
  900. Reading Data from a User Form.
  901. RE: Disable Insert Column without protecting sheet.
  902. How to open/save excel file with Visual C++
  903. Copy (removing blank cells) without clipboard
  904. Re: Vlookup and Pasting
  905. Auto macro
  906. Need syntax for If user name in before save event
  907. Collection vs. Array of Arrays, nszim
  908. Data validation - List Box
  909. Registration drawing - Excel User Conference
  910. using Dirty Method
  911. close workbooks before opening another workbook
  912. Programatically making worksheets
  913. urgent! need to find "," in number
  914. Help with VBA Type statement
  915. HTML Document.Links Issues
  916. How to know the linked cell of a check box
  917. financial functions dll
  918. Temporarily Suspending Worksheet_Change() until other code is run.
  919. Function instead of formula
  920. Choosing pictures
  921. Declaring Data Type of Array
  922. close all other workbooks
  923. how do I print .doc files from a list of pathnames in a spreadshee
  924. generate multi row event from single entry
  925. What Is The Right Provider?
  926. Test
  927. Shading cells with If statements
  928. Dynamically add a Reference to an Add-In in VBA (Excel 2000?)
  929. how to update Listbox of sheetnames if user changes sheetnames?
  930. color text base of value of the formula
  931. form button question
  932. activate macro by values in a column
  933. Timestamp
  934. Oralce Connection
  935. Re: Copy a record before deleting
  936. Userform question
  937. "Flipping" a matrix
  938. Excel Programming Question - VBA + WMI
  939. help with syntax
  940. panes frozen, set visible part of screen
  941. tabbing through textboxes??
  942. Sumif problem
  943. Continouse Calc while userform is shown
  944. Hide/Disable Tool bar
  945. need advice
  946. List Box: Wrap text?
  947. Lock Zoom of Worksheet.
  948. RE: merge ranges
  949. changing one percentage, but total must be 100
  950. Re: RegEx Check password string
  951. Excel User Conference - Atlantic City, April 19-21 - deadline tomorrow - Registration Giveaway
  952. Problems encountered using the DCOUNT function to analyse large databases
  953. Re: File sized in inexplicable way
  954. Macro button
  955. Creating a macro to apply a formula to particular rows
  956. RE: If A Directory Exists
  957. How do I print a Word.doc from its pathname in Excel spreadsheet
  958. How to open a workbook?
  959. Delete Multiple sheets
  960. a webbrowser popup
  961. Testing for numeric value in VBA
  962. populating a cell will a value from a range of cells
  963. Re: defined names problem
  964. RE: populating a cell will a value from a range of cells
  965. odd problem
  966. Help.. Add an event to a sheet module
  967. RE: invoicing
  968. Start macro at a special time
  969. pop up menu
  970. Extracting value froma table
  971. Userform finding next row to place data
  972. RE: Excel VBA - How do I make the third column in a row the active
  973. Use A Cell to Choose A Date from a Calendar
  974. modifying a excel *.csv file problem
  975. Formula to calculate military time into hrs
  976. Find
  977. Find Window in VB Editor always opens at/moves to bottom of screen ...
  978. RE: Excel VBA - How do I make the third column in a row the active
  979. RE: populating a cell will a value from a range of cells
  980. Need macro to run when workbook is calculated
  981. Open subtotal detail with hyperlink
  982. Logging Table with PrimaryKey
  983. remove horizontal scrollbar combobox
  984. Highlight certail text in a userform Text box
  985. Hidden sheets
  986. row argument query...
  987. Allow cell formatting only
  988. Macro -Moving data from one sheet to another
  989. Calling Sub difficulty
  990. Applying formula when a particular value occurs
  991. Problem with CPU Usage 100% related to stored external queries
  992. vlookup - after exhaustive search
  993. Workbook_SheetActivate Paste Problem
  994. why does userform close after programming worksheet event with CreateEventProc or AddFromString
  995. Calling Private Sub/Function
  996. Personal.xls Macro Function for Everyone...
  997. operating notepad from VBA
  998. Highlight column heading of current cell
  999. Pick projects from sheet and create new sheet per project
  1000. Copying sheets and PasteSpecial