Paste Special

[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

 

[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.

 

[muddan madhu]

paste special | format | ok

 

[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