Tom:
In your post yesterday, you listed this as a way to do the highlighting.

Range(ActiveCell.End(xlDown),ActiveCell.End(xlTo Right)).Select


Since Cell A10 is the left most cell and since it is blank, this line of
code only highlighted Cells A10..B11 because of the starting cell. Is
there a way to first select this cell and then still do an end down, end
right type code?Again it appears you only get two select command lines
in a row and then the thing resets itself for some reason.

I think the whole problem is that the left most cell in the range is
where the focus of the end to right and the end down type commands move
from.

Bruce

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!