Read cell value of xlVeryHidden sheet
 

How do I return the cell value of a cell in a xlVeryHidden sheet. Note file
is the current ActiveWindow.

Thank you,

Steven

Read cell value of xlVeryHidden sheet
 

You can add a link to the cell

=Sheet2!A1


Or with code
MsgBox Sheets("Sheet2").Range("A1").Value



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steven" wrote in message ...
How do I return the cell value of a cell in a xlVeryHidden sheet. Note file
is the current ActiveWindow.

Thank you,

Steven

Read cell value of xlVeryHidden sheet
 

Ron,

I thought that was what I was doing. I guess not ... or maybe my excel was
just acting up and when it saw that you were on the case it straightend up
it's act.

Thank you,

Steven

"Ron de Bruin" wrote:

You can add a link to the cell

=Sheet2!A1


Or with code
MsgBox Sheets("Sheet2").Range("A1").Value



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steven" wrote in message ...
How do I return the cell value of a cell in a xlVeryHidden sheet. Note file
is the current ActiveWindow.

Thank you,

Steven