Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Last Row

Last Row

ResolvedVersion 2003

Thu 5 Feb 2009, 17:05 Delegate Okechi said...

Okechi has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Last Row

What VBA code do you use to find the last non-zero cell in either a row or a column of a list

Thu 26 Mar 2009, 15:40 Delegate Phil said...

RE: Last Row

try in your VBA code:

Range("A1").Select
Selection.End(xlDown).Select
Range("A1").Select
Selection.End(xlToRight).Select

Modify the cell references to match whatever yours requires.

regards

Phil

TrustPilot
TrustScore 4.9 / 5 2435 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy