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.

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

Cliff Edwards

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