Code:
Dim rng1 As Range Dim rng2 As Range 'Finding last cell Dim lRealLastRow As Long Dim lRealLastColumn As Long Range("A1").Select On Error Resume Next lRealLastRow = Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, _ xlPrevious).Row lRealLastColumn
Leave a comment: