What Is "Me.Worksheets(..."
 

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

What Is "Me.Worksheets(..."
 

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


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

What Is "Me.Worksheets(..."
 

SidBord

See here

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

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

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