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