MrExcel Message Board Archive

  • Pivot table inaccuracies
  • reference books dealing with data analysis
  • loop with two stops
  • Loopy about my loop
  • hiding macro toolbar
  • Control Text Boxes
  • Accessing the Auto List
  • Printing selective rows
  • More Help - "Preloaded Formulas on Spreadsheet Invisible on
  • Copying Three selection within loop
  • Block an excel file
  • Help to modify a Marco
  • simple excel book for VB and object
  • Is it poss to resize sheet to "400 col by 2000 rows
  • Computing Overtime: A Longstanding Question
  • Help!Make "Pre-loaded" Formulas on Spreadsheet Invisible on
  • Text format
  • adding text
  • i almost have it figured out
  • startup sheet
  • AutoFit rows with top aligned & merged cells
  • Macro to import data from access
  • cascading combo boxes...???
  • How to calculate A1-style ranges
  • Returning data from a closed workbook to a variable
  • Formatting time/decimal
  • Table Lookup Solution needed
  • Auto sorting
  • Checking if a cell is blank
  • Remove XLM macro name from macro list
  • A more efficient way of doing this
  • not printing certain cells
  • Using Worksheet reference with worksheet name from another c
  • Date Validation of an input on a userform
  • Automatically define names
  • links...
  • Charting Ranges
  • make directory & open as
  • Matching to last value entered
  • sorting by data that has strikethrough in it
  • IF and Vlookup blank cell
  • Copying several cells in one
  • Find specific letters in a specific range
  • Colour the active row, then remove colouring when row is non
  • Count the number of characters in one cell
  • easiest way to do this?
  • Employer's odd time statement
  • Tabing to different cells
  • Subtracting mm:ss.000
  • Concatenate
  • passing access recordset values to excel and using them
  • Accessing which format is used in Conditional Formatting
  • Tab Wildcard
  • Link data with different workbooks
  • Macro problem! NEED HELP!!!
  • Macro has 2 problems
  • Excel 97 Splash screen
  • IsInteger
  • Urgent, please help... should be ez for u excel 'xperts!
  • Macro help
  • Inserting rows in Excel
  • Change color for 1 data label in a graph?
  • End of Sheet flag
  • Forms
  • Copy and Paste blues.....
  • Align all worksheets
  • "report" generation (advanced)
  • Conditional Random Draws of 3 values
  • Cell date formats changed by macro aren't sticky
  • Macro causes password protection in workbook
  • Protect/Unprotect VBAProject Properties
  • Macro to create a new workbook, copy sheet, but then...
  • deleting the contents of activecell, +2 cells next to it
  • Stats (Attn. Jack in UK)
  • Column chart bar width
  • Any Way to Convert TIF's or jpgs to Charts
  • Save a worksheet only!!!
  • replacing a zero result with a blank
  • visual Basic and excel
  • Sum total in S7:S2000 w/ a twist
  • Coding an Array
  • Format General Number to Currency
  • Count number of occurances of numbers
  • How do we let the group know the q was answerd?
  • Date format - Question
  • need help with VBA code
  • Data Validation Question
  • Juan Pablo G.
  • Changing cell colors based on day of the week
  • substituting a lookup ref. within a SUMIF()
  • More on SumIf........Totals
  • Watermark in Excel?
  • Is it possible to have a cell containing the current date/ti
  • Select Next Sheet
  • Formatting Dates
  • Summing top 5 of 7 values
  • unique number
  • Search for a word and delete the entire row.
  • Insert just one row
  • changing "," to "."