View Full Version : Last Row
ProteanBeing
02-04-2008, 01:18 PM
How do I find out what the last row in my list is? The list may be filtered but I need to know the length of the entire list.
Bob Phillips
02-04-2008, 01:25 PM
activesheet.evaluate("=MAX(IF(A1:A1000<>"""",ROW(A1:A1000)))")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.