Tom,
Thanks!
DataField is just what I was what I wanted to call the highlighted cell.
What you've given me is the way to highlight all of the cells within the
range but my problem is that when I move to the next cell, the previous
cell remains green.
The point of my little sub was to just to have the currently active cell
be green and return to none upon moving to the next cell within my
specific ranges.
Does this make any sense?
TIA
Pete Csiszar P.Eng.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!