R,

I emailed it to you. Let me know what you come up with. Getting an
error on the line "cells.find(num).activate" because for some of the
values there is nothing to activate because it does not exist on the
"Rows" worksheet. I get an "object variable" error. Thanks for the
input.

Mjack


--
mjack003
------------------------------------------------------------------------
mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141
View this thread: http://www.excelforum.com/showthread...hreadid=468422