Using "Address" function in VBA?

[Gerald42]

I'm really surprised I haven't been able to figure this out yet.

I'm trying to return the string address of a cell based on two indices alone, but i'd like to do it exclusively in VBA. Is this possible? I tried Application.WorkSheetFunction.Address() to no avail...

Thanks!

 

[Richard Schollar]

Hi

On two indices? Perhaps:

MsgBox Worksheets(1).Cells(x,y).Address

where x and y are your row and column indices respectively.

 

[Gerald42]

that's it!

thanks..i knew it had to be something simple