Min Function in excel VBA

[vba317]

I am trying to define a minimum function with a compile error. I was hoping to get some help.

Here is my current code:

Dim LR As Long
Dim MN1 As Long
Dim MNV1 As Long
Dim MNV2 As Double
Dim MXV1 As Long
Dim MXV2 As Double

MNV2 = WorksheetFunction.Min (Range(Cells(MNV1, "D"), Cells(LR, "D")).Address(False, False) & ")

 

[SkipVought]

Hi,

No address...

MNV2 = WorksheetFunction.Min(Range(Cells(MNV1, "D"), Cells(LR, "D"))

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[vba317]

I tried your suggestion. I still get a compile error: Expected: list separator or )

Tom

 

[PHV]

MNV2 = WorksheetFunction.Min(Range(Cells(MNV1, "D"), Cells(LR, "D")))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Just missing a )

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}