Re: VB to Return the Absolute Value (Excel 97 SR2 VB )

Thanks Rory!! Do you know how long I've been looking for a way to test for an amount between two points with a formula. It's easy to do via conditional formatting but to simulate that with an expression has been frustrating to say the least.