Excel Tutorial
20120724
largest value in range
Sub Largest()
Dim rng As Range
Dim maximum As Double
Set rng Sheet1.Range("A1:Z100")
maximum
Application.WorksheetFunction.Max(rng)
MsgBox maximum
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment