Calling all experts on this one. Attached is a workbook that contains three different tables on the worksheet. The number of rows these tables could contain could vary from month to month. As a result, I continuously need to manually remove and reapply the appropriate horizontal borders.
I’d like to be able to do this automatically with a macro. Here’s what it would need to do:
1. For all rows in Table1, select each cell in column C and apply a thin border (xlThin) to range C:J, L, and N:P that do NOT have a medium border (xlMedium).
2. For all rows Table2 and TableZ, select each cell in column B and apply a thin border (xlThin) to range B:J, L, and N:P that do NOT have a medium border (xlMedium).
The ‘AfterUpdate’ worksheet in the attached file shows what the expected result would look like. Any help on this matter would be greatly appreciated.
Here's a link that get's me very close, but still doesn't quite meet my needs: http://www.vbaexpress.com/kb/getarticle.php?kb_id=499