Hi Norman -

Thanks for the follow-up. Yes, I see that Bob's approach properly limits
the highlights to the rows in the data range. It also highlights the entire
worksheet row which is fine, but I thought I'd offer the OP an alternative
that also limits the highlighting to the columns in the data range.

Regarding your concern, I opted for the UsedRange object to improve
portability (the procedure is independent of data location). Based on
standard design assumptions (no superfluous data outside the data range - as
in Bobs example), Ive found the procedure to be reliable in testing.

My testing may have missed something or you may have something more specific
(or a generality) in mind; if so, let us know.

---
Thanks for the review and discussion,
Jay


"Norman Jones" wrote:

Hi Jay,

Here is a second version that highlights the data range only:

Did you note that Bob's code restricts operation to
the data range of interest.

Feasibly, your use of the UsedRange property may
be less reliable in this respect.


---
Regards,
Norman