Dim lng, wsi As Long
anz = 0
For wsi = 1 To 4
lng = Sheets(wsi).Cells(Rows.Count, 10).End(xlUp).Row
anz = Application.WorksheetFunction.CountA(Sheets(wsi).Range("J3:J" & lng))
anz = anz + Application.WorksheetFunction.CountA(Sheets(wsi).Range("J3:J" & lng))
wsi = wsi + 1
next
MsgBox anz
End Sub