Run Time Error 1004

[mtilbury]

If I put the below code into a new Workbook by itself it runs fine. If I use it in my project I get the following error? I don't understand why?


Run-Time Error 1004: Select method of Range class failed.

Dim InputSheet As Worksheet
Set InputSheet = ThisWorkbook.Sheets("Input")
   
    With InputSheet
        .Range(.Cells(2, 10), .Cells(.Cells(.Rows.Count, "A").End(xlUp).Row, 10)).Select
    End With