Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create an outside border using vba
Hello,
Does anyone know how to use visual basic to create an outside border on a block of cells? An outside border is when only the perimiter of the block is bordered rather than haveing a border on each individual cell. thanks, Rex |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create an outside border using vba
turn on the macro-recorder then do one block of cell manually...that way
you'll see the required code. All you'll need to do is make a few minor changes for your own ranges. -- Patrick Molloy Microsoft Excel MVP ---------------------------------- "Rex Huston" wrote in message ... Hello, Does anyone know how to use visual basic to create an outside border on a block of cells? An outside border is when only the perimiter of the block is bordered rather than haveing a border on each individual cell. thanks, Rex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create new border style? | Excel Discussion (Misc queries) | |||
create a thin border around the selected cells | New Users to Excel | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
How do you create a page border in Excel? | Excel Discussion (Misc queries) | |||
How to create thin cell border | Excel Discussion (Misc queries) |