My phraseology Jim
The intent was to ensure "only cells in one row have been selected"
However I now know how to account for the whole row too :)
Sandy

"Jim Cone" wrote in message
...

Hi Bernie,
That was my intent as Sandy said: "to ensure that only one row has been
selected"
But maybe the intent was... only cells in one row have been selected?
There's a solution out there somewhere. <g
Sincerely,
Jim Cone
Portland, Oregon USA


"Bernie Deitrick"
wrote in message
Jim,
Be careful with that EntireRow since it will extend the range beyond the
initial rRange (possibly).
HTH,
Bernie
MS Excel MVP