I’ve been asked if there is a way in VBA for EXCEL to place a heavy border line between every 5 rows in a spreadsheet, and to have the separation lines shift whenever rows are inserted or deleted. I have a way to change the shading using the Rows(i).Interior.ColorIndex property, but I can’t find a property defining the borders. Any help would be greatly appreciated.
A sample of code accoumplishing this would be even more appreciated.
TIA – Phil