MrExcel Message Board Archive

  • SaveAsFilename
  • sumproduct?
  • comparing 2 sheets, removing lines based on result
  • experts : how to mapipulate large data in excel
  • HELP Needed
  • Automatic Insert
  • Code to switch Calculation Mode ManualAuto (VBA Ex'97)
  • It's Friday & my head hurts - RESOLVED
  • need help with lookup()
  • how can I create a running list?
  • Multiple Files with VBA Macos Using same Shortcut Key
  • Charts
  • checkbook register
  • worksheet size ?
  • Check box inside of a combobox
  • invoice records
  • Locating and displaying data from a rather long column.
  • thought I could find it in the archives
  • Excel charts
  • Check for text, if true, then use this formula
  • If cell is blank, fill with text above
  • Sharing a workbook in real-time
  • extracting data
  • Dragging Countif functions
  • Remove area codes from phone numbers
  • SOLVED: How to determine current autofilter criteria?
  • MENU / COMMAND BARS
  • Pivot Table grouping (Excel 97)
  • VBA Code Slows When Setting 'Page Setup'
  • lots of data with n/a
  • lost focus ???
  • Worksheet names
  • Cheers folks !!!
  • vba case text string
  • Duplicate Lines in a spreadsheet
  • Cancel Button
  • MS Excel Limited Rows - 5000 ???
  • Financial function PMT
  • code needs a bit of updating
  • Find function
  • change the color of a line
  • another problem - sorting numbers
  • Delete VBA
  • add a sum dependent upon criteria
  • column letters and column topic visible with InPutBox
  • Macro code for a refresh button
  • Macro to show all on an autofilter?
  • help with nesting
  • ENTIRE ROW DELETE
  • macro problems
  • workbook 1 formula workbook 2 information
  • select and move contents of columns to rows
  • rows........again (resolved - thank God!)
  • Passing multiple arguments to a Sub
  • Pivot Table Calculations
  • xlsheethidden vs. xlsheetveryhidden
  • Solver and multiple IRRs
  • Moving ranges without changing formulas in adjacent column
  • User input in equations
  • Help with formulas
  • Full Name to First | Middle | Last
  • Conditional Format next question
  • selecting rows
  • Formula
  • Sum?
  • Is there a MrVB?
  • Dynamic Formats
  • Simpson's Rule or General Integration
  • how to add a for loop to my code...
  • saving multiple files as csv
  • visible sheets -
  • how can i make a custom command bar availble on opening and
  • selecting graphs
  • textbox help
  • IF STATEMENT
  • Edit Cell.
  • Sorting Problem
  • Concatenation...
  • cursor control
  • Subscript out of range
  • Finding linked workbooks
  • checkbox
  • Merge files
  • Submit pre-addressed email macro
  • Object Defined Error
  • Custom Function
  • accessing a specific cell of a copied range...
  • inverse of weeknum
  • Using the AND function with SUMIF??
  • Macro error
  • Referencing two cells in a msgbox
  • Entering text in a cell with vba - weird behaviour
  • Data validation limitations?
  • HOW can I import a precision number
  • Vlookup and Pictures
  • Recommended MS Access forum?
  • how do I create a form
  • variable cells
  • SHORTER MACROLINE
  • CANCEL BUTTON ON INPUTBOX