![]() |
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