What Is "Me.Worksheets(..."

[SidBord]

I have seen code in various places where they use the
prefix "Me.", like "Me.Worksheets("Sheet1")....". What is
the significance on "Me."?

 

[Chip Pearson]

The "Me" keyword refers to the class instance in which the code
appears. So if the code is in the ThisWorkbook module, it refers
to ThisWorkbook. If it appears in a class module, it refers to
that instance of the class.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dick Kusleika]

SidBord

See here

http://www.dicks-blog.com/excel/2004/04/the_me_keyword.html