When I try to copy the contents and formatting of one worksheet to another the formatting does not transfer with it? I use the 'paste special' function and select 'all' to copy.

Why?

Jim