VBA – Excel – Determine and set data range
Use: Function LastRowInt(InWS As Worksheet) As Integer LastRowInt = InWS.UsedRange.Find(What:=”*”, After:=InWS.Cells(1, 1), Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row End Function Public
Read more