Hi Sally.

Another interpretation of your question would be:

dblLocalReturnDiff = Abs(rng4.Offset(l, 0) - rng3.Offset(l, 0))


The first suggestion returns the absolute value of the difference of the
absolute cell values; the latter expression returns the absolute value of
the difference of cell values.


---
Regards,
Norman


"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:uee6XLAoGHA.4728@TK2MSFTNGP03.phx.gbl...
> Hi Sally,
>
> Try:
>
> dblLocalReturnDiff = Abs(Abs(rng4.Offset(l, 0)) _
> - Abs(rng3.Offset(l,
> 0)))
>
> ---
> Regards,
> Norman