What is "Me.Range"?

[dl7631]

Dear gurus, probably a simple question:

What does "Me.Range" mean? More specifically, I don't understand the second line of this piece of VBA code:

Dim LP as Long
LP = Me.Range("r4").Value

Thank you!

 

[Jonmo1]

Me is usually an object variable that refers to a sheet..

Specifically, I'm guessing that snippet is from some Worksheet Event code, like

Private Sub Worksheet_Change(ByVal Target As Range)


In that case, Me refers to whatever sheet the code is in..

So if the code is in say Sheet1
then me is simply Sheets("Sheet1")

LP = Me.Range("r4").Value
LP = Sheets("Sheet1").Range("r4").Value

Make sense?

 

[ScottR]

"Me" is a reference to the object that contains the code. In this case a worksheet but can also be a userform or class.

That code is the equivalent of (assuming the sheet is called sheet 1)

Dim LP as Long
LP = Worksheets("Sheet1").Range("r4").Value

 

[dl7631]

Thanks a lot!

 

[xenou]

Most often, you'll use the Me keyword in sheet modules or sheet code, or in button code, or userform code.

In other words, it's not for code in standard modules....

If this makes no sense, check here for info on code placement:
http://www.mcgimpsey.com/excel/modules.html