help me.. how to set border Preset=None

[yogesh_rathod]

i want to format cells
and setting preset = None (as same appear in Format Cells->Border)


i want to do this stuff programmatically

please any one help me..

Thanks In advance..

[HiArt]

Hi,

if you record a macro and then look at the code, you can often find how Excel does what you are after. Sometimes it's al ittle long-winded, but it gets there. If you record a macro to do this Excel generates the following code:

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

HTH

Art