What is the use of "Me" keyword in VBA

[Karthik Sen]

Hi All,

can anyone let me know What is the use of "Me" keyword in VBA

ex :

Please Login or Register  to view this content.

=========

Please Login or Register  to view this content.

[JBeaucaire]

For macros stored in a SHEET module, "Me" is another way of specifying this code is meant to run on the sheet in which the macro is stored.

In your example, it's redundant. Macros stored in the sheet module always send unspecific range commands to itself as the sheet. So this:

Please Login or Register  to view this content.

...is the same as:

Please Login or Register  to view this content.

If this macro were found in a standard CODE module, then your first version wouldn't work at all, and mine would send the command to whatever the current Activesheet happened to be.

[Karthik Sen]

Thank you!!!!!!!!!!!

[shg]

And ... in the ThisWorkbook module, Me refers to ThisWorkbook, and in a forms module, it refers to the form.