active cell in row
 

how can i select a particular cell within the selected row

i.e. user clicks any cell on a line, but i need to select cell in column e
in the selected row.

if that makes sense!!

ta, andrew.

active cell in row
 

If you want to make the cell the sole selection

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If not (target.count =1 and Target.column = 5) then
application.EnableEvents = False
cells(Target(1).Row,5).Select
Application.EnableEvents = True
end if
End Sub

right click on the sheet tab and select view code. Then put in code like
the above in the resulting module.

See Chip Pearson's page on Events if you are are not familiar with them:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"westg" wrote in message
...
how can i select a particular cell within the selected row

i.e. user clicks any cell on a line, but i need to select cell in column e
in the selected row.

if that makes sense!!

ta, andrew.