martynball
05-06-2010, 01:59 AM
Hey, I have got cells with different named ranges. Such as "J9" has the name of "u3p4".
I have then got this VBA code:
Sub displayTask()
Dim cell, selection As Variant
cell = Sheets("Marks Sheet").Range("task_display")
MsgBox (ActiveCell.Name)
End Sub
But for some reason instead of displaying "u3p4" it is displaying the actual location of the cell which is "='Marks Sheet'!$J$9"...
How cna I get it to get the actual name instead of the address....
I have then got this VBA code:
Sub displayTask()
Dim cell, selection As Variant
cell = Sheets("Marks Sheet").Range("task_display")
MsgBox (ActiveCell.Name)
End Sub
But for some reason instead of displaying "u3p4" it is displaying the actual location of the cell which is "='Marks Sheet'!$J$9"...
How cna I get it to get the actual name instead of the address....