Discussion Locked

Changing Borders in VBA for EXCEL

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

This discussion is closed to new replies.