ignore the rows of data that do not meet criteria and then put next result on next row

Hello I have a line of code

Please Login or Register  to view this content.

I want to do something like

Please Login or Register  to view this content.

however I get a error 424

What i am trying to do is copy the data from .range("D" & r & ":J" & r).value there will be some gaps in the rows from this data as some will not meet the criteria

On Sheet("Play") i want the data but without the blank rows. blank rows are the rows that the data does not match the criteria

Is that possible ?


Thank you or any help provided

Is this what you wanted?

Please Login or Register  to view this content.