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. Footer Picture
  2. importing custom files?
  3. Autofill Until
  4. read multiple line
  5. VBA - Solver use on arrays
  6. second worksheet change
  7. Connection String to SQL to run Stored Procedure
  8. Dailog Box Q
  9. highlighting rows when a value has been found
  10. finding empty selection
  11. Runtime Error "7": Out of Memory
  12. VB 2005 Express and VBA DLL´s
  13. error when sheet doesn't exist...
  14. selecting a chart
  15. Formula using a SUM of 3 code-defined cells
  16. Recommendation for XML Macro language person trying to convert to
  17. programming
  18. Question on Application/Workbook
  19. accessing .mpp file using excel VBA macros
  20. Document merging
  21. Request help
  22. interior color of a cell
  23. Compare rows to col
  24. How to protect a code with password to avoid mishandling
  25. How to find Watch window in Office X VB Editor (Mac OS X)
  26. Rejected Safe Mode action : Microsoft Office Excel.
  27. How can I do this with VBA?
  28. Tab Names
  29. Type Mismatch error in VBA code
  30. Check - Similar Row contents - Different Sheets
  31. Trouble with types...
  32. Multipage control question
  33. macro's run but spread sheet does not updata
  34. I need a way to password protect a combobox?
  35. Help with tidying up code please
  36. userform memory
  37. Type mismatch !
  38. hide rows based on value
  39. Need help with auto selecting cells
  40. Insert Median Automatically
  41. Data searching between sheets
  42. Color cell text based on date
  43. Copy and Paste Cell
  44. RE: Copy and Paste Cell
  45. Path/File access error (Error 75) using Name Statement
  46. dget or dsum, that is the question
  47. RE: Color cell text based on date
  48. Path/File access error (Error 75) after using Name Statement
  49. AddItems to a list box
  50. RE: Color cell text based on date
  51. RE: AddItems to a list box
  52. programatically change the data source of Pivots
  53. New guy with a tricky question
  54. Which is unsupported?
  55. Possible to reference column of named range in array formula?
  56. Command Box jams macro
  57. Help:loop on two workbooks
  58. VBA & Excel: Concatenation problem
  59. Macro to copy sheets from several files into a new workbook.
  60. Querying an Access Database from Excel VBA
  61. How To Q
  62. Worksheet Change Event
  63. ado connection with excel pivotcach-problem update/delete,etc database
  64. Dynamic print area
  65. Its so simple! Why won't it work!
  66. Tom Ogilvy
  67. Faulty Averaging Formula
  68. formatting the target cell
  69. Simple recorded macro crashes on playback. Why?
  70. Macro entering an infinite loop
  71. Pull drive information into worksheet
  72. Modify a data query ??
  73. ActiveSheet.QueryTables.Add
  74. RE: ActiveSheet.QueryTables.Add
  75. Extract a date for formula
  76. End sub early if mismatch
  77. Please, help with concatenation
  78. Macro Button does not work on second click
  79. How do I use the font as a filter
  80. updating wbook from other...
  81. Sum on Multipel sheets
  82. Solver Add-In not installing...
  83. Why must I click twice?
  84. Code to view and Print several documents
  85. last char of a string
  86. Use variable as email reipient names
  87. Command button and msgbox's
  88. Excel Solver Programming Error
  89. How do I set a price minimum in a spreadsheet?
  90. Copy-Paste a Row via a cell reference
  91. Copy File without opening
  92. Code to get data from webpage into Excel
  93. Progress Bar
  94. How do I update a ODBC query in Excel using pivotTables in VBA?
  95. Highlight Cells
  96. can I get the printer options to display with the print icon
  97. Pause Macro For Start Row While Parsing a Text File
  98. Update Named Ranges
  99. Function Help
  100. Question
  101. IF statement that looks at part of the contents of a cell.
  102. VBA format function Win2000 and WinXP
  103. If two lists don't match
  104. Range Total
  105. Deleting rows between
  106. writing data to a tab delimited text file?
  107. label effect
  108. Compare and report differences.
  109. Adding Cells in two different Workbooks
  110. relative time
  111. Fill the formulas at adjacent columns by VBA
  112. Conditional Autofill
  113. Open a protected XL file
  114. macro security & digital certificate
  115. Matching values in 2 columns
  116. Macros disables under medium security
  117. Textbox input control?
  118. Binary sorting?
  119. VBA to find account number that resides in one of several files
  120. How do you hide macro names from showing in "Tools"?
  121. Automatically Printing Autofilters
  122. Opening password protected files
  123. if duplicates then add quantities?
  124. Cell value changing automatically
  125. Last cell and first emty???!!!
  126. Toolbox gone funny
  127. Macro, how to protect sheet, but allow pivot?
  128. how to create excel file when clicking on the button.
  129. Tidy up of data within Excel Report
  130. "save as" macro help
  131. Delete a ROW in EXCEL
  132. INDIRECT COUNTIF's??
  133. Relationship between CHR alt Alt-XXX on the numeric keypad
  134. Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use:
  135. without opening excel i want to save the excel in some specified location
  136. Using excel in .NET
  137. Wrapping cell contents in quotation marks
  138. update wbook from vaiuos...
  139. binary sort?
  140. Lookup and store in array
  141. from rows to columns
  142. User Guided Button???
  143. excel to word help
  144. Hide Column - With text in cell
  145. Obscure userform problem
  146. clearing a selection
  147. Macro Bombing out - Leith Ross
  148. Automatically run a macro in time that user wants
  149. help with code to paste from another workbook
  150. question for Tom Ogilvi
  151. conditoonal programing
  152. Hide Column Condition
  153. what is the code to delete row&column.
  154. Make worksheets transparent
  155. Rename Worksheets excluding Weekends and Holidays
  156. how do I get my 2003 excel to recegnize my pocket excel worksheet?
  157. scroll rows up or down
  158. Userform Help
  159. Percentage difference between numbers in 2 cells
  160. Hiding rows based on cell content
  161. Due date changes when new value is inputted in a different column
  162. Specifying Range.Select in a loop
  163. Schedule Print Excel Document
  164. Change date with KeyDown
  165. Custom function - Help please
  166. beginner question
  167. RGB values
  168. FIND function not defined in macro
  169. FIND function not defined in macro
  170. Can't edit Excel worksheet with picture when automating Excel
  171. create a form for search text in active sheet then got to selected
  172. Anyone help please
  173. asynchronous Procedure Calls
  174. Need code for simple IF-Then
  175. How to crop only numbers from a string?
  176. Compare and update arrays
  177. How do you "Find" on NonActive Page & Return Values?
  178. Combo Boxes
  179. formatting the target cell
  180. Comparing two lists
  181. Keeping VB Window on Screen
  182. VB Help to Look at Next Row
  183. Sendkey
  184. how to subtract a range from another?
  185. Using a Form in a Macro
  186. Runtime Error 1004
  187. convert excel data to 2-D array using macro
  188. CreateObject("Notepad") ?
  189. Quick and Easy from Checkboxes
  190. how can I display memo data type in excel form?
  191. Move some data to new workbook - my attempted macro is no good
  192. Adding Cells
  193. Not rounding numbers in VBA
  194. VB Code To Conditional Format > 4 arguements
  195. VB Code to Conditional Format a Cell Range
  196. automatic import of .csv file into access database
  197. macro to unhide row
  198. Sort on Protected Fields
  199. name a backup file
  200. what is the best way to find a value in a sheet in VBA?
  201. Programming Excel with VBA: How to make Selection Nothing
  202. Align multiple MsgBox lines
  203. Error when checking field for data
  204. Header/Footer horizontal margins/text positioning
  205. Conditional Formatting for True/False
  206. Showing selected cell value
  207. Trend funtion
  208. Array <--> Range Error
  209. Array problem?
  210. Variable in more than one module
  211. Userform input into a particular cell
  212. Error messages: Program
  213. CANT SAVE TOOLBAR CHANGES
  214. Request code help, sorting array in memory
  215. Range variable not being reset
  216. Text Box in Chinese Under Excel 2003
  217. Pasting with Dynamic Last Row
  218. calculate number of business days between the 2 dates
  219. Quickly Update Range
  220. run macro only if condition is met
  221. Can I program Excel to open a workbook to a default worksheet?
  222. Chart disappears in Excel 2000
  223. Run SQL Server stored procedure in Excel macro
  224. Autoshape textbox
  225. Catching max iterations Stop of Solver in VBA
  226. cannot maximize or minimize
  227. Excel - Access
  228. Saving Reloading
  229. how do I calculate difference between two dates and times
  230. Anchoring a chart to a certain area
  231. Please add a "sheet" function like "row" and "column" functions
  232. difference application.quit & application.close
  233. Remove Error
  234. VBA macros to check a blank
  235. Deleting Rows
  236. putting a simple calculation in a field that may change rows
  237. SendKeys - Right Click?
  238. I need help -extracting specific data
  239. Help with entering data
  240. Column ROW CEL range vba
  241. MailingAddressesToColumns
  242. Can't get Find Box
  243. identical macros run fast and slow
  244. Appending special characters
  245. Turning off alerts in VBA
  246. Importing from multiple text files
  247. For Each Next returns "Empty" when Data in Cell
  248. What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
  249. Am I in the right place?
  250. looping a 'find and delete' code
  251. filtering CSV data
  252. Opening a .exe file from an excel hyperlink
  253. Circular referance problem
  254. How to color a row?
  255. Password - 3 chances and **off
  256. is there any sample of an excel dashboard ?
  257. Convert XLS to PDF
  258. Command bar diclaration
  259. Adding total over two worksheets based on date values
  260. Transpose and separating worksheet based on Input box name
  261. Make a list from a table of elements ?
  262. SaveAs with a pre-defined filename
  263. Form, SetFocus and AfterUpdate issue
  264. Refreshing a database query
  265. Sheet protection altered when saving
  266. XL2003: control button not visible
  267. Moving between a column's cells
  268. need some code help please
  269. Changing the macor button color
  270. Creating local cube using PivotTable
  271. all the messages in the thread
  272. Help with my user form
  273. count number of "D"
  274. relative sheet pt2
  275. [Help]Excel mouse select region
  276. Need Help Pls..... Urgent!!
  277. Array problem: Key words-Variant Array, single-element, type mismatch error
  278. LAddress of last cell in worksheet
  279. Array problem: Key words-Variant Array, single-element, type mismatch error
  280. How to show a progress bar in sheet calculation?
  281. saving and reloading the contents of a userform
  282. Just curious about Excel copying dates between workbooks???
  283. Does Sheet exist? If True Use If False Create
  284. comparing vertical list on one sheet to horizontal on another
  285. And another puzzel
  286. Msgbox not working
  287. Copy formulas exact without references changing
  288. Using Subtotals in VBA
  289. Copying template to workbook but user form does not copy?
  290. Closing Applications
  291. Refreshing Charts inside a Macro
  292. Hide & Unhide Charts
  293. How do I set up a daily average of unit sales formula
  294. Multiple For/Next
  295. Excell macros(need help)
  296. advanced filter macro to locate values via multiple criteria
  297. preventin links from updating
  298. Excel XP incompatible with Excel 2003
  299. Looping statment
  300. Macro to compare cell contents and make calculations
  301. NETWORKDAYS problem
  302. Which is the good PERSONAL folder in XP Pro
  303. Using automation to add xy scatter chart
  304. adding link to chart title using VB
  305. Finding cell address...
  306. % Change calculation
  307. Addin Modified date/time
  308. Checking if Workbook is Open
  309. Sumproduct With Dates & Text In Same Column
  310. Error Trapping when getting external Data
  311. File Save, yes, no, cancel macro
  312. big problem !!!
  313. Flip Letters and Numbers
  314. Problems with Combo Box
  315. Invert Picture
  316. link excel to paradox
  317. easye compile question
  318. Nesting Autofilter functions
  319. paste values
  320. Who can tell me where I go wrong?
  321. question error handling
  322. Getting Current Link Value
  323. Logon Screen
  324. relative sheet macro
  325. VBA Lookup
  326. validate lists
  327. I want to count rows between the occurence of one word.
  328. Running a procedure in a module on graph change
  329. Macro to hide rows
  330. open worksheet
  331. place pictur underneath tabs on multipage
  332. place picture
  333. Programmatically check cell formatting
  334. Range of Worksheet Function Max
  335. Wierd Msgbox action - Can anyone see the fault?
  336. why error in.... send xls
  337. Excel, Microsoft Jet and OLE-DB
  338. Using FIND in Visual Basic
  339. What do I not see?
  340. Can VBA Match?
  341. Unlock cells in other open workbook
  342. Top 50 Customers
  343. Works using XL interface but not in VBA (err: 1004)
  344. If option button not selected
  345. error problem
  346. Custom Menus in Chart Sheets
  347. VB error, runtime error 13 (type mismatch)
  348. Data Bound Controls in VBA??
  349. Trust Access to Visual Basic Project
  350. dynamic userform
  351. Remove Formulas, Keep Values
  352. excel hide and visible problem
  353. combo box using input range
  354. FileLen with very large files
  355. UserForm Templates
  356. autofiltered cells
  357. udf to convert <any text> to range name
  358. Import A Crystal Report into Excel
  359. Building a Pivot Table where column headings will change
  360. building code for an individual report
  361. COMPARE 2 WORKBOOKS
  362. Cluttering Clip Board - Excel XP
  363. Select Merge Areas
  364. Clearing what you have previously selected
  365. HOW CAN I DEFINE A RANGE IN LOOP
  366. changing row color
  367. How to align entries in columns so other columns will follow ?
  368. rename file
  369. Worksheet Functions that Change Other Cells
  370. ASP
  371. Password and view of spreadsheet
  372. Selecting sheets with unique names
  373. How to use a combo box
  374. concatination of cell contents
  375. RE: Worksheet Functions that Change Other Cells
  376. input box
  377. generating passwords question
  378. % variance calculation - amended
  379. input check in cell question
  380. % variance calculation
  381. How to glance at other workbook while remaining in MyForm.Listbox?
  382. Command bar diclaration
  383. How to "visit" other forms properly?
  384. Macro to copy and paste special values
  385. Macro to copy and paste special values
  386. Moving records from a sheet to another
  387. How to change Macro security level very high to low...
  388. Excel 2003 VBA: Detecting and removing toolbars
  389. any variable size
  390. Save As Dialog does not prompt for Web File Properties
  391. using an input box to allow users type in the differnt fields name
  392. Fill a cell in orange if the result is negative, help please.
  393. Single Space in PRN
  394. Simple problem
  395. Re: print column labels with one row of data at a time.
  396. Percentage Calculation using VBA
  397. Data validation on form
  398. Insert quotes around a lookup value
  399. RE: Insert quotes around a lookup value
  400. Macro error on MS Excel 10 for Mac Release 1
  401. Protection within Macro
  402. Forms
  403. Possible to have a named array formula?
  404. How to make excel to treat values in cell as a number?
  405. Deleting a row based on a value in a column
  406. String to number
  407. How to get a sheets name or list.
  408. Use CopyFromRecordSet to insert named range formulas? (Excel 2000)
  409. clear format from RichTextBox
  410. Maximum number of characters in a cell
  411. Fill blank cells
  412. Generate specific matrix
  413. Custom Icon for an Excel File
  414. Writing an array(2d) of user types to a worksheet
  415. Re: How to calculate with years....?
  416. Re: How to calculate with years....?
  417. How to calculate with years....?
  418. Argument help for UDF's
  419. How to make scrollbar disappear after clearing textbox?
  420. Urgent solutions needed to resolve vba coding
  421. conditional formatting question
  422. Userform with logo and without closebtn
  423. Worksheet function Vlookup
  424. Changing Values of a list
  425. UserForm referring to another excel file
  426. Script to increase font size of cells
  427. Deleting Command Bars on close of a workbook
  428. how can I use access forms in excel2003
  429. Multiform Tab Colours
  430. Fill two column combo box
  431. Importing Web Data
  432. How to run sub?
  433. MSQuery settings? ConnectionString?
  434. how to consolidate sheets
  435. AfterUpdate Event not Running
  436. Breaking a link.
  437. VBA Question
  438. Passing a Function name as a procedure argument
  439. get cell of function
  440. data from exel to visio for timeline
  441. Lost the menus on right mouse click
  442. Identifying the user's drive letter
  443. where can I learn indepth how to use class modules in excel vba
  444. Worksheet Question
  445. Flip comment to left
  446. Textbox Question
  447. Position menubar
  448. Macro to insert this formula automatically on start up
  449. On Form Start Up
  450. how do i build the macro i need?
  451. easy vba question
  452. Formatting Textbox, passing values to worksheet
  453. trigger database query on cell data input
  454. difficult function
  455. Auto Userform Picture Change
  456. Calculating hours between two points in time
  457. Parsing Huge Files of Text
  458. SpecialCells Method Question
  459. Recognize first emtpy Cell in column
  460. Code for reconizing a empty textbox
  461. Year question
  462. can someone help me with this formula
  463. Excel VBA: calculating checksums
  464. CurrentRegion less one Row
  465. Popup opening a spreadsheet
  466. How to reference a worksheet which name is specified in a cell
  467. Specifying range relative to activecell in macro
  468. Coping from existing spreadsheet
  469. Using the value in the inputbox again
  470. Turning off screen update while macro runs
  471. adding formulas to blank cells
  472. System Tray Notification/Alert
  473. How do I publish an entire excel workbook on the internet
  474. please help
  475. combobox problem
  476. Taking control of an existing instance of Excel
  477. copy column
  478. resizing excel window
  479. Help with referencing variable range
  480. Help with referencing variable range
  481. Input data from file to Excel in Column Format
  482. How to Put Conditional Sums in macros
  483. Used Rows Range?
  484. Import from another excel workbook on open
  485. Macro timing might be the problem
  486. quotation marks
  487. multiselect remove
  488. Maximum filename length. 218? 211?
  489. More formula help
  490. Sizing Autoshapes based on text length
  491. OLEDB - INSERT INTO Excel FROM Stored Procedure
  492. Reginal issue(Please help)
  493. Create filepath if it's not available
  494. Adding input to macro
  495. WithEvents of MSForms.Textbox
  496. Formula Problem
  497. Advanced Filter stopped working. URGENT
  498. text files
  499. VSTO: ConditionalFormatting not working
  500. following web link that are not hyperlinks
  501. Treeview, avoid selecting node on keydown or up
  502. Greying out the OK button
  503. web, querytable &jpg
  504. Use of SUMIF possible?
  505. Problems with Auto_Close when opening spreadsheet from a macro
  506. Creating an AVERAGE next to the top of a selection
  507. Formula in VBA
  508. Need MACRO to search for date
  509. How to install MICROSOFT FORMS 2.0 OBJECT LIBRARY
  510. Create an e-mail with recipient, subject and text
  511. Macro not running when cell value is updated
  512. Autofill until blank cell is reached
  513. Using variable name as a value for inserting a row
  514. How to evaluate string?
  515. Transfer Data to Customer Database
  516. Moving / sorting sheets in VBA
  517. Validation List Box
  518. Automatically Save and Route Code
  519. Conditional Auto Fill in
  520. many similar event procedures
  521. Run A Macro Against a Table Until it gets to bottom
  522. Filtering TIME/DATE
  523. Form displays but no text
  524. check if in list else quit application
  525. Re: Button to email my spreadsheet
  526. CSV separator in macro?
  527. File protect via extern USB crypto modul?
  528. Progress Bar
  529. Pivot - limiting user access with VBA
  530. How do I simulate a cursor down in Excel Macros
  531. extracting a string from a cell
  532. How to choose a folder
  533. please help me with folder and subfolders
  534. mbv vba-programma subfolders aanmaken
  535. Replace C/R with @@@
  536. Change - Status bar font
  537. Setting spaces between text in a cell
  538. Save "speed up"
  539. mutlipage in the center of userform
  540. create button in excel toolbar
  541. Draw a cirle
  542. User Defined Function Problem
  543. don't forget to keep up with excel 12
  544. How to select a specific file type
  545. Select rows using a variable
  546. VB Find String located after "/"
  547. Quick Search Loop
  548. change event procedure
  549. Import emails from outlook folder as TXT
  550. extract string
  551. Run Macro if
  552. sheet copy method fails...
  553. runtime error 1004
  554. determine if cell address is within a range of cells
  555. Automate Autofilter Results - Copy to New Sheet
  556. input box - I don't need the "cancel" button
  557. VBA Hangs
  558. ADODB Connection Problem
  559. Sharing data
  560. Open DialogBox in VBA
  561. Label minimum value in Chart
  562. Using CELLS function to define RANGE funcion
  563. how to add text to a comment in VBA
  564. Print selection in one page
  565. Saving picture in clipboard into file
  566. Deleting Columns Based upon Heading
  567. Help - Problem with date precission
  568. Copying a Variant Array to a worksheet
  569. Need to disable a prompt in Excel when trying to programatically update links in a PPT Presentation that is linked to Excel
  570. Getting Notepad.exe text in Excel including leading spaces
  571. VB Sum n+1
  572. Return key to "OK" a DialogBox
  573. Finding equation between two sets of noncontiguous data
  574. Defualt Formulas?
  575. Nested Withs of Multiple Objects (Parent-Child)
  576. Used Range of worksheet?
  577. Arranging data
  578. retrieving "Records Found"
  579. Sorting with code
  580. How do you link 2 drop-down menus?
  581. VSTO PasteSpecial
  582. Copy paste a formula in multiple cells
  583. Macro - Selecting Next Available Cell
  584. sendmail question
  585. Re: PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic
  586. Error trying to run a query in Access from macro in Excel
  587. help with macros to protect different sheets
  588. Reference problem
  589. end with loop question
  590. Disable Excel Program Messages
  591. Copy paste a formula in multiple cells
  592. Conditional Row Deletion
  593. BeforeOpen Event and Data Validation annoyance.
  594. Syntax To Link 2 Workbooks
  595. Re: "tab" thru cells in a specific order
  596. Protect/Unprotect Not Working
  597. Hide row if column does"not" contain
  598. Compressed folders
  599. Range of Object Global failed
  600. Error 1004 in search/copy
  601. can I set up a sort command to happen by clicking on a table headi
  602. If Cells.Find can't find anything
  603. Running a macro
  604. aligning textboxes on worksheet by cell reference?
  605. Userform close button
  606. Worksheet name
  607. split?
  608. Accessing Columns by name in a Row loop in VBA
  609. Quick Copy
  610. Button on toolbar for AutoCalc
  611. Retrieving contents of wildcard match in search and Replace
  612. Creating a pivot table automatically
  613. For each workbook
  614. Problem w/ Macro after move to Office 2003
  615. Rounded-off number
  616. Excel should let me fill down when I right-click
  617. Code to copy formula to variable range
  618. Splash Screen
  619. Autofilter and Cell Count
  620. Paste Special
  621. Help With Formula To Calculate Commissions
  622. Clear Columns Content
  623. Find, Copy and change from row to column
  624. Running Totals Formulas
  625. Calling a macro on a change of Field Button in Pivot Chart
  626. Selecting a single row range
  627. Delete current month using AUTOFILTER
  628. Cell Referencing
  629. Find the user of an Excel file
  630. No Blanks
  631. Return value based on certain criteria in multiple columns
  632. Stuck with script - Help Please
  633. how to request Code-signing certificate
  634. Margins control to VBA code
  635. Help with code
  636. Excel-created Word instance hanging on thru Outlook?
  637. Code Execution Has Been Interrupted
  638. How to open an external tool directly from an Hyperlink?
  639. Call subroutine from another workbook
  640. working with excel from visual studio 2005 express
  641. Excel VBA/Listbox Query
  642. How do I activate an facility from inside a macro?
  643. Recording a filter which then doesn't work.
  644. deleting all macro/codes from workbook
  645. How do I move a macro from 'personal' to a specific excel doc?
  646. Need to do a fancy string copy plus
  647. Urgent Help needed with macro
  648. Reflecting info between an excel file and a word one or two excel file.
  649. Macro Sum of Cells
  650. Refer to a hidden sheet using a macro.
  651. Accessing word documents from Excel
  652. macro to insert lines
  653. detecting data in a range
  654. Display AutoShape in UserForm
  655. Finding a string in a cell
  656. How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file?
  657. Relative columns in range vs absolute columns
  658. "Move Method of Worksheet Class failed"
  659. Running Watch in Excel
  660. Protection killed by sort button
  661. Problem SelStart and SelLength
  662. Help with For Next and Exit For
  663. userform fullscreen
  664. Selection.PasteSpecial with Office 2003
  665. Problem with "#N/A" after vlookup
  666. Truck loan spreadsheet
  667. Autosize textframe
  668. Filling down formula to cover complete range
  669. Rename Sheets based on date range
  670. How to change Macro security level very high to low...
  671. executing an add in
  672. import text file
  673. pass cell value as string to function
  674. dates in pivot not coming up with years
  675. Updating Macro's in Multiple Workbooks
  676. pivot date field range
  677. Formula
  678. Display Alert
  679. How do I simplify a macro in excel?
  680. Finding a row number
  681. javascript causing web query problems
  682. Concatenate a string when cells are not zero
  683. Insert Literal in Access Table using JETSQL
  684. Sorting number as text
  685. initialize userform, using a sub
  686. using text in an if function
  687. VSTO 2.0 vs Excel VBA
  688. Why Is This Crashing
  689. sumproduct in VBA
  690. Excel formatting should expand to other cells
  691. Run a macro when a cell is changed by an outside source
  692. How do I change color of cell or of character in a cell?
  693. copy range and paste to new worksheet
  694. Event priority
  695. Auto save at intervals to new filename in excel
  696. Activate code from another VBAProject
  697. Select text from a field
  698. Help with Date Reports
  699. Cells.Find problem
  700. Deleting data below last row in a determined range
  701. Deleting data below last row in a determined range
  702. outlook profiles
  703. Create a collection of controls
  704. Macro VBA, Drop down IF statement
  705. Macro VBA, Drop down IF statement
  706. Excel Data Merge
  707. Append columns to existing worksheet?
  708. Anyone know how to enter Info in a web page through VBA in Excel
  709. Automate Opening Files
  710. Hidding columns not working
  711. SQL query
  712. Excel and DDE CPS Plus serial data acquisition problem
  713. Why this basic LOOP does not work!
  714. How to: obtain the filename that a module exists in, via VBA?
  715. VSTO column insert shift to right
  716. "tab" thru cells in a specific order
  717. New menu items
  718. How to test if a range is with in another range?
  719. set print area based on selection
  720. set print area based on selection
  721. (EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
  722. Macro to paste in another workbook
  723. Vlookup top to bottom & not left to right
  724. Instert Rows Based on Cell Value
  725. Instert Rows Based on Cell Value
  726. Letters = Numbers
  727. Letters = Numbers
  728. Mirror/Flip Axis/Chart
  729. Mirror/Flip Axis/Chart
  730. Select paticular cells
  731. finding cell value when formula
  732. Automate Password log-on
  733. Copy Contract Number to CenterFooter on multiple sheets
  734. Comparing Absolute Column on multiple rows
  735. Creating Pivot Tables with macro Problem
  736. ChDrive error (server path)
  737. Macro to Recognize Dates
  738. How do I, in a marco VBA, code to take data from excel and append it to Access?
  739. How do I Append excel data to a Access database table in a excel macro?
  740. initializing multiple comboboxes
  741. Using Date$ function in file name
  742. Using Date$ function in file name
  743. Find last populated cell in a row.
  744. Creating Pivot Tables with Macros Problem
  745. userform in a separate workbook?
  746. How do I deal with several workbooks that are open in the ActiveWi
  747. Vlookup to closed workbook ?
  748. how to format a Docmd to pull in an Access file in Text format
  749. how to format a Docmd to pull in an Access file in Text format
  750. finding next empty row from bottom up!!
  751. finding next empty row from bottom up!!
  752. Problem with coding a msgbox
  753. Problem with overflow
  754. Macros--user choices
  755. onMouseOver Highlight Rows
  756. Error with macro-it worked now it doesn't
  757. saving file name and location with excel macro
  758. Filtered worksheet is frozen
  759. IsDirty
  760. problem with formatting text in every worksheet same workbook
  761. VBA syntax
  762. security for folder??
  763. excel lookups
  764. Pasting Tables from Excel to Word
  765. First Business day of the month?
  766. "grouped" footer changes
  767. Estimating costs
  768. Appending to Access table
  769. Appending to Access table
  770. Focusing on open workbooks
  771. Focusing on open workbooks
  772. Excel Spreadsheet troubleshooting
  773. For Each Statement still not working
  774. Help with Vlookup to several workbooks
  775. How to control the user can or cannot select? Selection filter?
  776. Unlock VBA project or Copy Sheets
  777. VBA Insert Stement for SQLServer
  778. SetFocus: conditional use of
  779. SetFocus: conditional use of
  780. Slecting worksheets one by one.....possible?
  781. Evaluating files without opening
  782. AutoFilter criteria
  783. Why No Work?
  784. For Each Statement not working as expected
  785. How to program a code to die
  786. How to program a code to die
  787. Putting Formula in Cell
  788. I want excel opening path.
  789. I want excel opening path.
  790. Close Internet connection
  791. Accessing excel 2003 from visual studio express edition
  792. Form.Show Problem in Excel 2003
  793. Mark a range from activecell
  794. Mark a range from activecell
  795. Replace formula with IF(error(formula;"";formula)
  796. highlight text in userform textbox
  797. btnUpdate_Click() Question in VBA
  798. error handling
  799. Hiding columns
  800. Prevent users from deleting the first row of a list
  801. Can this be done? Type of lookup
  802. data analysis toolpak
  803. data analysis toolpak
  804. Code for optimization, ReDim Preserve not handling it well, HELP please!
  805. Learning Excel
  806. mailing
  807. mailing
  808. double data
  809. double data
  810. Clarification on "Application.Worbooks.Count" proceedure
  811. VBA Print set up very slooooooowww
  812. Copying between Workbooks
  813. Re: Split Function gives rn-time error
  814. Lost Macro Control Characrters for Macros in Excel
  815. Add Dynamic Array to List Box
  816. Write Unique Values to New Worksheet
  817. Add .LOG to .txt file on creation
  818. Add .LOG to .txt file on creation
  819. Split Function gives rn-time error
  820. Split Function gives rn-time error
  821. Reset menu wanted
  822. quitting worksheet then excel if....
  823. Copy paste manually
  824. "tabbing" from one element to the other
  825. "tabbing" from one element to the other
  826. VBA: Object variable or With block variable not set (Error 91) - ???
  827. What's the most efficient to check a file name is valid?
  828. Copy last row with data to next empty row...
  829. Copy last row with data to next empty row...
  830. Setting EnableResize = False
  831. Cells(i, "B") not working
  832. Using my own dll to my excel code
  833. Invisible the Customize item in Execl
  834. Why am I getting a "Type mismatch" Error
  835. Copy only some existing worksheets to a new workbook
  836. Macro to change filename of the Hyperlink
  837. Multiselect ListBox - Active/Inactive Items
  838. Mtge calculation (Dly compound interest and multiple interest rate
  839. how do I prevent a workbook from being saved?
  840. using xlDialogChartSourceData
  841. Auto_Open Workbook_Open
  842. formula problem
  843. HELP WITH WORK/EXCEL MACRO
  844. type mismatch on saving excel calculation mode via VB app
  845. Re: formatting columns with formula results
  846. How to copy to cashe?
  847. How to delete spreadsheet if wrong password entered?
  848. Automate "Allow Users to Edit Ranges"
  849. Hyperlink to an external program
  850. XML Source Borders - Any known bugs?
  851. Protect Excel VB macro
  852. combo box multiple workbooks / sheets
  853. Usage of SUMIF formula in the VBA code
  854. Is there any way to switch among different sheets in a workbook while an inputbox is popped?
  855. Sub Totals with multiple rows and columns
  856. show form yes/no... if anything other than no, close appl.
  857. only letters in text box
  858. XLA add-in Abort load on Auto_Open
  859. problem macro to show a warning sheet...
  860. Stopping automatic macros
  861. error in attempt to warn about macro security
  862. Open / Run Application using VBA
  863. Converting Dates Problem
  864. Macro to copy excel and paste in word
  865. api fileopen dialog - lpstrFile size limitation?
  866. How do you turn a grid into columns?
  867. Help with formula
  868. Detecting if workbook running in IE or in Excel
  869. How to force VBA to create an Excel.Application object of specified version of Excel?
  870. Menu of sheet names
  871. Create New Sheets from Filtered List using Template
  872. Can Excel or Access activate a sound file based on a cell value?
  873. Data Flipping - Approach with formula?
  874. Close file automatically
  875. start application / macro warning problem
  876. How do I change the color of a cell depending on the result of the function in that cell
  877. Shelling out to DOS
  878. Data Flipping
  879. selection.interior
  880. Easy-Selecting "No" from message box
  881. Count between Values
  882. VBA: How to pass arrays in Function Calls?
  883. Auto Select from list of values
  884. blank filling remaining characters in a field.
  885. Assignibg a value to a property from a cell
  886. Resizing my range - End row
  887. Help with looping
  888. Delete Row based on cell contents
  889. Buttons & Timers
  890. Unusual excel behaivor causes crash... Magically linked worksheets?? Why?!
  891. .dll error message help needed
  892. Userform - Move to next textbox field by hitting enter instead of
  893. Excel data to SQL Server
  894. How to judge wheter an object is existing or not
  895. how to cancel the right mouse button
  896. VBA - Check for password protection
  897. Wait time variable
  898. Sorting and Filtering out data
  899. 'If' Statement - Must be a Better Way to Do This!
  900. Disallow Continuous String of same Character
  901. Can't Find Excel Interop reference
  902. how do I choose only certain names from a long list in excel
  903. XML Mappings to VBA
  904. Dynamic range (object variable error)
  905. ListBox external source
  906. Run-time error 9 Problem
  907. Use ADO to access SQL Database
  908. Calculate a suspense date of 90 days.
  909. What parameter changes upon new workbook Save?
  910. shortcut keys in VBA
  911. UserForm ListBox Events
  912. Why doesn't "Resume Next" work?
  913. replace text in files within subfolders
  914. Checking the status of a checkbox in a user form
  915. Date function: 1st, 3rd and 5th Mondays of a month
  916. Copying values between sheets
  917. How to ensure a VBA sub is run before closing a workbook
  918. Protect a worksheet but allow column resize
  919. copy subfolders, replace text in files and save files in copied subfolders
  920. invoking music through VB code
  921. Is this possible?
  922. Macro from a different xls file run, still says file in use
  923. convert american dates from a query
  924. convert american dates from a query
  925. Old Format or Invalid Type Library
  926. Choosing different cell values by user clicking a button
  927. sumif or sumthing else?
  928. If statement with cell validation
  929. how to combine 2 or excel into 1 excel file(different sheet)
  930. Automation object question
  931. damaged file
  932. Format a number to display as alternative text
  933. userform error
  934. mail
  935. Copy rows, but exclude blank rows
  936. Vector addition and polar plot... need help
  937. userform controls
  938. Copy and paste between sheets
  939. Re: Sort method of Range Object Failed
  940. Programming Chart Series
  941. Detecting when Excel user inserts or deletes a row
  942. error with userform, "unable to create embedded object"
  943. Code to Enable Macros
  944. RE: Using Array variable in FIND function
  945. RE: Using Array variable in FIND function
  946. Re: Name a Chart so that I can adjust it's position on the worksheet(programmatically)
  947. Text Box lost its leading 0 - need help
  948. Move Data
  949. Validation eradication
  950. need list of unique values from array in memory
  951. User Form Caption controls beyond formatting
  952. Help - PasteSpecial Method - Not Working
  953. Copy Problem
  954. Userform Question (Load/Unload/Show/Hide)
  955. Row number for End of Template
  956. "FIND" function
  957. VBA to Protect Worksheet
  958. Search for word(s) in several sheets
  959. Calculating a date within the OLE DB query
  960. Hide Macro Process
  961. My links in excel keep changing when adding another link?
  962. Help: Compile error: type mismatch: array or user defined type expected
  963. Text to Date
  964. FIle Open/Browse on Macintosh
  965. ~Help~ converting Excel equation to vba function
  966. Find and Replace several items
  967. check for certain dates in excel
  968. How To Reference The Previous Or Next Workbook s
  969. How to copy a sheet from a workbook to another in different folder
  970. How to transfer info automatically from an excel data base to a word document OR an excel
  971. Add standard button on custum commandbar
  972. VB to print one sheet twice, double-sided?
  973. excel spreads
  974. Combobox / Data Problems
  975. What does Excel97 not like about this Code Q
  976. DYNAMIC RANGES
  977. Transfer pivot table data to another workbook
  978. Range - Application Defined or Object Defined Error
  979. Selecting a file from dialog
  980. Macro doesn't work
  981. how to call subprocedure from within procedure?
  982. Transfer Excel Worksheet to Access
  983. Export As Gif
  984. SaveAs and always overwrite?
  985. A script to write in missing text
  986. A script to write in missing text
  987. TreeView for Dummies
  988. Parsing for middle initial
  989. attn: Tom Ogilvy re: cell data in header
  990. Looping thru all rows with instr() test
  991. Excel2000: code too slow
  992. how to validate excel spreadsheets
  993. Save file without a password req
  994. Conditional VLOOKUP?
  995. Replace formula's in two columns with the value's with VBA
  996. can we upload files in google group
  997. More info
  998. Copy Rows if Cell F? contains
  999. Controlling MS Word from VBA Excel
  1000. Excel distributables?