MrExcel Message Board Archive


  • Macro to edit text within a cell
  • file with 'ghost' links
  • Access query formula
  • Help with tabstrip?
  • If Statements
  • Date and Time Picker
  • Date Format (opposite from prev. topic - see below)
  • Command Buttons To Take You To Sheets
  • COUNTIF for Multiple Conditions! Need Major Help!
  • List Boxes
  • TIME OF A MACRO-RUN
  • SOLVED .. Thanks Jay Simple VBA code line questions
  • -SOLVED- very happy thanks ...Nimrod .. Case select in VBA
  • Search
  • duplicate list
  • Locating a value with the click of a button
  • Userform with Textbox Help
  • conditional formatting >3 , again ;(
  • conditional formatting >3 , again ;(
  • macro blank recognition with if statements
  • A Website like this for ACCESS?
  • Finish this code...for target offset
  • Vb code help pls
  • SUM IF Statements
  • VB code to turn off automatic calculations
  • Getpivot data hell
  • help with custom charts
  • If macro can't find search string
  • Need Macro Help
  • Autoupdating Pivot PageFields
  • Odd DB behavior
  • Generating Numbers
  • it's 5am gmt !!
  • extract data points from trendlines automatically
  • Formula or filter for pivot table
  • Reverse names and change one to upper case
  • Convert into data table in VBA code (2nd request)
  • protection of workbook
  • code to exclude zero values,needed
  • Cell Formats
  • Logon to outlook from excel
  • Impossible to center date labels between ticks?
  • Sorting in pivot table
  • Subtracting years
  • Formatting excel sheets
  • Counting Dates
  • Organization of VBA code in workbooks
  • Macro and Excel Formatting
  • Compare books 1 & 2 (rows), post results in book3
  • Conditional formating
  • Timer
  • Font Sizes
  • How to get the data address after AutoFilter
  • Data won't change automatically
  • Is worksheet switching with a variable possible?
  • SUMPRODUCT formula not working
  • Chart Help
  • Please help! Charts!
  • Selecting rows containing "hand drawn lines"
  • SELECTING LAST CELL IN A ROW RANGE
  • Message boxes
  • XY scatter diagram labels
  • Cell Borders???
  • sumif() & sumproduct()
  • user defined number of rows and columns
  • Duplicate Entries
  • Duplicate Entries
  • Adding total not working for a particular Excel file
  • Year Planner
  • textbox on userform
  • Adding Text to body of email
  • compare and sort 2 columns, via adding blanks for mismatches
  • Simple question
  • simple count question...
  • replacing words automatically
  • I can't sleep without seeing little coloured boxes! Help!!
  • VB sumproduct
  • Averaging Formula
  • Calculating days
  • Sorting Cells with Pictures
  • CLEARING THE CLIPBOARD
  • PivotTable Question
  • countif with 2 criteria
  • ROUNDUP
  • locking cells?
  • comparing two columns
  • Extracting Last Name
  • Running totals
  • Repairing damages 97 worksheets??
  • LOOKUP ?
  • help please! Getting UDFs to work...
  • Help with Lookups
  • Pick From Lists
  • Multiple criteria in an IF statement
  • Simple Question
  • triggering code ...
  • Using $ for a cell reference
  • Manual Recalc Always Global?
  • International Currency Format
  • date format not consistent