PDA

View Full Version : Microsoft 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 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. How to write VBA
  2. sumif when criteria range is larger but includes criteria
  3. sumif when criteria range is larger but includes criteria
  4. hiding select rows in sheets
  5. Some basic VBA questions
  6. Value Rounded when copied from another cell
  7. how do i change cell colour by value in excell
  8. I cannot find what is wrong with this code please Help me
  9. Date Format
  10. Need help with a Formula
  11. Use Names of Named Ranges in ComboBox
  12. Print & Close Buttons in Print Preview grayed-out when '07 script
  13. AxHost.GetIPictureDispFromPicture causes Excel 2002 to crash
  14. Parse cells with line breaks
  15. Open most recent file
  16. How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent?
  17. Update Links and Essbase Retrievals
  18. How to compare two differnet cell ranges to see if they are the sa
  19. Re: Viewing archived data
  20. Event Code Error trying to insert a picture
  21. Looking to remove pivot fields from pivot table via macro
  22. Copy in other cell just one letter.
  23. If statement question
  24. Macro + protection
  25. Attaching a Read Receipt to Outlook E-mail
  26. accessing twice a memo field in a recordset
  27. Finding date in a string
  28. changing validation drop down based on another cell value
  29. how to generate '*' in a textbox field that takes a password?
  30. VBA reset cell value if greater then 0
  31. Why? When I unlock my machine Visual Basic Editor appears (when I'min Excel)
  32. Animation
  33. Enable ActiveX control Option in Trust Centre
  34. Show Window Message while is running in other Software
  35. Testing a sheet for a change since last accessed
  36. worksheet as SQL linked table (format problem).
  37. Pls help with simple sub
  38. Workbook Compare utility
  39. Recalculation Failure
  40. Print page one of sheet only
  41. disappear excel embedded messagebox in protected sheet
  42. Creating a Check Box within a Cell (
  43. Table Tools for Excel 2007
  44. RE: Using SEARCH in a single cell to COUNT multiple entries of sam
  45. Macro to find, copy and paste
  46. CSV
  47. RE: Using SEARCH in a single cell to COUNT multiple entries of same te
  48. Using SEARCH in a single cell to COUNT multiple entries of same te
  49. RE: excel programming
  50. excel programming
  51. Copy/Paste in VBA Excel
  52. How to Programmaticaly Delete or disable minimize and Maximise but
  53. RE: two "ThisWorkbooks"
  54. Re: Compare rows
  55. RE: Compare rows
  56. Cell referencing, formulas, macros
  57. RE: find a sheet by a cell
  58. two "ThisWorkbooks"
  59. Compare rows
  60. find a sheet by a cell
  61. Key Word's for VLOOKUP
  62. Upgrade to 2003, strange stuff in Immediate Window
  63. Trace dependents - get formulae
  64. VBA - Cannot find project or library
  65. remove pivotfields and refresh
  66. objFolder.ParseName Method Not Found
  67. I want to separate text at all the full stops
  68. duplicating a frame
  69. Reading data from Excel Worksheet in vb
  70. Unable to name certain ranges
  71. unlocking VBA project programatically
  72. Where is the API documentation - Office 2007
  73. RE: Find and instance of "X" and all rows between the next instance of
  74. Msg Box Yes / No Q
  75. erasing space/blank in a cell
  76. macro - paste special (transpose)
  77. How can I click on a cell and enter a default value?
  78. HELP REQUIRED: Dynamic VLookup
  79. Error 1004 while getting Cell Name
  80. Search a database with multiple strings?
  81. Offset the result
  82. VBA coding a nested Vlookup, and a sumif formula
  83. Trace dependents
  84. Dates and comments
  85. vba sumif and vlookup codes
  86. count partial string in a range
  87. Concat rows -
  88. Data Matching and exporting
  89. Name definitions
  90. Problem adding the values of 2 TextBoxes
  91. Changing From Address before sending mail
  92. Joining 2 modules as 1 for email with Excel
  93. Data Query using Match/Index
  94. Pivot table
  95. Reference two types of named sheet in a code
  96. How do I trapped the error and optimize the code?
  97. PivotTable
  98. WORKSHEETS
  99. Pixel discrepency
  100. remove or add items from a pivot tables
  101. Problem with Solver add-in. Changing values
  102. Print area - Message box
  103. Can I pass the logon credentials in a macro to a ODBC query
  104. Re: Command Button not responding
  105. Relocating my AddIn
  106. Command Button not responding
  107. Importing a file..then saving back to original file
  108. Dynamic multi-sheet excel downloads without ActiveX?
  109. Re: Clearing cells in a range upon exitting Excel
  110. RE: Clearing cells in a range upon exitting Excel
  111. Re: Clearing cells in a range upon exitting Excel
  112. Clearing cells in a range upon exitting Excel
  113. Delete Multiple Rows in one go
  114. C# Excel Add-in
  115. Invoice Number duplicate Check
  116. Copy and Paste exact formula
  117. code snippet below. Is there a shorter way to do this type of thin
  118. Automatic Date Stamp
  119. search and/or loop dilema
  120. RE: Code Jumps
  121. Detecting Table Change
  122. Merge the contents of multiple cells into one cell
  123. event handler for calculation
  124. Code termination resets public variable
  125. what is the way to select ASCII file and import it into excel sheet?
  126. Locked Cells and Hyperlinks
  127. Hide/Show some worksheets
  128. Can I Licence my macros?
  129. Folder checking
  130. Get cell address calling a function in C#
  131. Reset All Command Buttons on an Excel UserForm
  132. Pros/Cons of having users Trust the VBA Project
  133. Detect if a Defined Name Exists
  134. Buttons for saving and exiting a workbook
  135. Macro button
  136. Auto fit wrapped and merged cells in entire worksheet Options
  137. How to reference a precedent range in another sheet?
  138. search 2 criteria then update data
  139. Match Value and Show MsgBox
  140. Whats wrong with this!!!!!
  141. Formula depending on cell value
  142. TextBox to time
  143. Array help.
  144. Vlookup using ComboBox value
  145. Evaluate function
  146. MSCOMCT2.OCX registration error "ClassFactory cannot supply requestedclass"
  147. Code to automatically email when xls file is save?
  148. Moving a label on a form at run time.
  149. in VBA script, make cell values = formula value, not formula
  150. how to count the most frequently used words in a range
  151. User variable to get object value
  152. Sum data from multiple Workbooks.
  153. Please help... real simple question...
  154. code
  155. VBA Formula Excel 2007
  156. Update "centerheader" code running slowly need help speeding up
  157. Querying multiple Excel files
  158. ODBC question
  159. Server Threw An Exception Error
  160. Using a values from a lookup table to populate a range
  161. Data From Multiple Sheets into one
  162. Using FileDir and then putting those files in order by date
  163. ComboBox Focus
  164. Macro error - open file with 'Invalid sheet name' - repair/recover
  165. Windows API for return values
  166. Unable to make the name Property of the Range Object Local
  167. Download Exchange Global Contacts using VBA
  168. advise if active workbook is read only
  169. adding the date to comment boxes
  170. repeat range of data values down through end of table
  171. simple code that does a search for me and returns a string
  172. Delet Sheets with out Automation Error
  173. Run a macro from within a function
  174. Finding the min number
  175. how to enter data into different work sheets from a single interfa
  176. Custom tab available to all open workbooks?
  177. Changing cell color by clicking the cell
  178. multiple criteria
  179. VBA Password Recovery
  180. Create .exe file for an add-in
  181. excel count/sum
  182. custom sort by vba
  183. webquery needs to import to row, not column
  184. Opening Workbook as Read Only and using ".Activate"
  185. Not statements and blank page printing
  186. Screen Flickers and slows down worksheet functions
  187. create .csv and thn FTP tht file
  188. copying comments in excel to a separate worksheet
  189. Find does not work in sheets with Pivot tables
  190. Transfer Date Loop
  191. Change Date code to yesterday/day before ,,,,
  192. Change Date code to yesterday/day before ,,,,
  193. Change Date code to yesterday/day before ,,,,
  194. Accessing an Excel file which has macros
  195. location for XLA's that I can easily get to
  196. Matrix manipulation in vba code
  197. Refresh data on form
  198. Failing to capture values correctly?
  199. after autofilter/delete rows left not visible
  200. Macro to define ranges
  201. Using matrices is vba code
  202. Copy rows and insert (x) number of times
  203. Function for week number
  204. Need Help!!
  205. Backwards compatibility of macros between Excel 2003 and 2007
  206. How to run macros as one close a excel?
  207. Query Tables naming not going to plan...
  208. Every 4th Row
  209. clear the entire active worksheet
  210. Chart line width
  211. How does this line of code run?
  212. Hide menu items
  213. inserting word art programmatically in excel 2007
  214. "Run-Time Error '1004'
  215. vba code for inserting word art using in excel 2007
  216. Miscellaneous VBA Questions
  217. Open workbook selected form dialog
  218. Print area - selection
  219. Too many different formats and Userforms
  220. I NEED A SIMPLE LABOR SCHEDULE...HELP
  221. Copy a blank Cell
  222. Does closing modules increase stability?
  223. Aborting a User Form display
  224. Macro to print to pdf and email each sheet
  225. On mouse move get element name?
  226. Run-Time error 1004 Application defined or object defined error -
  227. Using VBA to access data via the Internet
  228. Help - return date-time from a given # of days
  229. iterating through worksheets
  230. Re: Invalid procedure call or argument
  231. how to group sheets to perform a find
  232. RE: printing question
  233. XL2003
  234. macro for importing external data
  235. Invalid procedure call or argument
  236. Excel 2003 & XML Question
  237. printing question
  238. Compute Named Formulas
  239. CF (If Formula Is ) placed into macro
  240. Chart No Show by Using ChartWizard - 2007 Excel, C#
  241. using a value in a cell to hide rows
  242. How to access .NET Framework FileVersionInfo data type
  243. RE: XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook").CodeM
  244. Enter formula in Macro/VBA
  245. Delete rows if fits criteria in a Macro
  246. XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook").CodeModule
  247. Converting a Word doc to a multi-column Excel spreadsheet
  248. Detecting Internet Site
  249. Copy rows between two criteria
  250. difference between Value and Value2 and obtaining the value of a cell in excel xp and later
  251. Validation on text input boxes on a form
  252. Password Protect File in '07 With Macros
  253. I want to transfer data in a list based on value to an other workb
  254. how do create a formula
  255. Re: Stopping a userform subroutine
  256. Macros for sorting entries
  257. Chip Pearson Compare add-in question
  258. Change Event
  259. Email Lotus Notes
  260. Hyperlink macro - with filename
  261. Whats the diff with this If statement than the traditional If-else
  262. Slow to add or delete sheet
  263. Userform Combobox or List box?
  264. filter multiple columns for one value
  265. Offset of active cell
  266. Formula to match words
  267. Insert line sum rows
  268. Unwanted prompts when clsoing a workbook
  269. Macro security level
  270. Macro should autosave
  271. 2 Problems with Excel
  272. Connect MS Excel to SQL server sing internet: is it possible???
  273. cells to behave like check boxes
  274. How does this function works?
  275. Getting Information about Events Seen In the Object Browser
  276. Stopping a series of macros
  277. TIME
  278. What excel formula gives me the funcion (x*y%)/12 in my calculator
  279. How do Incorporate a condition in a case statement?
  280. Re: Stopping a userform subroutine
  281. RE: Stopping a userform subroutine
  282. Re: Stopping a userform subroutine
  283. AutoFill Macro
  284. Range name copy Macro
  285. Maximize Userform
  286. Range name copy
  287. Excel 2007 Help
  288. Need program logic to sort fieldA & delete duplicates
  289. Loop, copy, past
  290. Delete all Range Names Q
  291. Am referencing data want to place actual value
  292. Issue with conditional formatting - Formula changing
  293. Macro that uses range names
  294. 2007 Merge cells taking forever
  295. Programming for Excel Charts
  296. Enabling/Disabling OptionButtons, CheckBoxes etc. in another works
  297. RE: Worksheet_change event
  298. use of arrow keys in Excel
  299. Reading SQL Table into Excel and calculating/inserting group line (with VBA)?
  300. Excel Picture manipulation in 2007
  301. Delete row of cells in range based on condition
  302. Excel 2007 Visual Basic Editor
  303. Altering macro code
  304. Excel 2003 to 2007 VBA Change
  305. formula
  306. Office Home & Student 2007
  307. VBA=Excel cell
  308. Date Format Glitch - Book1.xls (0/1)
  309. Setting timer to run macro at regular intervals
  310. CommandButton not responding
  311. Autofill destination incrementing date by 1...don't want it to
  312. How to set 'insert picture' default open location
  313. Actions By Day?
  314. Modify sub to include sheetname in new col
  315. How to search files using EXCEL codes?
  316. using variables in listbox
  317. Tip # 46 User-level prevention is a magic cure
  318. Re: TAISTELU beettasoihdusta.
  319. Solver come out a different solversolve msg
  320. trying to replace auto_open with something like workbook_open
  321. Creating a global macro
  322. Excel DB Queries: passwords and connections
  323. Excel DB Queries: passwords and connections
  324. Referencing Userform Controls
  325. How to obtain current selection using C++
  326. What is the [-409] and the @
  327. Add-in Serious Error Message
  328. ActiveCell.Address to return non Absolute reference
  329. “Calendar Control” to Insert Dates
  330. Grouping data on seperate Worksheets
  331. command bar name not recognized
  332. Commission Calculator
  333. opening html in excel
  334. Application InputBox Type 8 Error
  335. Drop-down in FIND dialog
  336. pivot source change
  337. MATCH() and ISERROR() to extract set differences
  338. Calculating TextBoxes
  339. MS Query becomes inert
  340. BeforeClose Event problem
  341. How can I print from cell A1 to the last row ?
  342. Programmatically create html as input to Excel
  343. Adding lines to a TextBox
  344. Text Data Fields mixed with binary (Comp) and packed (Comp-3) data
  345. Text Data mixed with Binary (Comp) and Packed (Comp-3) fields.
  346. Confirm save file
  347. highlight row if cell value equal zero
  348. excel's range item method
  349. 2 Problems with Excel
  350. RE: polynomial regression
  351. polynomial regression
  352. Is it Possible
  353. Transferring Data from Code to a Textbox in the Form
  354. Using Excel to send email from gmail
  355. previous year
  356. Releasing Range Object
  357. Macro should Save and Overwrite file
  358. VBA-How to calc the day (number) for the Monday of Current Week
  359. HOW TO HIDE/SHOW PICTURE AS PER LOGIC IS NOT DESCRIBED PROPERLY.
  360. Displaying the extent of a range variable
  361. Using variable in Excel formula in VBA statement
  362. a command button problem
  363. How can I optimize this code?
  364. Is it possible to store multiple hyperlinks in a cell for Excel
  365. Open specific workbook
  366. Evaluate formula
  367. Formating a number in a textbox
  368. Macro not returning correct data
  369. to add a button to the active excel cell! here's the way!
  370. VBA macro in Excel
  371. Show Pricing and Description
  372. Addings sheets using Macro
  373. Filter range based on results of multiple selections in a listbox
  374. Unable to correct VBA code
  375. Copy range incld. format (e.g.conditional formatting) from closed
  376. Re: Send Free SMS Worlwide to any mobile phone iphone gsm
  377. Windows API - Searching a fonction
  378. Excel 2007 ribbon Controls & "My.Settings" equivalent in VBA
  379. Weird option button behavior
  380. Populate text box with sql from DAO
  381. Excel and Visual Basic
  382. macro for top10 & worst10 ranking
  383. macro for top10 and wors10 in ranking
  384. I generate excel file from c# & want to display image in it
  385. Identifying Conditional Format
  386. If I use 10 macro is ok but if I use 10: Auckland City Depot it is
  387. Microsoft Visual Basic for Applications Extensibility 5.3 Issue
  388. "IOAD command"
  389. How to initiate a sound via VBA?
  390. Printing macro comments in color
  391. Not able to declare variable in MS Query.
  392. Toobar Customisation
  393. protect in macro
  394. Fastest way to create clickable buttons in Excel via VBA
  395. .Sort.SortFields
  396. Trying to evaluate cell referenes in a string
  397. Re: Multiple selection from and into validated cell.
  398. Ask for email title/comments in working Mail Active Sheet code
  399. convert to date
  400. New Tab Macro
  401. problem when creating a series of matrix
  402. problem with creating a serie of matrixes
  403. Pivot Table refresh in VBA code not working
  404. Applying worksheet formatting to all sheets in workbook
  405. Importing .csv file once daily leaves a data connection
  406. Programmatically adding a conditional format
  407. Works on some systems with Excel 2003 and not on others
  408. Can macro test fill color in cell with conditional format?
  409. Barcode scanners
  410. Match and Copy to Next Sheet
  411. Weird Behaviour Function not invoked
  412. Import data macro
  413. Cells.Interior.Color question
  414. How can I format the last row !
  415. need a macro to drop excel sheets that were not populated
  416. How to open an Excel password protected file?
  417. Inserting formulas depending on a variable
  418. Navigate a user form using enter key
  419. How do I set up conditional formatting to give the greenbar effect?
  420. Complie Syntax Error
  421. System.Diagnostics.Process.Start Excel Commands
  422. Recgnizing signs 2
  423. Problem with .TintAndShade
  424. Using Excel statistical functions on a subset of an array
  425. Macro Help
  426. Sending an automatic e-mail
  427. Find a number i a range
  428. Getting around Dependency Tree Performance Problems
  429. personal.xls always opening??
  430. Recognizing signs
  431. problems adding botton to a menu bar
  432. Importing data from Adobe 8.0 to Excel 2007
  433. Add Cell name
  434. Displaying an Excel Range
  435. Testing for a directory
  436. Re: Using Excel to import .csv file into Access table
  437. Macro Unexpectedly calls a Function
  438. Temporarily store files in local PC
  439. Consolidate
  440. find next blank column in set area
  441. Automating a simple multiplication to a reference cell
  442. How do I make this code shorter? Its Result should be given to var
  443. Excel object library method to open a document in safe mode?
  444. Copying data from a table based on two date values
  445. Excel AutoFillOption
  446. null date?
  447. Saving filename and file save date?
  448. How to Copy from one sheet and paste into another
  449. Why does this stop excell from working
  450. Special lookup
  451. Run Macro On Exit
  452. Need Excel spreadsheet help on a dropdown box!!
  453. NetWorkdays Not Recognized in 2007
  454. Using Validation.Type on a Range
  455. Comparing Values from One Cell to Another
  456. looping?
  457. using the itemmethod
  458. UserForm assigns cell address to Variable
  459. RE: Project References
  460. Determine the distance between 2 cells in a column
  461. set variable from .find
  462. how do I join multi dimentional arrays
  463. protecting the entire worksheet
  464. ACCESS Query in EXCEL
  465. QUERY halts VBA
  466. Automatic Calculation in Code Takes Longer than Worksheet
  467. Found Data Not in Window View
  468. Question on Removing Characters
  469. Auto Filter memory
  470. printing specific cells
  471. Subtract Months
  472. Relative cell position in VBA
  473. Re: File -> New, bypassing task pane
  474. 3 different hyperlinks attached to the same cell?
  475. Compare Contents of 2 listboxes
  476. IF Statement Help
  477. ODBC connection via a text file
  478. get value from combobox on toolbar
  479. Warning if other files open
  480. checking for dupes
  481. Re: Stop Excel changing CSV text into dates
  482. Range Names
  483. Calendar default date
  484. Pasting Values Problem - sorting feature messed up
  485. Application.Evaluate
  486. How To Call A Function When A User Activates a Dialog Box
  487. Loop through rows to consolidate data
  488. using the functions of the excel to identify if a color in the cellchanged
  489. SQL import to Excel using VBA for PC and MAC
  490. File Sizes are much larger
  491. Dis-able Online Help
  492. Change Current Directory
  493. Excel 2007 : Create a Chart (record macro)
  494. How to combine arrays?
  495. Macro to create a new tab based on an existing tab
  496. Macro to add a line at the bottom of a table with prefilled functi
  497. xlfTextRef from another workbook
  498. Get data from another workbook
  499. Filter set in macro filters all values out
  500. delete rows from AutoFilter or Advanced Filter range
  501. XP Vista & Office Cheap!
  502. Update Links prompt
  503. Check Box
  504. Remove add-in - also remove toolbar
  505. VB For Excel Help Files
  506. Direction of entry to a cell
  507. serial communication
  508. ole timeout
  509. why is this code not working?
  510. calculate
  511. Find() and Replace() in Excel 2007 not working.
  512. Wrong data type returned from user-defined function
  513. a problem with variable number of parameters.
  514. Ole timeout - jdperrose
  515. DataValidation ListBox
  516. sample macro
  517. Esxcel conditional formatting
  518. VBA Reference Books
  519. Problem Closing Sheet
  520. VBA and pasting
  521. Re: Sheet Naming
  522. RE: Change order of data in a cell
  523. Cell Background Color Change --> Change Event
  524. Auto complete typing from another column
  525. CopyFromRecordset fails if more than 911 byte in a field
  526. VBA Function Reference
  527. RE: Code to select cells with data
  528. RE: delete rows from an Advanced Filter range
  529. Problems with writing array to worksheet using resize
  530. RE: Code to copy and paste those cells that have data
  531. delete rows from an Advanced Filter range
  532. Code to copy and paste those cells that have data
  533. RE: Sheet Naming
  534. RE: Change order of data in a cell
  535. Code to select cells with data
  536. Re: Change order of data in a cell
  537. Sheet Naming
  538. Points based on goal & weight of measures
  539. Change order of data in a cell
  540. Substitute a variable in a loop
  541. UDF: Count rows in named range
  542. Sheet Select Macro
  543. range name as file name
  544. Detect Previous Add-In Version
  545. How can a print macro run faster ?
  546. Macro Error stops App Macro
  547. Edit text in a Command button
  548. Capture Worksheet Change Value
  549. protect multiple sheets at one time with options
  550. Automation
  551. Input box question
  552. Documentation for command parameters for Excel4 calls
  553. RE: Stop Excel changing CSV text into dates
  554. Re: Stop Excel changing CSV text into dates
  555. Loop through workbooks
  556. VBA Change Format of All Cells in a Workbook
  557. line break character
  558. RE: Using Input Bx to Find Record
  559. Re: Using Input Bx to Find Record
  560. SendKeys question
  561. Userform with 1024+ textboxes
  562. Custom function problem
  563. RE: can this formula be coded?
  564. after a .Find command, offset the output 2 rows down.
  565. Cycle through A Range
  566. Save and print if change made
  567. Adding new data to sheet2 from sheet1
  568. Calling a module from textbox
  569. Adding text to an email
  570. macro program
  571. Encrypt the contents of a specific group of cells
  572. refer to another cell in the same row with the active cell
  573. a problem with excel addin
  574. a button on an excel cell
  575. Copying (variable) rows from another spreadsheet
  576. macro for pivot tables
  577. Worksheet Change Q
  578. Internet unnamed button not working
  579. run Internet explorer in VBA 2007 (EXCEL)
  580. Getting name of sheet
  581. Same name macros - One in XLA and the other in COM AddIn
  582. How to run macro for "private sub.."
  583. transposing repeating data records in excel
  584. Return value based on fraction of a list - VBA
  585. Saving Active Worksheet
  586. special filter or query
  587. #value error
  588. Column Subtotal Question
  589. Envelope Size
  590. Dynamic text box labeling
  591. If Statement..i think
  592. Invalid Picture - Any Suggestions?
  593. macro to show File Comments property
  594. Macro or formula
  595. Get Picture from Access Database
  596. EXCEL: to retrive data from the web
  597. MS Excel 2003 add-in converstion to MS Excel 2007
  598. (Name) vs Name properies for a worksheet
  599. Windows Message when Directory Already Exist
  600. Remove Item from ListBox1
  601. Run Macro when a condition is met
  602. AutoComplete feature in Drop Down Menus?
  603. Sum even columns
  604. Number Format based on Cell Content
  605. print range bottom right cell
  606. I want to make an order entry program for customers...
  607. Macro to select cells at current cell
  608. ShortName
  609. Vista IE7 excel 2000 VBA
  610. Select range starting at active cell
  611. Advanced Find & Replace
  612. removing data
  613. Excel Option/Reference/Install/Environment/etc. Issue
  614. Excel macro to read and edit mail rules
  615. replacing characters in a string
  616. Going to a cell in column B
  617. Visible Property
  618. Delete an OLE Check Box in COde when a deleting a row
  619. Insert number of rows based on criteria
  620. Copy Cell to Comment
  621. VBA script causes clipboard to be lost
  622. Select range from a varaible
  623. IF - formatting problem
  624. Macro To Send Emails
  625. Find formatting in text in cell, insert tags aroundformatting
  626. Forms built using VB6 used in a DLL used by Excel
  627. space from right
  628. RE: web refresh question
  629. Match Values
  630. 365 qoutes to be included in file
  631. Manipulate cells from UDF
  632. datepart question
  633. Trapping SheetChange Event in COM add-in
  634. Putting Internet explorer into Excel
  635. Update Sheet
  636. Copy and paste ONLY conditional format
  637. last row of sheet1 to use in a formula in sheet2
  638. Stack Overflow
  639. Subscript out of range, and more
  640. Loop within loop?
  641. Not sorted union range.
  642. sorting a range of cells in the same column by Address
  643. Timestamp Problems
  644. copy multiple cells to another sheet
  645. Digital signature breaks on insertion of new Worksheets
  646. Macro to copy and paste row
  647. Size of CommandButton changing while not expected !
  648. Run sort macro on active worksheet
  649. Determining if the user enabled macros
  650. Working with dates in VBA
  651. Excel: Code to delete entire rows when font is Strikethrough?
  652. MultiSelect Textbox
  653. Data Validation for TextBoxes
  654. Copy data from one sheet to another
  655. Setting a code range = coords of the cell containing the function
  656. Re: Help please with autofilter and dates
  657. To Database, or not...
  658. view web page with external links offline on laptop
  659. Excel VBA Vs Chart Data Tables
  660. Re: Multiple users experience slowdown ??
  661. Tip # 45 Detect And Repair
  662. Excel 2000 formulas won't copy
  663. Individual Character fonts in a cell
  664. import info from one workbook to another workbook
  665. Print Entire Workbook
  666. Communication between two Excel COM add-ins
  667. Visual Basic
  668. Helpfiles missing when excel is exported to Labview using Excel200
  669. RE: Open Foldr Macro..?
  670. RE: Open Foldr Macro..?
  671. comment
  672. Preserve keyword
  673. Excel Calendar/Rota program problem
  674. Protection Password Prompt Problem
  675. Can't save in Hidden Worksheet after converting to Excel Add-In
  676. Excel 2003/2007 Shared File Issues
  677. Limit fields in drilldown detail from pivot
  678. Column Subtotals with variable number of items
  679. Insert FileName - TabName and Date() - using VBA
  680. Code to stop a Macro
  681. compare two cells
  682. remove blank rows
  683. Error 91 while trying to save a workbook
  684. Multi select Listbox
  685. dll call in Excel 2007
  686. Re: VBA and insert question
  687. link comments section of properties dialog box to footer in Excel
  688. WebBrowser- connected combobox selection and function
  689. Excel 2007 UDFs result in #REF! errors
  690. a brief explanation of macro, when the cursor is over...
  691. Copy data from another workbook to any open workbook
  692. Object name on user form
  693. Treansposition - use arrays?
  694. Modify to write results into B2 down instead of msgbox
  695. Pivot Table Automatically updation problem
  696. VBA does not recognize Excel worksheet function "indirect"
  697. Make VBA wait for return from external function
  698. conditional formatting for a variable range
  699. Defining a range in many sheets
  700. statement not making sense
  701. Re: VBA and insert question
  702. if the file is shared, do not execute macro
  703. Muliple formula conditions
  704. macro that does a find and then find next
  705. Variable Date vs variant
  706. Getting info from one workbook to another
  707. Change event
  708. Excel does not get diaplyed properly (child controls (ActiveX) )
  709. combine multiple rows of data into one row.
  710. cursor activat in textbox
  711. Copy Conditional Formatting
  712. Radio Button
  713. Multi window Excel
  714. Sneding email thru VBA (using Exchange)
  715. Access Coding Question
  716. How to put formulas into blank cells from VBA when something isentered?
  717. Print Code
  718. Excel file for deliberations on proper entry date into a retirementplan
  719. Copy Formula Code
  720. UDF Not Returning Array to Range
  721. How to auto hide a row if the first cell is blank?
  722. When excel is opened need to ask a question
  723. For Each minor problem
  724. Multiple Countif - i,j,l counters probably mixed up
  725. Using combobox to find column
  726. Run a macro only when deleing a row
  727. Code Formula
  728. view web page with links offline
  729. Combining PDFs
  730. IS THERE A WAY TO SEARCH FOR AND CALCULATE MULTIPLE EXCEL FILES?
  731. Delete Selected Worksheets Macro
  732. Using a filter when sheet has VBA code
  733. Activate Sheet
  734. Userforms
  735. Re: loop problem
  736. creating new workbook from one sheet
  737. Re: loop problem
  738. If statement in VBA to change formatting from % to numbers
  739. Combo Box Drop Down Button
  740. Active Cell
  741. Delete Rows
  742. Do a lookup with VBA based on criteria in three cells
  743. Personal macro workbook
  744. Hiding automated spreadsheet activity
  745. Step Into Macro when file opens
  746. excel 4 macro migration to excel 2007
  747. Macro to hide rows below
  748. Last key pressed
  749. Cell Auto Code
  750. Linkk Workbk to data source