ScottyBee
07-29-2020, 11:57 AM
Hello,
I am typing in the following code and getting an error "run time 1004 unable to find Max". Any ideas? Thanks
Sub ColorMaximumValue()
Dim rng As Range, cell As Range
Set rng = Range("A1:A5")
Debug.Print Application.WorksheetFunction.Max("rng")
End Sub
26931
I am typing in the following code and getting an error "run time 1004 unable to find Max". Any ideas? Thanks
Sub ColorMaximumValue()
Dim rng As Range, cell As Range
Set rng = Range("A1:A5")
Debug.Print Application.WorksheetFunction.Max("rng")
End Sub
26931