Odd Border Error

[Brian]

I have been trying to figure out this issue on my own for a while, but can't
figure it out. I have created a macro which draws borders on currently
selected cells. The macro works perfectly 95% of the time. On certain files,
I get a runtime error 1004 : "Unable to set the LineStyle Property." The
sheet is not protected, and cells are not locked. If I select different cells
in the same sheet, I can get it to work just fine. It only happens with
specific cells. In addition to the macro not working, I cannot get the format
cells dialog box to open for the cells that are affected, but the format
cells dialog box opens just fine on other cells. Additionally, I have checked
to make sure it is not an issue with having InsideVertical or
InsideHorizontal. My issue occurred on a 3 x 3 selection.

Anybody have any ideas on what my issue could be?

Additional info:
I am running XP with Office 2007 SP1. The problem files come from a coworker
with a previous version of excel.

 

[DennyThury]

I too have encountered this exact same error(s) a VBA macro on one of my
spreadsheets!

Today, I openned a spreadsheet that was last accessed with Excel 2003 . The
VBA macro(s) worked just fine there, but now on Excel 2007 this is occurring,
and I'm stuck!

I'm running Office Professional 2007 SP1 Any resolution found?? Any help??

Denny