What Is "Me.Worksheets(..."

S

SidBord

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

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
 
Top