View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.