on error resume next
activeworkbook.worksheets(activesheet.range("F2"). value).select
if err.number < 0 then
beep
end if
on error goto 0

Charlie wrote:

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

--

Dave Peterson