examine cell, over write value

[Tom_B]

Hi,

I'd like to examine the value of a cell, check that it is between 0 & 7.6 and if it's over 7.6 overwrite the value with 7.6.

Thanks in advance

Tom

[jraj1106]

Hi Tom.

You try this macro code:

Please Login or Register  to view this content.

[Tom_B]

Thanks,
Just remembered I had asked here.
All good