Forum rules require VBA code to be wrapped in code tags.

Please edit your post to add the tags.

[code]
your code here
[/code]

Why not apply an auto filter to the column and copy all of the visible rows in one go?