MrExcel Message Board Archive


  • Macro to run directly XL Opened
  • Macro to Hyperlink
  • Auto save as Macro when opening an excal document
  • Link Cells from one sheet to another then Sorting Data
  • Property of a text box
  • Removing links from charts
  • selecting the last row of data in a Sheet
  • How to have a number in a cell, but show a text
  • Lookups
  • VBA Blank cells
  • ADDING DATA TO A GRAPH CAN IT BE DONE
  • possible permutations?
  • Computing the Modulus 43 Check Character
  • graphing a pivot table
  • About calling subs..
  • Move comments into a cell
  • PLEASE HELP ME !!! Making something like a shoping cart in
  • paste link and filter
  • How do I copy one cell into a range of cells?
  • Worksheet name
  • updating a graph of a pivot table automatically
  • SUM greater than but less than...
  • Substring Search within an Array of Strings (PART 2)
  • Random strings
  • what does this symbol stand for
  • rank or percentage
  • Time calculation
  • Hi, my beautiful saviours
  • how to acheive this functionality
  • "Workbook_Open" Subroutine Does Not Always Run
  • Filtering coloured cells
  • want to create a referance to the last entry in colum
  • Month Roll up
  • AutoFilter - VBA Code - PROBLEM SOLVED
  • Automatic PO numbering help
  • Select 500 lines from a table
  • 15 digits limit, need to show more then that in a cell !
  • Code for the real brains out their..
  • the Calculate Function
  • Excel Macro that will press Enter after data is entered in a
  • viewing and removing hidden links that auto update from othe
  • Footers and Headers
  • mapping spreadsheets
  • AdvancedFilterAction, Unique:=True
  • Importing Multiple Text Files at once
  • Function Help
  • Average Of Local Maximums
  • Between Function???
  • workbooks
  • if then help needed
  • OLE or DDE
  • ListBox on UserForm SetFocus>resolved
  • Picture in header.
  • Formulas / changing depending on cell values
  • Comma seperated to a comma delimited?
  • two workbooks.
  • Transportation Problem
  • CELL COLOR
  • Pictographs
  • COLOR CELL DEPENDING ON CODE
  • Combining Data Validation with a LOOKUP table
  • Nested Functions
  • Deleting PERSONAL.XLS (Resolved)
  • XL 2000 hangs on workbook with VB buttons
  • mouse position as a variable
  • mouse position as a variable
  • Pivot Table
  • how long in each period?
  • Excel crash
  • Filter -merge?
  • day first then month?
  • day first then month?
  • How to add drop-down list to Excel worksheet?
  • for next explained please
  • How to print macros
  • Average price between dates
  • a faster way? (keystroke shortcut question)
  • Column Widths
  • Spanish Translator
  • Importing files
  • Gantt Chart
  • Array to range problem..
  • Put range into textBox
  • Open Letter to users of this board
  • formula to find Sheet name in different worksheet
  • what's wrong with this code
  • Elapsed Time
  • Any code for Creating a folder
  • Range using Cell row and column #s
  • Weekly Timesheet
  • Copying Access fields into Excel
  • Row height too small-can't change
  • auto install off cd
  • Change/hide "last saved by" name in Properties of Exl97
  • how to search a pivot table
  • Beforesave issue
  • Preserving pivot table conditional formats
  • Creating a text file from Excel
  • Anyone has spreadsheet on "Rule of 78 Calculation" a.k.a. SU
  • Predicting annual return on monthly figures