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
Read More