referencing hidden sheets
Hi
....
varX=Worksheets("YourHiddenSheet").Range("A1").Val ue
Worksheets("YourHiddenSheet").Range("A1").Value=va rY
etc.
--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )
"mohsen" wrote in message
...
Hi, I have three sheets that I do some calculations in. I wrote a form
which provides a single input place for all of the sheets, but I cannot
hide my sheets. Everytime I hide them, so the user only sees the form,
the "sheet (x).select" will cause a compile error because it cannot find
the hidden sheet. Any suggestions, please?
|