Delete a line help

[depcdivr]

I have a macro that opens files within a directory that start with a certain string. Then I clear the contents of one sheet to refresh the data with the macro. After that I switch to a different sheet and I want to clear the contents of only the bottom line. Later in the macro I may be adding more lines and then will replace the cleared line at the end of the macro. Here is the code that I am using.

Set fileNamesCollection = New Collection
        MyFile = Dir(strx & "\*.xlsx", vbDirectory)
        Do While MyFile <> ""
            fileNamesCollection.Add MyFile
            MyFile = Dir
        Loop
    
        For Each MyFile In fileNamesCollection
            
            If Left(MyFile, 5) = "Rep S" Then
                Set wbtemp = Workbooks.Open(strx & "\" & MyFile)
                Sheets("POS Data").Range("A2: N2000 ").ClearContents
                Set wstemp = wbtemp.Worksheets("POS Summary")
                irow = wstemp.Cells(Rows.Count, 1).End(xlUp).Row
                Sheets(wstemp).Range(wstemp.Cells(irow, 1), wstemp.Cells(irow, 160)).ClearContents
            End If
          
        Next

The first part of the code works fine but it gets hung up on

                Sheets(wstemp).Range(wstemp.Cells(irow, 1), wstemp.Cells(irow, 160)).ClearContents

returning a Run-Time error '13' Type Mismatch.

I recently modified the code that was working extending the range from 55 to 160. I ultimately want to delete the whole line or just the contents from column 1 to 160. what am I missing or doing wrong?

 

[MARK858]

Sheets(wstemp) should just be wstemp (although you could just omit it)

 

[depcdivr]

Thats odd. I have run that code many times before and it worked. Made one change to the number and it failed. Your suggestion worked. Thank you

 

[MARK858]

You're welcome.
Sheets(wstemp) can never work like that as wstemp is a worksheet (an object) and Sheets is looking for a number or a string.
Sheets(wstemp.Name) would work (but is over complicating it) but not Sheets(wstemp)