Solved: Cell Address Value

[joms]

hi guys, just a quick question..
how to get the cell value given a particular cell address like: $A$29
Thanks. :)

[lucas]

Not sure I understand. Maybe something like:
Sub a()
MsgBox Range("A29").Address
End Sub

[lucas]

I think I read it wrong. Maybe:
Sub a()
MsgBox Range("A29").Value
End Sub

[joms]

hi lucas, thanks..