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

--
Regards,
Tom Ogilvy


"helmekki" wrote in message
...

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
--------------------


;) ;)


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=271193