Paste Special

N

Neil Pearce

Hi all,

Under the paste special option there is a option to past "all except
borders". is there a way to only paste the borders and nothing else?


Cheers,

Neil
 
T

tedmi

Doesn't appear to be such a possibility. The closest if Paste Formats, but
that grings over the content formatting (number, date, etc.) and background
fill.
 
N

Neil Pearce

Sounds like I'll have create a Macro that copies and 'special pastes: format
only' the selected area, and then reset the format of the selected area back
to the required state.

Thanking-you for the help chaps.


Cheers,

Neil
 
Top