How do you use the Worksheet property of the Range object?

[Excel_vba]

According to the Microsoft website, the Range object has a property called Worksheet.


1. How do you use this?
2. How is this possible when a range is a "subset" of a Worksheet?

[tigeravatar]

Excel_vba,

See here for details and examples:
http://msdn.microsoft.com/en-us/libr.../ff837845.aspx

[Excel_vba]

Thank you Tiger. You can obtain the worksheet name by doing something like:

Msgbox Worksheets(1).Name


1. So I not sure why there would be a need to have a Range object before Worksheets(1).Name?
2. I also this anyway with a Range:

MsgBox Range("A1:A10").Worksheet.Name

The Message returned was the name of sheet 1, which was "Andre." However, when I selected sheet 2 (which I named Larry), I still got "Andre" as the name returned even though sheet 2 (Larry) was the active sheet. Why does the code in the line above always return the name of sheet 1?

[GC Excel]

Hi,

The Message returned was the name of sheet 1, which was "Andre." However, when I selected sheet 2 (which I named Larry), I still got "Andre" as the name returned even though sheet 2 (Larry) was the active sheet. Why does the code in the line above always return the name of sheet 1?

Are you sure? Because when I selected sheet2, it returned the name of sheet2.

Code I used :

Please Login or Register  to view this content.

With that being said, I don't see a good reason to use this property...