Error 1004 while getting Cell Name

[Ashish]

Hi,

I have the following simple Macro. I get a Runtime Error 1004 "Application
defined Or object-defined error" when the MSGBOX statement attempts to
execute.

***************************************************
Sub Macro1()

Dim myrow, mycol As Integer

Sheet1.Activate
Sheet1.Cells(1, 1).Select
MsgBox Sheet1.Cells(1, 1).Name, vbOKOnly


End Sub
***************************************************

Please help urgently!!!

Thanks and regards,
Ashish Sardey

 

[Mike H]

Hi,

Do you mean it's defined name? If so try this

MsgBox Sheet1.Cells(1, 1).Name.Name

Mike

 

[Ashish]

Hi Mike,

I tried this option as well. It doesn't work, and gives the same error.
Please help urgently.

Thanks and regards,
Ashish

**************************************************