Hi!
I just wanted to know how i could switch between two worksheets in the same workbook (excel file) through the program.

I understand that we can perform functions only on the active sheet at a time.. Is this true...
jus wanted to know that if i just assign different worksheets to the activesheet, will it help me to work one sheet then go back to the previous one...

Or is there a better way to tackle this problem...


cheers
Abhilash