Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concise border removal method
Hello, I am using Office 2003 on Windows XP.
I am trying to come up with a concise way of removing all borders from a range of cells. Something like the following, but this generates an error: [C6..E10].BorderAround LineStyle:=xlLineStyleNone I'd really rather not have to individually set every single border to none. But, is that the only way? Could someone please post an easier method? Thanks much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concise border removal method
Range("E6:C10").Borders.LineStyle = xlLineStyleNone
-- HTH... Jim Thomlinson "XP" wrote: Hello, I am using Office 2003 on Windows XP. I am trying to come up with a concise way of removing all borders from a range of cells. Something like the following, but this generates an error: [C6..E10].BorderAround LineStyle:=xlLineStyleNone I'd really rather not have to individually set every single border to none. But, is that the only way? Could someone please post an easier method? Thanks much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
Make instructions clear, concise and in plain english. | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) |