Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Match
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 ------------------- If ComboBox1.ListIndex = 0 Then Range("K20").Activat ------------------- ;) ; -- helmekk ----------------------------------------------------------------------- helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693 View this thread: http://www.excelforum.com/showthread.php?threadid=27119 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Match
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Match
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 -------------------- ;) ;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX and MATCH with range | Excel Worksheet Functions | |||
entry must match value in range | Excel Worksheet Functions | |||
Match 2 Conditions then Avg Range | Excel Discussion (Misc queries) | |||
Index-Match from a range | Excel Worksheet Functions | |||
Match / Name-assigning To A Range | Excel Programming |