vba last column

Sometimes it is very necessary you get the last Column or last Row of your dataset in Excel This is a simple VBA code to get the Last Column and Last Row in your dataset Sub lastRow1() lastRow2 = Cells(Rows.Count, 2).End(xlUp).Row End Sub   What the above code does is that, we are using the…