MrExcel Message Board Archive


  • disabling userform in form
  • Zero formatting
  • if_and_or_then loop help
  • Copying from Multiple Workbooks into One
  • Validation drop down list
  • Renaming the "Name Box"
  • Activecell value inserted as number
  • Application.WorksheetFunction.Year
  • display top line of textbox in form as default?!?!?!
  • Deleting an Add-In
  • xlDialogOpen
  • Combobox - selecting first row
  • How to add an AND condition in array formula
  • Compile Error
  • return key...
  • Gridlines print and are not supposed to.
  • Truncation problem
  • Macro skips lines of script
  • Month Names
  • VBA: Extract data from multiple spreadsheets
  • How can I capture the ThisWorkbook.BeforeClose result?
  • Counting Characters
  • Runtime Error 1004 Method of Range of Object_Global_Failed
  • Rounding numbers
  • Subtotal: Sum & Count
  • calculate dates
  • moving and filtering data
  • Summaries inside a pivot table
  • Adding Tabs (Worksheets)
  • Problem With ChDir
  • Pivoting Data for value
  • Data validation referring to cell that has count if function
  • Moving Text Boxes
  • Insert Workbook File Name
  • Merging workbooks and worksheets
  • Range inside loop defined by two cells contents
  • compile error in hidden module
  • Check For A Folder & Create Folder
  • Brackets & Me.Name
  • average formula
  • Macro not working on all versions of Excel
  • Mial merge using excel as data source
  • Deleting Dates
  • Convert a range into range name in each worksheet?
  • correlation addin to macro
  • Need count formula
  • Is there a Time Control for Excel VBA
  • cell value in a text box?
  • Can Excel work as Access
  • RefEdit missing in my help files ?!
  • Macro to insert rows part II
  • Inverting or Transposing X and Y Axes
  • keyboard shortcut for add function "sigma key"
  • Trouble with IF statement
  • A couple of questions for members to whom “excel” in Excel!
  • Scary and Confusing Formula Problem
  • Need Conditional Format help
  • Sumif with 2 sets of criteria
  • Buttons displaying for a half second, then disappearing
  • error 28: out of stack space
  • Image Behind button
  • Using An Array from one userform to another in VBA?
  • Formula to pull Min & Max Date
  • Insert row after every two rows
  • Same Range and Name, different sheets?
  • File Name in Spreadsheet
  • Merge Cells / Keep Text for Unique Column 1 Cell Values?
  • How does Excel 2000 store link values?
  • Help With IF & Time Formula
  • VBA formula help
  • creating additional files automatically (diff. file names)
  • List of Drives
  • Convert Time to a Number for computation
  • Problems with Macro to convert to CSV
  • Rounding Time
  • Calculating LIFO Returns on Investments
  • Text to Column doesn't always work for dates - WHY?
  • Pivot Table /macro/Formatting Owies
  • make a variable retain its value after userform closes
  • formula in column
  • Headings
  • Text Boxes and Last Empty Row
  • Print Macro
  • Annoying problems
  • Offset Query
  • COPY SHEET TO ANOTHER WORKBOOK
  • Sound
  • Slow Code !!
  • Newbie;VBA Advanced Filter Help
  • Displaying named range used in formula
  • Daylight Savings Time Funcitions
  • IF-DATE NESTED FUNCTIONS
  • Hiding Rows Based on Data Input, or Not
  • Pivo table functions
  • Automatic date when data entered in another field
  • File --> SaveAs "Headache.xls"
  • UserForm "Errors occured during load" in '97
  • How good is password protection in Excel?
  • VBA - How to select a range in a non-activated worksheet
  • Return date range