HIGHLIGHTING ROWS & COLUMNS
Tom,
I think it only selects the row and column of the activecell, not the whole
sheet (at least it does with me, and it seems to be what Bill is suggesting
will happen).
Regards
Bob
"Tom Ogilvy" wrote in message
...
Since this
Range(sCol & ":" & sCol & "," & sRow & ":" & sRow).Select
Selects the entire sheet, it would be easier to just do
cells.Select
--
Regards,
Tom Ogilvy
"Wild Bill" wrote in message
...
Thanks for the augmentation. Clever alpha parse there :) But I'll go
on a limb and say that
Range(sCol & ":" & sCol & "," & sRow & ":" & sRow).Select
is only one operation, and saves a call to Union besides <g
The IV and 65536 were only to illustrate that he could substitute a
limited range, as I indicated. And his "grid" may not start in A1, so
he may need a tad of work coming up with the substitutions.
|