Assuming you're intending to find the last row, column K (the 11th
column):

Claimno = Cells(MyRow, 11).Value

If not, what do you intend "11" to mean?


In article ,
rocket0612
wrote:

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