fixing run time error 91 object variable or with block variable not set

[ABDELFATTA]

hello
i need help fixing this code i try copy data from sheet to another based on criteria
the error in this line

thanks

[sintek]

Other than changing:

rngC.Offset(, -6) '! 6 to 5

And

Please Login or Register  to view this content.

your code works...Not sure why you are looking for last column in loop if you are only copying A to F

Please Login or Register  to view this content.

Another option...

Please Login or Register  to view this content.

[davesexcel]

If you are in column F, you can't offset(,-6) columns, that will take you off the sheet.
Try it, select F1 and then move to the left 6 times.

[sintek]

Also...that code does not produce that error?

[ABDELFATTA]

thanks daves for your notice

[ABDELFATTA]

thanks sintek you give me verity codes are great and for correcting my code works so well but i have two thing if is possible whether my code or your i don't copy repeatedly data just if i have a new data then copy to bottom old data and how i can delete the copied data from source sheet"data"

[sintek]

Please Login or Register  to view this content.

If you really want to loop then....

Please Login or Register  to view this content.

[ABDELFATTA]

well done ! sintek thanks for your time

[sintek]

All good...