MrExcel Message Board Archive


  • How do I ask the user to click on a sheet and have that shee
  • eliminating a bunch of rows based on the value of a single r
  • formula for time to 10th of an hour
  • How to link two sheets into a third sheet?
  • Lookup/Find function in VBA
  • Stupid Scroll Bar!
  • Extracting Date Range
  • Disable the automatic link message
  • Rounding in Excel
  • Style problem - unable to delete it
  • How to auto update Userform.textbox value on each pass thru
  • Want to ZIP and Email the current workbook
  • Newbie desperate for Timesheet help
  • Is this possible?
  • Programatically find Min and Max values
  • Calculation between dates
  • Custom Reports
  • =CONCATENATE
  • macro cannot be found
  • fill colour
  • dynamic VB?
  • Displaying Array
  • Combobox help PLEASE - DESPARATELY NEED HELP!!
  • Clear Cell contents That Has a Query
  • Auto backup.
  • Can Excel do this?
  • on open
  • Need to compare two spreadsheets/columns
  • Consecutive entries in range
  • Calculating how often a name appears
  • Adding times together
  • What is Excel equivalent of Lotus #AND# function?
  • Printing gridines?
  • Sheet Format
  • Help with Do While Loop
  • Range
  • Automatically converting to Text formatting
  • VBA Variable carryforward?
  • returning cell number
  • Not so picture perfect
  • FOR YOGI and ALADYN - YOUR'E RIGHT.....
  • Novice here...
  • printing problems
  • macro calling a function
  • I Don't Want to Click and Drag
  • a macro ?
  • File Search
  • Current time
  • Open file using UNC names and Chdrive
  • Range or Link ?
  • having problem with code
  • formatting dates and times in visual basic
  • Hidden sheet or cells?
  • Conditional Formatting
  • Yet another cell formatting question
  • Help with VBA
  • sorting hyphenated numbers
  • Selecting Print Areas
  • Identifying points on an XY Scatter Chart
  • Finding Cells with data
  • Import HTML table - formatting question
  • Macro to insert row always at botom of table
  • Countif criteria
  • Must be easy?!
  • General logic question...
  • MessageBox Query
  • Repeat run of macro
  • Set a worksheet to open
  • Deleting part of a cell
  • Produce a fan chart
  • permanently storing values
  • AUTOMATIC UPPER CASE
  • Counting cells
  • Date formatting
  • relating lists and cells
  • Copying spreadsheets and then pasting it onto word - Help!!!
  • Can't view password protected code
  • Applying Custom Number Format
  • Networkdays
  • Protecting
  • Getting external data
  • macro
  • Adding a new function to Excel
  • Can I package XLM macros with Excel 2000?
  • NT username...
  • Macros in Excel 97 and 2000
  • Tables
  • Auto Save default Excel 2000
  • Lock out cells
  • Hiding toolbars, status bar etc.??
  • Decent Title Case command?
  • Data Entry for Remote Reviewers
  • Create button on spreadsheet
  • Getting an addin to run automatically
  • Changing Date Format
  • Excel Template Wizard - any good?
  • Nesting
  • search for a number format
  • Averages
  • how to set print area within macro