Range Match

[helmekki]

Hi

My last used cell in A column is A20......
I want to use the comming code to activate the cell in column T sam
row
i.e. row 20..........(T20)

My point is how modify Range property to do the job i want....

here is the code:

PHP code

 

[Tom Ogilvy]

set rng = Cells(rows.count,1).End(xlup)
if Combobox1.ListIndex = 0 then Cells(rng.row,"T").Activate

 

[Myrna Larson]

R = Range("A65536").End(XlUp).Row
Cells(R, 20).Activate
'or Range("T"&R).Activate