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?
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?
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?
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....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.