View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default 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?