Simplify code to outline selection

[jacob@thepenpoint]

Hello All

I have a macro which summarizes a data selection in several different ways. Each summary is formatted with a snazzy border around it. My problem is simplifying the code to add the borders, I have gotten rid of the excess that I know how to get rid of but am wondering if there is not some way to get a border around a selection of cells without having all of this:

Please Login or Register  to view this content.

It seems like there should be some way to act on the entire selection at once without doing it edge by edge.

Thanks for your help!

[watersev]

hi Jacob, this should help:

Please Login or Register  to view this content.

[yogananda.muthaiah]

Hi watersev,

how about if boxes inside the given range ("AR5:AV14") i.e Borders

[jacob@thepenpoint]

Thanks Watersev
Works like a champ!