| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Underline problem underlines across width of cell | Excel Worksheet Functions | |||
| Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Last cell problem | Excel Programming | |||
| cell problem | Excel Programming | |||
Hybrid Mode
