i want to find the last empty row for a particular coulmn like A coulmn .
sub abc()
iRow = wkb1.Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
End Sub
as this is taking only first coulmn and providing me with Irow = 2 but there is data present on second B coulmn .
Please help ...
thanks
aksh619