find max value in macro

S

Steve

I want to define a constant in my macro to be the maximum value in the range
from c2 to the the last row in column c.
 
Top