Return sheet name from an address range

[avi]

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

 

[Norman Jones]

Hi Avi,

Try:

Dim sStr As String

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

 

[merjet]

Range(name).Worksheet.Name should work.

Hth,
Merjet