Using =MAX in a VBA Macro

[cgillett76]

Hello,

I would like to use the following in a VBA macro but cannot get it to work:

=MAX((B9:B31=F9)*ROW(B9:B31))

Any help would be great.

Thanks
Chris

 

[Gary McMaster]

The syntax looks something like the following. Search for "Worsheet Function" in VBA help.

Dim lNum As Long

lNum = Application.WorksheetFunction.Max(ActiveSheet.Range("B9:B31"))

MsgBox lNum

Gary