MrExcel Message Board Archive

  • sig figs
  • Merge Cells - Wrapping Text?
  • Import form results
  • DGET limitations...
  • isolating initials from name in single cell
  • Excel Spreadsheet with Macros
  • Display cell width & height
  • 1-2-3 Weighted Average
  • formula bar
  • Name a Sheet a variable?
  • Protection Macro
  • xlDialogSaveAs - default file name
  • counting charcters and digits but ignoring spaces and punctu
  • Find Cell
  • one more question regarding counting in different bases
  • Macro to delete a macro?
  • Selecting cells
  • Dynamic Range in a macro
  • How to run Macro on close??
  • selecting columns in a macro
  • options in excel to calculate certain fields for 10, 15 or 2
  • Starting Marco
  • Starting Marco
  • Change in cell value not triggering Macro
  • Copy Sheets
  • type mismatch errors for date values
  • autofilter & protection
  • PROTECT A SHEET AND ENABLE AUTO FILTER - Code provided
  • SUMIF by Text colour
  • Expanding this formula
  • Importing Large CSV file into Exel
  • MISSING MACROS please help!!!
  • subtotal
  • delete a macro with a macro ......password
  • Converting currency from numeric format to words
  • Saving as web page and making it interactive ?
  • column auto width with macro or vb
  • HELP!!! How do I delete duplicates on XP???
  • Inserting rows
  • Unique entries
  • replacing excel names
  • EASY - Formatting Odd Numbered Rows
  • Paste to specific column (dates)
  • COUNTIF problem
  • Defaulting empty Cell to 0
  • What row is this string in?
  • Controls and VBA help
  • Need Find in Open Workbook Code Debugged. HELP
  • Data labels on graphs
  • Discontiguous cell copy/paste
  • File Format Not Valid Message
  • copying macros
  • how do i create a menu
  • COUNT with text
  • See Below
  • True / False to Pass / Fail
  • sum and autofiltering
  • Dsum problem
  • Why are dates so tricky???
  • VBA to count the number of populated cells...?
  • turning off the _beforeclose event
  • Summing hours - not by 24 hour format
  • Opening a specfic file
  • Page numbers in a cell
  • Automatic Link
  • Subtracting results
  • subtracting dates
  • Easy String Question
  • Using Excel functions to return a value within a range
  • Works in one place but not another.
  • allow macro to get behind cell protection
  • Hiding workbooks
  • OptionButtons in Frames
  • Multiple If Situation
  • Link to cells plus one row down
  • copying with 10 cells at a time
  • Access Poser
  • Look a the value of the current cell on the other worksheet
  • PivotTable Multiple Consolidation Ranges
  • Excel 97 Drop Down Menus-SLOW
  • #N/A result when using INDEX, MATCH
  • Event to set sheet and cell on open file
  • this must be easy
  • Automate number combinations
  • SUMIF problem
  • What is "UsedRange"???
  • EXCEL DIGITS being changed to ZEROS!!! HELP
  • Saving files automatically while u work
  • OnTime Function
  • Pivot tables.
  • sorting data -few questions. How do I...?
  • VB Code - easy if you know how!
  • I would like to do “Ctrl-H”
  • Password basics
  • Find in a List and move to the right?
  • Link cells won't link properly.
  • Protect individual cells only
  • autostart macro???
  • looking for macro code to create dynamic range
  • sorting by the last digit in a cell - how??