Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

Find Min & Max VBA

Hello,

I have a set of numbers in column B like below:
43
432342
432
342
34234324
534
432
3
443
543
432
4453
34
323243


I need the best way via VBA to find the Maximum and minimum of this set? How to do it?

Thanks
Avatar of Rayne
Rayne
Flag of United States of America image

ASKER

Also, all the numbers in that set, will be of same number of digits, just different

thanks
SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

Thanks everyone :) for your excellent help. I badly needed this

R
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2012