Apply Border to Main Area - Hiccup

This code is working great, as needed, except on one of my workbook sheets. I cannot figure out what the difference in the two sheets is which is causing the code to apply the border incorrectly.

In the attached file, there are two different layouts: Main Page(?) and Adjustments(?)
The code works great on Main Page, but is bordering the wrong area on Adjustments. It uses the row/columns where two text strings are found as markers for the Range'ing part of the code since other workbooks will not have the same exact layout but will have those same labels.

Please Login or Register  to view this content.

I've toggled back 'n forth many times between the two layouts and can't pickup on the difference which is causing the code to border the wrong area on Adjustments.

I've input some zeroes (highlighted) into a few of the far-right column cells so you can watch the code work.
On Main Page, you will see the border applied to the correct COMPARABLES area. On Adjustments, the border ends up bounding the first row and the row with "COMPARABLES" in the first column cell.
Main Page is correct.

What am I not seeing?

Thank you,
Delain

Huh, my attachment attempt didn't attach; didn't notice till you mentioned. On the preview it was there.

Yes, you are right. There seems to be a bug on my code. I need to look at it. Right now, I am in a middle of a footie.

Try this one and let me know.

Please Login or Register  to view this content.

Holy cow! A couple of misplaced periods(.)???!!! That's the difference in the code??
How was it even able to run with such a slight difference? I've got so much to learn on the Range'ing code. I just don't get it.
Seems to have fixed the problem.

(I messed up with the attachment and description of the post. I presumed the row deleting part of my larger code that you helped me with, yet didn't include it for others who might have stumbled into this post. Didn't need it since that Sub Calls the Border_Apply Sub.)

Footie?

Thank you,
Delain

Delain,
I need to look at it again. Please let me know if the code fails again.
It is the European semi-final and the referee just given a penalty to France ( You call it soccer).

Good, cause I'd like to understand the difference, when you have time.

Also, seems something needs to be changed in the other code posting from #7 in:http://www.excelforum.com/showthread...t=#post4426709

It's not working with the Adjustments sheet either.

Later.

Thank you,
Delain

You already know, the dots are messing up the code, but I need to do lots of test. For now, try

Please Login or Register  to view this content.

Delain,

Okay, Try this one

WW, not sure I can see the difference with your suggested code from what I had. However, your code is giving the same bad result on the Adjustments sheet but good result on the Main Page sheet.
See attached wkbk for your result versus what is needed.

AB33, did you determine what the difference with the two sheets is which your new code addresses?
The new code works on the Adjustment sheet as needed; along with, the Main Page as the original code was already doing.

Thanks for the great help.

Delain

Now, we can call it a beautiful thing! From what I can tell, as far as coding, it is exactly the same as AB33's and gives the same and needed result.

I would still appreciate some insight as to why the original would work fine on the one sheet but not on both. Their layouts are very similar.

Thank you,
Delain