VBA - maximum and minimum extraction

[luv2glyd]

I'd like to have a macro that looks at 2 or 3 cells in a spreadsheet and simply extracts their max or min, with the least amount of code such as this:

Please Login or Register  to view this content.

How can this be done?

Thanks

[Ron Coderre]

Not sure exactly what you're looking for.

Here's something to play with:

Please Login or Register  to view this content.

Can you work with that?

[luv2glyd]

yes - exactly what I need. Thank you

[shg]

Please Login or Register  to view this content.

.. is equivalent to

Please Login or Register  to view this content.

I think Ron meant

Please Login or Register  to view this content.

[Ron Coderre]

Shg, thanks so much for catching that error!
I'd only tested it on a blank sheet with values in those two cells.
Didn't even notice the code referenced the entire range.