Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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."? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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."? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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."? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula for an "if" "then" scenario linking 3 worksheets | Excel Discussion (Misc queries) | |||
Compare two worksheets with "contains" and not "exact" values | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Why is "History" a "reserved name" while naming Excel worksheets? | Excel Discussion (Misc queries) |