Finding the max of a range where numbers are stored as text using VBA

[PC_Meister]

Hello,

I am wondering if there is a way to find the max of a range using VBA, I have thought of using the "max" worksheet function, but the problem is I have a range where the numbers are stored as text. I could convert the text to numbers and then run the max function but I would like to keep them stored as text. Any ideas?

Thanks

 

[Rick Rothstein]

I am wondering if there is a way to find the max of a range using VBA, I have thought of using the "max" worksheet function, but the problem is I have a range where the numbers are stored as text.

Try it this way...

MaxVal = Evaluate("MAX(0+A1:A100)")

Change the range to suite your needs.

 

[PC_Meister]

Try it this way...

MaxVal = Evaluate("MAX(0+A1:A100)")

Change the range to suite your needs.

Thx Rick, but I am looking for a VBA solution if possible.

 

[Rick Rothstein]

Thx Rick, but I am looking for a VBA solution if possible.

That is a VBA solution... MaxVal is an assumed variable name (you did not actually tell us what variable to assign the max value to, so I made up a name) and the value from the Evaluate function is being assigned to it.

 

[PC_Meister]

oops you are right, got it now!