YasserKhalil
10-27-2010, 11:07 PM
Hi everybody
I learnt to refer to the last row by code
Now I have column B with formulas until B100 but the results are until B11 and the other cells in the column are bank
I want to refer to the Last Row to be 11 not 100
Here's my code but it appears to be 100 not 11
Dim LastRow As Integer
LastRow = Cells(Rows.Count, 2).End(xlUp).Row
MsgBox LastRow
I learnt to refer to the last row by code
Now I have column B with formulas until B100 but the results are until B11 and the other cells in the column are bank
I want to refer to the Last Row to be 11 not 100
Here's my code but it appears to be 100 not 11
Dim LastRow As Integer
LastRow = Cells(Rows.Count, 2).End(xlUp).Row
MsgBox LastRow