Excel - Visual Basic

[rambob]

I'm trying to use the EXCEL function, MIN in a macro. I use the exact syntax from HELP but it still errs. The syntax I'm using is,

myValue = MIN(B59:B71)

The error I get is, "Compile Error, Expected: list separator or )".

Can anybody help?

 

[acron]

What you are using is the Syntax for the function as used in a worksheet.

The correct VBA syntax is :

myValue = Application.WorksheetFunction.Min(Range("B1:B71&quot)

Tahnkfully than can be abreviated using a shortcut for the evaluate method :

myValue = [Min(B1:B40)]

A.C.

 

[acron]

What you are using is the Syntax for the function as used in a worksheet.

The correct VBA syntax is :

myValue = Application.WorksheetFunction.Min(Range("B1:B71&quot)

Tahnkfully than can be abreviated using a shortcut for the evaluate method :

myValue = [Min(B1:B71)]

A.C.

 

[rambob]

Acron,

Thanks very much...that worked like a charm!