PDA

View Full Version : Solved: difference between activate and select



philfer
02-06-2008, 12:23 PM
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
02-06-2008, 01:11 PM
He doesn't, they are equivalent. I tend to use ACtivate on sheets, Select on a range, but that is just my style.