Checking if text appears in a cell.If not copy and paste Information.Object Required error

Hi All,

Hopefully you can help me. I have tried writing some VBA and failing quite poorly, before this I had written a filter for the information but now need to get it into another worksheet.

Here is the code I have written, I have no idea where I have gone wrong!

Please Login or Register  to view this content.

Thanks in advance,

Danny

I think you need to use Cells (i,2) and nor Range (i,2). When you have two numbers to referencing a cell you can't use Range.

Regards,
Antonio

Thank you Antonio. That worked perfectly. One more question, how would I make it move onto the next row please? Also how do I set the range for how many rows to go down to?

Regards

Danny

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio