Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Finding the maximum value in a range
Sub ShowMax()
    Dim TheMax As Double
    TheMax = WorksheetFunction.Max(range("A1:C3"))
    MsgBox TheMax
End Sub