PDA

View Full Version : Solved: Quickie- Explanation Properties/Objects



YellowLabPro
10-05-2007, 07:48 AM
I got this line of code to not only work, but deliver the correct results:

lrow = Cells(Rows.Count, "A").End(xlUp).Offset(, 2).End(xlUp).Row


What I want to ask to reassure myself that I understand why it worked:
The first .End returns a range object, which lets me reference another property, the Offset Property, is this correct?

rory
10-05-2007, 08:01 AM
The Cells property returns a Range object, the End property applies to that object and returns another Range; the Offset property applies to that to return another range, then the End property gets another range, then you return the Row property of that Range. :)

YellowLabPro
10-05-2007, 08:44 AM
Thanks Rory.
Got your speedo ready?

rory
10-05-2007, 08:46 AM
More of a board shorts kind of guy, me! :)
Can't wait - this afternoon has been dragging really badly!

YellowLabPro
10-05-2007, 08:50 AM
Com'on, I know your Brits, Speedos all the way....
Are you leaving today?

rory
10-05-2007, 09:05 AM
Tomorrow morning. Just time for a couple of swift Guinnesses tonight, then home to finish packing.

YellowLabPro
10-05-2007, 10:10 AM
Have a great time and talk w/ you when you get back....