Highlight cells in column of found text string - Rework

In a previous post, my request was provided and implemented, thus labeled "Solved".
http://www.excelforum.com/showthread...t=#post4187076

Not sure why, but now I'm getting unwanted results.

Goal: Highlight, with yellow, the cells in the column with the column heading "ACCT #" - below the label and not above it, nor in an area outside of the pertinent data table.

Attached is an xlsx showing the BAD results of the code and with the two areas that are being highlighted but not desired. Then one showing Good results of the highlighting. I do see one difference being that the cells above "ACCT #" are empty in this one, but need it to work if there is data above the Column label as in the bad highlight example, if possible.

Here is the section of code that does the work:

Please Login or Register  to view this content.

This is indeed part of a larger module and I can insert that also, but there is a lot to weed through that shouldn't be impacting this.

Let me know where I need to clarify in this request.

Thank you,
Delain

Thanks for your interest in this.

I don't understand

. . .they cannot (wont) contain VBA. Excel must have it's settings updated to allow VBA . . .

But then you're asking me if I uploaded a file with the VBA code contained in the file. I'm confused on that point.

The sheet I attached does not contain any code; it shows the needed result, after the code runs, except for the areas I don't want highlighted. The code resides in my personal.xlsm file where 95% of my code lives. I run this particular code from a macro button on the Ribbon.
I inserted the code, in my post, that does the highlighting and mentioned that I could insert the larger module if someone really thought it was critical.

CF, of course is a good thought, but I'm not using CF in this instance as I don't want it active in all of these worksheets. The highlighting is a special application after a copy of my worksheet is copied out of the primary workbook, given a new name, and the highlighting covers the accounts I am directing a team of assistants to deal with.
Works great, except in instances where there is text/data in the cells above the column header as shown in the original post.

Help me understand how I could have made my original request more clear as I don't want to confuse this process.

Thank you,
Delain

Exactly what I needed; beautiful!

One of my biggest weaknesses with Excel VBA, regarding basics that I should know by now, is coding Range areas for Selecting and applying actions, formats, extracting data, etc..
I have read various articles and how-to's across the Internet. But, do you have a recommendation for a good source to learn this from?
My VBA understanding is cobbled ( I call it.) from deciphering code like yours and others, along with the how-to explanations. Needing to maintain production with my job is a tough balance with being able to invest more time in taking a course or such.

Thanks for your help. Seemed no one else wanted to touch this one.

Delain

Good thought.