'set rng = selection
rng.Borders.LineStyle = xlNone

Regards,
Peter T

"Peter Rooney" wrote in message
...
Rowan,

What's the quickest way to remove ALL border formatting from a range i.e.
top right, left, buttom, inside horizontal and vertical and diagonals?

Cheers

Pete
<snip