VBA Error Message - Runtime Error 424 Object Required

Hello,
I’m trying to modify the below code that I found to suit what I’m trying to do but it’s not working. Basically, I have a tab called Input and another tab called Lead. I want to be able to run this macro and if the text that is entered in cell D9 on the Input tab is found on the Lead tab, then the cell should be deleted from the Lead tab and shifted up. There is named range on the Lead tab called “LeadsList”.
The following line gets highlighted when I run the code and I get error message:

Set xlRange = xlSamplesheet.Range("LeadsList" & iLastRow)

Error Message – Runtime error 424 Object Required

Please Login or Register  to view this content.

Thanks!