View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default 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