ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA cell ref problem (https://www.excelbanter.com/excel-programming/346888-re-vba-cell-ref-problem.html)

Luke Bellamy

VBA cell ref problem
 
Stupid hidden sheets threw my code references out.

---------------
Luke Bellamy
Newcastle, Australia
http://www.cashwhiz.com.au

"Luke Bellamy" wrote in message
...
Hi - I have a spreadsheet where I run this code

Debug.Print Me.Range("I9").Value
Debug.Print Me.Range("I9").Text

and it produces:
Error 2023
#REF!

The wierd thing is that this cell is empty and I get the
same result even if I type in any value in the cell I9.

Any ideas? could this be corrupt?

Thanks
---------------
Luke Bellamy
Newcastle, Australia
http://www.cashwhiz.com.au





All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com