runtime error

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
I'm getting a runtime 1004 error for the .Borders line. Anybody know why?

Code:
    With rng2
        .BorderAround , xlMedium
        .Borders(xlInsideVertical).Weight = xlMedium
        .Font.Bold = True
    End With
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You code worked for me on a contiguous range on an unprotected sheet (Excel 2000).

What's the address of rng2?
 

Forum statistics

Threads
1,078,082
Messages
5,338,071
Members
399,202
Latest member
Lydiemarie63

Some videos you may like

This Week's Hot Topics

Top