Hi Bob,

I tried that previously and got a error. When i changed it to -- select --
it worked. So, I thought that may be sheets can only be selected.
I tried with -- Activate -- now and its working perfectly fine. (Dunno why I
had the problem in the first place.)

You can activate a sheet as well.
Anyway, then whats the difference between select and activate? Especially
when I record a macro and click on some other workbook I get --
Windows("hari").activate -- and if I click on some other Worksheet I get --
Sheets("sheet1").select. So, what causes VB to assign activate and select in
a selective manner.

Thanks a lot,
Hari
India

"Bob Phillips" wrote in message
...
Hari,

You can activate a sheet as well.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hari Prasadh" wrote in message
...
Hi,

Why do we Select a sheet but Activate a window.

(Above from the syntax writing point of view)

Thanks a lot,
Hari
India