LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Greegan
 
Posts: n/a
Default Copy worksheet question

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet question Anthony Excel Discussion (Misc queries) 2 July 8th 05 10:10 PM
how do i copy the format of a cell from one worksheet to another Edith F Excel Discussion (Misc queries) 5 June 16th 05 09:17 PM
Change position of move or copy worksheet option in Excel JesseAviles Excel Discussion (Misc queries) 1 February 22nd 05 10:25 PM
copy worksheet (keeping formats) Ken New Users to Excel 3 February 16th 05 04:37 PM
How do I copy a cell (content AND format) from one worksheet to a. Excel Format Copy Excel Worksheet Functions 1 February 9th 05 10:34 PM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"