Difference between .Activate and .Select
I think the subtle differences are more in selecting ranges
Range("A1:B9").Select
Range("B5").Activate
makes B5 the active cell in the A1:B9 selection.
--
Regards,
Tom Ogilvy
"JMMach, MCSC" wrote in message
...
Please clear up a bit of fog for me.
When I run:
Sheet04.Activate
Sheet05.Select
both have the same effect; they make the sheet active.
But I'm thinking that there must be, perhaps, a suttle difference between
the two.
Can anyone tell me what the suttle difference might be, and when it would
be
more approriate to use one over the other?
Thanks
TTFN
JMMach
|