VBA defining range based on value

[Homegrownandy]

Appreciate that.

[JoeM]

I am not seeing any problems. It returned 28 for me.
Let's try qualifying the sheet name. I realize that your sheet name may change, but just test it with this. If it is on the wrong file or sheet, it should give you errors. That will tell us that the macro is not running where your think it is.

    lastRow = Sheets("UUTS_17300130").Cells(Rows.Count, "A").End(xlUp).Row
    MsgBox lastRow

[Homegrownandy]

It does give 28 with that code. #ill do some testing.