Give this a whirl...

sub test
Range("A1:B50").Borders.LineStyle = xlNone
end sub
--
HTH...

Jim Thomlinson


"Finance Guru" wrote:

Hi All,

I know how to clear the contents of cells in a macro,ie.
Range("A1:B50").ClearContents - however can anyone tell me what needs to be
included in a macro to clear "Borders" created around cells for a given range.

I am just getting into creating macros - so if the above is not clear,please
let me know.
Thank you