Hey i started looking at this today and wasnt sure what is beeing done in the
vlookup, also is there a way for it to see if the sheet is there. Sometime I
dont have both sheets.

Bernie Deitrick wrote:
The line

Set myR1 = Range("A1:Y1")

Should also have the sheet name:

Set myR1 = Sheets("Sheet Name").Range("A1:Y1")

Sorry about that - it will default to the active sheet otherwise....

HTH,
Bernie
MS Excel MVP

Try the macro below.

[quoted text clipped - 106 lines]
:=False, Transpose:=False
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1