Finding the lowest value variable

[AdrianNeal]

I have 5 variables in that stores row numbers, I need to find out which has the lowest value and then put that value into another variable
is there a way to do this without creating a horrible nested IF ELSE .?

 

[Eric W]

Maybe

   MyMin = WorksheetFunction.MIN(v1,v2,v3,v4,v5)

 

[AdrianNeal]

Brilliant, thank you

 

[Eric W]

You're welcome.