Kirk,
Open your source and destination WBs, then record a macro when you
right-click the WS to be copied Move or Copy Check the "Create a Copy"
box Select the "To book" and "Before sheet" options OK.
See the VBA code generated.

NickHK

"kirkm" wrote in message
...
Is it possible to import a whole sheet from one xls to another,
including the colours, layout and any comments associated with cells?

Thanks - Kirk