Hello I have a line of code
I want to do something likePlease Login or Register to view this content.
however I get a error 424Please Login or Register to view this content.
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
Bookmarks