Hi Rocket0612,

Try changing:

Claimno = Range(MyRow, 11)

to

Claimno = Cells(MyRow, 11).Value


---
Regards,
Norman



"rocket0612" wrote
in message ...

Can anyone see a problem with this:


Code:
--------------------
Sheets("Sheet1").Activate
Set MySheet = ActiveSheet

MyRow = Sheets("Sheet1").Range("O1")
Claimno = Range(MyRow, 11)
--------------------


It keeps erroring on the last line. I'm trying to get it to find the
last value entered on spreadsheet. Range O1 shows the Row to look for
and is correctly showing the Row to be used.

thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile:
http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=380551