..Address will return a string.

It really depends on what you want and how you declared rngStart.

dim rngStart as range
set rngstart = c.offset(1,0)
msgbox rngstart.address

or

dim RngStart as string
rngstart = c.offset(1,0).Address

How did you declare that rngStart variable?

green fox wrote:
>
> Thanks Dave,
>
> Even with the changes rngStart returns the value when the condition is
> met. I've tried using
>
> Set rngStart = c.Offset(1,0).Address
>
> but I get a type mismatch error.
>
> Do you think I would be better off assigning names to the cells, then
> using those to delineate the range?
>
> Andy

--

Dave Peterson