Apply Border to Main Area

User needs code to apply Thick Border to outline the COMPARABLES area of this sheet.

Border already exists as needed on three sides in attached sample, but may not always be there and columns/row addresses may change. So, need code that will find the area and apply Thick Border Outline.
In attached file, it would be A15:M28 area.

Thank you,
Delain

Thanks for the quick reply; however, as stated in OP, this is not a static address. It will be a different size range, consisting of varying rows.

As accomplished in a couple of other similar applications, I can suggest using the label "COMPARABLES" as a reliable landmark for targeting the area needed; along with selecting/applying over to the far-right column and last used row of this area (without including the Notes below).

Thank you,
Delain

Try the attached.

Beautiful . . . . again!!
Tweaked it just a tad to loosen its use.
Including here for reference:

Please Login or Register  to view this content.

Thank you for the great help,
Delain

AB33,

One other thought.
What can we change in the code shown in #5 that could eliminate the FIND ("INDICATED VALUE PER") step?

Instead of using that as our far-right landmark, can we simply have it seek .End(xlRight) from the COMPARABLES column, somehow? I'm not sure how to implement.

Thank you,
Delain

Seems to work fine. May be some instances we can use without the other specified column label.

Thank you,
Delain