PDA

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)))")