Assuming the values are numeric:

myVal = Application.Max(range("A1"),range("B9"))

--
Regards,
Tom Ogilvy


"msubks" wrote:

I'm trying to generate a value equal to that of the greater value of 2
compare cells, any way to do this with an If statement. I have only been able
to generate "true" or False values.