Read cell value of xlVeryHidden sheet

S

Steven

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

Thank you,

Steven
 
R

Ron de Bruin

You can add a link to the cell

=Sheet2!A1


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

Steven

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Toggling xlVeryHidden 8
Transfer data between two tables 3
Problem with ".Visible" sheet property 2
Sheets - xlVeryHidden 2
Cell data entering slow! 0
Change the colour of a neighbouring cell 6
Modify data on a hidden sheet? 5
Date diffrence in days, weeks and months. 1

Top