Try, instead,:

MSGBOX(myRange.Address)
--
Gary's Student


"davegb" wrote:

One of the things I have the most trouble with in VBA is figuring out
when I'm working with a range, if the range I want to be selected is
the correct one. Doing a watch doesn't help. Is the best way simply to
put in a temporary "range.select" and see if it's the correct one, or
is there a better way?

Thanks again!