ozmasa
10-31-2016, 06:30 PM
I'm listing some calendar information from Outlook to Excel spreadsheet and I'd like to make borders around each cell in the range, but I don't know how. I can make border around the range...
exlWb.Range("A1:J11).BorderAround LineStyle:=xlContinuous, ColorIndex:=vbRed, Weight:=xlThick
but how to make all the borders, around each cell? Now I have a solution where I have a loop writing a border around each cell in the range, but it is not a very elegant way to do it...
exlWb.Range("A1:J11).BorderAround LineStyle:=xlContinuous, ColorIndex:=vbRed, Weight:=xlThick
but how to make all the borders, around each cell? Now I have a solution where I have a loop writing a border around each cell in the range, but it is not a very elegant way to do it...