Solved: difference between activate and select

[philfer]

Hi,

I am working on a spreadsheet that already has a macro in it that a previous mush more experienced developer wrote.

In it he uses :-

Sheets("Sheet1").Activate
Sheets("Sheet1").Select

Why does he need both?
Can anyone tell me why he did this?
And what the difference is between the two?

Cheers
Phil

[Bob Phillips]

He doesn't, they are equivalent. I tend to use ACtivate on sheets, Select on a range, but that is just my style.