MrExcel Message Board Archive


  • how can i save a sheet in my workbook as a separate file usi
  • Can someone explain the percentile function
  • Array Formula
  • Moving file confuses macros
  • Slight problem.
  • e-mail to multiple recipients
  • Using Activecell to set print area
  • Is file or workbook already open
  • Prevent saving edited workbook
  • macro to set the date and count down.......Anyone?
  • Hours worked X Pay Rate
  • Currency formatting dilemna
  • formulae problem confused?
  • number manipulation
  • Counting Weeks
  • Updating cells - or not as the case may be
  • Problem with dates in Excel
  • Dates incremented across sheets
  • Color filled cells
  • Excel macro and formula
  • What is wrong with this code
  • finding the minimum value in a row of numbers
  • Macro to hide a row
  • Formula hell in '97
  • Try this for a cool way to have a messagebox greeting
  • Setting Default Headers and Footers
  • What is the difference between VB and VBA?
  • running a macro when file is opened
  • 2-line label on custom toolbar button?
  • Blank cell stops Marco
  • VLOOKUP
  • Show denominator and numerator of fraction
  • serial number
  • Need help with lookup
  • Shipping Times
  • Margins and Landscape
  • Help ! This one should make you think !
  • Chart
  • Array Formulas help?
  • sorting list that includes merged cells
  • VB Code to move data from one sheet to another
  • TODAY
  • evaluate division
  • xxxxxxxWorkbook.Close not working!
  • Macro message
  • Copying formulas to differnet columns
  • document name reference
  • find activecell in Excel - not via VBA
  • Don't know if it's Excel or Outlook
  • Strange Problem
  • Excel file won't print
  • Tabulating random number results
  • Color font red when cursor passes over it
  • Disable Auto Open Macro
  • password protect a worksheet
  • "IF THEN" macro help please
  • Chart with graphics
  • big job 2
  • Offset Woes...
  • Running a macro on Save command
  • Slight Problem with Private Sub Workbook_BeforeSave Macro
  • MACRO TO CHANGE ANOTHER MACRO
  • all excel spreadsheets print but one
  • Excel V5.0 to Lotus Notes 4.5
  • get rid of #value!
  • Get column numbers of first and last columns in selected ran
  • Referencing
  • Is this possible? What's the best way?
  • anyone got any simple code that can add a macro button onto
  • Macros and combo boxes
  • Exit Macro if NO is choosen from Msgbox
  • Vlookup
  • Format Painter
  • Macro that choose which worksheet to view that is on ALL wor
  • Input Box Script
  • Counting unique entries
  • assigning shortcut keys
  • Comments
  • macro that can copy each persons’ info in a list to a auto-g
  • Tables...
  • when you put this code in what would be the best way to save
  • Trying to get excel to auto fill a series of fields
  • date time formatting
  • Repost of Unique entries
  • Data Fill: easier way than this VBA?
  • IF function
  • Simple Conditional Formatting question...
  • copying macros
  • totalling the number times button pushed
  • Learning VBA
  • Freeze panes
  • Conditional Formatting Challenge
  • Reading Data from nonstandard CSV file
  • Multiple Files
  • Compiling data from multiple sheets
  • Formulas
  • Nasty Formula into user-defined Function..
  • simple copy and paste
  • fuzzy lookup
  • making a user-defined function accessible to all workbooks