MrExcel Message Board Archive


  • Easy chart question
  • Subtotals for each month
  • calling an event from a procedure
  • Help with Dates..
  • Version Control
  • quick check
  • Text in tables
  • Titlebar
  • how page setup pages wide by works?
  • Automatic Range Naming
  • How to do automatic increment the number
  • Can I change from pixels to inches?
  • Budgets- How to get a sub-total from multiple sheets?
  • Jay Petrulis or Anyone: Using a Data Filter within a Macro.
  • I need help fast
  • Check for Zero or Blank field value
  • IF conditional Statements...again
  • Sorting with null values
  • Offtopic discussion
  • Compile error :Duplicate declaration in current scope
  • Clearing multiple cells
  • Calender object
  • Duplicates
  • Pause a script
  • Color background
  • Cut and paste error message problem
  • IF Stmt
  • Variable Range for SUM Function
  • can u tidy this up
  • i lost my autofill handles....
  • Ooops - Menu Tools Recovery
  • formatting an amount range
  • split axis
  • Write a macro to split out depts into individual files
  • Macro to Import a data file
  • Excel locks up
  • Formatting Row with Macros
  • VLOOKUP
  • Format Cells, huh?
  • HELP - Need help with a spreadsheet, probably easy to do
  • autofill handles gone
  • Adding Columns......
  • Drop Down/Manual Entry
  • Help with my pourcentage
  • macro moving
  • How do you post a screen-shot in the msg-body?
  • Personal Macro Workbook
  • pivot tables
  • Pasting into Powerpoint
  • error handling...I'm stumped!
  • data validation
  • changing color of a cell based on logical return
  • Headers and footers
  • Date Question: Convert 7.45 years to "Hrs" / "Months" forma
  • Average Mulitple Columns
  • Message box buttons
  • Changing time entries from minutes to decimal
  • Excel VBA/formula direction
  • return a value based on several conditions...
  • Looping Macro choosing Columns
  • Outlook BCC
  • how do u reproduce a column heading elsewhere?
  • Selective vlookups
  • how to turn off launch of email browser
  • Best way to deploy a macro?
  • Stop the save message!
  • Formula for calculating age
  • outlook vba
  • adjacent columns / duplicate values / average
  • VBS to import into excel
  • using " in a formula
  • Change Calendar Year to Financial Year
  • GetPivotData - Can't retrieve the subtotals
  • Automating Copying Workbooks
  • Is there a better way to write this?
  • Disappearing Spreadsheet
  • Hyperlinks
  • help with formula
  • making Excel 'count'
  • "Between" in excel - coding for number ranges
  • format column as text, and replace all 1's as 0001
  • Retrieving from a list only those rows with data
  • For Each Worksheet in...do this
  • Another VLookup question.
  • Auto run macro
  • drop down box in a cell
  • Relative referencing??
  • where is it?
  • Setting the limits of the worksheet
  • PasteSpecial
  • Urgently Need Help BIG TIME!!!!!!!!!
  • $ in Formulas
  • Custom Dialog box
  • Excel opens all xls files
  • CheckBox Array . . . . I think?
  • Opening excel files from windows explorer
  • Avoiding Names in Formulas
  • Conditional formating on data validation - possible?
  • How to find number of chart's in one worksheet
  • Personal.xls in networksituation