Paste Special
 

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

Paste Special
 

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

Paste Special
 

paste special | format | ok



On Apr 10, 3:34*pm, Neil Pearce wrote:
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

Paste Special
 

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

"muddan madhu" wrote:

paste special | format | ok



On Apr 10, 3:34 pm, Neil Pearce wrote:
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