Is there anyone that could please help me with the correct way to d
this.

This is what I want it to do.

I want it to open a sheet I named through the VBE . For exampl
instead of being Sheet1 I named it SheetORIGINAL.

Here is what I am trying to do

x = activecell.offset(0,30).value (This is where the name or valu
ORIGINAL is stored)

Sheet & x.activate
Sheet & x.printout



Thanks

Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=38363

Josh

jhahes wrote:
Here is what I am trying to do

x = activecell.offset(0,30).value (This is where the name or value
ORIGINAL is stored)

Sheet & x.activate
Sheet & x.printout

Sheets("Sheet" & x).Activate


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com