hello everyone, i have a column from a2:a2000
i want to save a file that counts how many cells from a2:a2000 have data
so basically, if A2:A197 have data, i want the file name to be "Dec (15) DB (197).xls
i am using this code but its not counting for some reason

ActiveWorkbook.SaveAs "C:\My Documents\Downloads\" & Format(Date, "mmm") & " (" & _
Format(Date, "dd") & ") DB (" & lnglastrow - 1 & ").xls"
anyone have an idea why?
thanks for your help