EDIT: ok, saw your update...it works. Thanks again.

One, last question.

Let's say I have a series of sheets and Sheet2C refers to Sheet1A &
Sheet2B, Sheet3C refers to Sheet2A & Sheet3C. Is there anyway to make
it a continuous macro always referring back the the previous sheet for
column A, or would I have to repaste a modified code for each new sheet
added?

Thanks for all the help.


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=567563