Minimum/Maximum Dates in Range
 

In a range of selected cells, I want to find and store the minimum date in a
variable called MinDate, and the maximum date in a variable called MaxDate.
How do I do that? Thanks!
--
Steve C

Minimum/Maximum Dates in Range
 

On Jun 18, 7:43 am, Steve C wrote:
In a range of selected cells, I want to find and store the minimum date in a
variable called MinDate, and the maximum date in a variable called MaxDate.
How do I do that? Thanks!
--
Steve C

Hello Steve,

You can use the Worksheet Min and Max functions on the dates. In VBA
you can assign the results to your variables like this...

MinDate = ActiveSheet.WorksheetFunction.Min("A1:A10")
MaxDate = ActiveSheet.WorksheetFunction.Max("A1:A10")

Change the range "A1:A10" to whatever you are using. To run this
another Worksheet that isn't the ActiveSheet, replace ActiveSheet
with...

Worksheets(<Sheet Name).WorksheetFuntion.Min("A1:A10")
Worksheets(<Sheet Name).WorksheetFuntion.Max("A1:A10")

Sincerely,
Leith Ross

Minimum/Maximum Dates in Range
 

dim MinDate as date
dim MaxDate as date

mindate = application.min(selection)
maxdate = application.max(selection)



Steve C wrote:

In a range of selected cells, I want to find and store the minimum date in a
variable called MinDate, and the maximum date in a variable called MaxDate.
How do I do that? Thanks!
--
Steve C

--

Dave Peterson

Minimum/Maximum Dates in Range
 

Fabulouso! Thank you both.
--
Steve C


"Dave Peterson" wrote:

dim MinDate as date
dim MaxDate as date

mindate = application.min(selection)
maxdate = application.max(selection)



Steve C wrote:

In a range of selected cells, I want to find and store the minimum date in a
variable called MinDate, and the maximum date in a variable called MaxDate.
How do I do that? Thanks!
--
Steve C

--

Dave Peterson