There isn't any difference with a single cell range.

But you could use

Range("A1:A10").Select
Range("A2").Activate

to select A1:A10, with A2 being the activecell.

Using:

Range("A1:A10").Activate

will default to A1 being the activecell.

There is rarely a need to select or activate a range to use it in VBA.

HTH,
Bernie
MS Excel MVP

"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