Sort of range leaves range "selected"
Not sure if this would help, but you could just add one line at the end of
your sort code to select one cell of your choice, for example:
[A2].Select
Hope this helps.
"Mike Jamesson" wrote:
I have a dozen or so worksheets with the same template, and my code does a
sort on a range within each sheet. After the sort, tho, the range is still
"highlighted", as if I had selected the range (which I didn't, not with
"select", at least), i.e., it's shaded just as if I had clicked on the upper
left cell of the range and dragged down to the lower right. I would like the
range to remain visually unaltered, but I can't figure out how.
Thanks in advance
Mike J
|