MrExcel Message Board Archive


  • Adding months to a date
  • subtotal up
  • Title Case
  • Replacing ranges in conditional formatting
  • Formatting problem
  • vlookup with multiple files/sheets?
  • Linear Exel Chart Programming
  • Time limit for OnTime
  • Month and Year Tenure Calculation
  • IS THERE A WAY OF HAVI
  • Pie in Pie chart. Please help!!
  • Close active workbook through filename??
  • transfering cell information from columns to lines
  • Rounding a price to end in .99
  • Auto-Emailing to Changing Email Addresses
  • Diagram scale via name? (e.g. y-max=$a$1)
  • SUMPRODUCT problems
  • links and range names
  • Need help with formula
  • Pics in cells?
  • countif code
  • VBA in 2000 won't run in 97
  • open/copy last modified csv
  • Can U Modify this macro please???
  • Test if a Cell matches a group of Cells
  • Sum Conditional Formats
  • "no more new fonts may be applied in this workbook"
  • Compact List
  • combining 2 sheets (1 common column) -leading zero problem
  • Simple for you, but important to me! Loan Calc
  • maximize a user form
  • combining 2 sheets, lookup not working
  • Reading Excel Database and Inputing Name In Word
  • COUNTIF combined with AND
  • Multiple Saves in Excel
  • Unable to remove linked data source.
  • CHANGING TIME FORMAT
  • Selecting the current column in Excel 97/VB
  • Finding duplicates within groups
  • validation list
  • Find match and add data to list
  • Sum items from multiple sheets - using Vlookup?
  • MCONCAT question for Aladin
  • question
  • FInd out if a certain book is open
  • MAIL WITH BCC
  • Using NAMES in Macros
  • Copy Column Data and Insert into new Column
  • Prompt to Burn CD
  • User form
  • Custom Function If - Sumif
  • VBA script to cancel a macro where a W/S is not balanced
  • Protection Problemes with Hyperlinks
  • How to make a cell REQUIRED?
  • wierd comment like text box
  • Extract email addresses from an import.
  • always on top
  • VBA Reselect source data Xl2000 PivotTable
  • Converting functions English to French or French to English
  • Validation Drop Down List is Missing
  • IF FUNCTION
  • Auto insert a Formula
  • Selecting different worksheet
  • Default to Enable Macros when opening workbook?
  • Auto Fill Cells
  • do something based on file extension
  • Treat ranges of cells as one during sort?
  • Keep blank cells as-is during sort?
  • Copy multiple cell contents into a single cell
  • To Manage Autofill Temporary Cache of Excel (Any Version)
  • Generating random text/names
  • I have the idea not the knowledge
  • VLookup
  • Checking VBA code is doing what u tell it to do!
  • Row and or cell deletion
  • Confirming a worksheet is protected (aka Protection phobia)
  • Missing list box arrows - Please Help
  • Calculate a total !!
  • Anonymour ftp in macro
  • Update Linked Files Problem
  • Legend size problem
  • attatch picture to IF() function?
  • Cheeky Training Question
  • Hyperlink on an image
  • Move to new workbook error in VBA
  • Which convention to use for coding
  • Select method failed... ( Run-time error '1004' )
  • Outlook or Express
  • Can someone help?
  • Excel confused about Analysis Toolpak
  • Finding name matches in two seperate list
  • Pasting quickly without formats
  • Bold characters in a cell
  • Inserting the Julian date into a header or footer
  • find the average of a cell containing a formula
  • Help with copy last 25rows that match condition to other sht
  • increase a time by a certain interval
  • Making Cells Flash
  • Cell Value = Scenario
  • compare problem!