MrExcel Message Board Archive

  • sort every second row
  • How can I protect cells~?
  • Delete spaces in a cell containing text
  • Sorting my data - how do I do it??
  • Adding lines when data in a column changes
  • Check cells against an array
  • Variable copy and paste macro
  • Totalling amounts in groups
  • Adding lines when data changes in a column
  • Filter
  • Number check
  • Passwords
  • Selecting Next Row in Filtered Range
  • Sum when rows of numbers varies
  • Vlookup or Hlookup Offset Vary
  • UserForms
  • Sum when rows of numbers varies(2)
  • VLOOKUP
  • alerts!
  • empty values in a line-graph when using a formula
  • Excel UserForms
  • 0 (zero) values shown in line graph for empty values - (EDIT
  • nested formulas
  • Making cell value the sheet name
  • carrying out calculations only for the no. of entries
  • Columns
  • For Pro's - Link, Macro in workbooks folders
  • Macro to save workbook with cell adress as file name to othe
  • TRIM
  • Sorting Drag Down Option
  • Message Box Size
  • cell colour change
  • Paste Special Values to MERGED cells
  • Date Format
  • copying cells a set no. of times
  • Print Question
  • Round to Thousands
  • If then using a wildcard to search for text
  • VBA-Passing a variable between modules
  • Juan Pablo G.
  • Want to copy a cell x times
  • Thanks Juan Pablo G.
  • Dynamic macro button label
  • Accepting only given values.
  • Saving a file with macro
  • Pivot Table: Group: Date - Error in Conversion
  • IF condition on whole L column
  • Auto_Close / Prohibit Close
  • Retreiving the current row number
  • Modulus 10 help
  • For Tom Urtis, Deleting spaces with VBA code
  • Conditional List box
  • Counting instances of the word "January" in cells B12:B80
  • inputting variables in vb macro
  • Spell Check in a protected worksheet
  • Extract web address
  • Drop down list in macro
  • Using Cells.Find etc... VBA
  • No. days between dates excl. Sat & Sun ie work days only
  • More Message Box Questions...
  • Printing 6 copies
  • Invalid Page Fault Error When Saving Workbook
  • Combined results
  • Can Formula be the result of the =IF function
  • Data clean up w/ SUBSTITUTE
  • Referencing
  • Pick From List
  • Macros in different workbooks
  • Kilograms
  • Kilograms
  • visual Basic and excel
  • Formula Needed
  • List and run optional macros from a combo box or pop-up?
  • Hiding behind no name
  • Suppressing Duplicates
  • Automatic Row Height
  • Great site... Quick question..
  • Slow Code Any Suggestions
  • conditional formatting for formula
  • Converting Data to Date Type from General Type
  • Matching data and returning count
  • passing a range between modules
  • summing a standard range down a column
  • Can you conditionally hide a cell?
  • windows script host for NT reading Excel
  • Sum if with multiple options
  • Excel won't open
  • Function to calculate a markup
  • macro help
  • Excel custom function
  • Checking to see if a workbook is open
  • Extracting data to a list
  • Help writing an Excel macro
  • Dragging down cells containing names
  • Copying cells a set no. of times with a referance to the num
  • Columns(2)
  • Macro to print specific range
  • Command Buttons
  • Counting dates
  • Rounding Currency Amounts