Is there a quick way to set a border around every cell in a range?
I have a macro that is producing various data onto a number of worksheets. All the cells should have a border around them. I know I can use something like
ActiveCell.BorderAround Weight:=xlMedium, ColorIndex:=xlAutomatic
for each cell but this seems long and laborious. Is there some kind of for each loop such as - for each cell in a selected range set BorderAround. Alternatively is there a way to select a range and then withoe command format all the cells with border around?
Any advice is greatly appreciated
I have a macro that is producing various data onto a number of worksheets. All the cells should have a border around them. I know I can use something like
ActiveCell.BorderAround Weight:=xlMedium, ColorIndex:=xlAutomatic
for each cell but this seems long and laborious. Is there some kind of for each loop such as - for each cell in a selected range set BorderAround. Alternatively is there a way to select a range and then withoe command format all the cells with border around?
Any advice is greatly appreciated