Thread: What Is "Me.Worksheets(..."
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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."?


Reply With QuoteReply With Quote