Exclude a range

[YQue]

Hi all,

I'm trying to exclude a range, when copying sheets in a Macro.

a3:ae7 is part of a header, but I can't seem to not copy that range when grabbing my data.

Suggestions are welcome!
Thanks in advance.

JQ

 

[Andrew Poulsom]

If you are copying a sheet everything will be copied. Just delete rows 3 to 7 after the sheet copy.

 

[YQue]

I know how to copy from copy-and-paste.
I developed a Macro that opens 100+ workbooks and copys the information to one master workbook. However each source worksheet has header information that I would like to exclude. The range I designated is the a3:ae7 indicated before.

Thanks

 

[Andrew Poulsom]

So what code are you using to perform the copy/paste? Can't you exclude the headers from the copy range?