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. Where do I find help for Visual Basic for Applications Extensibili
  2. VB Macro for Excel
  3. Help
  4. import txt file macro
  5. Ranges of Named Fields
  6. BUG: Font Size / Control Size Changes
  7. Global macro for resizing and reformatting Excel charts
  8. import data from works 3.0 on windows 3.1
  9. Determining whether a named textbox on a chart exists
  10. Replace Update Links prompt
  11. Referencing a cell when using VLOOKUP
  12. Logic and Loop Code
  13. Change to UPERCASE
  14. Check cells for 'Auto Save As' file naming
  15. how do I automatically advance data to next cell when overwritten
  16. Help with creating hyperlink via VBA
  17. Create a new folder
  18. Change to Worksheet Change Event
  19. Help on Echange rare
  20. Need a Macro plz !
  21. What's wrong with this code?
  22. Writing a line in to a file
  23. Open multiple text files and paste contents to single cell
  24. drag and drop a formula
  25. Need Help with Set Object = Collection(index)
  26. Cells.Replace in VBA
  27. How do I make my Excel 2003 document work in Excel 2000?
  28. How do I select the last entry in a sheet, to use in a formula?
  29. Another way to remove formula
  30. Last item in listbox not getting displayed.- - Excel VBA appln.
  31. Programmatically inserting hyperlinks
  32. Create Discout Table
  33. Open dialog box and disabling
  34. run-time error 1004
  35. Check if date is valid
  36. Runtime error 91 when connecting to SQL Server 2000
  37. selecting range and copying to new worksheet
  38. How to disable files type combo box in Open Dialog box
  39. exact copy/paste
  40. Help with a Macro....
  41. existing file excel2000 macro
  42. How do I calculate an offset between two ranges?
  43. Best way to write an app using Excel sheets that doesnt look like excel
  44. turning off automatic calculation when loading VBA add-in
  45. Need help with arrays (I think)
  46. Returning value in VB editor
  47. searching in several columns
  48. Listbox selection follows hyperlink
  49. Remove Selected Entries from Excel List
  50. lookup formatted cell
  51. Text to speech
  52. HELP: survey data collection & analysis
  53. Name the ActiveCell
  54. format as %
  55. Activate Previous worksheet after adding a new worksheet
  56. appending records
  57. Idiot can't insert page breaks.
  58. Rollup worksheets into a master worksheet - automatically?
  59. how to average a cell value across worksheets?
  60. Finding and Formatting the 5 highest values in a range?
  61. Macro/Loop If Statement Help -delete the row with the specific te
  62. Deployment and config files
  63. VB code donation required please!
  64. two unaswered questions, Could you answer me one or the two of the
  65. problems maximizing windows in VBA
  66. Compile List of Rows With an Empty Cell
  67. UPPER / LOWER function VBA
  68. Obtaining column/row numbers of cells in user defined function
  69. FormatConditions appears to kill copypaste
  70. SaveAs macro in Excel
  71. Copying Selective columns
  72. VBA Excel Model Diagrams
  73. Macro Won't Open up Userform
  74. Toolbars and menus
  75. Automatically remove a Combo Box
  76. Double Countif
  77. update cell in automatic mode....
  78. Compile List of Rows With an Empty Cell
  79. Worksheet Change Event
  80. tracking database change
  81. Need directory path without filename
  82. How do I get A ComboBox to execute
  83. skip hidden sheets
  84. Finding the last modified directory and file
  85. Recording Macro, toggle absolute/relative reference, button disapp
  86. Activeprinter
  87. Lock Checkbox value
  88. Concat and summarize 6 columns to 2 columns
  89. Open files within specific file structure
  90. VBA code to change registry value of existing DSN
  91. Macro Sum Formula For a Variable Rang
  92. Tools...References shows "MISSING:" in front of 2 references
  93. internet connection via excel macro
  94. Listbox Slider control
  95. Stops at certain row with Error 91
  96. Runtime Error 1004???
  97. Columns resize event
  98. Compare a selected Range with a Named range and select cells that do not exist
  99. Finding the number of rows on a worksheet
  100. how to add database values to a specific cell
  101. Bug with SelLength? (Excel 2000)
  102. Problems sending file link in email
  103. combination
  104. Porting Modules
  105. how to - Insert predifined text in each cell of a column
  106. How do you insert lines to make an accounting journal page
  107. "Always trust macros from this publisher" is greyed out in Excel
  108. Re: Help
  109. Adding only working days
  110. Help
  111. Creating a master list
  112. Command Button on Pivot Chart
  113. Export or save my digital signature?
  114. Re: Ron de Bruin (ADO help)
  115. Loop
  116. How to offset certain cells after dragging down a formula
  117. Using Older versions of ms excel with 2003
  118. Assign Cell Content As File Name
  119. Excel should rewrite macros when adding rows or columns
  120. Macro to select cells within a range in which the cell color is none
  121. Supress dialog box when MS query returns more than 65536 rec's
  122. RE: Error when loading a programme from a tool bar
  123. where do i place the code ?
  124. Application.WorksheetFunction problem
  125. exact number of characters in textbox
  126. RE: Copying table from webpage to worksheet
  127. insert data ODBC
  128. changing rows for columns
  129. Macro for Excel to add up items and delete extra lines?
  130. changing cell values from within UDF
  131. Is it possible to unprotect a workbook without opening it?
  132. Opening Word Files in excel sheets
  133. Open CSV file, format data and write output to a text file.
  134. How to re-set focus to the text box after deleting invalid data?
  135. RE: I want to add a checkbox at the end to return data to a separate s
  136. Reading excel data into another aplication
  137. action on lostfocus in a cell
  138. Capabilities of a User-Defined Function
  139. Merge / Collate Workbooks into 1 Workbook
  140. word å’ŒExcle 图æ*‡æ—*法显示
  141. NEW VBA in NEW Excel ??
  142. Re: Inputting month and year only
  143. Message on screen
  144. Closing Excel Application
  145. Deleting a record from Access data base using programming from excel
  146. Re: Inputting month and year only
  147. linking format
  148. Database question
  149. How to duplicate Worksheets
  150. Re: Changing directory names
  151. Re: Changing directory names
  152. Doing a macro in every worksheet except 2
  153. Re: ATT: Ron de Bruin (ADO help)
  154. code for organizing array
  155. Solver
  156. Re: Excel not adding proplerly... - sample.xls (1/1)
  157. Re: Excel not adding proplerly... - sample.xls (1/1)
  158. Excel not adding proplerly... - sample.xls (0/1)
  159. find all instances of text in string
  160. Determining File Size
  161. error 2015 performing vlookup
  162. final answer to run macro at certain time
  163. With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project.
  164. Need help with loop
  165. on click change cells color and increase a number..
  166. Consolidate data in an 2-dimension array in VBA
  167. All Subdirectories
  168. Clipboard Clear API error
  169. Database
  170. Re: Clipboard Clear API function Error
  171. Newbie: Help with workbooks
  172. User defined functions
  173. Object variable or withblock variable not set
  174. Weird Cell Behaviour
  175. Object Defined error
  176. Doesn't recognize worksheet
  177. Error trapping
  178. Userform locks up Excel
  179. Exporting Access Queries to sepcific ranges in an Excel workbook
  180. Send a query and receive data through a Comm Port
  181. Format Series in Pivot Chart
  182. Exporting Access Queries to sepcific ranges in an Excel workbook
  183. email several attachments (change to ron's macro?)
  184. HELP !!!
  185. Workbook to Web
  186. using a multi-select listbox to pull data
  187. Thanks Tom
  188. Adding a control to a User Form
  189. Macro only working on 1 row
  190. Unable to set FormulaArray property of the Range class
  191. duplicate data, if command in VBA
  192. How do I handle #Value in VBA?
  193. DDE Commands
  194. Delete 2 rows skip 1 delete 2 more
  195. Format Data Series in Pivot Chart
  196. Code compatibility issue
  197. how shell open AcroReader w/command line filename?
  198. How to round down to nearest 5 minutes, time calc?
  199. VBA to control the Mouse
  200. How can I use the worksheet function FIND in VBA or is there a FIN
  201. Autorun.inf
  202. Problem with Code --- Please help
  203. Automating Solver in loop
  204. File or function not found error
  205. Can't get OptionButton choice result from form?!!
  206. Adding a column with reference to another
  207. Usinf cells for filename
  208. GroupName for OptionButton
  209. Which runs first, Workbook_Open() or external query refresh?
  210. Macro to Update Charts
  211. which event/method should be used to handle sheet refresh in VBA
  212. Help declaring array limit with variable?
  213. RE: which event/method should be used to handle sheet refresh in VBA
  214. Automatic filtering keystroke
  215. Copy Paste Special Values
  216. Moving objects
  217. Changing the size of Comment Shapes
  218. Help wih complex formula or macro or solution
  219. Text wildcards
  220. using cell info in an equation... Very frusterated
  221. Null to Zero from External Data
  222. Number rounding within a formula
  223. Custom graphical cell contents
  224. Sheet Reference in vlookup
  225. macro abouut solver
  226. Late Binding
  227. Calling a Sub with a Command_Click
  228. selecting a cell based on lookup with VBA
  229. private macro and shortcut key
  230. Trigger macro when nr of sheets changes
  231. Workbook_BeforeClose doesn't work!!!
  232. Graph Ranges
  233. Find Column heading and then Delete entire column
  234. Copying a variable range
  235. VBA Code to copy values &formats to the next worksheet
  236. Make textbox1.value default
  237. Function Used?
  238. Locking components BUT Still allowing to change settings via VBA
  239. Populating a database with a template
  240. Find last word in cell
  241. Too many different format cell
  242. sending e-mail it is ok from VBA not from Excel it-self
  243. UserForm - Storing user's choices
  244. Sheet Listing
  245. Progressbar
  246. VBA help to replace if formula
  247. VBA Help to replace If formula
  248. Which sheet will be printed?
  249. digital certificate
  250. array question
  251. application.dialogs(xlDialogPrint) - arguments
  252. copying data from text file to excel sheet
  253. Display of arabic-type fonts in Excel VBA forms
  254. copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro
  255. Delete words in cell if that word is in red
  256. How do I Clear ALL unprotected data entry fields in a protected sh
  257. VBA copy from single to merged cell.
  258. RETURN TO C
  259. Copy and paste values for particular column
  260. Before print
  261. VBA code to edit a formula in excel?
  262. First-time Use Code
  263. password protection popup
  264. Excel 2003 protect not working in Excel 97
  265. Move to a set cell if
  266. Data Validation with additional input
  267. Changing the active workbook
  268. copy line nased 2 button on userform...
  269. Assessing whether any checkboxes are checked within frame
  270. Validation, how to see "today" date on top of the drop down list?
  271. Test for for sheets existance
  272. Followhyperlink using specific web browser
  273. Userform Textbox multiline Vs format in worksheet
  274. Help on cleaning / speeding up code
  275. Disable Option in Como Box
  276. Need offset range for loop
  277. Microsoft Query using Excel
  278. Using a variable in a formula
  279. Pivot Table - display filtered data
  280. import text file
  281. Hyperlink Code only works when file saved on desktop
  282. Autofilter method of range class failed
  283. Menu item deletion
  284. Last row in spreadseet
  285. excel2000
  286. accounting software template in excel 2000?
  287. get HelpContextID's or Tags of all userforms
  288. word automation
  289. Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
  290. One sheet e-mail
  291. Dynamically name MultiPage Pages
  292. ado command timeout property
  293. MouseDown()-MouseUp()
  294. Please help!
  295. Template
  296. Automatic Border along Pagebreak
  297. macro in excel 2000 vs excel 2002
  298. Adding Sheets to a combo Box
  299. ranking cells in excel
  300. Why can't you use brackets, braces like parenthesis in Excel?
  301. help extending formula to range
  302. How to set the value of a cell using its row and column numbers?
  303. Parse out answers from a column
  304. Range of averages
  305. Code problem
  306. Re: Subtotal - copy to other worksheet
  307. Data sorting with a twist
  308. Reading a text file line by line
  309. how to retrieve properties of a file in VBA
  310. Export UNIQUE rows to access with ADO
  311. Subtotal - copy to other worksheet
  312. Anything New with the Too Many Cell Formats Issue?
  313. transfering data
  314. Worksheet Sizing
  315. Excel won't quit from VB.NET
  316. Loop problem
  317. Repeated Multiple Find
  318. Numbering
  319. Display of Record Set
  320. The formula to determine if with 3 separate if conditions.
  321. Accounts payable projection and tracking
  322. comparsions of columns and deletion
  323. Manual sequence to add a combobox/dropdown/listbox to toolbar
  324. Move cell info from one worksheet to another buy click a checkmark
  325. Delete excel file after copy
  326. Delta
  327. Getting text data from textbox
  328. disable events does not work
  329. Macro to view 'Print' dialog box
  330. Before Print and UnDo
  331. VBE PROTECTION
  332. Programmers available
  333. date problem
  334. Trouble calling Add-In Macros
  335. ActiveWindow.VisibleRange.Width - Is this the correct code
  336. Re: find question
  337. find question
  338. Change cell value when right-clicked/double-clicked
  339. Print VBA code in Editor format colors
  340. Good chalenge on header/footer
  341. Return of position on page in excel
  342. ActiveX control error -
  343. URGENT !! Drawing Programme in excel
  344. Screen updating
  345. user form error 9
  346. Check if cell value is found in a seperate range of values
  347. TEXT() function problem in Excel 2002
  348. Array formula returning #N/A when inserting new rows.
  349. Next w/o For?
  350. Mathematical Time Conversion Formula
  351. Help with complex formula or macro or solution
  352. Fill-in Range from UserForm
  353. Code execution interrupted on PrintPreview close
  354. Controlling Monarch through VBA
  355. Linking Multiple Workbooks
  356. Access Question
  357. Color text macro
  358. How to fill an internet field using VBA
  359. Add-Ins ???
  360. Text color in listbox
  361. Can I make an alert box with with a yes/no question?
  362. Color Text Macro
  363. Macro to synch three pivottables based on same data
  364. Paste event
  365. Array contents in module page?
  366. VB to protect cells not working in Excel 2003?
  367. How to fill an internet field using VBA
  368. Creating and Destroying Excel Objects from VB
  369. Interfacing EXCEL wir an RS232 serial device
  370. If Cells.Find finds something
  371. Vlookup
  372. how to protect VBA source codes
  373. Merge consecutive cells using conditional formatting.
  374. How to get value of CheckBox in VBA?
  375. Change zoom to fit different resolutions
  376. Mutli-dimensional Array to Single-Dimension Array
  377. Hiding Rows
  378. Sort collection string keys
  379. List in cell
  380. Forms, Range Control
  381. if statments using text
  382. Disable Form Events From Being Triggered
  383. Add Current workbook as an attachment
  384. user defined function receiving a range as parameter
  385. Counting Digits in a string
  386. using vba to copy user-defined chart type
  387. Using picture files
  388. Resizing Picture
  389. copy line with 2 condition....
  390. using input from user to select wk1 to wk52
  391. Adding shapes to xy scatter charts
  392. Copy line based a click into userform...
  393. First New Post
  394. less than 0.5 but more than -0.5
  395. VB code in Excel
  396. filling userform textboxes
  397. Locale problem
  398. External table/range reference trouble
  399. Flashing message in cell (alternate font and background colors)
  400. VBA and SQL
  401. Excel/Access ODBC
  402. Use Macro to copy part of text in cell
  403. Connecting To a Excel Database
  404. Using VBA to access files in a list in EXCEL
  405. Alarm, Play wav file
  406. select cells in red only
  407. vb exe crashing
  408. Choosing multiple Criteria to populate a textbox.
  409. run vba code dynamically of another add-in workbook
  410. MsgBox Position
  411. Find the nearest point to 1000 rows where "amounts" balance and apply special formatting to that row
  412. .offset() function
  413. Variant
  414. Is Nothing
  415. Deleting a chart using VBA
  416. Disabling Security Messages (Macros)
  417. Change Process Priority
  418. AppActivate
  419. Combo Box Sorting Update Problem
  420. OLE Error
  421. How can I call Fourier Analysis from a Visual Basic macro?
  422. Why does this not work
  423. copy column
  424. Timecalculations : How ?
  425. How to show messge box text in Excell work sheet
  426. Selecting part text in a textbox
  427. Scroll name in about-form for credit
  428. Ok IM REALLY LOST.. PLEASE HELP
  429. If Not equal to statements
  430. Date returning value or day of week
  431. Two columns whit same value
  432. hide columns
  433. Check box
  434. Lock to copy/ modification data
  435. How can I make For-Next loop with date?
  436. Worksheet
  437. Hlookup Problem
  438. getting extra excel instance when controlling from access VBA
  439. Run Macro & Rename Sheet upon creating copy from blank.
  440. Convert Excel 4 Macros
  441. RE: How can I make For-Next loop with date?
  442. How to make a function change other cells in worksheet
  443. Is there a Template for Church Business and Reports?
  444. Copy method failed
  445. Urgent help on floating segmented bar chart
  446. RE: Urgent help on floating segmented bar chart
  447. Disabling and re-enabling the AutoFilter from VBA
  448. Late Binding or Late Anything
  449. source location and error message 400
  450. Code looping until machine freezes!!?
  451. Help with word object
  452. Dynamic Hyperlink
  453. Help with Vlookup
  454. Need to Add References
  455. how to close active ie browser using a macro
  456. SKIPPING A COLUMN
  457. GetOpenFilename - Error
  458. User defined type not defined
  459. copyFromRecordset - vs - getRows
  460. Check for previous entry
  461. find values and combine in one cell
  462. find values and combine in one cell
  463. possibly array formula for depletion
  464. AddIn functions in code?
  465. Cell formatting
  466. Selecting a row relative to the position of a button
  467. Filter copy incl more than it should
  468. Populate Combo Box with Text file
  469. List all worksheets (and Document Names)
  470. Media Player versus Windows Media Player
  471. Macro Required - to process data
  472. UDF Raising an error
  473. Autofill
  474. Find latest date for each row
  475. DropDownBox?
  476. dropdown.fontsize ??
  477. Transfer rows with varying criteria
  478. Project: Assignment letter
  479. long list into printable view
  480. Transferring rows with variable criteria
  481. load local htm help file with HelpContextID
  482. Path name in title bar-READ ONLY prob
  483. Checking accuracy
  484. Input box Type:= 8 not working
  485. Selecting a range using a column number reference
  486. Cells.Find for text w/ line break
  487. No active cell
  488. Removing items from listbox
  489. Problems changing Embedded Chart Name
  490. Re: VBA Question: User Form and input masks
  491. VBA Question: User Form and input masks
  492. Email body with a script and a table
  493. Interesting performance "black hole"
  494. Error message
  495. simultaneous pairings
  496. Why it is not pasting it to the correct place?
  497. Copy to PDF
  498. export range as picture
  499. Rogue Admins
  500. spin button code
  501. Forms and scrolling
  502. Sum (IF
  503. Auto fill
  504. How to detect if a workbook is hidden through VBA
  505. Need help with odd behavior of worksheet rows
  506. Code with query goes from greyhound to turtle speed
  507. A new excel challenge
  508. Dynamic Find and Replace String Within Functions Based on Column Values
  509. protect and unprotect
  510. protect and unprotect
  511. Move Part of Cell String
  512. Imported file Date formats unrecognisable/unconvertable
  513. How do I program telnet using exel through dos?
  514. Security discussion - how to effectively distribute an Excel file
  515. VSTO Date Evaluation
  516. OPen excel workbook...
  517. Copy Down Formulae
  518. problems w solution 4 enable AutoFilter for a protected worksheet
  519. How can I copy data from one workbook to my own workbook?
  520. printing the project
  521. How can I copy data from one workbook to my own workbook?
  522. too many combos
  523. i need help
  524. Problem with AppActivate.
  525. to update or not to update
  526. Allow user input, but not format changes
  527. How to see columns from which values were not returned by HLOOKUP functions?
  528. Count Numerous Matches Only Once
  529. Variable Acting Like a Constant?
  530. CubeFields
  531. Address Property
  532. Determine if an excel file is already open
  533. Download from SAP too big
  534. Passing an index to a second workbook
  535. Data sorting a crosstab table
  536. Filtering and coping w/combobox
  537. Chart Objects Error
  538. Find a value in a column
  539. Selecting multiple criteria HELP!!! :(
  540. Excel 2003, paste special menu
  541. opening a .csv file via VB
  542. Row Reference
  543. Golf League Help
  544. Entering subtotals quickly in several columns
  545. Same value in cel
  546. Text alignment within a listbox
  547. Copying sheets form other workbooks
  548. Sort Data Automatically
  549. How do i can countinuously update time?
  550. Smart Application.Path
  551. emailing in Lotus Notes
  552. Compile error: Can't find project or library
  553. Excel strange (erroneous?) decimal behaviour
  554. closing excel
  555. Search Google from Textbox
  556. how to check if folder exists
  557. Find part of string & delete row
  558. Changing the text color of a complete row ...
  559. Macro when Inserting Line
  560. Sending Mail from VBA
  561. How to replace a function with its resulting reference in a formula?
  562. Activex control button problem
  563. Select a varying range of text and paste into a cell
  564. what is mean by ^ in formual
  565. Insert calculation with VBA is slow
  566. Paste Method failed (Activesheet.Paste)
  567. comparing data in two similar format reports
  568. Dos Directory
  569. Personal.xls
  570. How to Clean up exported Userform.frx?
  571. userform problem
  572. How to replace a function with its result or resulting reference in a formula?
  573. showing / hiding gridlines through VB code
  574. filter using VBA
  575. VB-macro - Copy from another workook
  576. Chart problem.
  577. Quick question - quick answer about assigning shortcut keys
  578. Loop through cells meeting conditions
  579. CustomDocumentProperties problem...
  580. MatchEntry for combobox added during runtime
  581. Activate and Display a Workbook in Internet Explrorer
  582. Printing Help
  583. How can I copy the data of sheet 1 to sheet 2 with modify?
  584. Copy Cell to Same Cell on Multiple Sheets
  585. Saving file using data from worksheet
  586. Highlighting entire row
  587. VBA ".Find"
  588. Convert code rows to columns
  589. repost: Need Help With Steaming Data Macro
  590. Excel opens All files in Default file location
  591. customize calendar (some dates in red color) in excel
  592. Importing csv data into worksheet from the web
  593. How do I Sum variables
  594. .Net Excel Add-in missing Images in ListView
  595. Paste method fails in VBA
  596. Relative Ranges in excel macro
  597. One custom menu copies
  598. Linking access records in to excel
  599. Disable "Select Multiple Items" in Pivot Table
  600. Display contents of (Multiple Items) from Pivot Table
  601. reset the data range...
  602. Exported Date Format is Changed by Ecxcel
  603. Excel VBA to click 'submit' on form
  604. how do I add paramters / criteria in the excel query?
  605. Userform/Module
  606. Select Case help
  607. ColorIndex and Caps Change too slow
  608. Macros with the VBE
  609. Add the specified number of work days to the a date.
  610. convert to a number
  611. Writing data to SQL server
  612. Last Row of Selection
  613. change font color whenever click a page of multipage control
  614. Copy filterto workbook
  615. Custom Number Format
  616. Maintain focus on one worksheet while collecting data in others
  617. Application.Calculation gives run time error
  618. Stumped on Array
  619. before mail
  620. Form Close Button
  621. Pivot Table - 3 columns turn-around-times
  622. How to find the rows existing in one column but not the other?
  623. OLEOBJECTS IN WORKSHEET ARE WACKED
  624. Identifying Objects (again)
  625. File name in Vlookup
  626. Get the list from Autofilter after filter some criteria
  627. Conditional formatting two rows at a time
  628. cannot shift objects off sheet
  629. IF THEN-HIDDEN ROWS
  630. Finding cell address for minimum number
  631. How to define tab key settings?
  632. VBA does not recognize Excel worksheet function "indirect"
  633. One macro to rule them all
  634. Re: What is wrong with this code?
  635. Moving cells to another sheet
  636. Refencing a Microsoft WORD Library in EXCEL VBA
  637. HELP with this code!
  638. Verify the format of the content of a textbox included in a frame
  639. Removing Cells from an Excel Range
  640. How to clear items on a form?
  641. What is wrong with this code?
  642. Selected Cells Menu
  643. Create floating button based on button click in menu
  644. Want macro to select current cell
  645. Using Wildcard on Workbooks.Open
  646. Validation Question
  647. Color Rows
  648. Help on Vlookup for Undetermined Range
  649. Returning Columns to a List Box for a Holiday LookUp Table
  650. Follow on to: Determine if a workbook is already open
  651. what is stdole reference in excel vba library
  652. Formatting text in Commments to cells
  653. Advanced Formatting [2]
  654. VBA
  655. Adding Excel charts to PowerPoint presentation in Office 2003
  656. Copy tab delimited string to worksheet row - VB6 application
  657. Excel and Vba questions
  658. Open an existing workbook and reference it
  659. error in XValues
  660. Use VBA to format paint cell(s)
  661. using VB to filter
  662. Formulas in Pathnames
  663. Restricting Characters in a cell.
  664. Is this wrong?
  665. How can I upload a file to my webfolder?
  666. Halt all code while macro runs
  667. Can't close e-mail
  668. Userform from a Userform Problem
  669. Read Binary
  670. Variable table array name in VLOOKUP
  671. New Job
  672. working with large text files
  673. Excel: I can't see the worksheet tabs on my screen anymore. HELP!
  674. How to display data in Combobox with no dups
  675. Accidentally Protecting Sheets
  676. Retrieving range string from named range
  677. "ByVal Cancel As MSForms.ReturnBoolean"
  678. Attaching sheet to e-mail
  679. Validation inputmessage multilines
  680. How to transpose an excel worksheet having more than 10000 rows into a text file, may by tab delimit
  681. Too narrow columns
  682. Save workbook with 10 different names
  683. Change "Properties" of files
  684. Problem Pasting entire row.
  685. How's this verification done?
  686. Advanced Formatting
  687. How to force Excel to NOT update hyperlink paths?
  688. Add double quotes to each field
  689. Worksheet reference vs Worksheet("").Activate
  690. Consuming a web service in Excel 2003 that requires a certificate
  691. Creating a back up copy.
  692. Refering to Public Variables in Functions
  693. Find & Delete Duplicates across two Excel Worksheets
  694. Fill an individual report with values from a team report?
  695. How do I copy a worksheet form a workbook in my workbook
  696. Run Time Error 13 Type Mismatch
  697. Select Case, Less and Greater than?
  698. Excel VBA: Browse For Folder - Cancel Button
  699. Preventing automatic upgrade of references to ADO
  700. Cancel RefEdit
  701. VBA to Merge Cells
  702. LIKE in Excel VBA?
  703. How to activate add-ins for particular files??
  704. Force a Message Box to close unanswered
  705. copy userform input to cells
  706. #NA error using vlookup in vba
  707. Sorting Data.... Help!!!!
  708. Locate cell name using variable and looping
  709. -1^2+1 vs 1-1^2
  710. event with commandbar button right-click?
  711. From excel to word
  712. Trouble with web services in excel 2003
  713. Rank items in VBA Array?
  714. how to write a macro for solver function
  715. copy paste special values
  716. Chart on a Userform
  717. Dropdown Sub Menu
  718. dialog box to pick path & file
  719. Easy solution need for find problem
  720. time stamp a cell that doesn,t change when time stamping another
  721. type "cheese" in a1. Click cheese and get picture?
  722. data entered on multiple sheets also added to summary sheet
  723. Automated data entry
  724. New Sheets for hyperlinked files
  725. time sheet help
  726. Macro sheet by sheet error
  727. Distributing Macro's and Personal.Dot files
  728. Retrieving data from work sheet to USER FORM
  729. Form creates new workbook and pulls data
  730. IF THEN FORMULA
  731. Can this be condensed
  732. applying a macro for a specific field to a range of fields
  733. Data input macro
  734. Data Field in Pivot Table
  735. Identifying Objects
  736. workbook open query
  737. UDF for opening most recent file added
  738. Prevent User from Going Past a Certain Cell
  739. I want to make one loop
  740. How to hide a textbox
  741. VBA Beginner: Help with Checkboxes on created User Form
  742. Userform searching and update
  743. filter a combobox
  744. Determine if a workbook is already open
  745. Search & Extract various strings from many files to one excel file
  746. List Box Multiselect Form
  747. please help
  748. please help
  749. Re: Set as read only based on user name.
  750. Select last worksheet in workbook
  751. Searching multiple columns
  752. Set as read only based on user name.
  753. Add data to different worksheets in same workbook
  754. Data Entry Form (similar to default Excel Data>Form)
  755. Arranging data
  756. List box: Populate with Range Names
  757. Using Excel VBA to close IE
  758. How do I count cells in spreadsheet that are not empty?
  759. Pathname reference
  760. MaxLength Property issues
  761. Clearing Ranges from Multiple workbooks.
  762. vb code help with date format
  763. Re: SAP BEX
  764. Run an External .exe
  765. Re: SAP BEX
  766. VBA in Excel - Public variables & VB 6.0 vs version 6.3 in Office
  767. VB executable
  768. Group date into Year and Quarters
  769. why am I getting a 3010 error?
  770. using a range in a custom function
  771. Get File Size (Number of Bytes) of Active Workbook
  772. access closed workbook
  773. Can't Trigger Event Procedure from a Checkbox created on the Fly.
  774. Link Checkboxes and Grey out the Check
  775. IF ... and... HELP ... :)
  776. check if worksheet is empty
  777. Concatenate to a text file
  778. InStr GRRRRRRRR!!!!!!!!
  779. How do I create a range with all values in a sheet?
  780. Assign Macro 2 a Button....confusion
  781. Long running macro and screen update
  782. Creating a varying UserForm using cells from a hidden worksheet
  783. Wrong number of arguments - Help
  784. Private Sub Workbook Open() - question
  785. VBA Coding - any ideas why this UDFs not working?
  786. Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
  787. Re: Help with VBA Mail Merge
  788. Conditional symbols
  789. How to check if Software is loaded on a users C: drive
  790. nested if loop with logical OR/AND
  791. search for string within a string
  792. Large documents and Java
  793. Re: building a reporting sheet which reports by date and shows values of another sheet
  794. highlighting duplicates
  795. Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
  796. Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
  797. Re: Pass Excel User License to Variable
  798. Re: Pass Excel User License to Variable
  799. Advanced filter in VBA - criteria in non-adjacent ranges
  800. Sorting multiple columns as one
  801. RE: Copy row if....
  802. Re: Copy row if....
  803. Re: How to store current row into variable
  804. manipulate string
  805. Working with Rich Text Format
  806. Write variables from a loop, once only
  807. After VLOOKUP!
  808. Advanced filter: criteria in non-adjacent ranges?
  809. newbie help - code need correcting
  810. Find first empty row
  811. RowsToColumn
  812. Using XLA to load VBA program
  813. Dynamic calculations according to user input
  814. Sum
  815. Linking to external workbook
  816. subtotal question
  817. Linked sheet design theory
  818. to click on a cell and go to named local HTML file
  819. Capturing Steaming Data Macro problem?
  820. Countif declaration problem with ""word""
  821. VBA, Excel Date Problem
  822. Need Help with Macro Code
  823. Simple Question
  824. Watch to Trap Protected Sheet (Repost)
  825. Run Time Error 1004
  826. Excel Templates
  827. [VBA] Creating sheets based on criteria
  828. Looping through a group of checkboxes
  829. pastespecial question
  830. send email with email addresses in a range of cells
  831. Pasting Values of range to another range
  832. Just the numbers please...........
  833. save as from combo box list
  834. Accessing Microsoft Access Tables
  835. Do not know to how reference another sheet in my formual - embarrasingly simple I hope
  836. COMBOBOX
  837. Microsoft Discussions Page Layout
  838. Disabling Menus
  839. Dim
  840. resize question
  841. hiding a workbook
  842. How do I "conditionally" change font size based on text length?
  843. Find Duplicates and Append
  844. Send button in Excel
  845. transposing and creating new rows
  846. Macro with Drive-change?
  847. Supress screen update while writiing to another sheet
  848. Macro to Change Font Color
  849. Opens directory
  850. Optimization question: how to bypass copy and paste
  851. Sheet1.Activate vs Sheet1.Select
  852. automating a procedure
  853. Error 1004: Calculate Method of Range Class Failed
  854. Random Sequence with no Duplication
  855. formula
  856. Sizing of copied columns
  857. Data > Table
  858. TreeView
  859. Add Sheets
  860. Macro
  861. Error Handling issues
  862. wrong reference after dragging down a formula
  863. General Loop question
  864. VSTO Cell Alignment Enumeration
  865. Question regarding "INDIRECT" and Charts
  866. Range select
  867. Extracting column number of max value
  868. ? activate a commandbutton in code ?
  869. Repeating macro procedure on several worksheets
  870. Continuous Range
  871. Loop through Combinations and Keep a Count
  872. today() bug
  873. VB code needed as this is way beyond a novice like me!
  874. Run several macros in a row
  875. Help with Object variable error
  876. Deployment of Microsoft Office Xp Primary Interop Assembly
  877. Which control caused the macro to run?
  878. making a formula over varying ranges
  879. Control Face ID's
  880. Automating to generate the next Invoice No.
  881. Editable combo. Elaborate code example wanted.
  882. HyperLink
  883. Naive question on Range naming but please answer
  884. Re: Save workbook, in .zip
  885. Save workbook, in .zip
  886. Strange conditional copying of spread sheet??
  887. Paste Special
  888. code skips blanks in data
  889. Im literally a beginner, please help!
  890. drag formula down with other reference
  891. Help with code
  892. copying combobox
  893. i = input box - help
  894. Autofill dynamic no. of rows and columns
  895. VB Code help
  896. Playing sound in VBA
  897. public function
  898. Adding Labels to XY Plot
  899. Very Strange Error when using Format()
  900. Read out VBA code from a damaget excel.xls workbook.
  901. Copying data to another sheet and sorting it automatically
  902. Multiple selectboxes on one row in a listbox???
  903. Combobox_change does not repond?
  904. Error opening recordset where table is empty (but has field names) - How do I avoid?
  905. Saving Excel workbook in SQL server using c#
  906. problematic problem
  907. Saving Excel workbook in SQL server using c#
  908. Avoiding macro run for terminating by user
  909. Saving Excel workbook in SQL server using c#
  910. Can I get all fields for all tables in a FoxPro DB into excel (one table per sheet) automatically?
  911. copy all named ranges in a sheet to seperate sheets
  912. using cell data to name a range
  913. Compare multiple listbox contents
  914. Excel instances remain opened
  915. VB Complie error - can You Help
  916. variable interest rate calculation
  917. Autofill with changing data
  918. Error while Checking for Regular Expressions Library in VBA
  919. change curdir to a folder on a network
  920. Maintaing a Data List
  921. Conditional Formatting or a Formula I think?
  922. Embedded queries...
  923. Re: PasteFace issue
  924. Navigation Command Bar
  925. FOR EACH statement
  926. Display Last Figure
  927. Command Button
  928. mouseover-event
  929. Copying individual files (workbooks) into worksheets
  930. Message Box Colour / Color
  931. Printing a Sheet without opening workbook
  932. FollowHyperlink automatically
  933. IE Window Name
  934. IsNumber question
  935. Conditional format question
  936. Reading the Clipboard Source Information
  937. display and change listbox data
  938. comparing rows and deletion
  939. Visible Instances of an Application
  940. web page title into range "B1"
  941. Conditional Formating a range
  942. Code Doesn't Wait!
  943. Docking the Watch Window
  944. Range question
  945. Data Validation List
  946. VBA Printing
  947. Combination Formula
  948. Can Excel act as Access?
  949. Bypass entry of data from Lookup Table
  950. Create a list of unallocated payments
  951. deaking with nulls, I think...
  952. Macro to go quickly to a sheet
  953. How to copy the hyperlink of a list of cells in another column
  954. Unlock VBA Project
  955. Userform access on multiple excel files??
  956. Find last used cell in row with blanks inbetween
  957. Copy/paste error help
  958. Newbie: Can't delete to left with WScript
  959. DOS....there must be a better way
  960. Selection
  961. Range problem
  962. VB code help please
  963. formula help please
  964. Keep getting runtime error 1004
  965. Microsoft Excel 11.0 object libary
  966. Extract cells
  967. Worksheet tab popup menu not working
  968. Delete rows with numeric values, leave rows with text
  969. copy question
  970. renaming sheets dinamically
  971. Formula help
  972. Workbook_BeforeSave Head ache
  973. Macro help please
  974. Excel macro to open files within a folder
  975. Printing pdf
  976. Compare cells and grab if matched
  977. Unexpected SaveAs prompt for workbooks with pivot tables
  978. Trouble with Calling a workbook
  979. Why does memory usage expand so much?
  980. Problem with references/variables
  981. Open A Word Document from Excel
  982. does excel know in which cell a button is located?
  983. VBA and line graph
  984. comma as concatenation operator ?
  985. macro to add in a column by manipulation of other columns
  986. de-link *dates* in chart from data
  987. Select Case for Active Worksheet syntax.
  988. filter of column problem
  989. Excel VBA Help
  990. Row Number of Max Value
  991. Capture ENTER
  992. Macro to append En Spaces
  993. double click and move over
  994. clear the values, but not the formulas in a range
  995. Index Match #N/A error, please help
  996. how do I refer to a multi-sheet named range
  997. RE: I hope this Excel question belongs here...
  998. Runtime Error
  999. Userform.Lable Variables
  1000. Storing Sheets Names for loop