I have a sheet calls "Recap" and I want to know how much line that I have in this sheet.I tried with this code:

```
Function FindingLastRow(Mysheet As String) As Long

Dim sht As Worksheet
Dim LastRow As Long

Set sht = ThisWorkbook.Worksheets(Mysheet) 
LastRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row
FindingLastRow = LastRow

End Function

```

......

in my macro i tried this:

....

```
Dim lastR As Long
lastR=FindingLastRow("Recap")
msgBox lastR

```

.....