Finding The Last Row Or First And Last Available Blank Row

1 minute read Examples on how to first the last row, first available blank row or the last blank row ‘ last Row, working from the bottom of a Column upwards (therefore the Column can contain blanks & the last Row will still be returned) MsgBox Cells(Rows.Count, 1).End(xlUp).Row MsgBox Cells(Rows.Count, “A”).End(xlUp).Row MsgBox ActiveSheet.Cells(ActiveSheet.Rows.Count, “A”).End(xlUp).Row MsgBox … Read more