| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy all of excel file including header
I am trying to copy a excel file. when i copy and paste my header and footer
is not there. can you help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I copy all of excel file including header
Right-click on the sheet tab. "Move or Copy...".
1) Be sure to check "Copy" on the dialog 2) Note that one of the options is to copy/move to a different, or even new, workbook. (Headers & Footers are also copied) In VBA: Use the Worksheet.Copy method (no Pasting). See Help. HTH, -- George Nicholson Remove 'Junk' from return address. "Donna" wrote in message ... I am trying to copy a excel file. when i copy and paste my header and footer is not there. can you help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I copy header & Footer into new file? | Excel Discussion (Misc queries) | |||
| Copy an excel sheet from one file to another including formulas | Excel Discussion (Misc queries) | |||
| How do I copy the print settings, including header and footer fro. | Excel Discussion (Misc queries) | |||
| Including Spreadsheet Date in a header | Excel Programming | |||
| Can't Get data without including Header using ADO | Excel Programming | |||
Linear Mode
