I'm betting that you got an error on one of these two lines:

Set wks1 = Worksheets("Sheet1")
Set wks2 = Worksheets("Sheet2")

In my test workbook, my worksheets were named Sheet1 and sheet2.

What are your sheet names?

Put those names in that code.


CatherineN wrote:

no luck and if i had ANY idea what i was doing, maybe I
could attempt to make a minor change to make it work... it says it is
out of range but I dont have any idea what that means. Thanks for the
help though

--
CatherineN
------------------------------------------------------------------------
CatherineN's Profile: http://www.excelforum.com/member.php...o&userid=35469
View this thread: http://www.excelforum.com/showthread...hreadid=552479

--

Dave Peterson