Macro for a Border
 

I am working on a spreadsheet, columns A through F with many rows. I would
like to add a thick black border around cells Ax:Fx on any given row.
Actually, my target cell will always be in the A column, so when I click on
the macro to execute it cells a:f in that row will be surrounded by thick
black border.

Thanks gang.

Macro for a Border
 

Sub AddBorder()
Range(Cells(ActiveCell.Row, "A"), Cells(ActiveCell.Row,
"F")).BorderAround _
Weight:=xlThick
End Sub

--
HTH...

Jim Thomlinson


"JSnow" wrote:

I am working on a spreadsheet, columns A through F with many rows. I would
like to add a thick black border around cells Ax:Fx on any given row.
Actually, my target cell will always be in the A column, so when I click on
the macro to execute it cells a:f in that row will be surrounded by thick
black border.

Thanks gang.

Macro for a Border
 

Thanks, Jim.

--
HTH...

Jim Thomlinson


"JSnow" wrote:

I am working on a spreadsheet, columns A through F with many rows. I would
like to add a thick black border around cells Ax:Fx on any given row.
Actually, my target cell will always be in the A column, so when I click on
the macro to execute it cells a:f in that row will be surrounded by thick
black border.

Thanks gang.