Return sheet name from an address range
 

Hello,

I'm looking for a VBA function that returns the sheet name from a full
address of an excel range.

I am looking at a different solution than ...Range(name).Worksheet as
it seems not recognized in VB6

Please help
Avi

Return sheet name from an address range
 

Hi Avi,

Try:

Dim sStr As String

sStr = Range("MyRange").Parent.Name


---
Regards,
Norman


"avi" wrote in message
oups.com...
Hello,

I'm looking for a VBA function that returns the sheet name from a full
address of an excel range.

I am looking at a different solution than ...Range(name).Worksheet as
it seems not recognized in VB6

Please help
Avi

Return sheet name from an address range
 

Range(name).Worksheet.Name should work.

Hth,
Merjet