G
Guest
I have an error when I run this function
"Application.WorksheetFunction.Max(rng)"
because the information in C:C is in TEXT format.
I mean, For example:
In this case "rng" has only integer-numbers in a text format.
Dim rng As Range
Dim MaxUnit2 As Integer
Dim MinUnit2 As Integer
Set rng = Worksheets("Sheet1").Range("C:C")
MaxUnit2 = Application.WorksheetFunction.Max(rng)
MinUnit2 = Application.WorksheetFunction.Min(rng)
Can I use the same function : "Application.WorksheetFunction.Max(...)" TYPE
for this particular case?
Thanks
Coco
"Application.WorksheetFunction.Max(rng)"
because the information in C:C is in TEXT format.
I mean, For example:
In this case "rng" has only integer-numbers in a text format.
Dim rng As Range
Dim MaxUnit2 As Integer
Dim MinUnit2 As Integer
Set rng = Worksheets("Sheet1").Range("C:C")
MaxUnit2 = Application.WorksheetFunction.Max(rng)
MinUnit2 = Application.WorksheetFunction.Min(rng)
Can I use the same function : "Application.WorksheetFunction.Max(...)" TYPE
for this particular case?
Thanks
Coco