I need help range selection and cells selection

Hello everybody,

in my vba learning process,

i have one question of this below.

Is these below create same purpose action or different? Please help me.

range("a"& i).end(xlup).row

cells(rows.count, i).end(xlup).row

range(rows.count, "a").end(xlup).row

or adding column at the end.

Ok

I have tested these for you.

The first one gives you the last used cell in column A regardless of the value of i.

The second one returns 1 whatever the value of i

The third one simply returns an error.

Sub Macro1()
'
' Macro1 Macro
i = 20
temp = Range("a" & i).End(xlUp).Row

temp = Cells(Rows.Count, i).End(xlUp).Row

temp = Range(Rows.Count, "a").End(xlUp).Row
End Sub