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

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