Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the VBA equivilate to Excel worksheet function MAX?
I am trying to do the same thing as =MAX(I2,M2,Q2) would do.
How can I do this? Can I add more values to compare? Thanks, Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the VBA equivilate to Excel worksheet function MAX?
Hi Phil
Sub test() Dim L As Long L = 600 MsgBox Application.Max(3.1415, L, 903.33, -4, 2) End Sub -- HTH. Best wishes Harald Followup to newsgroup only please. "Phillips" wrote in message news:Xd8zb.400557$Tr4.1152293@attbi_s03... I am trying to do the same thing as =MAX(I2,M2,Q2) would do. How can I do this? Can I add more values to compare? Thanks, Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel worksheet function | Excel Worksheet Functions | |||
Excel Worksheet Function | Excel Worksheet Functions | |||
excel worksheet function | Excel Worksheet Functions | |||
Excel If then Else function in Worksheet | Excel Worksheet Functions | |||
Excel worksheet function | Excel Discussion (Misc queries) |