Basic syntax ?

[David]

What is the difference between these?

Worksheets("Sheet1").Select
Worksheets("Sheet1").Activate

Interested in knowing what impact either would have in a macro.

 

[pfsardella]

Chip Pearson provides a good answer in the following thread.

http://www.google.com/groups?hl=en&...&c2coff=1&safe=off&th=70c09581f0dddcd3&rnum=1

HTH
Paul

 

[David]

David wrote

Chip Pearson provides a good answer in the following thread.

Ah, shoulda Googled first. Thanks.