MrExcel Message Board Archive

  • Months
  • how to do a rank and iserror together
  • Close workbook
  • lookup simultaneous 3 columns
  • Vertically center comment in cell
  • Is this code correct?
  • Newbie
  • Shading cells
  • merging-editing lists
  • Changing Cell Value to another Value
  • Everyone... Know of any good sites to download examples of
  • Combining Macro Modules
  • Index /match
  • Stumped
  • Struggling with how to select cells by date and copy / paste
  • more sites with statistical maths excel stuff required
  • Speed, why does this take so long?
  • Pivot table - refresh new rows?
  • concatenate dates?
  • Can this be done???
  • Tab, Header, Footer macro help sought (Resolved)
  • keeping VBA code and workbooks private
  • Changing Position of the Negative Sign
  • What's a "userform" ?
  • Importing Files
  • printing address labels
  • Error with macro to fill blank rows with data from above (ti
  • Comment Count
  • Vlookup dilemna
  • opening and updating a second workbook
  • Difficult Macro: Selecting a cell that is always changing
  • Columnar vs. Row Formula References
  • Extracting data from multiple workbooks.
  • pausing a macro for user to have a look
  • UserForm
  • Extract data from one workbook to another
  • Moving data from sheet to sheet
  • For Each c In Worksheets("1").range("I2:I100")
  • Sort on the last column
  • Adding Dates
  • Shelling to DOS program requiring keyboard inputs
  • Command Button Question?
  • Percent format
  • Comparing Dates in 3 different Columns
  • An easy one for someone I am sure :-)
  • Using IF formula
  • Easy VB Q
  • scientific number formats???
  • Conditionally Format Question
  • List of Formula's / Functions???
  • Wierd One Here >>>>
  • Delete Links Excel 2000
  • Excel Paste Special Linked Object
  • NOW SOLVED : JWalk's toolbar calculator problem
  • how to get a true date format
  • Conditional Counting
  • A quick general question regarding size of s'sheet
  • Present Value (formula)
  • using notepad with excel
  • NOW()-TODAY()
  • Error when deleting rows.
  • please read in and help (not excel). but still please help!
  • Make Macros available in all workboks that would be opened
  • iteration problem
  • Stop For Each statement at first occurence
  • Moving date by using a code.
  • Text box problem
  • different save name in notepad
  • Input Box - I think???
  • If-Then-Elself Fix
  • Need help with a formula (I think?)
  • Clip board
  • Userform FontStyle
  • keeping 0s after decimal
  • Calculating time between 2 dates DATEDIF Function
  • Chalenge ! Unable to figure out how to do this.
  • Macro sending e-mails
  • Update during sort, calls functions that refer to ranges bei
  • Selecting an unknown area of data
  • need help counting w/multiple conditions
  • Excel 97 Macro
  • Copying Cells
  • Paste Special Excel to Word - Size
  • Macro: Find the row, then copy certain cells in that row
  • VLOOKUP Function
  • 2 Versions Of Excel...
  • Interrogaing tion Data in a Combo Box
  • Max value in macro
  • Using rank in a range that changes
  • Array via VBA to cells
  • delete rows between two specified values
  • Dynamic Summation
  • how to see the Excel Embedded function? (How to write UDF)
  • summing a column of "x"'s
  • Copy & Paste From sheet a (L1) to sheet B (A2)
  • Display in cell not the result of formula in cell
  • BUTTON "O.K."-CANCEL
  • Delete Dupicates in a coulmn
  • STUCK - Need to get a dos prompt
  • re-opening a new workbook