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. Solved
  2. Ranges into an array.......why doesn't this code work?
  3. Problem copying from protected sheet
  4. Re: Pivot Table data based on user input
  5. Re: Conditional Formatting a whole line based on cell value
  6. Excel Charts and VBA
  7. sheet1 tab staying still
  8. One button, one macro, several sheets
  9. Delete File(s) over a certain age
  10. excel sheet dirty read and dirty write?
  11. Excel Publishing option
  12. Converting a file to text
  13. I create sheet using vb codes after that i want change sheet name
  14. Selecting a cell during a macro
  15. Can i send a message in communicator using an excel macro
  16. Re: UDF that participates in circularity always dirty
  17. Re: Application.FileDialog(msoFileDialogSaveAs)
  18. Create Folder
  19. Reposting -- no response yet -- issue with removing validation in
  20. Find character in string
  21. Find character in a string
  22. Adding Shapes: Position changes when running code a second time - Why?
  23. Re: Can this be done better? - 'selective protection'
  24. Outlook to use procedures written in Excel VBA
  25. stop redundant calls to UDF
  26. Using Commandbutton for different ranges
  27. Events in another workbook.
  28. Re: Writing a Formula or VBA
  29. VBA Macro
  30. Looping Through Combobox
  31. Formula/ Macro to combine data from multiple rows
  32. Help needed for Visual Basic 6.0 Macro to rename an Excel WS
  33. Paste special transpose macro
  34. Combobox & Addresses
  35. Calculation Time
  36. Control Toolbox vs Forms
  37. Re: Matching data in spreadsheet columns
  38. Formula calculating very slow
  39. Last 4 tests
  40. Helo with Justify macro
  41. Count values in different columns
  42. RE: copy csv file to Excel
  43. office 2007 and C#
  44. inputbox, color of default background is black
  45. Refer to a control inserted in chart
  46. Re: Data Entry and Protection
  47. Re: Procedure too large
  48. Macros and VB in excel
  49. Creating many worksheets with text from initial worksheet (and mor
  50. Macro/VB issue with Microsoft Excel
  51. Sending Mail from Lotus Notes
  52. Re: run sub routine with multiple conditions
  53. Pivot Table Macro
  54. Worksheet activation on Opening Workbook
  55. Re: Store Current Selection As Range Variable.
  56. batch process to covert file to excel file
  57. command in filter, then save as individual workbook and print out
  58. SaveAs problem in Excel VBA script
  59. Using SendMail through Access - Excel Automation
  60. Re: sending automatic email with VBA-Excel in Vista OS and Windows Mail
  61. Re: AllowedEditRange
  62. Re: Matching Records in two tables
  63. Re: User Defined Type not Defined
  64. Search Functionality
  65. Re: Userform Control Enter Event
  66. RE: Copying a Named Range with changing cell references
  67. Re: Print with no line feed
  68. Re: Page break macro based on cell content / formula
  69. Re: How to disable close button in userform?
  70. Re: Issue with ComboBox on a UserForm
  71. Re: 2007 Ribbon control disabled by Excel when sheet is protected - Override with getEnabled?
  72. Assigning a Range to a dynamic array
  73. RE: Procedure too large
  74. VBA Command - Not Familiar With Program
  75. Re: Tweaking to pull a local HTML page instead of a server page?
  76. Re: C++ Excel automate, add hyperlink
  77. Re: How to employ ExecuteMso Sub in Excel 2007?
  78. RE: Ref Commandbutton
  79. no custom button in ribbon
  80. Get First Letter of each word
  81. Data Validation Dropdown bug
  82. Copying from dynamic workbooks
  83. RE: Ref Commandbutton
  84. Excel date fields to MS SQL Sever via OLE
  85. Re: macro command "definitions"
  86. ODBC connection trough Visual Basic in Excel 2003
  87. RE: Array problems
  88. variable
  89. Re: List help with sumproduct formula
  90. Code from Powerpoint VBE not Working in Excel VBE?
  91. RE: Help – I need to extract information from………..
  92. Re: Help – I need to extract information from………..
  93. RE: Two-way data comparison help please
  94. Command Button Drop Downs
  95. Copying out corresonding values
  96. Setting row height to 0 in the visible celss of a range
  97. how to use MZTools to get a calltree?
  98. Why does this Worksheet Calculate Event run so slow?
  99. how to sum values of an unkown number of cells
  100. Creating a Project Schedule, displaying the hours per day.
  101. Case Select
  102. VLOOKUP Help
  103. trying to write a tab-delimited file
  104. Sort and Renumber
  105. Speed
  106. Regex syntax request for help
  107. Insertion of Excel plots in a userform using VBA
  108. cell already referenced
  109. Path Issue
  110. Matching a date or value
  111. Remember Last Cell
  112. Userform
  113. get other workbook objects values
  114. RegExp information
  115. scheduled tasks
  116. Macro for PPT changes the object number when looping over 42 times.
  117. xlsm
  118. change cpu used
  119. "Web Services References" add-in
  120. Copying text within text box and having scroll bar appear
  121. What determines the language of MSGBOX's Yes , No ?
  122. Process monitor macro needed
  123. Having trouble formatting paragraph in text box of form
  124. why,,,, dificult??
  125. get value of a known cell
  126. Help Using Excel 2003 to send emails
  127. Accessing groups of option buttons
  128. Invoke hyperlink
  129. Create a chart from a "txt" or a "csv" file
  130. Keep track of OnTime macros
  131. How to activate a worksheet at a set time
  132. Export Multiple worksheets to text files
  133. Type Mismatch Error in Excel VB on RowIndex
  134. How can I change the case of letters without using function ?
  135. Cell to indicate protected sheet
  136. countif from whole row as range
  137. How to use MS assistant instead of drop down list in excel
  138. populate text boxes from data in worksheet
  139. Generating password-protected PDF using Excel VBA
  140. 1.04 Mb with nothing in file ???
  141. help with a worksheet needed
  142. If then else assistance - conditional "deletion"
  143. Run-time error 1004
  144. excell error on close with commandbutton
  145. Compare and Count data in worksheet rows.
  146. check that active cell is within a range
  147. error 1004
  148. Setting Pivottable RowField Width
  149. Counting based on characters.
  150. Text box
  151. Custom zoom
  152. VBA enhancements
  153. using rons email but need just printrange to mail
  154. Application.Sheet1.PrintOut = property not suported
  155. checkbox & controlsource
  156. ListBox Value
  157. "Run-time error 429: ActiveX comonent can't create object" MSComm
  158. Why doesn't this simple macro work
  159. Excel 2007
  160. Accent / Diacritic word search
  161. EXCEL 2007 / RS 232
  162. Defined named range (Array list)
  163. VBA help: need folder names
  164. Data from SQL to Excel in a formated manner..
  165. Error when trying to remove Validation from cells
  166. ActiveSheet.Pictures.Insert problem in excel 2007
  167. Match 2 cells and total another
  168. Match 2 cells and total another
  169. Run Code on Cell Select
  170. find cells that match in column
  171. I have 4 columns, I need to match col. a & c, then sub b from d
  172. Excel 2000 clocks -- Excel 2003 works fine.
  173. needing help with replace(c.value
  174. WAV Files
  175. Help, please. Anybody?
  176. Type mismatch error
  177. Type mismatch error
  178. Unique Values
  179. Re: copy worksheet tab data into one sheet
  180. Custom Sort a Pivot Table (possibly w/ VBA?)
  181. how to generate date error message
  182. Using a text cell reference as a variable in a macro...
  183. Insert Row after Specific Value in Previous Row
  184. Goto last cell
  185. find
  186. Using VBA to send a javascript:opendocument command, then grab information from the active IE6 window
  187. Workbook Open
  188. msgbox
  189. highest used area of an array ("uBound" of used area)?
  190. Info on UserForms and command buttons
  191. sort within a sort
  192. Looping or Repeating on all worksheets
  193. Add-in macro button assignment spontaneous change
  194. Combine column data into one
  195. Active Cell
  196. RefEdit error
  197. Cell Value
  198. MERGE ROW CELLS BY MACRO
  199. referencing a Drop Down Menu
  200. combo box value
  201. Worksheet_Change not repetitive
  202. Macro Question revisited
  203. Application.Wait information request
  204. Problem with that PPT changes an objects number during macro in aloop
  205. SaveAs dialog box
  206. How to save data back to databak
  207. ListBox Execution
  208. Slow Macro Issue
  209. Copying the last used cell only
  210. Call Macro If x 2 Q
  211. Closing an Excel Spreadsheet via command button
  212. Re: Copy worksheet tab data into one sheet
  213. VBA Code for pop confirmation box
  214. help modify code
  215. MERGE CELL BY MACRO
  216. VBA Lookup with Find method
  217. Prevent selecting filtered rows in AutoFiltered Range
  218. Items received vba
  219. stop formula recalculation when formula contains UDF
  220. Stripping Formating from Header/Footers
  221. Get cell reference as parameter in function
  222. Linked File and Range
  223. Sorting file names
  224. Strings
  225. Select Case Not Returning Correct String
  226. Retrieving OptionButton Control Value
  227. Copy data in multiple worksheet tabs into one worksheet
  228. IF Cell contents = "a" then hide row
  229. after click a button(commandbutton), getting the button name
  230. variable names stop to adapt to changes
  231. Find Worksheet
  232. MACRO TO INSERT ROWS
  233. Calendar
  234. İki eksenli grafikte y ekseni sabit x ekseni iki değer nasıl oluşt
  235. Uncheck every Check Box Q
  236. select range...
  237. Columns to rows
  238. My file is 28 MB w/ code & forms; ~40MB with data - is this too bi
  239. intersection point
  240. How to have multiple values in a single cell?
  241. Fun with GetOpenFilename
  242. BDP/BDH/BDS functions in Bloomberg
  243. Issue with workbook not being selected when form button is clicked
  244. Macro to create a varying named range
  245. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  246. How to traverse cell.Dependents
  247. Page Header: Setting using InputBox for LeftHeader
  248. SetFocus not working
  249. Correct structure
  250. Formatting the Formula Bar
  251. Single quotation mark prefix
  252. macro OK in Excel 2003 but NOT in Excel 2000
  253. compile error with FaceId
  254. PivotTable filter ordering
  255. using the WorkDay function in VBA
  256. Calling function from non-referenced add-in
  257. Delete entire row if column B shows -
  258. Macro to update data
  259. copying macro to multiple excel files
  260. Range properties from Array variables
  261. Add Tab names to Userform
  262. Recursively scraping web pages for embedded links and files
  263. find values and add them
  264. Create Multiple Dynamic Ranges in a single column
  265. print to pdf with vba
  266. Complex Graph
  267. XL2003: VBE Project Explorer not showing folders
  268. Formula in a Text Box
  269. Using "Undo" with bound ListObject
  270. FIND function i VB
  271. Improve speed of data transfer loop
  272. alphabetize within a cell
  273. Copy/Paste Multiple cells from Excel to Word
  274. Combinations
  275. Using Excel for statistical analysis - a question for problem-solvers
  276. Assigning cell values with VB
  277. VBA or Function Required . . .
  278. problem with background query
  279. Kill a Macro?
  280. Matching user input to number in range
  281. Create list of different columns
  282. Delete the active wb
  283. Detect Excel service pack
  284. make hotkey in commandbutton1 on userform
  285. Programing - TEXT - EXCEL
  286. if value begins with "" then
  287. Pearson and Peterson are Genuises!...er...Genii!
  288. subtract date and time between columns
  289. Excel Cell Display window blanked out
  290. SLA - Downtime calculation
  291. How to protect worksheet?
  292. How to stop a VBA Module from opening
  293. Chart Question
  294. Send email in a different way
  295. Adding Time to a Date
  296. Callling Word fronm Excel
  297. OLE Object on Sheet updates Value in Code but not its Display
  298. Setting up Classes
  299. How to detect cell content modifications?
  300. Spread Revenue Over Time - Excel Help
  301. Web site plus excell
  302. runtime error 9 in my macro
  303. How to set Cell Format using VB.NET
  304. Search and change text color or style only
  305. Copying Data between worksheets
  306. Filter Pivot Table
  307. sort (ascending) data while worksheet is protected
  308. activate
  309. How to create Loop
  310. How to create Checkboxex on the fly
  311. PLEASE HELP
  312. Date Serial Problem
  313. delete row on basic of cell
  314. Deleting a row in a message (opposite to VbCrLf)
  315. Macro to do numerous tasks
  316. Loop
  317. Autofilter over 255 characters in a cell?
  318. copy range to Text (Tab delimited) (*.txt) file
  319. Help creating a custom function in VBA
  320. Retrieving a value at some cell from another Workbook
  321. XL2007 - Known problem? - Driving me crazy.
  322. Form Actions
  323. Worksheet_change event assistance
  324. Data comparison
  325. WORD ART WITH EXCEL 2007
  326. Clear Method not working for a ListBox clear
  327. A formula for birthdays
  328. Run-time error '1004'
  329. Unwanted "Flashing" of screen
  330. enable and repurpose the Spelling control?
  331. Macro launched from another file only partially works
  332. How to change debug.print font?
  333. Listbox Output to Individual Listboxes
  334. Formatting cells with VB
  335. Exporting Values into Microsoft Word Form Fields
  336. Specifying cell in Worksheet_Change even
  337. Dates
  338. Excel 2003: VBA - Hide Rows process now too slow
  339. find
  340. Textboxes remembering previous entries
  341. excel crash on workbook_open userform.show
  342. countifs
  343. Declaring arrays
  344. Private sub Worksheet change question
  345. delete empty space after certain characters
  346. If texbox value begins with "E" then send to another sheet.
  347. Macro gets lost
  348. Sending email routine, tweks needed
  349. Multipage control
  350. How do I protect my code?
  351. Insert a number rows according to a cell value
  352. Scraping/listing document URLs on a server that don't have web pages/existing links?
  353. application.EnableEvents = false not disabling events
  354. VBA syntax to check between two time frames i.e. 2 PM thru 5 AM?
  355. Find using a variable value
  356. How to obtain superscript and mixed font info when read from Excel?
  357. include date and time in email subject line
  358. Grouping related ribbon tabs
  359. How do I plot two curves on a single XY scatter chart?
  360. Textboxes Not Calculating Properly
  361. Macro to delete with filters
  362. Find something
  363. What are the options in the print macro?
  364. Halting Execution -- A Newbie Question (possible repeat, sorry)
  365. Cell Error Markers
  366. Macro to mark a column where text in row (or cell) is as specified
  367. Can I switch to my custom Function category ?
  368. Stopping Code Execution -- Newbie
  369. hide formula bar (and menu bar etc)
  370. If find function to not find anything
  371. if multiple conditions are true, then copy the row to a new sheet
  372. How do I track down 'invalid references'
  373. opening workbooks in subfolders
  374. Shadow Menu
  375. Programming Shapes
  376. Clearing formulas
  377. Compare Columns, Find Matches
  378. MultiPage Page Order
  379. Add custom icon using VBA
  380. Reading Directories
  381. Extract data from seperate files-macro
  382. ADODB Connection in Same Excel File
  383. Identify defined name range by another cell value
  384. How to create pivot table from web query
  385. Formula for list summary
  386. MACRO TO BRING WORDART ON CELL VALUE
  387. Invalid Precision: cbColDef value out of range
  388. find
  389. Selecting dates from current week with Macro
  390. try to email with vba, but more than one sheet and convert to pdf
  391. Problems with an if (using rng Nothing) - only to produce sheet giventhat it doesn't already exist
  392. Make excel Worksheet as data base
  393. How do you programatically format embedded charts
  394. Restoring the Macro Recorder to Default w/ relative references sho
  395. Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range)
  396. Last cell with constant in a sheet
  397. how do I disable spell check in email sent from Excel macro
  398. Auto Number Excel Forms During Save As
  399. Synchronize Combo Boxes?
  400. Listing installed COM add-ins
  401. Deleting Duplicate Rows In a Selection with a True Statement
  402. Making changes on "grouped" sheets via code
  403. SQL with Excel ranges
  404. Inconsistent behavior using VLOOKUP
  405. vba editor comes up everytime this specific macro is run
  406. Determine if a shared workbook is open
  407. vba editor comes up whenever macro is run.
  408. VBA and Excel 2007
  409. Plot Area Changes Automatically When Updated
  410. Sum / countif data range
  411. pulling apart a field
  412. pivot table order
  413. return to first column of next row
  414. Invalid Precision: cbColDef value out of range
  415. Limit Dates in Pivot Table
  416. Numbers Not Calculating Correct on Userform
  417. Formula to add a date to a cell that is 6 months from today
  418. Maximum number of named ranges?
  419. Adding validation fails with automation error
  420. Goal Seek with dynamic Goal Seek
  421. ExportAsFixedFormat for Multiple Sheets in a Single Excel File
  422. Configure Built-in Font Color Command Button?
  423. align and resize controls
  424. Conditional Formatting and Text Alignment
  425. If column = value sum another column and place result in cell
  426. From VB6 how to determine if an Excel cell string containssuperscript?
  427. Pivot table from xml data
  428. No... while trying to update to Excel file
  429. COPY FORMULA TO THE LAST CELL
  430. Code for file download
  431. Code for file download
  432. Save As PDF / XPS
  433. Range is nothing
  434. Replace last three characters
  435. Zip and mail more than one sheet from the ActiveWorkbook
  436. Display formula result in a popup.
  437. disable clear all using VBA
  438. Time conversions from data dump
  439. Integartion of BDC into Excel services
  440. Help passing Range to Class Module method
  441. identifying the end of a data column
  442. Vlookup and #N/A
  443. Text Box
  444. VBA block cell copying.
  445. Multiple Windows in Single file
  446. DATE IN COMPUTATION
  447. most efficient way to filter out and iterate through XLS databases
  448. Loops stop working and presents "1004':
  449. SumIF
  450. EVALUATE method returns zero
  451. Custom menus don't appear under custom ribbon tab
  452. Adding AUTOSUM to Cell menu in Excel 2007
  453. Loops stop working and presents "Run time error '91':
  454. Variables in Variables
  455. Conditional Format
  456. Filtering one or more items in 2 columns
  457. Need help to enter text in Polish language
  458. Re: How to see cell value exactly as Excel displays it?
  459. How to see cell value exactly as Excel displays it?
  460. Workbook Open bypasses Query Refresh
  461. coding for variable rows
  462. Why is my vbasum(F1:F45) called 46 times?
  463. outlook express 6 glitch
  464. Message Box Help
  465. return row header as answer
  466. .Formula vs .Value?
  467. Check cells in row for last cell with data to use as multiplier?
  468. Set Formatting Menu Font Color with VBA
  469. UserForm and user input
  470. For Each ws autofill
  471. Create worksheets based on value
  472. How to refresh a pivot table that uses changing source data
  473. Bloomberg API: Preserving Values?
  474. Sending Email to non-standard address using CDO?
  475. return chart's source data location/range
  476. Random phantom breakpoints and random bogus compile errors
  477. Record Not in Access DB
  478. Importing Specific Data From Multiple Pages From The Web
  479. PLEASE HELP!!
  480. How can I hide contents of a cell and password protect to reveal
  481. VBA 6.5 on older systems
  482. GetPivotData - Why does the reference not change when I drag theformula?
  483. format in VBA
  484. Subscript out of Range
  485. Obj Variable or withblock variable not set?
  486. Save Copy or Cut Reference
  487. Use criteria in an Advanced Autofilter's single column
  488. Transpose 3 columns into Single column
  489. Return the first 2 letters of a Cell Value
  490. Vlookup across workbooks
  491. Inserting rows if a particular item is chosen from a list
  492. copy formulas on a weekly basis to next available
  493. having trouble with a chart range
  494. Excel runs much slower in console app
  495. Zip and mail more than one sheet from the ActiveWorkbook
  496. How to run a process in the background?
  497. Multi-level User Definet Types
  498. respostX2 - deleting blank rows after macro-generated pivot table
  499. respostX2 - deleting blank rows after macro-generated pivot table
  500. VBA Error
  501. Passwords on files used in calculation
  502. Macro to Transpose All Items in a Vertical List, and Add a Comma
  503. Downloading into a column
  504. Which cell is calling a user-defined function?
  505. Getting/using the File path of a spreadsheet
  506. Help needed with macro
  507. Excel program
  508. Look up data.. help please :-)
  509. Referring to merged columns in range object
  510. Re: transpose loop
  511. count column c with condition in column A
  512. Using the result of an input box
  513. Creating a line break (newline) in a cell with SpreadsheetML
  514. Reset of radio button values without calling _Click() function
  515. Custom Context menu (Right click menu) not working in sheet changeevent.
  516. Copy worsheet from different files in to one file
  517. Crash on ActiveWindow.Close
  518. Variable not seen
  519. Simple question
  520. exclude holidays on UserForm Calendar control
  521. application.filesearch error in excel 2007
  522. Sheet Select
  523. Look Up sheets
  524. Unable to view search results
  525. HELP Debug
  526. Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names)
  527. application.goto reference using references in the worksheet
  528. Converting a number todate
  529. Macro not running when Image/Button Object is pressed
  530. delete all rows where cell is not date format
  531. if cell is not date format delete row
  532. if cell is not date format delete row
  533. if cell is not date format delete row
  534. Scrambleing data when refresh
  535. Combobox that populates text boxes on userform
  536. help with "Goto" command
  537. Reactivating file based on text value producees subscript error
  538. Combo Box Wont Show Values
  539. Help with autofiltering a list based on criteria
  540. How can I tell the shape of a Variant containing an Array?
  541. Calendar using TODAY function
  542. Re: Automate Monthly Task
  543. Insert "/" into cells that contain data, using a macro
  544. app.quit
  545. why would a large addin save in 2 seconds or 18 seconds
  546. run code *after* drop down list choice
  547. page header multiple rows
  548. wait function
  549. if - then actions
  550. Changing a horizontal axis crosses value using VBA
  551. circular argument
  552. Re: Conditional Formating
  553. check column -A- and fill out column -B- by vba
  554. Re: CC Field Q
  555. Ranges in VBA
  556. Writing text at end of spreadsheet
  557. user form tabs
  558. Filtering Data Based On Different Criteria
  559. Programmatically adding code to worksheet
  560. Pivot Tables
  561. Concatenate Rows depending on cell value in rows
  562. What does it take to get class functions to execute?
  563. html help and custom msgbox
  564. Page Fields Converting to Text
  565. Using calculated fields to count unique items in a pivot table
  566. getting data from website's url and webpage
  567. Rename worksheet tabs
  568. Copy a Range that matches Todays date Q
  569. v lookup problem
  570. cell top of screen
  571. How can I sort contents of one column based on the contents ofanother column?
  572. Dialogs(xlDialog...).Show arguments usage
  573. getformat
  574. Pivot Table Macro - How to describe the Active range (so that themacro can be used on new sets of data)
  575. Why doesnt this work?
  576. AutoShape Macro Help
  577. Filter Data based on criteria
  578. Seperate letters and numbers in a cell
  579. Protect workbook when saving
  580. Excel Automation
  581. Adding Cells and Indexing
  582. ScreenUpdating Not Working
  583. delete rows where value in Column B=0
  584. Need loop guidance
  585. Using Cell Numbers in a range
  586. Row number of filtered row
  587. Variable value
  588. R1:C1 format
  589. Function
  590. Using ADO from Excel form to relational Access Db
  591. Referencing two versions Object models
  592. Copy/Paste data based on a criteria
  593. Locking worksheet based on the cell value
  594. array formula to extract members of list A that are not in list B
  595. How to include field name in CopyFromRecordset
  596. Filesearch error in Excel 2007
  597. Find first empty cell in range and paste formula??
  598. Control don't refresh
  599. How to add a text box with scroll bars in excel 2007?
  600. Minimum references required
  601. Count items in a column
  602. Excel Functionality
  603. Code Help
  604. Code Crashing
  605. use option button background color to format cells
  606. Value cells
  607. Skip part of macro on re-run?
  608. msgbox
  609. worksheet as data entry for Access database?
  610. Increasing and decreasing cell values
  611. Copy and pasting based on criteria
  612. Coded to delete extra rows after pivot table
  613. Open And Close Form
  614. Adding a second line in a header or footer through VBA
  615. How can I change the caller cell's format into "mm/dd/yyyy"?
  616. Paste not working again
  617. Macro to split data
  618. Passing Parameters to an ODBC
  619. Opening files from Excel
  620. Accessibility of a server
  621. What programming to use in VBA to convert in to number?
  622. lost reference to activesheet when opening workbook inside IE
  623. OUT OF OFFICE IN OUTLOOK 2007
  624. read Matrix
  625. Copy to
  626. Query refreshing inside a loop - out of memory
  627. Getting error using Month()
  628. Asian file names
  629. Macro freeze up
  630. Totally Lost
  631. blank display while macro runs
  632. Excel 2007 filesearch
  633. Instr
  634. Excel 2007 ambiguous name detected:Worksheet_Change
  635. links
  636. Need help with a macro that takes information from another workboo
  637. Can Not Complete This Task with Available Resources
  638. Import text files to cells
  639. Copying a chart included in a range
  640. Counting Octals.
  641. Userform
  642. How to put a button on a cell and assign macro to it?
  643. Looping through columns
  644. Deploying Excel 2007 VBA Project in an Office 2007 Standard enviro
  645. AMENDMENT IN MACRO
  646. extract certain values from multiple workbooks into a new file
  647. calling .net exe file from within SSIS script task
  648. highlighting rows
  649. Summary page
  650. Getting #VALUE! while entering UDF as an array function
  651. Activating a workbook
  652. Custom Toolbar question - newbie
  653. userform closing after input
  654. Code that searches a column, then copies and pastes any matches intoa new Spreadsheet
  655. Setting a variable = ActiveWorkbook
  656. code to delete all rows beneath and columns right of pivot table
  657. peraphs impossible... order line base color...
  658. Copy data from worksheet to another automatically
  659. Closing VBE systematically
  660. Remove/Inactivate "X" in UserForm
  661. Pivot Tables: Hide detail for a RowField via code: Get an Error?
  662. Exclude rows with result 1
  663. Calling a user Function in Worksheet
  664. If cell value = x or y then perform formula set else skip
  665. How to read in cell border?
  666. Copy Error
  667. Average - without zero?
  668. Best Substitute for Range(cells(),cells()) in worksheet
  669. Windows API - File Menu Processing...
  670. Easy Question: Cell Value
  671. Bloomberg download
  672. Image in Userform looses quality
  673. Excel 2007 VBA - Can't type in VBA editor
  674. Automatically populating new rows with formuals above
  675. Forcing cell value update/refresh
  676. Add Column at the end with concatenate formula
  677. Count CheckBoxes in a Frame that are True
  678. How to set Range variable to point to End(xlDown) cell?
  679. Conditional Formatting
  680. Advanced tool uses TrueType fonts to represent tiny charts
  681. Filter out Non-Number (i.e. Text) Cells
  682. Combobox
  683. VBA, copy lines with specific value
  684. Save Changes to Add-In
  685. VBA Project Passwords
  686. save and add to CSV file
  687. save workbook without code
  688. How to get the last valid (non blank) cell index?
  689. how to detect if macros been disabled
  690. Copy & Paste...if
  691. Import from Excel to an access database using Jet in vb.net
  692. hide name box
  693. IF statement for lookup matchup
  694. Excel Error
  695. UDF Function or Macro Needed
  696. Updating Listbox in Excel Form
  697. Updating Listbox in Excel Form
  698. Updating Listbox in Excel Form
  699. Public oMyClass As New MyProject.MyClass
  700. best way to get an updatable SQL Server 2000 recordset into Excel?
  701. Not ScreenUpdating with PrintOut Property
  702. Enter Key Press Event
  703. Using VBA to change the color of the active cell if the value in thatcell is less than 15%
  704. How to automate Print Zoom to fill page
  705. An old macro needs updating
  706. Macro's
  707. drop down change event
  708. isblank macro
  709. DELETE ROWS ACCORDING TO FIGURES
  710. Run time error 2147319765(8002802b)
  711. Setting cells to change colors as a date approaches
  712. Shopping Cart application
  713. protect my sql query
  714. range with variable row
  715. Checking Data, Help Please
  716. Information dependent on other information
  717. Block games in Excel
  718. Deleting Worksheets
  719. Questions on Ron de Bruin's Excel Email Macro
  720. hyperlink follow through and save file
  721. If Then else
  722. 0E560 = 0?
  723. Withdrawing a template from "Data tracking"
  724. Change the date when there is a change in another cell
  725. Hyperlinks with Cells(r,c).Value reference
  726. Need help with MAcro for Multi-value cell and row processing
  727. Excel 2003 and 2000 and VBA Macro
  728. XL2002 - Worksheet_Activate Question...
  729. OLAP cube DateTime dimension
  730. import multiple text files into single sheet separate column
  731. Custom menu groups don't appear on ribbonX when no workbook is ope
  732. Re-Arrange Tabs
  733. Big excel file
  734. Subtotals
  735. Looking Up Text entries
  736. SQL and Excel
  737. Ribbon stopps working after Save
  738. GETPIVOTDATA help
  739. Pass criteria in Microsoft Query
  740. Subscript out of range
  741. depedent drop down lists
  742. Run time error?
  743. Programatically filter a protected shared workbook
  744. checkbox value unavailable?
  745. Putting zero value within a specified range, help please...
  746. Buttons
  747. 3 dimension array using Excel names
  748. Replace Dialog Box Keeps Moving To Bottom After Replacing Text
  749. User Forms & Checking Inputs
  750. Excel Combobox keystrike
  751. break into an invisible instance of Excel
  752. How can I set a text box or label to show the vaule of a spinner?
  753. How can I set a text box or label to show the vaule of a spinner?
  754. Macro to give different outputs dependent on result
  755. Excel 2007
  756. Hide a cell so that users can't see the contents
  757. Loop to tidy up my code?
  758. Doing a LOOP for multiple columns, help please...
  759. if then multiple sheets and values
  760. Unhide rows error
  761. Column value
  762. Listbox Properties
  763. Adding current date and contents of a cell in the footer
  764. Sendkeys to paste excel worksheet object to powerpoint
  765. Fixing Rows...Help please..
  766. Paste from Word to Excel
  767. suspend processing for TextBox_Change events when initializing a f
  768. SaveCopyAs changes SheetName
  769. Excel formula that adjusts to new columns as entries made in cells
  770. Combo Boxes
  771. Filter and Delete all rows with a date greater than or = today
  772. Reference value plus 7
  773. intersect
  774. adding code lines with vba code
  775. How to get the last row in a column without selecting
  776. Mulitplication within an "IF" statement.
  777. Creating a procedure using VBA Code
  778. Auto Update files for just this run of code
  779. Accessing External Module
  780. Wizard pages not hiding when go to next page
  781. Passing criteria from one Excel Query to another
  782. Shorting the Code
  783. PICTURE TROUBLES
  784. Copying sheets without copying named ranges
  785. Save As File Format
  786. Specify chart template size
  787. Rename a worksheet to use with a pivot table
  788. Paste object from excel to powerpoint
  789. formula with percentages
  790. Calculate text strings
  791. Merge several fixed width text files into one
  792. Is Excel compatible With VB 2008 Express Edition
  793. Cells.Find
  794. Conditionally Disabling Optionbuttons
  795. Calculate total days
  796. IgnoreRemoteRequests & multiple Instances
  797. VBA Code to Insert Borders Along Automatic Page Breaks
  798. Removing duplicates
  799. items in pivot's page section
  800. Resolving "File Now Available" Read-Write dialog at end of code
  801. MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS
  802. change email page color
  803. Advanced Filter is unstable HELP
  804. Form Control Drop Down Lists
  805. Copy from an application
  806. Disable Paste in Excel 2007
  807. SetFocus method
  808. Using "Custom XML" as a datasource
  809. Video tutorial for programming Excel macros or such
  810. HELP! Writing Text file from Excel Spreadsheet.
  811. Copy data into blank cells
  812. Protected cells in Protected sheet
  813. Name of the current pivottable from active cell
  814. Changing Category (x) axis labels for radar charts
  815. Reference Sub from another workbook
  816. Variable variables and sub routines
  817. Problem with Error handling in loop (with find)
  818. Trying to copy data from one workbook to another
  819. Creating a macro to paste in a specific cell
  820. counting filtered items in PivotTable
  821. VLOOKUP works but gets #REF when macro changes formulas to values
  822. Excel Publish Event
  823. IFERROR(Vlookup) question
  824. macro queries
  825. MACRO TO DELETE ROWS
  826. Will accounts 2008 export data to excell as well as import
  827. Recording a Macro
  828. Changing Toolbar Image
  829. IF(NOW()
  830. Excel automation using VB Express
  831. subtotal bold
  832. Whats wrong with my code? This is a real challenge...
  833. Setting a Control Variable for a listbox
  834. Calling a macro in excel
  835. IF statements
  836. Download a spreadsheet with VBA
  837. Run Time Error, FormulaR1C1
  838. CopyPicture method (# 1004) failed
  839. Protection Macro
  840. Retrieving Pipe (|) delimited text file into ADO Recordset
  841. Dbl-Clicking anyfile.xls = excel basic grey screen
  842. Saving a worksheet to a new workbook
  843. Macro to display pictures
  844. checkbox1 value = true if range got data
  845. Excel to Access
  846. Delete Duplicate Rows, by Date field
  847. Error in loading DLL
  848. Re-entrant call to VBA
  849. put textbox data in sheet (sheet name selected in a listbox)
  850. label caption
  851. Macro writing formulas
  852. Use workbook name in Connection
  853. Search multiple strings in one text file
  854. UsedRange and LastCell feb08
  855. Can UDF modify worksheet(s)?
  856. list sheet tab names in listbox
  857. link textbox to cell
  858. Macro to Convert Data to Different Format
  859. Excel Autofill Showing Mondays ONLY in a calendar year
  860. Has Microsoft fixed Excel's Dependents bugs?
  861. Paste Macro
  862. VBA Click a link
  863. Triple Filter
  864. Formula Madness
  865. Automatically starting macros
  866. Oracle ODBC driver password
  867. 2007 Status Bar in Excel 2003
  868. FORMULA TO MINUS TEXT CHARACTERS
  869. reference to another sheet not in wkbk brings up dialog box
  870. cell range
  871. Calculating column 'J' and offsetting result in column 'L' on nextblank row (continue to end of sheet)
  872. macro question
  873. Stop VB from deleting modules from wrong file
  874. Selecting current range for pivot macro
  875. Why does a find wrongly return true when I search a variable?
  876. Code execution error
  877. im sorry to even go as far as asking
  878. worksheet cells displayed on a user form
  879. Export/Import custom toolbar
  880. Links to Update every 10 seconds...
  881. Changing of Sheet Codes for the worksheets...
  882. transpose cols to rows excel 2003 looping macro help please
  883. View a non-Excel file whose name is in a cell
  884. WAV files
  885. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  886. Select all rows in a date range
  887. Active Workbook
  888. excel help with min() fn reference
  889. Pages
  890. Convert GEDCOM file to excel lists
  891. Data form errror
  892. Identify a change in computers
  893. Average row of Data using VBA
  894. to print or not to print...
  895. unlock cells if value is...
  896. Macro runs in another workbook if you open simultaneously
  897. How do I get Excel to stop publishing?
  898. Casing of built-in property Font.Bold
  899. is it possible to have a common macro for Multiple workbook
  900. Form in excel
  901. Macro to delete 2 rows every 500 rows
  902. How to return the color of a cell
  903. Insert value in text box based on previous tselected value.
  904. Help with code
  905. Prevent Worksheet from being deleted
  906. how do I reference a cell in a previous sheet not by name, by orde
  907. Using VB instead of function for INDEX
  908. Is this macro scenario possible using VBA?
  909. my first macro - super simple for any veteran... help appreciated!
  910. Cancel Key Press Event
  911. Adding a Name range with vba
  912. give value of next column
  913. DirectDependents not working properly.
  914. Worksheet add
  915. Restrict access to only one sheet
  916. Set up shared bililng spread sheet
  917. What's the difference between .Dependents and .DirectDependents?
  918. Creating a truncated range- Speed issue
  919. Animated Gif89
  920. Control desktop Icon
  921. vba problem when grouping sheets
  922. Count mails in Excel
  923. How to Create an array
  924. Chart VB Code Syntax
  925. Printing x amount of pages if cell is greater than 0
  926. How to save existing Workbook with a new new name, without changingthe open Workbook name?
  927. RangeName Define Limitations
  928. Find and Replace
  929. How to undo ClearContents?
  930. dll File
  931. NumberFormat
  932. Worksheets("Sheetname").Select refuses to kick in from User Defined function
  933. Loop to Filter, Name Sheets. If Blank, Exit Loop
  934. close pdf file before closing excel
  935. Loading a formula from VB
  936. Paste a function using a Macro
  937. Code failure with different partitions
  938. Copy pasted name range
  939. Set Visible Cells To TRUE
  940. Application.AutomationSecurity stops calling macro
  941. Creating a button to execute a macro
  942. Type MisMatch with Set Statement
  943. Quick sort problem
  944. Looping thru sub-level of controls on userform
  945. Macro on Hidden spreadsheet
  946. Calculating Column and off setting calculated value to another column
  947. Error when opening up file in Excel 2007, but not when opened withExcel 2002
  948. Range help
  949. Include Blank Value In Validation List
  950. a slight syntax error...
  951. Help with Calling a subroutine in the ThisWorkbook Class
  952. Macros acting on a filtered list
  953. cond. formatting - border thickness
  954. How to "Scrape" currency conversions off web... Maybe using Google
  955. VBA Help
  956. forms toolbar greyed out
  957. Coverting strings to numbers and trimming trailing zeros
  958. IF formula?
  959. Get text from clipboard to string?
  960. Export to CSV via macro does not use local regional settings
  961. Macro Doesn't Run With Command Button, But Does Run With F8 Key
  962. Help to align FORMAT
  963. auto inserting thumbnails into an office program for web use
  964. Determine drive
  965. reference for OpenFileDialog
  966. Hyperlinking cells and macros
  967. How to feed a userform a variable to display in a textbox?
  968. Copy an entire row based on value in one cell
  969. Command Buttons
  970. Opening a csv file stops macro
  971. Compute length of a string in points depending on current font
  972. Protecting VBA (Excel) code
  973. How to interrupt code
  974. Need event for selecting a series on a chart
  975. Emailing a userform with its values
  976. Concatenating and Copying columns from 30 sheets
  977. Changing Excel charts pasted into PPT 2007
  978. Re: Chart Text Box
  979. Two macros at startup excel?
  980. Adding Column A for All sheets : Please HELP
  981. HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007
  982. 'INDIRECT'ly referred cell's own simple formula fails....
  983. What is VBA equivalent to Tools/Auditing/Trace Dependents?
  984. Add new record to Access using VBA in excel
  985. find location
  986. Relative cell value in function
  987. trading system and filter test
  988. Excel 2007 Print Preview button disabled
  989. Re: Quicker Counting
  990. calling VBA from EXCEL
  991. Vlookup that checks against two values
  992. Trying to Send a Keystroke to a specific Window
  993. tuncating a table in sql from excel
  994. Restoring Attached Toolbar
  995. Copying headers and footers between sheets
  996. Data to be transferred to new workbooks
  997. How do I create mathematical links from workbook to workbook?
  998. vba password protection
  999. Populating Values In One Table With Values From Another Using VBA
  1000. import .pdf file to .xls