Try:

Sheets("My Sheet").Select

or

Sheets("My Other Sheet").Activate.

Cheers, Pete.

-----Original Message-----
Hi guys!

Just a quick question:

I would like to write a function in VBA which would allow
me to move
between the sheets in excel.

Does anyone know the method for it?

Thank you


---
Message posted from http://www.ExcelForum.com/

.