Macro - Clear Borders
 

@ Gary's Student
@ Jim Thomlinson
@ Gord Dibben

Hi Guys - I have tried them out and they work - thankyou all. The diagonals
is a step too far for me,but I will file it away somewhere .. some day to
called upon in the fullness of time.

FG

"Gary''s Student" wrote:

Select a range and:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/21/2007 by James Ravenswood
'

'
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
End Sub

--
Gary''s Student - gsnu200758


"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