On Tue, 16 Feb 2010 08:24:01 -0800, Jim Peterson
wrote:

Thanks Ron for the help. Your second suggestion works fine. (Due to
circumstances, I do have to look at the cell above (a6) each time and not the
originating cell (B5 in this case).

Jim

Glad to help. Thanks for the feedback.
--ron