making a different sheet active
 

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

making a different sheet active
 

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

making a different sheet active
 

This should do what you asked...

Worksheets(Range("F2").Value).Activate

Rick


"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

making a different sheet active
 

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