Is there a way of comparing two values in VBA and taking the greater absolute value whilst preserving the sign?

Cheers

B