MrExcel Message Board Archive


  • VB Concatenate logic
  • Removing Blank Cells
  • Why "data may be lost"
  • VBA stopping w/ no Error?
  • Pivottable -> 'Others'
  • Resolved: Capture active cell location
  • Excel crashes on font changes (solved)
  • CELLS, CELLS, and more CELLS
  • Help With Program, Formatting, & Loops
  • If statement
  • Returning Cell References to a Macro
  • min max by date
  • What's going on here???
  • Select Case
  • ROW Change Numbers to Letters
  • count negative cells
  • Number format based on drop-down selected?
  • Period as separator in mins:secs time
  • Is this the most efficient version of this formula? RESOLVED
  • VB Select("A:A") selects A:H due to merged columns
  • Formulas with a blank result
  • how to let user select filename when using macro
  • Sort Function with a command button
  • VLOOKUP
  • How can I compare formulas?
  • Recalculate based result
  • Number Formatting
  • Duplicate entries
  • Can't make excel function work in visual basic
  • Finding the next empty line
  • Text to value - Resolved - Thanks :)
  • sound
  • create drop-down menu with macros
  • macro to sum like cells across multiple worksheets
  • referencing another file
  • Need Triggering event with cells calculate resulting in mess
  • unprotect commandbar when sheet protected
  • Running macro on all open files.
  • Range
  • Why do I need 2 single quotes for 1 to show up?
  • Trim function
  • Calculating Dates :-( Help Plz
  • select and copy a range
  • Excel Performance Question...
  • Whats wrong with my CHANGELINK code?
  • Sorting odd/even numbers
  • Take horizontal info from one worksheet and display vertical
  • Combining two columns into one
  • Pivot table field LIMITS? urgent help needed.
  • formula that returns the file name
  • Unload/hide
  • HOW DO I GET RID OF BLANK PAGES?
  • Excel 2002 .. still struggling with VBA for AutoSum!
  • Importing from Work
  • List Box - not able to scroll to last item
  • Excel Macro
  • Scenario summary or the IF scenario
  • How do I save a single specific sheet from a workbook
  • TSTom or anyone, some help please :)
  • Importing stock info from MSN Money (www.investor.com)
  • Excel formula
  • printer problems
  • Macro to cut and paste digits to a new cell
  • Trends
  • Animation of status bar
  • With Statement
  • Coincident (or overlapping) points
  • Multiple results in the same cell
  • Dangerous add-ins
  • Book for a Beginner
  • page numbers
  • Tough Formula Question :-?
  • New to Excel - Need formula
  • resolved thanks
  • Subtotals within subtotals
  • Use one cell for several numerical values and then calc. ave
  • Need help with MatchEntry on Combo box (Userforms)
  • Sending email to using different accounts
  • Extracting the row from a cell reference
  • Cut part of cell
  • visual basic.
  • Tabname Check
  • Thanks to all NOW OK Undo macro, now with code
  • Changing Userform caption colour and removing 'X'
  • another search question
  • Help With Formula Needed.
  • CREATE INPUTBOX
  • Excel macros & cell reference
  • ColourIndex not working
  • Sending only the active sheet
  • Array formulae question
  • Please Help, I need a macro to import data conditionally
  • Tracking Changes and/or Conditional Formatting
  • Autoexec macro question
  • View
  • *For Each Y in Range* not working properly
  • Diasplay string dependant on MAX value
  • After Filtering can you have Excel Autonumber Lines Every Ti
  • Another day, another problem.
  • Data Form Sort