I am using this sub to get the last row and column with data. If it tries to search a column that is empty, it errors out. How can i avoid this ? or do this better?
Public Sub GetLastRow(RowLast As Long, ColLast As Long) Dim lastRow As Range, ws As Worksheet Dim lastColumn As Range...