Hi,
Use the following code to identify the last row of the range.
Can you recommend a better solution!
Thanks in advanceCode:Dim Riga As Long Riga = Application.WorksheetFunction.Max(Cells(Rows.Count, "A").End(xlUp).Row, _ Cells(Rows.Count, 2).End(xlUp).Row, Cells(Rows.Count, "C").End(xlUp).Row) MsgBox Riga
Bookmarks