you can try this

worksheets(range("F2").Value).activate

--


Gary


"Charlie" wrote in message
...
On the currently active sheet cell F2 has the name of the sheet I want to
make active. How do I activate this sheet?
thanks,
ck