If your macro does the same thing as edit|Move or copy sheet, then you should be
seeing the headers, too.

But it sounds like you're copying some of the cells--not all. Maybe you can
amend the macro to include those header rows???

You may want to post that portion of the code that does the copying.

Greegan wrote:

How would I have the Header copied over when I copy the worksheet I've
selected - but in a macro?

I have it now so I click a menu button that's linked to the macro which
copies the worksheet and has very few issues showing up, except the header
is not copying over.

I understand this is how its supposed to happen, but outside of recording a
macro where I'm copying info from one sheet's Header to the other I don't
know what else I can do. Can anyone assist me with this?

Thanks in advance

G

--

Dave Peterson