Error LineStyle
 

Recorded a macro (in Excel 97) that places border around each selected cell.
But when I run that macro I get err 1004 "Unable to set the LineStyle
property of the Border class".

It's fine if I delete references that try to change xlInsideVertical or
xlInsideHorizontal, but I need to apply a complete border to the four sides
of each cell.

Thank you for any help.

Error LineStyle
 

If you're still having this issue, please post your code.

Cliff Edwards

Error LineStyle
 

Thanks, Ward. I seem to have 'fixed' it. The problem was in whether a cell or
a range of cells were selected. "On Error Resume Next" gets around it.
literally.

"ward376" wrote:

If you're still having this issue, please post your code.

Cliff Edwards