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. No Dir in Spreadsheet Referencing of Cells
  2. Updating original data from vlookup screen (macro?)
  3. Removing selection and maintaining formatting
  4. Error 91: Object Variable Not Set
  5. error 91: Object Variable not set
  6. text trigger
  7. faster way to save/restore a worksheet in MS Access
  8. Remove validation
  9. Calculating Commissions
  10. Copy Merged Cells to Single Cells ??
  11. Code for Select a file and save it in a different location
  12. Worksheet events
  13. Date format in an XML export
  14. CAN I ADD CONTROLX BUTTON TO CUSTOMISED TOOLBARS
  15. OK I admit that I can not make a Command Button work
  16. How do i hide the main title bar in excel 2007
  17. NOVICE with text and list box queries
  18. I am so close....if null add new problem
  19. Finding a Minimum Number other than Zero within a Range
  20. Offset from end of a selection
  21. Excel cursor
  22. Check available pagesize
  23. please help!
  24. column copy
  25. Selecting last pasted object
  26. Column lookups of specified numbers
  27. problem with code
  28. Userform Position exactly adjacent to Cell A 46
  29. Create a copy - Worksheet
  30. Parsing Data String from text file line
  31. Find and Replace Row
  32. automatically deleting a worksheet (without warning prompt)
  33. removing links between workbooks
  34. View panel
  35. how can add a wordin the same sheet
  36. ActiveCell
  37. Close workbook without alerts
  38. HELP
  39. Capture cell address in UDF
  40. Check if a workbook has an "open password"
  41. IfError Help
  42. Bitwise comparison question
  43. Macro's
  44. Active Cell Filling
  45. Exporting code modules
  46. Re Post: Re-arranging Cells to a specific
  47. Group a range - closing the group does not hide the controls....
  48. macro v active x control
  49. Dynamic chart
  50. UserInterfaceOnly question.
  51. confine text to cell
  52. Resizing Userform
  53. Looping through a specific column
  54. Preventing Duplicates...
  55. Multiselect on Listbox and Click Event
  56. Turn off highlight on Listbox after click_event
  57. Remove Trailing Comma
  58. top values within subtotals
  59. Insert page break & merge text in 2 rows
  60. Pop-up calendar with protected sheet
  61. Using Cell Data in Multiple Places
  62. Control Hierarchies in Userforms
  63. Exporting XML data (encoding question)
  64. Selecting an entire column
  65. Advanced Filtering on an inactive sheet
  66. FormulaR1C1 problem
  67. Having problems w/ Solver code
  68. Loan calculator- Payment
  69. .Find and With stmts
  70. Activate previous Workbook
  71. Adding text to Formula result in VBA?
  72. How to calculate Number of rows in Excel ?
  73. Getting reference to an OLEObject from another cell?
  74. Validation Drop Downs within a List
  75. Validation based on digits in the middle of a string
  76. range.offset(0,1) is OK but range.offset(0,2) not
  77. addnew
  78. DoneEx Removal
  79. Listing
  80. Needing Help
  81. Tooltip for Shape/Picture?
  82. Predictions with Excell
  83. Copy chart to clipboard - VBA
  84. 1 Dynamic Userform vs Multiple Userforms
  85. Help with a "delete rows" Macro
  86. Vlookup "contains"
  87. Protecting VB Code
  88. A Sheet by any other name.....
  89. Excel Stored Dates
  90. Spinner and Date What the heck is happening?
  91. delete macro from vbs
  92. webquery URL with brackets
  93. How do I find cells with invalid data and true conditional formatt
  94. Projects accumulate in Project Explorer
  95. Adding two characters in front plus three in back
  96. Is there a way to do this?
  97. Sending information from a cell in excel to a task in outlook
  98. application run - macros within macros
  99. Calling sub from CommandButton knowing which sheet is active
  100. Command Button Tooltips
  101. Biggie for me
  102. Excel macro that deletes all rows which doesn't contain the character "|"
  103. Yet Another Macro Question
  104. determine if Pivot Table field item is hidden
  105. Copy values (loop) from TXT file to excel
  106. Running code from form button
  107. addnew
  108. Strange Formular for OLE
  109. Excel Macro, slow performance on terminal server...
  110. Excel 2007 Ribbon Check custom buttons
  111. Check Box Control
  112. Propogate information based on cell contents
  113. Problem with Vlookup
  114. Command button
  115. Search Folder for Files
  116. starting Solver with VBA
  117. script to send data from worksheet to multiple workbooks
  118. Random Numbers
  119. Need help with checkbox to select recipients of an E Maiil via Lotus Notes
  120. How unprotech .XLS if we dont't have password?
  121. Selecting the one with the bigest amount
  122. PivotTable CommandTimeout
  123. Unload a Userform created in VB6
  124. open all workbooks in a folder
  125. Another Stock Macro Question
  126. BRAND NEW USER -: PROBLEMS WITH LIST AND TEXT BOX INPUT
  127. Publish as Web Page with Password
  128. Adapt sheet Protection
  129. calification analisys
  130. If cell is changed clear all cells to the right in that row
  131. Help with copy and pasting
  132. ComboBox1 is DELETED(!?) when Me.Pictures(1).Delete runs in my macro
  133. MailEnvelope
  134. Trigger Email with Excel File Closed
  135. toggle button in excel
  136. How to locate Cell in which control resides
  137. Create characters
  138. Windows.RangeFromPoint method is not working properly
  139. Pivot table showing #Num! error - SSAS2005 SP2
  140. Shift + F2 problem
  141. detect shape overlap?
  142. automatic sorting selected data into acsending order
  143. Re: can someone help me with these 8 lines of code
  144. Excel training from Rockhurst University Continuing Ed. for free
  145. updating Excel.FormatCondition
  146. can someone help me with these 8 lines of code
  147. Double clicking a Cell Programatically
  148. Time
  149. Help Please !!!
  150. For-Each loop, I think.
  151. Currency List Dropdown for Worksheet
  152. Referencing Cells in another worksheet in same workbook
  153. Macro not working in personal.xls
  154. Open Excel in safe mode
  155. Error 1004
  156. Transfering records based on a condition
  157. Sum based on variable text
  158. How do I keep color and font btwn tabs in Excel 2003?
  159. have to open csv files with possibly more than 65000 rows of data in them,
  160. How to select cells with checkboxes?
  161. Combo box with Data Validation feature
  162. Error with Using Macro for XYScatter plots
  163. Password Protection
  164. External Data-Changing Numeric Formatting
  165. Remove Cell Contents Macro
  166. Opening a 2nd workbook to get data from, need an easier way
  167. Show A userform on selection range
  168. Copying Range gives object defined run wrror
  169. VB Code to return to top of page
  170. Autosort on an Array
  171. Inserting VLookup using VBA - Problems concatinating contents of cell & variable
  172. Copy Macro and Forms/code
  173. Selecting Items from drop down list
  174. Null exist in Excel
  175. load a PDF file with VBA
  176. Error'9': Can I create a msgbox for the user?
  177. How to speed up response to scaling axes with code?
  178. Using macros in an external worksheet
  179. How to use CompareSideBySide method?
  180. Copy and Split Macro
  181. Macro to compare then copy if string found
  182. Mod function
  183. Calculate marketing mix
  184. copy tabs into new workbook, save, and close.
  185. Unlocking specific worksheets
  186. Real-time character counter
  187. Apply custom chart type - VBA
  188. Challenge of the day part 2
  189. Pivot Table
  190. Reports in Excel?
  191. Creating Multiple Charts from Same Pivot Table using macro
  192. Error on loading userform
  193. Excel vba chart build problem.
  194. Always keep first part of text in a cell
  195. Challenge for the day.
  196. lookup and copy certain value in a loop
  197. Run Time Error on activate coding
  198. Set A1 on Top left Corner Q
  199. List worksheet names
  200. Looping and copying from a list
  201. ascii to character
  202. To thank or not to thank
  203. Quick watch...
  204. Cutting/pasting from Excel.Application object - missing the obvious?
  205. Excel - Stock Macro Help
  206. Macro Help
  207. Special Http Response feature?
  208. Should be simple: Lookup a picture from a folder based on a cell value changing
  209. Search for name of a file in a directory (http path)
  210. Can Turn Off Internal "Undo" Stack in VBA?
  211. Running DDE functions within VBA subroutine - Any assistance appreciated
  212. Add loop to Vlookup
  213. Compile error when using Res=Inputbox
  214. Text Files
  215. Kill Function
  216. Strange Excel Bug?
  217. Limiting a worksheet's selection range.
  218. messagebox help
  219. summing cells on a different sheet
  220. Macro Optimization - 25,000+ Rows
  221. Rather tired and need solution please 4 Vllookup :-D
  222. Create a reference to a workbook which is already open
  223. Userform and Checkbox - will this work?
  224. Pivot Criteria Capture
  225. BRAND NEW USER -: PROBLEMS WITH LIST AND TEXT BOX INPUT
  226. Worksheet functions in VBA
  227. Hiding Code in Workbook
  228. MessageBox Assistant
  229. execute macro from command line
  230. Extremely long SQL Array
  231. How to Summarize between step?
  232. Time Sheet End of Month
  233. Sending e-mail from Excel
  234. XL4 error executing Page.Setup function
  235. Shape selection
  236. New User......Please Help
  237. Problem opening file from a server
  238. Check Box Status
  239. Saving files one level up
  240. ADO Recordset include Field names
  241. Populate one combo box based on the selection of another combo box
  242. write a program in xl
  243. Finding a date in between a range of dates.
  244. Macro to locate today's date from a list of dates
  245. Skip Read-only message
  246. Cell passwords
  247. Launching Macro when Cell Changes
  248. Returning the number of comments in a workbook
  249. Combobox Code, Wont Copy and paste?
  250. Entering Data into Column C based on word from Column A
  251. I can't find the YIELD method
  252. Updating a Piviot tabel when Excel data updates
  253. User Defined Function giving #NAME? error
  254. RE Define Named Range.
  255. Required Fields in Excel Application?
  256. Delete row if 3 columns have empty cells in a row
  257. Reading Text file into an array
  258. Averaging not Summing
  259. Removing modules and forms
  260. Open Word from Excel
  261. Combobox Hiding Text behind
  262. Checking for a duplicate value
  263. Runtime error 1004
  264. Excel 2007 Macro security problem.
  265. Question about the TextBox control
  266. ActiveWorkbook.ChangeLink
  267. Excel to Powerpoint pastespecial date problem
  268. Sheet protection
  269. Excel to Powerpoint pastespecial date problem
  270. convert object name from string to object
  271. Macro. XML -> Excel
  272. Font color setting problem
  273. Problem with Splash Screen user form with updating status
  274. Excel Find and Replace Problem with Array
  275. Using Dynamic Ranges in Get Data command
  276. Password Protecting a command button
  277. File save macro error
  278. Quotation marks within a formula
  279. How do you create a macro to auto number in excel 2003
  280. help hiding excel application
  281. How to
  282. dynamic formula? not sure if it's even possible to do this with Excel ...
  283. Office HTML: Excel headers and footers metadata erroneously transl
  284. need some suggestions on how to solve my problem
  285. ranges
  286. Delete Row
  287. save on condition
  288. Error handling and escape key
  289. Message Box Q
  290. How to move to column B1 from column Z1
  291. referencing inputbox input to worksheet
  292. all the check boxes should be checked if i check a particular checkbox in that row
  293. Macro Loop to Count Copy
  294. Macro runs OK for me, but not for the other users
  295. Trying to create a macro to auto number blank (excel 2003)
  296. Help on solving the linear programming model using solver
  297. command button function
  298. How keep user form constant
  299. lisbox reference and calculation
  300. Copy Excel Files to new directory
  301. Value Change Range of Sum in Another Cell
  302. Which Excel Version Best for Creating New Applications or Add-ins?
  303. How would you design this application???????
  304. Resizing and Printing a UserForm
  305. Sum , multiply betwenn 2 comboboxes
  306. Automatically updating external data sources
  307. MSXML2.XMLHTTP: "Access is Denied" - works on IE 6 SP1 but not SP2
  308. Help with creating a custom function
  309. User Form Question
  310. ADO data access to excel
  311. To thank or not to thank
  312. ASCII CODE of a character...
  313. How to fix .sort in Excel 2007
  314. Here is a challange for someone... Needing to "step through" and combine data fields
  315. Create appointment
  316. Tab Indexing Behavior on a Mac
  317. Macro to save file in changing directories?
  318. Calendar Control missing
  319. Change dates from dd/mm/yy to 6 digits being ddmmyy
  320. Drop Down lists
  321. Displaying data on Excel Statusbar?
  322. Split Cells
  323. Protected project
  324. convert .csv to .xls for very large file
  325. How to use INDIRECT
  326. Conditional Formatting, copy for rows
  327. error handling message help
  328. MSXML2.XMLHTTP Works with IE6, IE6 SP 1 but not with IE6 SP 2 - wh
  329. Opening an ACCESS db from the VBE in EXCEL
  330. if AddIn_1 isRunning vbcr application.enableEvents=False vbcr end if: how to do this??
  331. Date Issue
  332. Putting woirksheet name into a variable
  333. another macro is running ... how to recognise that process in code???
  334. Selecting the first blank cell in a column
  335. Automaton error/Unspecified error
  336. xlSortTextAsNumbers inconsistent? Excel 2003
  337. Problem with Spaces While Editing in VBA
  338. Open File - Need an warning to appear if file cannnot be found
  339. ScreenUpdating is always true when stepping through code ! ....
  340. Need Help with VB6 and Excel
  341. conditional formulas in Excel
  342. Why oh why!!!
  343. excel formula and vba
  344. Hide Cell contents
  345. Converting Excel Calculations to C# (or VB.NET) code and assemblie
  346. Reading command line parameters in a VBA program
  347. Matching lists
  348. Editing existing data
  349. Excel 2007 encryption
  350. FTP a file to UNIX server using Excel Macro
  351. Access embedded forms controls from VS2005
  352. Call sub with array
  353. New and exciting things
  354. Simpler Macro
  355. Drop down menus
  356. finding the last row for a macro
  357. copy specific rows to a new sheet
  358. Pivot Table Calculated Field / Item
  359. second biggest in array
  360. Copy destination
  361. Protect Worksheet / Workbook in BeforeSave Event
  362. Sub to strip away "Sheet" prefix from names
  363. Problem with rank function based on a non-worksheet array
  364. Blinking text
  365. Need Help am Brain Dead today.
  366. read and check cells in loop
  367. len limit of 255 of function. any workaround?
  368. Post to a Sheet Depending on a Value within a Cell Q
  369. sort numeric array
  370. check if valid and size array
  371. Searching for multiple words in a cell
  372. Using an excel addin to call macros in current sheet.
  373. pivot table restore
  374. if with or
  375. Identifying the user that has a workbook open?
  376. msQuery: is JOIN command possible in Excel?
  377. shorten connection time <<Macro Tweak needed>>
  378. Last Modified Date & Time
  379. Calling DLL functions in Excel VBA
  380. need advise on mycode
  381. summarising information in a workbook on a new worksheet
  382. Command button calculation from Userform and Cell reference
  383. Clearing a Sheet
  384. how do I get excel to round to specific numbers?
  385. NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS
  386. DP use when sheet protected
  387. function tweak?
  388. COM Addin Security
  389. Selecting data to copy and paste
  390. Textbox and Bullets
  391. Scheduling by workdays only spreadsheet problem
  392. Coding a filename into a macro
  393. Recording a range of changed cells.
  394. Create Harvey Balls in Excel?
  395. Print Preview + Coordinate Problem
  396. Looping through a spreadsheet
  397. deleting rows with VB
  398. Lock cell and reprotect sheet after save
  399. activating a workbook
  400. Change ws designator
  401. Charts Sheets to Powerpoint
  402. tabbing in code
  403. Function for RowHt. How to create
  404. Opening text files
  405. Can I Atomatically Split Cell Contents
  406. Hide / Unhide Workshets on Print and Open
  407. setting the range of cells to be used for customtype errorbars
  408. Repost of Question on Preventing 2 cells from having the same valu
  409. Creating a macro to swap cells but retain formatting
  410. Listbox Help
  411. Correct syntax for hiding a chart sheet
  412. Search for Quote
  413. How would this work deliberately naming a sheet, pls?
  414. Protect sheets when activated from ShowSheetsList application
  415. Adding Date to another Cell
  416. Conditional CCP entire row
  417. Format from Row Source
  418. Embarassingly simple question regarding VB Editor
  419. Parsing into different sheets
  420. Footer Color
  421. sql RETRIEVING DATA FROM TWO TABLES
  422. Excel date input inconsistancy
  423. Rename Multiple work sheet
  424. SAP interfaces
  425. Digitaly sign my Macro code
  426. web service as external data source?
  427. Form Updating
  428. excel 2000 faster than excel 2003
  429. topmost modal form
  430. Function select second lowest
  431. Putting comboboxes in an MSFlexGrid
  432. Referring to sheets wiht variable names
  433. move to the cell on the right, my code not working pls help
  434. want to advanced to cell on the right but my code won't work
  435. want to advanced to cell on the right but my code won't work
  436. Close specific workbk
  437. Unprotect VBA-Code using VBA-Code?
  438. singel cell reference
  439. Setting the CodeName of a new worksheet in the VBE Editor
  440. Array Argument Parenthesis
  441. Chart font
  442. remove msg box prompt
  443. TextBox.Visible = True ... not working
  444. Help with Search Range in Function
  445. IM A NEW USER HAVING TROUBLE WITH CODE
  446. Dynamic List Box using VBA
  447. custom toolbars to exclusive files.
  448. Circular Express when $ added
  449. How to get mutally exlusive cells on mouse click
  450. Change Event programming
  451. Sub to transform table into cols
  452. NORMAN JONES - WHEREFORE ART THEY ARE YOU
  453. Updating references in copied excel work sheet
  454. Combo Box Form Control
  455. excel b74=b74+1 when b4-b54 ="Y"
  456. Mouse over pop up
  457. Change current directory to the directory that the workbook loads from!
  458. Help - How to check if value exists in closed workbook?
  459. Rename multiple controls.
  460. Automating the copying of a line
  461. Rename multiple controls.
  462. Is there a workaround with #REF error message?
  463. How to count dates in a column between 2 dates
  464. Can I link multiple Listboxes to one Scrollbar
  465. Wath means
  466. Combination question
  467. Trouble formatting a date variable to contain a time value
  468. Stop error message
  469. Array function with more than 29 arguments
  470. Help with Case Please
  471. Need Help Pls - What's wrong with this?
  472. Array function with more than 29 arguments
  473. Finding and transfering data
  474. Need help with Array
  475. VBA to SQL DB with user input and results to worksheet
  476. Watermark image
  477. My Macro does NOT Delete ROWS??
  478. I need help with cell returning number as credit or debit
  479. Result code for SaveAs
  480. turn off recalc in PivotTables?
  481. Naming files
  482. Coping data from excel to word
  483. Tax Table Formula in Single Cell
  484. Disabling Button Commands in 2007
  485. Create pivot table
  486. Accessing VBProject causes the program to crash
  487. "Form" to add data with?
  488. Can i sell my vb program
  489. ENTER instead of TAB
  490. Showing userform
  491. Date check for expiration
  492. Excel VBA resize picture in powerpoint
  493. Extract 5 digit number from string
  494. Change image for Ribbon items
  495. Need simple 'Paste' macro code
  496. filling a combo box with two Columns
  497. Advice on optimizing spreadsheet
  498. HELP WITH A COUPLE OF SIMPLE FORMULAS FOR A NEW USER
  499. Return sheet name from an address range
  500. User selection of folder and open all .xls files within folder
  501. Return cursor to previous cell
  502. "Excel has encountered a problem..." error
  503. WHO CAN EXPLAIN THAT "macro problem"?
  504. how do I tell a macro to move to the bottom of a collumn plus one
  505. Dynamic Data Range from External Text File, Filter
  506. VB Code Highlight Rows Based on Color Index
  507. Adding scroll bars
  508. delink all charts in worksheet
  509. problem in watching the comments tags when making protection to sheet
  510. array question
  511. Re: Saving workbook causes new sheet and lockup
  512. MS Query Not Returning Data to Excel
  513. DLL Vs. EXE?
  514. Prompt user for input
  515. Run Time Error 1004: Application-Defined or Object-Defined Error
  516. Appending data and dates to a merged cell
  517. Recursive Classes - Design Pattern needed
  518. How do I modify Cell Comments from VBA?
  519. Form help
  520. How to Insert Rows but not Ripple up others
  521. Saving workbook causes new sheet and lockup
  522. Export Specific Sheet in Listbox to New Workbook
  523. Counting Specific Number of Days across Multiple Months
  524. Recording macros/Compatibility Mode Office 03/07
  525. XL2002: Button Labels & Sheets...
  526. Using a macro to create a report on another worksheet
  527. Test if there is data in a cell or not?
  528. Copy from clipboard in excel/vba: size limit ?
  529. how do i make a visual basic function calculate every cycle?
  530. Using CASE Statement to Derive Months from Numeric Dates
  531. NETWORKDAYS thru 2020
  532. Question: Can't pass an Array to a class
  533. Macro to Outline based on Indent Level
  534. Excel: Self-updating cell
  535. EnableEvents
  536. Get address of found range to use in a formula
  537. Updating Links Error on Buttons that call up Macros
  538. Placeholder in find code
  539. Making the macro's execution faster
  540. Check a value in a range
  541. Protect Excel VBA Project from another Excel Macro
  542. VBA code crashes Excel 97 - Help please!
  543. Cumulative totals
  544. Mailenvelope Gives Error to Only One User
  545. Clear Contents at 5PM daily
  546. Time arithmetic
  547. Automatic adjustment of Cell height?
  548. Changing the font size in the charts
  549. How to use RTD + Bloomberg/Reuters
  550. Help with combo/Listbox
  551. MACRO to Copy incl. hyperlinks
  552. Returning a zero value in an average total
  553. Find value and replace cell below
  554. Disable Move, but not Copy
  555. Compile error: Method or data member not found
  556. application.screenupdating = false not working
  557. Making array in DLL available in VBA?
  558. Runtime Error 1004
  559. UserForm does NOT save changes to design (Excel 2000)
  560. Export to Excel 2007
  561. Userform does not load
  562. Blacnk Cells in Excel
  563. Pivot table formulas
  564. Excel doesn't acknowledge formula as an operation
  565. Force a Date variable to store a time value
  566. copy data from excel 1 to excel 2 when different dates and columns
  567. Argument value, application.run
  568. Defaults for 'Find'
  569. About Officemenu(RibbonX)
  570. Corrupt/ Bad Recordset
  571. Help Please !!!!!!
  572. Date problems
  573. If blank, insert adjoining cell value
  574. code to select first sheet
  575. Add-Ins aren't loading
  576. Randomly selecting a name from a list
  577. Macro Suddenly Stopped Working
  578. Use Cell Values to Create Tabs with specific names
  579. Using VSTO to Print Excel Document without Empty Pages
  580. Macro - update the cell to the left after a find
  581. Build a range from a cell
  582. is there a way to avoid repeating yourself in an excel if formula?
  583. How to update datasources of a pivot table ?
  584. Backwards-compatibility problem with OpenText
  585. Tabstrip and Treeview
  586. Border question
  587. What is wrong with this macro?
  588. How to trap an error with onError in a for i loop
  589. Sheet Protection Bug?
  590. search an array for values contained in another array
  591. Putting an Icon on a CommandBar Button
  592. Late binding
  593. Travel to next cell immediately below, but filtered.
  594. SpinButton problem
  595. Macros Referenced in Custom Menu Fail after Save
  596. Best way??-one WB, many users entering only their own info
  597. Re: How can I programmatically add a hyperlink to a cell in the excel ?
  598. macro changes sheet location
  599. Using Vlookup with IF statements
  600. Auto Filter
  601. Autofill in VBA question
  602. Custom String Format
  603. scroll to activecell?
  604. Can I simplify these IF statements
  605. Validation Error - Please Help!!!
  606. Is there a more elegant way to macro this?
  607. Using Vlookup for IF statements
  608. Keep getting Errors in Code
  609. vbscript and Excel
  610. Pivottable cashe
  611. Split string into seperate cells
  612. Must I VBA?
  613. Lookup to return multiple results in one cell
  614. How to "Step Back"
  615. Copying text from website OR selecting and coping certain text within a cell
  616. How to Print out Code
  617. select fields with more then one dash (-)
  618. Xl 2003 Sp2 error message
  619. Collate information from different files via a macro
  620. Looping Thru Worksheets
  621. Question: "myself" in a Class
  622. Summing occurrences within a list
  623. "Number Formatted As Text": How To Avoid?
  624. Pop up based on criteria
  625. Running Macro on Multiple Worksheets
  626. Error on input box
  627. Loop through range and add each cell contents to a string
  628. Hide sheet - Help
  629. EXCEL SPREADSHEET HELP
  630. Prompts to Discard digital signature while saving
  631. Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste
  632. Problem with Excel 4 macros (I think)
  633. Drop down list/Combo box?
  634. Custom Add-in - How to Manage
  635. Controlling media player in VBA question
  636. Count non-zero cells
  637. Calendar Pop up issue
  638. Updating from internet
  639. referencing to matrix labels
  640. Merging Cells
  641. truncate numbers
  642. Find ID Number
  643. Scope of variable
  644. Where's the Excel 2007 SDK?
  645. Bug - Programmatic copy/paste other sheet to activecell
  646. SaveAsCopy generates error HRESULT:0x800A03EC
  647. New site for all IT students
  648. Stop
  649. Turn off ThisWorkbook Code?
  650. Listbox to display ALL Available Printers to User on a Userfrom
  651. Adjust Windows Date/Time from Excel VBA
  652. Charts with Combobox
  653. Pivot Table drilldown and protecting workbook
  654. Summarise data by average in OLAP cube
  655. ADO Excel to Access - bulk transfer of array?
  656. Object required error...
  657. Solver ignores constraints in protected sheets XL 2003
  658. why only 1 Excel window available since 2003?
  659. Add Page x of x based on sheets.
  660. modifying Ron DeBruin's menu macro
  661. Labelling a persistent object
  662. weird excel 2007 bug
  663. Creating charts in non-English versions of Excel
  664. Fill a combobox preserving characters format
  665. Customer Add-In Management XL2007<-- Please Help!
  666. How to label an object that persists in memory?
  667. Populate Excel Spreadsheet and Preserve Cell Formatting
  668. Loading DBF into existing sheet
  669. Change ColumnWidth for Multiple Columns?
  670. Calculated field in Pivot
  671. Need Help
  672. Delete a Comment/Note/Macro
  673. Preventing a cell value based on change in other field
  674. vbide
  675. Linking Excel files with part of a file name.
  676. DeleteDuplicatesViaFilter From Chip Pearson's Website
  677. Opening Workbook to a specific sheet
  678. Conditional statement
  679. Setting the Headers and Footers in Excel 2007 when exporting Information from Cobol program
  680. Workbook.Range Problem
  681. CommandBar not Visible on Chart Pages
  682. Save as method generates 1004 error
  683. Code to make only certain sheets visible
  684. vbKeyCapital
  685. vba Code Performance
  686. If Worksheet is active then...
  687. Populate ComboBox list with Access data
  688. Secure Add-ins
  689. pivot refresh hangs
  690. select columns by text in first cell
  691. Add values from two columns into third one in another worksheet
  692. Sub menuing
  693. I can't figure this out - please help
  694. word userform using xl database
  695. rs.find or rs.filter
  696. Excel 2002 Verisign Digital signature
  697. Re: Generating report with VBA
  698. Help with dates
  699. Automate IE right-click "Save Target As..."
  700. input string into a column based on the value of a cell
  701. Number Formatting
  702. loop problems
  703. comparing spreadsheets spreadsheet compare add-in
  704. Place a list box in a cell
  705. How to get all number combination from a list
  706. Path/file access error in VBE (Excel 2003)
  707. Subtraction by row
  708. PRIMARY KEYS
  709. New Book Template
  710. Specifying a string in a range
  711. Page Break preview shrinks unnecessary rows/columns
  712. VeryHidden causing a problem...?
  713. Use the Selection.End(xlDown) method to select data in a column but do not stop at a blank space. PLEASE HELP!!!
  714. Changing content of a cell based on changes in another cell
  715. FileSearch parameters locked
  716. Why Checkbox count = 4
  717. brain dead today - resize problem
  718. Rerunning Macro takes longer after each consecutive use....Why?
  719. Variable Ranges
  720. Naming a word file from excel
  721. Application.GetOpenFilename
  722. code error
  723. Primary key search
  724. Need stopwatch function
  725. Annoying Blinking and no real Help in NGs
  726. MsgBox () - Put Numbers In?!
  727. Send SMS from Excel
  728. Open Query in Macro in Essbase
  729. Help Please, so confused now.
  730. ADO.NET DataSet
  731. personal.xls
  732. Stopping ANYTHING from happening when user clicks on an area of the sheet
  733. copy excel chart to word - format problem
  734. Create worksheets from data
  735. Is Auto Filter On
  736. Protected sheet - Autofilter - Excel 97
  737. 3rd party software for building add-ins and help files
  738. Filter that has a couple of glitches and fails to work
  739. Handling errors
  740. Handling errors
  741. MergeWorkbook
  742. How to use automation to save xls into pdf from office 2007?
  743. Creating a Dynamic Array from list that may change in size
  744. Date as variable vs in excel worksheet
  745. Split function
  746. Excel 2007 VBA - Disable "Exit" Command
  747. Worksheet_SelectionChange stopped working
  748. if condition is met, shade cell [WORKS] but if value changes: erro
  749. Need Help writing a macro
  750. Macro Use