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