Forum Discussion
Solved
One cell in Sheet2, =Sheet1!H4. H4 has a formula and it is still working. But I can't find sheet1.
"A" cell in Sheet2 has a reference from sheet1, =Sheet1!H4. That cell, H4, calculates using the parameters in Sheet2, and the "A" cell in sheet2 will show the result. I want the check the formula in ...
In brief, if you don't see Sheet1 within hidden one, right click on on any tab, View Code, here stay on Sheet1 and select proper value at the bottom from Visible (-1 if to make it visible)
In brief, if you don't see Sheet1 within hidden one, right click on on any tab, View Code, here stay on Sheet1 and select proper value at the bottom from Visible (-1 if to make it visible)
- Thanks!
sunhao8 , you are welcome
