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. Create appointment
  2. Tab Indexing Behavior on a Mac
  3. Macro to save file in changing directories?
  4. Calendar Control missing
  5. Change dates from dd/mm/yy to 6 digits being ddmmyy
  6. Drop Down lists
  7. Displaying data on Excel Statusbar?
  8. Split Cells
  9. Protected project
  10. convert .csv to .xls for very large file
  11. How to use INDIRECT
  12. Conditional Formatting, copy for rows
  13. error handling message help
  14. MSXML2.XMLHTTP Works with IE6, IE6 SP 1 but not with IE6 SP 2 - wh
  15. Opening an ACCESS db from the VBE in EXCEL
  16. if AddIn_1 isRunning vbcr application.enableEvents=False vbcr end if: how to do this??
  17. Date Issue
  18. Putting woirksheet name into a variable
  19. another macro is running ... how to recognise that process in code???
  20. Selecting the first blank cell in a column
  21. Automaton error/Unspecified error
  22. xlSortTextAsNumbers inconsistent? Excel 2003
  23. Problem with Spaces While Editing in VBA
  24. Open File - Need an warning to appear if file cannnot be found
  25. ScreenUpdating is always true when stepping through code ! ....
  26. Need Help with VB6 and Excel
  27. conditional formulas in Excel
  28. Why oh why!!!
  29. excel formula and vba
  30. Hide Cell contents
  31. Converting Excel Calculations to C# (or VB.NET) code and assemblie
  32. Reading command line parameters in a VBA program
  33. Matching lists
  34. Editing existing data
  35. Excel 2007 encryption
  36. FTP a file to UNIX server using Excel Macro
  37. Access embedded forms controls from VS2005
  38. Call sub with array
  39. New and exciting things
  40. Simpler Macro
  41. Drop down menus
  42. finding the last row for a macro
  43. copy specific rows to a new sheet
  44. Pivot Table Calculated Field / Item
  45. second biggest in array
  46. Copy destination
  47. Protect Worksheet / Workbook in BeforeSave Event
  48. Sub to strip away "Sheet" prefix from names
  49. Problem with rank function based on a non-worksheet array
  50. Blinking text
  51. Need Help am Brain Dead today.
  52. read and check cells in loop
  53. len limit of 255 of function. any workaround?
  54. Post to a Sheet Depending on a Value within a Cell Q
  55. sort numeric array
  56. check if valid and size array
  57. Searching for multiple words in a cell
  58. Using an excel addin to call macros in current sheet.
  59. pivot table restore
  60. if with or
  61. Identifying the user that has a workbook open?
  62. msQuery: is JOIN command possible in Excel?
  63. shorten connection time <<Macro Tweak needed>>
  64. Last Modified Date & Time
  65. Calling DLL functions in Excel VBA
  66. need advise on mycode
  67. summarising information in a workbook on a new worksheet
  68. Command button calculation from Userform and Cell reference
  69. Clearing a Sheet
  70. how do I get excel to round to specific numbers?
  71. NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS
  72. DP use when sheet protected
  73. function tweak?
  74. COM Addin Security
  75. Selecting data to copy and paste
  76. Textbox and Bullets
  77. Scheduling by workdays only spreadsheet problem
  78. Coding a filename into a macro
  79. Recording a range of changed cells.
  80. Create Harvey Balls in Excel?
  81. Print Preview + Coordinate Problem
  82. Looping through a spreadsheet
  83. deleting rows with VB
  84. Lock cell and reprotect sheet after save
  85. activating a workbook
  86. Change ws designator
  87. Charts Sheets to Powerpoint
  88. tabbing in code
  89. Function for RowHt. How to create
  90. Opening text files
  91. Can I Atomatically Split Cell Contents
  92. Hide / Unhide Workshets on Print and Open
  93. setting the range of cells to be used for customtype errorbars
  94. Repost of Question on Preventing 2 cells from having the same valu
  95. Creating a macro to swap cells but retain formatting
  96. Listbox Help
  97. Correct syntax for hiding a chart sheet
  98. Search for Quote
  99. How would this work deliberately naming a sheet, pls?
  100. Protect sheets when activated from ShowSheetsList application
  101. Adding Date to another Cell
  102. Conditional CCP entire row
  103. Format from Row Source
  104. Embarassingly simple question regarding VB Editor
  105. Parsing into different sheets
  106. Footer Color
  107. sql RETRIEVING DATA FROM TWO TABLES
  108. Excel date input inconsistancy
  109. Rename Multiple work sheet
  110. SAP interfaces
  111. Digitaly sign my Macro code
  112. web service as external data source?
  113. Form Updating
  114. excel 2000 faster than excel 2003
  115. topmost modal form
  116. Function select second lowest
  117. Putting comboboxes in an MSFlexGrid
  118. Referring to sheets wiht variable names
  119. move to the cell on the right, my code not working pls help
  120. want to advanced to cell on the right but my code won't work
  121. want to advanced to cell on the right but my code won't work
  122. Close specific workbk
  123. Unprotect VBA-Code using VBA-Code?
  124. singel cell reference
  125. Setting the CodeName of a new worksheet in the VBE Editor
  126. Array Argument Parenthesis
  127. Chart font
  128. remove msg box prompt
  129. TextBox.Visible = True ... not working
  130. Help with Search Range in Function
  131. IM A NEW USER HAVING TROUBLE WITH CODE
  132. Dynamic List Box using VBA
  133. custom toolbars to exclusive files.
  134. Circular Express when $ added
  135. How to get mutally exlusive cells on mouse click
  136. Change Event programming
  137. Sub to transform table into cols
  138. NORMAN JONES - WHEREFORE ART THEY ARE YOU
  139. Updating references in copied excel work sheet
  140. Combo Box Form Control
  141. excel b74=b74+1 when b4-b54 ="Y"
  142. Mouse over pop up
  143. Change current directory to the directory that the workbook loads from!
  144. Help - How to check if value exists in closed workbook?
  145. Rename multiple controls.
  146. Automating the copying of a line
  147. Rename multiple controls.
  148. Is there a workaround with #REF error message?
  149. How to count dates in a column between 2 dates
  150. Can I link multiple Listboxes to one Scrollbar
  151. Wath means
  152. Combination question
  153. Trouble formatting a date variable to contain a time value
  154. Stop error message
  155. Array function with more than 29 arguments
  156. Help with Case Please
  157. Need Help Pls - What's wrong with this?
  158. Array function with more than 29 arguments
  159. Finding and transfering data
  160. Need help with Array
  161. VBA to SQL DB with user input and results to worksheet
  162. Watermark image
  163. My Macro does NOT Delete ROWS??
  164. I need help with cell returning number as credit or debit
  165. Result code for SaveAs
  166. turn off recalc in PivotTables?
  167. Naming files
  168. Coping data from excel to word
  169. Tax Table Formula in Single Cell
  170. Disabling Button Commands in 2007
  171. Create pivot table
  172. Accessing VBProject causes the program to crash
  173. "Form" to add data with?
  174. Can i sell my vb program
  175. ENTER instead of TAB
  176. Showing userform
  177. Date check for expiration
  178. Excel VBA resize picture in powerpoint
  179. Extract 5 digit number from string
  180. Change image for Ribbon items
  181. Need simple 'Paste' macro code
  182. filling a combo box with two Columns
  183. Advice on optimizing spreadsheet
  184. HELP WITH A COUPLE OF SIMPLE FORMULAS FOR A NEW USER
  185. Return sheet name from an address range
  186. User selection of folder and open all .xls files within folder
  187. Return cursor to previous cell
  188. "Excel has encountered a problem..." error
  189. WHO CAN EXPLAIN THAT "macro problem"?
  190. how do I tell a macro to move to the bottom of a collumn plus one
  191. Dynamic Data Range from External Text File, Filter
  192. VB Code Highlight Rows Based on Color Index
  193. Adding scroll bars
  194. delink all charts in worksheet
  195. problem in watching the comments tags when making protection to sheet
  196. array question
  197. Re: Saving workbook causes new sheet and lockup
  198. MS Query Not Returning Data to Excel
  199. DLL Vs. EXE?
  200. Prompt user for input
  201. Run Time Error 1004: Application-Defined or Object-Defined Error
  202. Appending data and dates to a merged cell
  203. Recursive Classes - Design Pattern needed
  204. How do I modify Cell Comments from VBA?
  205. Form help
  206. How to Insert Rows but not Ripple up others
  207. Saving workbook causes new sheet and lockup
  208. Export Specific Sheet in Listbox to New Workbook
  209. Counting Specific Number of Days across Multiple Months
  210. Recording macros/Compatibility Mode Office 03/07
  211. XL2002: Button Labels & Sheets...
  212. Using a macro to create a report on another worksheet
  213. Test if there is data in a cell or not?
  214. Copy from clipboard in excel/vba: size limit ?
  215. how do i make a visual basic function calculate every cycle?
  216. Using CASE Statement to Derive Months from Numeric Dates
  217. NETWORKDAYS thru 2020
  218. Question: Can't pass an Array to a class
  219. Macro to Outline based on Indent Level
  220. Excel: Self-updating cell
  221. EnableEvents
  222. Get address of found range to use in a formula
  223. Updating Links Error on Buttons that call up Macros
  224. Placeholder in find code
  225. Making the macro's execution faster
  226. Check a value in a range
  227. Protect Excel VBA Project from another Excel Macro
  228. VBA code crashes Excel 97 - Help please!
  229. Cumulative totals
  230. Mailenvelope Gives Error to Only One User
  231. Clear Contents at 5PM daily
  232. Time arithmetic
  233. Automatic adjustment of Cell height?
  234. Changing the font size in the charts
  235. How to use RTD + Bloomberg/Reuters
  236. Help with combo/Listbox
  237. MACRO to Copy incl. hyperlinks
  238. Returning a zero value in an average total
  239. Find value and replace cell below
  240. Disable Move, but not Copy
  241. Compile error: Method or data member not found
  242. application.screenupdating = false not working
  243. Making array in DLL available in VBA?
  244. Runtime Error 1004
  245. UserForm does NOT save changes to design (Excel 2000)
  246. Export to Excel 2007
  247. Userform does not load
  248. Blacnk Cells in Excel
  249. Pivot table formulas
  250. Excel doesn't acknowledge formula as an operation
  251. Force a Date variable to store a time value
  252. copy data from excel 1 to excel 2 when different dates and columns
  253. Argument value, application.run
  254. Defaults for 'Find'
  255. About Officemenu(RibbonX)
  256. Corrupt/ Bad Recordset
  257. Help Please !!!!!!
  258. Date problems
  259. If blank, insert adjoining cell value
  260. code to select first sheet
  261. Add-Ins aren't loading
  262. Randomly selecting a name from a list
  263. Macro Suddenly Stopped Working
  264. Use Cell Values to Create Tabs with specific names
  265. Using VSTO to Print Excel Document without Empty Pages
  266. Macro - update the cell to the left after a find
  267. Build a range from a cell
  268. is there a way to avoid repeating yourself in an excel if formula?
  269. How to update datasources of a pivot table ?
  270. Backwards-compatibility problem with OpenText
  271. Tabstrip and Treeview
  272. Border question
  273. What is wrong with this macro?
  274. How to trap an error with onError in a for i loop
  275. Sheet Protection Bug?
  276. search an array for values contained in another array
  277. Putting an Icon on a CommandBar Button
  278. Late binding
  279. Travel to next cell immediately below, but filtered.
  280. SpinButton problem
  281. Macros Referenced in Custom Menu Fail after Save
  282. Best way??-one WB, many users entering only their own info
  283. Re: How can I programmatically add a hyperlink to a cell in the excel ?
  284. macro changes sheet location
  285. Using Vlookup with IF statements
  286. Auto Filter
  287. Autofill in VBA question
  288. Custom String Format
  289. scroll to activecell?
  290. Can I simplify these IF statements
  291. Validation Error - Please Help!!!
  292. Is there a more elegant way to macro this?
  293. Using Vlookup for IF statements
  294. Keep getting Errors in Code
  295. vbscript and Excel
  296. Pivottable cashe
  297. Split string into seperate cells
  298. Must I VBA?
  299. Lookup to return multiple results in one cell
  300. How to "Step Back"
  301. Copying text from website OR selecting and coping certain text within a cell
  302. How to Print out Code
  303. select fields with more then one dash (-)
  304. Xl 2003 Sp2 error message
  305. Collate information from different files via a macro
  306. Looping Thru Worksheets
  307. Question: "myself" in a Class
  308. Summing occurrences within a list
  309. "Number Formatted As Text": How To Avoid?
  310. Pop up based on criteria
  311. Running Macro on Multiple Worksheets
  312. Error on input box
  313. Loop through range and add each cell contents to a string
  314. Hide sheet - Help
  315. EXCEL SPREADSHEET HELP
  316. Prompts to Discard digital signature while saving
  317. Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste
  318. Problem with Excel 4 macros (I think)
  319. Drop down list/Combo box?
  320. Custom Add-in - How to Manage
  321. Controlling media player in VBA question
  322. Count non-zero cells
  323. Calendar Pop up issue
  324. Updating from internet
  325. referencing to matrix labels
  326. Merging Cells
  327. truncate numbers
  328. Find ID Number
  329. Scope of variable
  330. Where's the Excel 2007 SDK?
  331. Bug - Programmatic copy/paste other sheet to activecell
  332. SaveAsCopy generates error HRESULT:0x800A03EC
  333. New site for all IT students
  334. Stop
  335. Turn off ThisWorkbook Code?
  336. Listbox to display ALL Available Printers to User on a Userfrom
  337. Adjust Windows Date/Time from Excel VBA
  338. Charts with Combobox
  339. Pivot Table drilldown and protecting workbook
  340. Summarise data by average in OLAP cube
  341. ADO Excel to Access - bulk transfer of array?
  342. Object required error...
  343. Solver ignores constraints in protected sheets XL 2003
  344. why only 1 Excel window available since 2003?
  345. Add Page x of x based on sheets.
  346. modifying Ron DeBruin's menu macro
  347. Labelling a persistent object
  348. weird excel 2007 bug
  349. Creating charts in non-English versions of Excel
  350. Fill a combobox preserving characters format
  351. Customer Add-In Management XL2007<-- Please Help!
  352. How to label an object that persists in memory?
  353. Populate Excel Spreadsheet and Preserve Cell Formatting
  354. Loading DBF into existing sheet
  355. Change ColumnWidth for Multiple Columns?
  356. Calculated field in Pivot
  357. Need Help
  358. Delete a Comment/Note/Macro
  359. Preventing a cell value based on change in other field
  360. vbide
  361. Linking Excel files with part of a file name.
  362. DeleteDuplicatesViaFilter From Chip Pearson's Website
  363. Opening Workbook to a specific sheet
  364. Conditional statement
  365. Setting the Headers and Footers in Excel 2007 when exporting Information from Cobol program
  366. Workbook.Range Problem
  367. CommandBar not Visible on Chart Pages
  368. Save as method generates 1004 error
  369. Code to make only certain sheets visible
  370. vbKeyCapital
  371. vba Code Performance
  372. If Worksheet is active then...
  373. Populate ComboBox list with Access data
  374. Secure Add-ins
  375. pivot refresh hangs
  376. select columns by text in first cell
  377. Add values from two columns into third one in another worksheet
  378. Sub menuing
  379. I can't figure this out - please help
  380. word userform using xl database
  381. rs.find or rs.filter
  382. Excel 2002 Verisign Digital signature
  383. Re: Generating report with VBA
  384. Help with dates
  385. Automate IE right-click "Save Target As..."
  386. input string into a column based on the value of a cell
  387. Number Formatting
  388. loop problems
  389. comparing spreadsheets spreadsheet compare add-in
  390. Place a list box in a cell
  391. How to get all number combination from a list
  392. Path/file access error in VBE (Excel 2003)
  393. Subtraction by row
  394. PRIMARY KEYS
  395. New Book Template
  396. Specifying a string in a range
  397. Page Break preview shrinks unnecessary rows/columns
  398. VeryHidden causing a problem...?
  399. Use the Selection.End(xlDown) method to select data in a column but do not stop at a blank space. PLEASE HELP!!!
  400. Changing content of a cell based on changes in another cell
  401. FileSearch parameters locked
  402. Why Checkbox count = 4
  403. brain dead today - resize problem
  404. Rerunning Macro takes longer after each consecutive use....Why?
  405. Variable Ranges
  406. Naming a word file from excel
  407. Application.GetOpenFilename
  408. code error
  409. Primary key search
  410. Need stopwatch function
  411. Annoying Blinking and no real Help in NGs
  412. MsgBox () - Put Numbers In?!
  413. Send SMS from Excel
  414. Open Query in Macro in Essbase
  415. Help Please, so confused now.
  416. ADO.NET DataSet
  417. personal.xls
  418. Stopping ANYTHING from happening when user clicks on an area of the sheet
  419. copy excel chart to word - format problem
  420. Create worksheets from data
  421. Is Auto Filter On
  422. Protected sheet - Autofilter - Excel 97
  423. 3rd party software for building add-ins and help files
  424. Filter that has a couple of glitches and fails to work
  425. Handling errors
  426. Handling errors
  427. MergeWorkbook
  428. How to use automation to save xls into pdf from office 2007?
  429. Creating a Dynamic Array from list that may change in size
  430. Date as variable vs in excel worksheet
  431. Split function
  432. Excel 2007 VBA - Disable "Exit" Command
  433. Worksheet_SelectionChange stopped working
  434. if condition is met, shade cell [WORKS] but if value changes: erro
  435. Need Help writing a macro
  436. Macro Use
  437. Marco to automatically replace existing file
  438. random hyperlinks in excel 2002
  439. Code that Worked with SQL 2000 Does Not with SQL 2005
  440. Macro Calculation Issues
  441. Manipulating an image with from VBA
  442. Excel Marco to save, Web Publish (On a different Server) and execu
  443. Worksheet_Change Triggers on "Delete" but not on Data Entry
  444. Microsoft Query - pull data from Access "Too many parameters"
  445. macro
  446. Re: Assistnace with Small Macro. Thanks in advance
  447. Userform, ComboBox and Outside data...
  448. Select and Copy a range
  449. Copying rows from worksheet A to worksheet B based on criteria
  450. Avoiding an error
  451. Find in a column
  452. 'Option' Buttons
  453. Jagged Arrays Problem - How to Assign Arrays to an Array
  454. Terminating Excel
  455. worksheetname
  456. Jagged Arrays
  457. retrieving the day of the year
  458. Not recognizing a specific sheet the first time
  459. Run Time Error 13 Type mismatch
  460. Excel document file changes
  461. Does anyone know why keyboard shortcut does not work in Excel 2007 for callback functions?
  462. Create a registry key for an Excel file
  463. custom popup menu in cell
  464. Zoom & Autoresizing Column
  465. Sorting and averaging. Do I need a macro?
  466. creating popup menu when user right-clicks on cell
  467. Locating data from a list
  468. Cutting cell with object
  469. Simplify this into a loop
  470. Formatting Numbers
  471. How to install a new version of an Excel program - Import file does not allow replace to modules
  472. Imperfect Matches
  473. combinations
  474. For-Each-Next Freezes Excel
  475. need to speed up some page formatting code
  476. make VbA invisible
  477. Checking 2 Ranges
  478. add 1 day to date variable
  479. Subquery Confusion
  480. Excel attachments in Outlook automatically print when opened
  481. Cycle through pivotcharts
  482. Extend Excel C API add-in for using RibbonX API
  483. need some help for linear interpolation
  484. Creating a range stack
  485. File Not Found Automatic Cancel
  486. print macro is slow
  487. Failure at File Save
  488. Search column for a value
  489. VB Statement for opening multiple files of type?
  490. Code modification help please
  491. Excel97 to 2007
  492. Must I Always Click Twice to Return to My Document from a User Form
  493. Use External Function
  494. not sure on constants
  495. code to deselect a chart modified by VBA
  496. Application Status Bar circular
  497. Slow chart problems with very large data sets
  498. Find postion of number character within a string
  499. BeforeClose Event
  500. How to add filter to email macro
  501. Cell Value to String and Trim then Delete un-needed Rows
  502. Change numericals in alphabets.
  503. Shared Workbook - Freeze Pane & Hidden Column Issues
  504. Email Booster from Excel
  505. Adding/deleting ranges and renaming accordingly
  506. VBA Sumproduct for External Source
  507. Addnew
  508. Validation check
  509. Using the Dictionary object
  510. RE: Help needed with Inputbox problem
  511. Filtering data via VBA code
  512. Re: Help needed with Inputbox problem
  513. Application Status Bar Scroll
  514. How to find and count # of files in a directory
  515. how to add a macro
  516. Togglebuttons in a Userform.
  517. Grouping values
  518. is application open?
  519. drop down list
  520. Enter data in correct row from form
  521. Excel Macro Question - correction
  522. Excel Macro question
  523. Unattended Installation WindowsXP and Software
  524. Code for Work Sheet
  525. looping through one range to fill another
  526. MSXML2.DOMDocument
  527. sendkey problem
  528. Convert Text into Formula in VBA
  529. copy chart delay (musa.biralo query)
  530. number transform right at data entry
  531. Compile 6 identical ranges(size and fields) into a text file.
  532. copy column cell data onto another worksheet
  533. Userform enable/disable
  534. calling/running a macro on another worksheet
  535. clear picked cells
  536. Pls Help! Sending data to an IE web form.
  537. Pivot Table VBA question
  538. WORKBOOK OPEN
  539. before double click
  540. newbie question
  541. looking for repetitive information in a report
  542. looking for repetitive information
  543. Find Programming Job?
  544. Excel 2003 vba hiding totals for some pivot items and not others
  545. Hiding Empty Rows
  546. Custom Footer (Dynamic text with Static text)
  547. Comparing Two Columns on Two Worksheets and then Adding New Info.
  548. InputBox that obtains Workbook, Worksheet, and Range
  549. Cannot debug
  550. Excel saving with unknown extensions: .rcv and ht_
  551. How do I run an external command from within VBA
  552. Using a worksheet as a table in an SQL query
  553. Array formulas + more than 255 chars
  554. Replace...
  555. I need a macro that fills in a cell with an "X" if I click it.
  556. copy and pasting header information
  557. adding date with double click
  558. Compile error
  559. Need to replace existinf graph for new graph with the same name
  560. combine vlookup and hlookup
  561. Automation error. The object invoked has disconnected
  562. Opening Workbooks
  563. remove the border for all series for all charts
  564. macro to increase a value and print
  565. Automate Copy and Paste
  566. Flashing highlighter
  567. excel loading add-in..
  568. DisplayAlerts
  569. about the limitation of bas module
  570. Making modifications to macro module from R. De Bruin
  571. Delecting Rows
  572. zero to the left of a number
  573. Open a file in the same instance with ShellExecute
  574. Windows in Task Bar in Excel 2003
  575. macro-written correct formula returns #NAME? and #VALUE?
  576. It works but I need better code...
  577. Trouble with SENDKEYS?
  578. More Excel 2007 Speed Issues
  579. Problem Saving with the 'Must Enable Macro' workaround
  580. Check for existence of a file
  581. Copying data based on certain criteria
  582. Format to Value
  583. macros and collections
  584. Find Last in Range & Insert
  585. Copy paste to another Workbook, Error 1004
  586. Vehicle Insurance Premium Calculation
  587. How to work with only one colum of a variant
  588. count rows till cell is blank
  589. Modeless Userform Not Displaying
  590. Date Format Frustrations
  591. How to know if a workbook is already open?
  592. Control G
  593. isempty close
  594. Strings to Numbers
  595. Modifying hyperlink beyond default options
  596. Locking all cells of a given color in a given range
  597. Type mismatch error in Find method
  598. Sending emails with VBA is somehow getting stopped - help appreciated...
  599. # sign doesn't work with between-date searching
  600. .xla removal
  601. Convert hours to days-hours
  602. Refering to Active Wbk from VB6
  603. Program for Fan Balancing
  604. Changing the CONST Variable
  605. Cahnging the CONSTR Variable
  606. Userform change question
  607. Problem in Range VBA excell...
  608. second event
  609. How can I count BOLD letters in a cell?
  610. SORT (Excel) doesn't work in a column created from a LOOKUP functi
  611. import access dates into xl "calendar"
  612. Type mismatch?
  613. Resize the image in excel 2007
  614. SaveAs command doesn't save extension
  615. Write VB6 code to be used with VBA
  616. Formula req for macro
  617. game in excel
  618. probably really simple for most, but not me
  619. formula or code?
  620. complication between VB syntax and Object Value with [-] minus character
  621. Save worksheet as new workbook
  622. Apply bottom border only on filled cells, leaves blank cells without border?
  623. Toughy...
  624. Disabling events within an event handler
  625. VBA equivalent for WScript.Sleep
  626. Combining a Text or picture into another picture
  627. How do I determine what key was pressed
  628. Automatically add a textbox to a user form based on user requireme
  629. Can I add this VB script to a VBA script?
  630. Selecting print range
  631. How can I add scrollbar to a number of cells
  632. Address of first visible cell
  633. Deleting cells
  634. Highlight active cell and de-highlight previous cell
  635. addresses
  636. Add-in does not load
  637. EXCEL VALUE PASTING
  638. Major 2007 Excel Problem
  639. Macro Help
  640. show daily sales as a percentage of monthly sales target
  641. Macro converting Wind Direction from text to degrees
  642. Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
  643. Web Query
  644. printing
  645. 65532-65536:Hyperlinks
  646. Declaring a variable as a range in another worksheet
  647. How to programmatically set a focus on the selected cell?
  648. How can Excel check that a text string is even-numbered or not?
  649. Paste as Excel object (not as picture)
  650. Audible Alarm Marco w/Pop-up Message
  651. upgraded from 200 to 2007- modify macro menus
  652. Live chart in a userform
  653. Errors of Adding OWC10 Spreadsheet reference
  654. Edit Chart Macro Help - Skip ActiveChart Selection if no data
  655. Calling a VBA add in from a macro subroutine
  656. auto filter macro
  657. calculate hours using start time & end time, excluding weekends
  658. PointsToScreenPixels Documentation Incorrect
  659. copy cell
  660. telling a macro to go back to where it came from
  661. Delete Worksheets Named Sheet1, Sheet2, Sheet3, etc.
  662. summing based on multiple array criteria
  663. Merge Multiple Workbooks
  664. Object required error 424 why getting?
  665. Microsoft.Office.Interop.Excel Texttocolumns C#
  666. Losing worksheet calculations reference when deleting a sheet
  667. Choose Which Macro to use
  668. Read from a terminal application
  669. Check if Excel file is password protected
  670. load/parse large text file
  671. Find repeated values in multiple worksheets and create summary worksheet
  672. ADO recordset
  673. Name a sheet using letters from a string?
  674. clearing columns in VBA
  675. Prevent an Image from being removed
  676. Macro to copy text between delimeters
  677. Activate an open window and send keystrokes to it.
  678. code for selecting 2nd visible row
  679. Time
  680. Adding counter to new worksheet
  681. formula a value in a formula
  682. Equivalent of Workbook_BeforePrint in C++?
  683. plz plz help me out with this
  684. Open a file - Application unknown
  685. Filling a ComboBox range on focus
  686. Update a file on AS400
  687. Supressing "Do you want to save the changes you made to <file>?" message
  688. Tree View Design help
  689. Hyperlink not showing complete file path
  690. Help sought re vbmodeless form rendering a class module useless
  691. Help with disabling items in the menu
  692. Help with Command Button
  693. Arrays and picture
  694. Hiding Rows Error - "Runtime Error 1004 - Unable to set the hidden property of the range class"
  695. Need help with a repetative task
  696. Assign kbd shortcut to a macro using vba
  697. Formatting issue
  698. autofilter criteria
  699. Display "Activate" dialog from sheet navigation context menu
  700. Import data using QueryTable somehow change sheet cells references
  701. Copy from one workbook to another
  702. Can I get information
  703. Help with "If" function?
  704. Select a contact & paste it in Excel
  705. [column(101:200)] confusing
  706. Pause/Delay to Import Data, then Apply Protection to Sheet
  707. If and?
  708. Dynamic Sum
  709. Verify date by week.
  710. Edit cell to add value to existing number
  711. Macros that run between Excel and WORD
  712. Why does change event fire when workbookclosed
  713. Cancel = True
  714. array formulas in vba help
  715. Date format
  716. i need help in microsoft excel
  717. Losing calculations when deleting a sheet
  718. Animate objects
  719. columns read 1,2,3 rather than A,B,C
  720. Need to use multiple values in the If function in Excel
  721. Excel and VSTO
  722. Libraries in Excel
  723. Data logging with excel vba
  724. Time Fromula
  725. Ongoing Row Count
  726. Filtering protected sheets (again).
  727. Sum with Parameters in a Subquery
  728. Referring to the only sheet
  729. Concise Way To Tell If Range Contains Any Data?
  730. How do I change the state of an item in a (form) multiselect list box
  731. Text box w/ scroll ability
  732. Text box w/ scroll ability
  733. Before Close event
  734. How can I print find all list in excel?
  735. preventing addIn opening in second instance of Excel?
  736. excel and scrollbars
  737. Changing graph axes using named range
  738. macros to save then email
  739. Remove specific text from cell string
  740. Data Validation using multiple columns
  741. getting rid of the border
  742. Compare columns and move data based on a value and change the sign to negative
  743. Xl2003: Validation.Add method gives error from Command Button
  744. Xl2003: Validation.Add method gives error from Command Button
  745. Range Names Limitation
  746. Custom Filter by Daterange or Month
  747. Msgbox not ok
  748. Validation
  749. Opening excel
  750. Populate Userform Listbox with Access values