Error LineStyle

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

1004 Error: Unable to set the LineStyle property of the Border class 1
Removing Border lines and colour for All sheets 3
VBA set thick borders around non empty cells in range 0
Recorded macro fails after save, close, then reopen 7
Border Macros 5
Problem setting BorderArround LineStyle:=xlLineStyleNone 3
Border around range working -Border for cells within range not wor 3
"Unable to set the LineStyle property of the border class" 4

Top