Thread: VBA cell ref problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luke Bellamy Luke Bellamy is offline
external usenet poster
  
Posts: 1
Default 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



Reply With QuoteReply With Quote