Range("A1:B9").Select
Range("A2").Activate
Results is A1:B9 is selected and A2 is the active cell
Range("A1:B9").Select
Range("A2").Select
Results is A2 is the single cell selected (and is the active cell).
If A2 is not in the current selection then
Range("A2").Select
Range("A2").Activate
are the same.
as are
Range("A1:B9").Select
Range("A1:B9").Activate
--
Regards,
Tom Ogilvy
"Darlajane" wrote in message
...
Hi,
Perhaps a silly question but I was just wondering what is the
difference between something like:
range("A2").select
and
range("A2").activate
?
And in what situations would you want to use either one?
Thanks for your help
Helen
--
Darlajane
------------------------------------------------------------------------
Darlajane's Profile:
http://www.excelforum.com/member.php...o&userid=15326
View this thread: http://www.excelforum.com/showthread...hreadid=277730