I'm still grappling with a code for deleting an entire row from a sheet. I'm
getting nowhere so I was hoping someone could start me on the right track
with a sample code here's the details:

On Sheet 1, Cell A1 is a 5 Digit number I want to lookup on Sheet 2, Range
A2:A1000 and then delete the entire row corresponding to the number.

Cheers
gregorK