insert borders to a range that will change each time macro runs
Posted on 2014-10-15
I have been using the below code to insert borders but I need a varaition to this:
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
What I need to do is insert to the range I select, so if I say
and the range is B3:J15 I just want borders around those cells
if range is B3:J58 I want borders around those cells.
I have tried to change ......With ActiveSheet.UsedRange.Borders
but have not been successful.
Could an Expert assist me please.