Copy and Unknown range After autofilter.

[mattd4385]

All the data is in col A to F. I filter this data using auto filter in the macro.

The length of the data will change
after being filter is could be 0 rows to a few 100 rows.

Also the first row has a header that i Do Not want to copy.

How can i select this data so that it can be copied?

 

[Trevor G]

Matt there is no need to start a new thread you should stick with the first.

http://www.mrexcel.com/forum/showthread.php?t=567925

Did you try my code idea and what was the result...