Hi TK,
Yes, you can use the built-in worksheet function MAX from VBA:
Sub test()
Dim l1 As Long
Dim l2 As Long
Dim l3 As Long
l1 = 1
l2 = 2
l3 = 3
MsgBox Application.WorksheetFunction.Max(l1, l2, l3)
End Sub
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Tommi wrote:
Hello!
Is there a convenient way to check in VBA, which of my 5 Long-type
variables is biggest?
-TK