Kelly,

Don't select it.

Worksheets("Detail").Copy Destination:=WorkSheets(Control).Range("A1")

is an example of how to copy. The rest should be possible, post your code if
you need help how to.

--

HTH

Bob Phillips

"Kelly" wrote in message
...
Hi all, Using the Office 2000 pakage,

Hi, I am trying to clean up a template and get rid of all
my hidden rows and columns and centralize all my variables
to one Control sheet. My Control sheet is very hidden.

Some of my code errors out because when I use... Sheets
(Control).select it can't find the sheet.

I don't want to unhide the sheet and rehide it every time
I run this code.

Is there a way to access this sheet (to copy a range of
cells) without using the Unhide function?

Thanks Kelly,