Finding the row where some data sits and deleting it!

Hi thanks for looking at my post.

I'm new to vba programming in excel and am hitting an issue when trying to find a specific row within a sheet and deleting the row.

What I am looking to achieve is to look in the data list and remove the row with "NO WINNER" in. I look in box A3 if 'no winner' is there then that's fine and I'm happy for the thing to progress with the other macros that I have built. However, if A3 does not contain 'NO WINNER' then i need to look in the list which could have 2000 entries and delete that entry/row. This is a bit of polish on a nice tool I have built but it's driving me mad because on my main machine the below works fine but on the machines I'm distributing this on I get a 91 error which is doing my head in and I can't fix it.

I was wondering if there is a neater way for me to achieve my objective which is to find the row with 'NO WINNER' in and remove it.

Any gurus out there who can help a newbie!

Here's my current code

Please Login or Register  to view this content.

Sometimes it's best to specify more of Find's parameters:

Please Login or Register  to view this content.

This is getting there but seems to be deleting all of my data not just the row I'm trying to delete....any suggestions?

in my code it was this that caused my problems 'tRow = FindTitle.Row'

Thanks for the help

I don't understand how that can happen. Have you got any merged cells? Post a workbook.

Dave - if you have concerns about confidentiality, just use dummy data - the actual content shouldn't matter as long as the layout and structure reflect your actual file. Best to keep things on the forum if possible.