how to create an outside border using vba

R

Rex Huston

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
 
P

Patrick Molloy

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.
 
Top