Hi,

I'm making a VBA application that will be used on both Windows XP (Office 2003) and Windows 7 (Office 2010).

I tested the application on multiple machines (with multiple users), and it works perfectly on Windows XP.

When tested on a Windows 7 machine, I get an error when it formats the borders on the sheet...

What makes it even more eccentric fact that xlEdgeTop works, while xlEdgeBottom doesn't.


        

with sheet5

'...... irrelevant code omitted ........

    'this line of code, and other lines similar to it, does work in both W7/2010 and WXP/2003.
        .Rows(Range("S06F050").Row & ":" & _
            Range("S06F050").Row).Borders(xlEdgeTop).LineStyle = xlContinuous
            
   'this line of code, adn other lines similar to it, does NOT work in W7/2010, but does work in WXP/2003.
        .Rows(Range("S06F050").Row & ":" & _
            Range("S06F050").Row).Borders(xlEdgeBottom).LineStyle = xlContinuous

'...... irrelevant code omitted ........

end with

Thank you for your assistance,

- Shane