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. Can't find a hidden worksheet that appears in the name manager
  2. How do I extract the last update date from a different excel file?
  3. Re: Excel 2003: Customizing Toolbars
  4. VBA to acsertain if last w/s change was "insert Row"
  5. Updated header information from cell
  6. input of selected cells equals content of another cell
  7. Excel macro to add an hyperlink that shows only the filename (no p
  8. Output from UDF matrixfunction sometimes a row, sometimes a column,why?
  9. how to make the content in an excel cell read only?!
  10. how to compare parts of text in different cells
  11. UDF in Excel 2007 for Filter or Query
  12. Disabled VB Editor Button and Macro Buttons
  13. Why this isn't running properly (excel macro) Pls help!!
  14. New to Excel Programming
  15. Automatically go to a cell when opening sheet
  16. How to show and hide a picture on a button at runtime?
  17. Workbooks collection
  18. VBA code to format only the cells added in a new row insertion
  19. CopyTransposePaste into next blank row
  20. Help with PROPERTY GET
  21. Referencing two types of sheets - I get Error HELP!!
  22. Command buttons not responding-sticking
  23. How to extend the life of a variable from one Private Sub routine to another?
  24. ComboBox problem
  25. lenghty code
  26. Move SUBTOTAL cells
  27. VBA for worksheet change (add row) event (I think)
  28. reality canvass: VBA as career? VBA as extra skill in another career?
  29. Hyperlink
  30. Arithmetic Error -- Converting Expression to Int -- Weird Behavior
  31. Formatting workbook and going to first sheet
  32. Creating a Macro Recorder from scratch
  33. range function
  34. (maybe) pivot table question
  35. Adding Command buttins by macro
  36. Create A Windows Shortcut To a .xls File?
  37. 2003 to 2007 , ActiveWorkbook.ReadOnly
  38. How to modify the sql statement on a pivot table using VBA- XL2000
  39. Does this column have any "###"?
  40. Using DAO to write to textbox in userform
  41. Automating a comment entry using code - specific requiremnents..
  42. OptionButtons from ControlToolbox
  43. Wrapping multiline text in merged cells
  44. Set properties of a Check Box
  45. Enabling an option button using the enter key
  46. OnKey problem
  47. Global Const for password
  48. How to stop Random
  49. Kill Delayed?
  50. Data Validation - Can 2 items from a list be combined?
  51. Why ? What is error 424 ?
  52. VLOOKUP ---> Assistance Needed
  53. ranges
  54. Re-setting HPageBreaks
  55. making a named range available from an add-in
  56. How to simulate File-Send-To Exchange Folder
  57. Change BackColor of CommandButtons in Black by Macro
  58. Subject: Shared workbook for Writing
  59. Formula detection - Unique vs Copied?
  60. Copy rows with Interior Colour Index values 15 and 35 to a new she
  61. Put number next to Sheet name
  62. Select more than on CommandButton
  63. how to recognize a specific letter in a cell
  64. how o recognize a specific letter in different places in a cell??
  65. How to make my code recognize one letter in a text in a cell???
  66. code execution has been interupted - Excel 2003
  67. Multiple record counter
  68. How to thanks for your beloved ?
  69. intersection with multiple ranges
  70. Re: counting how many lines of code in each workbook - memory issues
  71. Where is the Microsoft Script Editor?
  72. Macro Covering Many Columns, why has to be UNION
  73. AppActivate problems or is there a better way to take focus froma non modal user form
  74. Data Validation, ignore blank ?? jan09
  75. "PLEASE WAIT" Window Message
  76. Macro does not delete all the required rows
  77. determine the actual vissible text
  78. Sum values of column 5 of listbox1
  79. Invoke Macro on entering data in column
  80. sheets active vs select
  81. counting occurences of cell matches
  82. determine how a cell is formatted
  83. .Find and return range
  84. Try a gay Aborigine today! Young virile Aborigines will performfor you.
  85. Calculate NPV - Array must be flexible
  86. vbe or worksheet function for cpu saving ??
  87. Read the search keyword
  88. Get Sory options??
  89. Customize Standard Toolbar
  90. Edit a Cell
  91. Populating 2 ranges with different random nums in each cell
  92. Vlookup REF error
  93. Focus problem??
  94. Printing
  95. Sortering av alder
  96. hyperterminal, excel, and MSComm
  97. Filtering multiple sheets
  98. folder hierarchy transfer to excel sheet
  99. Connection to MySQL using VBA
  100. inserting the numbers into excel column ?
  101. I'd like to have a chart placed on my user form?
  102. Best method for working with Excel Database
  103. Reading and writing to ini files in Excel 2007
  104. InStrRev Question
  105. regions in excel
  106. execute a macro from cell click event
  107. Sort question (of sorts)
  108. Reset New Workbooks
  109. does anyone know of a basic CMMS template/app. in XCEL?
  110. Enabling/Disabling multiple option buttons
  111. Shared workbook for Writing
  112. copy excel named ranges to powerpoint as pict with VBA
  113. Excel vba programming primer somewhere?
  114. Excel TableDestination As String?
  115. Ranking Duplicate Numbers
  116. Application.ScreenUpdate
  117. Auto Execute Macro
  118. Making customized asynchronous function
  119. SelfCert Fails to Create Certificate
  120. range calculate
  121. DDE link in VBE
  122. vba if and goto statements
  123. Keeping running tallies of items in two columns
  124. VB to set wordwrap on Control Toolbox Textbox
  125. Change cell value when selection made from drop list in another ce
  126. Change all numbers to zero
  127. How to wirte vba to find the opening file?
  128. Unable to get the PivotItems property of the PivotField Class
  129. Concatinating strings in a footer
  130. ActiveX control security
  131. Print preview from macro problem
  132. How to write VBA
  133. sumif when criteria range is larger but includes criteria
  134. sumif when criteria range is larger but includes criteria
  135. hiding select rows in sheets
  136. Some basic VBA questions
  137. Value Rounded when copied from another cell
  138. how do i change cell colour by value in excell
  139. I cannot find what is wrong with this code please Help me
  140. Date Format
  141. Need help with a Formula
  142. Use Names of Named Ranges in ComboBox
  143. Print & Close Buttons in Print Preview grayed-out when '07 script
  144. AxHost.GetIPictureDispFromPicture causes Excel 2002 to crash
  145. Parse cells with line breaks
  146. Open most recent file
  147. How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent?
  148. Update Links and Essbase Retrievals
  149. How to compare two differnet cell ranges to see if they are the sa
  150. Viewing archived data
  151. Event Code Error trying to insert a picture
  152. Looking to remove pivot fields from pivot table via macro
  153. Copy in other cell just one letter.
  154. If statement question
  155. Macro + protection
  156. Attaching a Read Receipt to Outlook E-mail
  157. accessing twice a memo field in a recordset
  158. Finding date in a string
  159. changing validation drop down based on another cell value
  160. how to generate '*' in a textbox field that takes a password?
  161. VBA reset cell value if greater then 0
  162. Why? When I unlock my machine Visual Basic Editor appears (when I'min Excel)
  163. Animation
  164. Enable ActiveX control Option in Trust Centre
  165. Testing a sheet for a change since last accessed
  166. worksheet as SQL linked table (format problem).
  167. Pls help with simple sub
  168. Workbook Compare utility
  169. Recalculation Failure
  170. Print page one of sheet only
  171. disappear excel embedded messagebox in protected sheet
  172. Creating a Check Box within a Cell (
  173. Table Tools for Excel 2007
  174. Application.ScreenUpdating = False
  175. RE: Using SEARCH in a single cell to COUNT multiple entries of sam
  176. Macro to find, copy and paste
  177. CSV
  178. RE: Using SEARCH in a single cell to COUNT multiple entries of same te
  179. Using SEARCH in a single cell to COUNT multiple entries of same te
  180. RE: excel programming
  181. excel programming
  182. Copy/Paste in VBA Excel
  183. Re: two "ThisWorkbooks"
  184. How to Programmaticaly Delete or disable minimize and Maximise but
  185. RE: two "ThisWorkbooks"
  186. Re: Compare rows
  187. RE: Compare rows
  188. Cell referencing, formulas, macros
  189. RE: find a sheet by a cell
  190. two "ThisWorkbooks"
  191. Compare rows
  192. find a sheet by a cell
  193. Key Word's for VLOOKUP
  194. Upgrade to 2003, strange stuff in Immediate Window
  195. Trace dependents - get formulae
  196. VBA - Cannot find project or library
  197. remove pivotfields and refresh
  198. objFolder.ParseName Method Not Found
  199. I want to separate text at all the full stops
  200. duplicating a frame
  201. Reading data from Excel Worksheet in vb
  202. Unable to name certain ranges
  203. unlocking VBA project programatically
  204. Where is the API documentation - Office 2007
  205. Msg Box Yes / No Q
  206. erasing space/blank in a cell
  207. macro - paste special (transpose)
  208. How can I click on a cell and enter a default value?
  209. HELP REQUIRED: Dynamic VLookup
  210. Search a database with multiple strings?
  211. Offset the result
  212. VBA coding a nested Vlookup, and a sumif formula
  213. Trace dependents
  214. Dates and comments
  215. vba sumif and vlookup codes
  216. count partial string in a range
  217. Concat rows -
  218. Data Matching and exporting
  219. Name definitions
  220. Problem adding the values of 2 TextBoxes
  221. Changing From Address before sending mail
  222. Joining 2 modules as 1 for email with Excel
  223. Data Query using Match/Index
  224. Pivot table
  225. Reference two types of named sheet in a code
  226. How do I trapped the error and optimize the code?
  227. PivotTable
  228. WORKSHEETS
  229. Pixel discrepency
  230. remove or add items from a pivot tables
  231. Problem with Solver add-in. Changing values
  232. Print area - Message box
  233. Can I pass the logon credentials in a macro to a ODBC query
  234. Re: Command Button not responding
  235. Relocating my AddIn
  236. Command Button not responding
  237. Importing a file..then saving back to original file
  238. Dynamic multi-sheet excel downloads without ActiveX?
  239. Re: Clearing cells in a range upon exitting Excel
  240. RE: Clearing cells in a range upon exitting Excel
  241. Re: Clearing cells in a range upon exitting Excel
  242. Clearing cells in a range upon exitting Excel
  243. Delete Multiple Rows in one go
  244. C# Excel Add-in
  245. Invoice Number duplicate Check
  246. Copy and Paste exact formula
  247. code snippet below. Is there a shorter way to do this type of thin
  248. Automatic Date Stamp
  249. search and/or loop dilema
  250. Detecting Table Change
  251. Merge the contents of multiple cells into one cell
  252. Code Jumps
  253. event handler for calculation
  254. Code termination resets public variable
  255. what is the way to select ASCII file and import it into excel sheet?
  256. Locked Cells and Hyperlinks
  257. Hide/Show some worksheets
  258. Can I Licence my macros?
  259. Get cell address calling a function in C#
  260. Reset All Command Buttons on an Excel UserForm
  261. Pros/Cons of having users Trust the VBA Project
  262. Detect if a Defined Name Exists
  263. Buttons for saving and exiting a workbook
  264. Macro button
  265. Auto fit wrapped and merged cells in entire worksheet Options
  266. How to reference a precedent range in another sheet?
  267. search 2 criteria then update data
  268. Match Value and Show MsgBox
  269. Whats wrong with this!!!!!
  270. Formula depending on cell value
  271. TextBox to time
  272. Array help.
  273. Vlookup using ComboBox value
  274. Evaluate function
  275. MSCOMCT2.OCX registration error "ClassFactory cannot supply requestedclass"
  276. Code to automatically email when xls file is save?
  277. Re: Excel DB Queries: passwords and connections
  278. Moving a label on a form at run time.
  279. in VBA script, make cell values = formula value, not formula
  280. how to count the most frequently used words in a range
  281. User variable to get object value
  282. Sum data from multiple Workbooks.
  283. Please help... real simple question...
  284. code
  285. VBA Formula Excel 2007
  286. Update "centerheader" code running slowly need help speeding up
  287. Querying multiple Excel files
  288. ODBC question
  289. Server Threw An Exception Error
  290. Using a values from a lookup table to populate a range
  291. Data From Multiple Sheets into one
  292. Using FileDir and then putting those files in order by date
  293. ComboBox Focus
  294. Macro error - open file with 'Invalid sheet name' - repair/recover
  295. Unable to make the name Property of the Range Object Local
  296. Download Exchange Global Contacts using VBA
  297. advise if active workbook is read only
  298. adding the date to comment boxes
  299. repeat range of data values down through end of table
  300. simple code that does a search for me and returns a string
  301. Delet Sheets with out Automation Error
  302. Run a macro from within a function
  303. how to enter data into different work sheets from a single interfa
  304. Custom tab available to all open workbooks?
  305. Changing cell color by clicking the cell
  306. multiple criteria
  307. VBA Password Recovery
  308. Create .exe file for an add-in
  309. excel count/sum
  310. Find and instance of "X" and all rows between the next instance of "X"
  311. custom sort by vba
  312. webquery needs to import to row, not column
  313. Opening Workbook as Read Only and using ".Activate"
  314. Not statements and blank page printing
  315. Screen Flickers and slows down worksheet functions
  316. create .csv and thn FTP tht file
  317. copying comments in excel to a separate worksheet
  318. Find does not work in sheets with Pivot tables
  319. Transfer Date Loop
  320. Change Date code to yesterday/day before ,,,,
  321. Change Date code to yesterday/day before ,,,,
  322. Change Date code to yesterday/day before ,,,,
  323. Accessing an Excel file which has macros
  324. location for XLA's that I can easily get to
  325. Matrix manipulation in vba code
  326. Refresh data on form
  327. Failing to capture values correctly?
  328. after autofilter/delete rows left not visible
  329. Macro to define ranges
  330. Using matrices is vba code
  331. Copy rows and insert (x) number of times
  332. Function for week number
  333. Need Help!!
  334. How to run macros as one close a excel?
  335. Query Tables naming not going to plan...
  336. Every 4th Row
  337. clear the entire active worksheet
  338. Chart line width
  339. How does this line of code run?
  340. Hide menu items
  341. inserting word art programmatically in excel 2007
  342. "Run-Time Error '1004'
  343. vba code for inserting word art using in excel 2007
  344. Miscellaneous VBA Questions
  345. Open workbook selected form dialog
  346. Print area - selection
  347. Too many different formats and Userforms
  348. I NEED A SIMPLE LABOR SCHEDULE...HELP
  349. Copy a blank Cell
  350. Does closing modules increase stability?
  351. Aborting a User Form display
  352. Macro to print to pdf and email each sheet
  353. Run-Time error 1004 Application defined or object defined error -
  354. Using VBA to access data via the Internet
  355. Help - return date-time from a given # of days
  356. iterating through worksheets
  357. Re: Invalid procedure call or argument
  358. how to group sheets to perform a find
  359. RE: printing question
  360. XL2003
  361. macro for importing external data
  362. Invalid procedure call or argument
  363. Excel 2003 & XML Question
  364. printing question
  365. Compute Named Formulas
  366. CF (If Formula Is ) placed into macro
  367. Chart No Show by Using ChartWizard - 2007 Excel, C#
  368. using a value in a cell to hide rows
  369. How to access .NET Framework FileVersionInfo data type
  370. RE: XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeM
  371. Enter formula in Macro/VBA
  372. Delete rows if fits criteria in a Macro
  373. XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeModule
  374. Converting a Word doc to a multi-column Excel spreadsheet
  375. Detecting Internet Site
  376. Copy rows between two criteria
  377. difference between Value and Value2 and obtaining the value of a cell in excel xp and later
  378. Validation on text input boxes on a form
  379. Password Protect File in '07 With Macros
  380. I want to transfer data in a list based on value to an other workb
  381. how do create a formula
  382. Macros for sorting entries
  383. Chip Pearson Compare add-in question
  384. Change Event
  385. Email Lotus Notes
  386. Hyperlink macro - with filename
  387. Whats the diff with this If statement than the traditional If-else
  388. Slow to add or delete sheet
  389. Userform Combobox or List box?
  390. filter multiple columns for one value
  391. Offset of active cell
  392. Formula to match words
  393. Insert line sum rows
  394. Unwanted prompts when clsoing a workbook
  395. Macro security level
  396. Macro should autosave
  397. 2 Problems with Excel
  398. Connect MS Excel to SQL server sing internet: is it possible???
  399. cells to behave like check boxes
  400. How does this function works?
  401. Getting Information about Events Seen In the Object Browser
  402. Stopping a series of macros
  403. TIME
  404. What excel formula gives me the funcion (x*y%)/12 in my calculator
  405. How do Incorporate a condition in a case statement?
  406. Stopping a userform subroutine
  407. AutoFill Macro
  408. Range name copy Macro
  409. Maximize Userform
  410. Range name copy
  411. Excel 2007 Help
  412. Need program logic to sort fieldA & delete duplicates
  413. Loop, copy, past
  414. Delete all Range Names Q
  415. Am referencing data want to place actual value
  416. Issue with conditional formatting - Formula changing
  417. Macro that uses range names
  418. 2007 Merge cells taking forever
  419. Programming for Excel Charts
  420. Re: Solver come out a different solversolve msg
  421. Enabling/Disabling OptionButtons, CheckBoxes etc. in another works
  422. use of arrow keys in Excel
  423. Reading SQL Table into Excel and calculating/inserting group line (with VBA)?
  424. Worksheet_change event
  425. Excel Picture manipulation in 2007
  426. Delete row of cells in range based on condition
  427. Excel 2007 Visual Basic Editor
  428. Altering macro code
  429. Excel 2003 to 2007 VBA Change
  430. formula
  431. Office Home & Student 2007
  432. Re: How to set 'insert picture' default open location
  433. Re: How to set 'insert picture' default open location
  434. VBA=Excel cell
  435. Date Format Glitch - Book1.xls (0/1)
  436. Re: using variables in listbox
  437. RE: Setting timer to run macro at regular intervals
  438. Re: How to search files using EXCEL codes?
  439. Re: CommandButton not responding
  440. RE: Setting timer to run macro at regular intervals
  441. Re: Setting timer to run macro at regular intervals
  442. Re: using variables in listbox
  443. Re: CommandButton not responding
  444. Referencing Userform Controls
  445. How to obtain current selection using C++
  446. What is the [-409] and the @
  447. Add-in Serious Error Message
  448. ActiveCell.Address to return non Absolute reference
  449. “Calendar Control” to Insert Dates
  450. Grouping data on seperate Worksheets
  451. command bar name not recognized
  452. Commission Calculator
  453. opening html in excel
  454. Application InputBox Type 8 Error
  455. Drop-down in FIND dialog
  456. pivot source change
  457. MATCH() and ISERROR() to extract set differences
  458. Calculating TextBoxes
  459. MS Query becomes inert
  460. BeforeClose Event problem
  461. How can I print from cell A1 to the last row ?
  462. Programmatically create html as input to Excel
  463. Adding lines to a TextBox
  464. Text Data Fields mixed with binary (Comp) and packed (Comp-3) data
  465. Text Data mixed with Binary (Comp) and Packed (Comp-3) fields.
  466. Confirm save file
  467. highlight row if cell value equal zero
  468. excel's range item method
  469. 2 Problems with Excel
  470. RE: polynomial regression
  471. polynomial regression
  472. Is it Possible
  473. Transferring Data from Code to a Textbox in the Form
  474. Using Excel to send email from gmail
  475. previous year
  476. Releasing Range Object
  477. Macro should Save and Overwrite file
  478. VBA-How to calc the day (number) for the Monday of Current Week
  479. HOW TO HIDE/SHOW PICTURE AS PER LOGIC IS NOT DESCRIBED PROPERLY.
  480. Displaying the extent of a range variable
  481. Using variable in Excel formula in VBA statement
  482. a command button problem
  483. How can I optimize this code?
  484. Is it possible to store multiple hyperlinks in a cell for Excel
  485. Open specific workbook
  486. Evaluate formula
  487. Formating a number in a textbox
  488. Macro not returning correct data
  489. to add a button to the active excel cell! here's the way!
  490. VBA macro in Excel
  491. Show Pricing and Description
  492. Addings sheets using Macro
  493. Filter range based on results of multiple selections in a listbox
  494. Unable to correct VBA code
  495. Copy range incld. format (e.g.conditional formatting) from closed
  496. Re: Send Free SMS Worlwide to any mobile phone iphone gsm
  497. Windows API - Searching a fonction
  498. Excel 2007 ribbon Controls & "My.Settings" equivalent in VBA
  499. Weird option button behavior
  500. Populate text box with sql from DAO
  501. Excel and Visual Basic
  502. macro for top10 & worst10 ranking
  503. macro for top10 and wors10 in ranking
  504. I generate excel file from c# & want to display image in it
  505. Identifying Conditional Format
  506. If I use 10 macro is ok but if I use 10: Auckland City Depot it is
  507. Microsoft Visual Basic for Applications Extensibility 5.3 Issue
  508. "IOAD command"
  509. How to initiate a sound via VBA?
  510. Printing macro comments in color
  511. Not able to declare variable in MS Query.
  512. Toobar Customisation
  513. protect in macro
  514. Fastest way to create clickable buttons in Excel via VBA
  515. .Sort.SortFields
  516. Trying to evaluate cell referenes in a string
  517. Ask for email title/comments in working Mail Active Sheet code
  518. convert to date
  519. problem when creating a series of matrix
  520. problem with creating a serie of matrixes
  521. Pivot Table refresh in VBA code not working
  522. Applying worksheet formatting to all sheets in workbook
  523. Importing .csv file once daily leaves a data connection
  524. Programmatically adding a conditional format
  525. Works on some systems with Excel 2003 and not on others
  526. Can macro test fill color in cell with conditional format?
  527. Barcode scanners
  528. Match and Copy to Next Sheet
  529. Weird Behaviour Function not invoked
  530. Import data macro
  531. Cells.Interior.Color question
  532. How can I format the last row !
  533. need a macro to drop excel sheets that were not populated
  534. How to open an Excel password protected file?
  535. Inserting formulas depending on a variable
  536. Navigate a user form using enter key
  537. How do I set up conditional formatting to give the greenbar effect?
  538. Complie Syntax Error
  539. System.Diagnostics.Process.Start Excel Commands
  540. Recgnizing signs 2
  541. Problem with .TintAndShade
  542. Using Excel statistical functions on a subset of an array
  543. Macro Help
  544. Sending an automatic e-mail
  545. Find a number i a range
  546. Getting around Dependency Tree Performance Problems
  547. personal.xls always opening??
  548. Recognizing signs
  549. problems adding botton to a menu bar
  550. Importing data from Adobe 8.0 to Excel 2007
  551. Add Cell name
  552. Displaying an Excel Range
  553. Testing for a directory
  554. Macro Unexpectedly calls a Function
  555. Temporarily store files in local PC
  556. Consolidate
  557. find next blank column in set area
  558. Automating a simple multiplication to a reference cell
  559. How do I make this code shorter? Its Result should be given to var
  560. Excel object library method to open a document in safe mode?
  561. Copying data from a table based on two date values
  562. Excel AutoFillOption
  563. null date?
  564. Saving filename and file save date?
  565. Why does this stop excell from working
  566. Special lookup
  567. Run Macro On Exit
  568. Need Excel spreadsheet help on a dropdown box!!
  569. NetWorkdays Not Recognized in 2007
  570. Using Validation.Type on a Range
  571. Using Excel to import .csv file into Access table
  572. Comparing Values from One Cell to Another
  573. looping?
  574. using the itemmethod
  575. Re: Multiple selection from and into validated cell.
  576. UserForm assigns cell address to Variable
  577. Determine the distance between 2 cells in a column
  578. set variable from .find
  579. how do I join multi dimentional arrays
  580. protecting the entire worksheet
  581. ACCESS Query in EXCEL
  582. QUERY halts VBA
  583. Automatic Calculation in Code Takes Longer than Worksheet
  584. Found Data Not in Window View
  585. Question on Removing Characters
  586. Auto Filter memory
  587. printing specific cells
  588. Subtract Months
  589. Relative cell position in VBA
  590. Re: File -> New, bypassing task pane
  591. Project References
  592. 3 different hyperlinks attached to the same cell?
  593. Compare Contents of 2 listboxes
  594. IF Statement Help
  595. get value from combobox on toolbar
  596. Warning if other files open
  597. checking for dupes
  598. Range Names
  599. Calendar default date
  600. Pasting Values Problem - sorting feature messed up
  601. Application.Evaluate
  602. How To Call A Function When A User Activates a Dialog Box
  603. Loop through rows to consolidate data
  604. using the functions of the excel to identify if a color in the cellchanged
  605. SQL import to Excel using VBA for PC and MAC
  606. File Sizes are much larger
  607. Dis-able Online Help
  608. Change Current Directory
  609. Excel 2007 : Create a Chart (record macro)
  610. How to combine arrays?
  611. Macro to create a new tab based on an existing tab
  612. Macro to add a line at the bottom of a table with prefilled functi
  613. Get data from another workbook
  614. Filter set in macro filters all values out
  615. delete rows from AutoFilter or Advanced Filter range
  616. XP Vista & Office Cheap!
  617. Update Links prompt
  618. Check Box
  619. Remove add-in - also remove toolbar
  620. VB For Excel Help Files
  621. Direction of entry to a cell
  622. serial communication
  623. ole timeout
  624. why is this code not working?
  625. calculate
  626. Find() and Replace() in Excel 2007 not working.
  627. Wrong data type returned from user-defined function
  628. a problem with variable number of parameters.
  629. Ole timeout - jdperrose
  630. DataValidation ListBox
  631. sample macro
  632. Esxcel conditional formatting
  633. VBA Reference Books
  634. Problem Closing Sheet
  635. VBA and pasting
  636. Re: Sheet Naming
  637. RE: Change order of data in a cell
  638. Cell Background Color Change --> Change Event
  639. Auto complete typing from another column
  640. CopyFromRecordset fails if more than 911 byte in a field
  641. VBA Function Reference
  642. RE: Code to select cells with data
  643. RE: delete rows from an Advanced Filter range
  644. Problems with writing array to worksheet using resize
  645. RE: Code to copy and paste those cells that have data
  646. delete rows from an Advanced Filter range
  647. Code to copy and paste those cells that have data
  648. RE: Sheet Naming
  649. RE: Change order of data in a cell
  650. Code to select cells with data
  651. Re: Change order of data in a cell
  652. Sheet Naming
  653. Points based on goal & weight of measures
  654. Change order of data in a cell
  655. Substitute a variable in a loop
  656. UDF: Count rows in named range
  657. Sheet Select Macro
  658. range name as file name
  659. Detect Previous Add-In Version
  660. How can a print macro run faster ?
  661. Macro Error stops App Macro
  662. Edit text in a Command button
  663. Capture Worksheet Change Value
  664. protect multiple sheets at one time with options
  665. Automation
  666. Input box question
  667. Documentation for command parameters for Excel4 calls
  668. VBA Change Format of All Cells in a Workbook
  669. line break character
  670. Stop Excel changing CSV text into dates
  671. Using Input Bx to Find Record
  672. SendKeys question
  673. Userform with 1024+ textboxes
  674. Custom function problem
  675. after a .Find command, offset the output 2 rows down.
  676. Cycle through A Range
  677. can this formula be coded?
  678. Save and print if change made
  679. Adding new data to sheet2 from sheet1
  680. Calling a module from textbox
  681. Adding text to an email
  682. macro program
  683. Encrypt the contents of a specific group of cells
  684. refer to another cell in the same row with the active cell
  685. a problem with excel addin
  686. a button on an excel cell
  687. Copying (variable) rows from another spreadsheet
  688. using variable in value1 of PivotFilters.Add
  689. macro for pivot tables
  690. Worksheet Change Q
  691. Internet unnamed button not working
  692. run Internet explorer in VBA 2007 (EXCEL)
  693. Getting name of sheet
  694. Same name macros - One in XLA and the other in COM AddIn
  695. How to run macro for "private sub.."
  696. transposing repeating data records in excel
  697. Return value based on fraction of a list - VBA
  698. Saving Active Worksheet
  699. special filter or query
  700. #value error
  701. Column Subtotal Question
  702. Envelope Size
  703. Dynamic text box labeling
  704. If Statement..i think
  705. macro to show File Comments property
  706. Macro or formula
  707. Get Picture from Access Database
  708. EXCEL: to retrive data from the web
  709. MS Excel 2003 add-in converstion to MS Excel 2007
  710. (Name) vs Name properies for a worksheet
  711. Windows Message when Directory Already Exist
  712. Remove Item from ListBox1
  713. Run Macro when a condition is met
  714. AutoComplete feature in Drop Down Menus?
  715. Sum even columns
  716. Number Format based on Cell Content
  717. print range bottom right cell
  718. I want to make an order entry program for customers...
  719. Macro to select cells at current cell
  720. ShortName
  721. Vista IE7 excel 2000 VBA
  722. Select range starting at active cell
  723. Advanced Find & Replace
  724. removing data
  725. Excel Option/Reference/Install/Environment/etc. Issue
  726. Excel macro to read and edit mail rules
  727. replacing characters in a string
  728. Going to a cell in column B
  729. Visible Property
  730. Delete an OLE Check Box in COde when a deleting a row
  731. Insert number of rows based on criteria
  732. Copy Cell to Comment
  733. VBA script causes clipboard to be lost
  734. Select range from a varaible
  735. IF - formatting problem
  736. Clicking into refedit changes screen to bottom of worksheet
  737. Macro To Send Emails
  738. Find formatting in text in cell, insert tags aroundformatting
  739. Forms built using VB6 used in a DLL used by Excel
  740. space from right
  741. web refresh question
  742. Match Values
  743. 365 qoutes to be included in file
  744. Manipulate cells from UDF
  745. datepart question
  746. Trapping SheetChange Event in COM add-in
  747. Putting Internet explorer into Excel
  748. Update Sheet
  749. Copy and paste ONLY conditional format
  750. last row of sheet1 to use in a formula in sheet2
  751. Stack Overflow
  752. Subscript out of range, and more
  753. Loop within loop?
  754. Not sorted union range.
  755. sorting a range of cells in the same column by Address
  756. Timestamp Problems
  757. copy multiple cells to another sheet
  758. Re: (ADO)Getting data from access database Memo field
  759. Digital signature breaks on insertion of new Worksheets
  760. Macro to copy and paste row
  761. Size of CommandButton changing while not expected !
  762. Run sort macro on active worksheet
  763. Determining if the user enabled macros
  764. Working with dates in VBA
  765. Excel: Code to delete entire rows when font is Strikethrough?
  766. MultiSelect Textbox
  767. Data Validation for TextBoxes
  768. Copy data from one sheet to another
  769. Setting a code range = coords of the cell containing the function
  770. Help please with autofilter and dates
  771. To Database, or not...
  772. view web page with external links offline on laptop
  773. Excel VBA Vs Chart Data Tables
  774. Multiple users experience slowdown ??
  775. Excel 2000 formulas won't copy
  776. Individual Character fonts in a cell
  777. import info from one workbook to another workbook
  778. Print Entire Workbook
  779. Communication between two Excel COM add-ins
  780. Visual Basic
  781. Helpfiles missing when excel is exported to Labview using Excel200
  782. Open Foldr Macro..?
  783. comment
  784. Preserve keyword
  785. Excel Calendar/Rota program problem
  786. Protection Password Prompt Problem
  787. Can't save in Hidden Worksheet after converting to Excel Add-In
  788. Excel 2003/2007 Shared File Issues
  789. Limit fields in drilldown detail from pivot
  790. Column Subtotals with variable number of items
  791. Insert FileName - TabName and Date() - using VBA
  792. Question about http://www.sulprobil.com/html/vlookupall.html
  793. Code to stop a Macro
  794. compare two cells
  795. remove blank rows
  796. Error 91 while trying to save a workbook
  797. Multi select Listbox
  798. dll call in Excel 2007
  799. link comments section of properties dialog box to footer in Excel
  800. WebBrowser- connected combobox selection and function
  801. Excel 2007 UDFs result in #REF! errors
  802. a brief explanation of macro, when the cursor is over...
  803. Copy data from another workbook to any open workbook
  804. Object name on user form
  805. Treansposition - use arrays?
  806. Modify to write results into B2 down instead of msgbox
  807. Pivot Table Automatically updation problem
  808. VBA does not recognize Excel worksheet function "indirect"
  809. Make VBA wait for return from external function
  810. conditional formatting for a variable range
  811. Defining a range in many sheets
  812. statement not making sense
  813. VBA and insert question
  814. if the file is shared, do not execute macro
  815. Muliple formula conditions
  816. macro that does a find and then find next
  817. Variable Date vs variant
  818. Getting info from one workbook to another
  819. Change event
  820. Excel does not get diaplyed properly (child controls (ActiveX) )
  821. combine multiple rows of data into one row.
  822. cursor activat in textbox
  823. Copy Conditional Formatting
  824. Radio Button
  825. Multi window Excel
  826. Sneding email thru VBA (using Exchange)
  827. Access Coding Question
  828. How to put formulas into blank cells from VBA when something isentered?
  829. Print Code
  830. Excel file for deliberations on proper entry date into a retirementplan
  831. Copy Formula Code
  832. UDF Not Returning Array to Range
  833. How to auto hide a row if the first cell is blank?
  834. When excel is opened need to ask a question
  835. For Each minor problem
  836. Multiple Countif - i,j,l counters probably mixed up
  837. Using combobox to find column
  838. Run a macro only when deleing a row
  839. Code Formula
  840. view web page with links offline
  841. Combining PDFs
  842. IS THERE A WAY TO SEARCH FOR AND CALCULATE MULTIPLE EXCEL FILES?
  843. Delete Selected Worksheets Macro
  844. Using a filter when sheet has VBA code
  845. Activate Sheet
  846. Userforms
  847. creating new workbook from one sheet
  848. If statement in VBA to change formatting from % to numbers
  849. loop problem
  850. Combo Box Drop Down Button
  851. Active Cell
  852. Delete Rows
  853. Do a lookup with VBA based on criteria in three cells
  854. Personal macro workbook
  855. Hiding automated spreadsheet activity
  856. Step Into Macro when file opens
  857. excel 4 macro migration to excel 2007
  858. Macro to hide rows below
  859. Last key pressed
  860. Cell Auto Code
  861. Linkk Workbk to data source
  862. Scroll Event
  863. Writing a named range to SQL Server 2000 table
  864. Uploading files:Not sure if this is an easy or hard one
  865. SUMIFS with relative reference r1c1
  866. Summing data in one column based on date in another column
  867. Replace Underscores Between Words from an Object with a Single Spa
  868. Each Stakeholder of A File Must Select His Name (Only)
  869. VBA + Excel Performance: your feedback requested
  870. How can I automatically POST in a Public Folder?
  871. Conditonally format a text box
  872. Rename new worksheet with the current date
  873. Close msgbox automatically
  874. how do i show non-unique records (duplicates) using advanced filte
  875. how do i calcalate hours above 7am and >19:00am leaving 12 hrs
  876. Macro Error in Command Button
  877. Confused by CDbl behaviour
  878. Save Error Message
  879. File or Window is open
  880. Enabling add-in causes excel to crash
  881. Writing value to another file
  882. first column in row
  883. Replace
  884. Re: what is wrong with this code? (when used in the excel_addin)
  885. UDF to copy formatting as well as text?
  886. Last Day of the Latest Month Syntax problem
  887. How to run Solver while viewing a graph?
  888. RE: Volatile UDF evaluates to zero on opening workbook until I press F
  889. Re: vba solution
  890. RE: moving within forms
  891. Offset
  892. code to change font color of row
  893. control toolbox vs forms toolbars
  894. Format Total but not GRAND Total rows
  895. Format Total but not Grand Total rows
  896. Select range between column and row
  897. mapi.session
  898. XL2007 workbook with multiple users?
  899. VBA Coding Help
  900. Viewing/editing Macros
  901. Worksheet DESIGN - Prev. Balance
  902. Excel 2003 - Typing Letter in Dropdown Cell
  903. Can anyone correct this code ???
  904. Can you do user defined Menu Macros in Excel like in Lotus?
  905. Go to a given row number
  906. objMessage.Recipients.Add
  907. How to create "permanent" toolbars
  908. Indirect question
  909. Problem Using 'Mod'
  910. user editing cell when code runs
  911. Help with code
  912. Coloring a cell based on a formula
  913. How do I display the winner's name in a ranked list of names?
  914. Passing information between worksheets
  915. Excel Shared AddIn
  916. User Forms and Sending E-mails
  917. Format Looping
  918. Function for smooth curve on a chart
  919. Help with... Help
  920. vlook up Function
  921. AddDiagram Not woring in Excel 2007
  922. preventing comboboxes from triggering when sheet copied
  923. Getting Defined Name from Cell
  924. Search for Values part2
  925. hide and unhide worksheets when a set button on a form is clicked
  926. Problem with hide/show for userform where showmodal is set to true
  927. Sum two data ranges when met two conditions
  928. halt a subroutine question
  929. Sum of data ranges in two different sheets giving two conditions
  930. How can I cut and paste from excel to other applications, multiple pieces of info?
  931. find in workbook
  932. hide and unhde worksheets when a set button on a form is clicked
  933. error subscript out of range in commandbutton_click
  934. Where did my question go?
  935. An 'Insert' question
  936. Do not show this message again
  937. insert picture in microsoft office excel 2007
  938. insert picture in microsoft office excel 2007
  939. calculate vba userform type mismatch when decimal is entered
  940. Search for Values
  941. Copying data from one sheet to another
  942. SelectionChange Event Glitch
  943. #VALUE! Error from UDF
  944. Access form from Excel
  945. MSForms.DataObject Misbehaving
  946. date format
  947. rename worksheet
  948. copy & Paste
  949. Storing automatically updated data
  950. Export % from Excel to Word as %
  951. Filling out paper forms
  952. difference between range.text and range.value
  953. Save a file
  954. Timer question
  955. Distribute Cost by Month
  956. Delay in file opening in excel 2007
  957. Pause until MSNSTockQuote runs
  958. Barcode scanning macro
  959. Retain rows with Max values - Delete other rows
  960. what does =Print means in MS EXCEL
  961. Transferring of certain cells from one workbk to another
  962. export file and arrange
  963. Generate calendar column month headers in YYMM Format
  964. Conditional Formatting More Than three
  965. Identifying the worksheet and cell that contains a function call
  966. Hide WScript Command window
  967. Share a digitally-signed macro workbook
  968. Referring to a certain column in an array
  969. SUMPRODUCT for other Excel functions?
  970. Coping cell comments to another cell
  971. excel4 function descriptions
  972. Expand Event for Grouping
  973. worksheet change?
  974. CountIf
  975. If Range R Is Nothing Exit otherwise Copy Another Range
  976. Auto Filter Freeze Up
  977. Select and Print Dynamic # of Columns
  978. VBA coding for pasting a formula
  979. How to Strip Leading Spaces and Underscores from Object
  980. ChDir and ChDrive
  981. initializing an array
  982. [Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
  983. go to next columb
  984. Auto-Filter When Workbook Protected
  985. Unprotect
  986. looping thru rows of variable length
  987. Setting up Template without ROWS LIMITATION
  988. Over My Head Print Code
  989. Protection greyed out in Excel
  990. change variable type
  991. Excel to Word Macro help
  992. How can I automatically format a column as it is imported?
  993. how to extract a dataset to the active cell?
  994. excel addin
  995. Runtime error 438
  996. keywords, modifiers
  997. Code for Cut Paste each page to separate sheet
  998. Record Actions
  999. Suppress "Saving" window
  1000. Computer ID