Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Daisy Brown   on Dec 25 In MS Office Category.

  
Question Answered By: Myrtle Wilson   on Dec 25

Okay, after a bit more tinkering, I think i know what's happening,
but i've no idea why or how to correct it.

Application.WorksheetFunction.Max or Application.WorksheetFunction.
Min seem to be evaluating the entire named  range but are returning
the value of the first cell in the range  not the value of the cell
that corresponds to the actual max  or min. Don't know if this sheds
any light on what's happening.

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Extracting dates from named range Or get search suggestion and latest updates.


Tagged: