I see, thanks.

Tom Ogilvy wrote:
*Find doesn't produce an error when the item searched for is no
found. Code
that assumes the item will always be found produces the error

cells.Find("ZX2HZ")

doesn't produce an error

cells.Find("ZX2HZ").Activate

produces an error because it assumes the string is found.

--
Regards,
Tom Ogilvy

--
Message posted from http://www.ExcelForum.com