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