Compile Error when using standard Excel functions in VBA

[jcher1979]

Hi,

When I include standard functions (for example "MIN") in my own VBA function (located within a module) i get the compile error "Sub or Function not defined".

Anyone know why i'm having problems using the standard functions in my code?

Thanks.

 

[Norie]

You need to use WorksheetFunction to access the worksheets function.

Can you post your code?

Msgbox Application.WorksheetFunction.Min(Range("A1:A10"))

 

[jcher1979]

This is exactly what i was looking for, thanks!