count number of "used" rows trick with vba - can't remember

what is the vba code that actual goes to the bottom of the workbook and works its way back up to count the number of used rows.  for instance you have a value in a1 and a5 and the code will return a count of 5 by going to the bottom and then working its way back up.
BigWill5112Asked:
Who is Participating?
 
Chris BottomleyConnect With a Mentor Commented:
activesheet.range("A" & activesheet.rows.count).end(xlup).row


xlup is -4162 if calling from VBS rather than excel VBA

Chris
0
 
BigWill5112Author Commented:
Perfect
0
All Courses

From novice to tech pro — start learning today.