Hi Wei

I am reading through someone else's code, and they seem to use
Sheets("Sheet1").Select where
I would have used Sheets("Sheet1").Activate.
I think I understand the difference between Activate and Select as applied
to cell ranges, but
I was not too sure when applied to sheets.
It was unfamiliar to me and I just wanted to make sure I wasn't missing
somthing.

John


"Wei Lu [MSFT]" wrote in message
...
Hello John,

Yes, if you only have 2 sheets, it is no difference.

Sheets("Sheet1").Activate is the same as clicking on the Sheet1 tab with
the mouse.

What's your problem you are facing?

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.