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


On Thu, 21 Oct 2004 09:47:18 -0500, helmekki
wrote:


Hi

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

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

here is the code:

Formula:
--------------------
If ComboBox1.ListIndex = 0 Then Range("K20").Activate
--------------------


;) ;)