View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NDBC NDBC is offline
external usenet poster
 
Posts: 204
Default find row address of target cell

done.

trow = target.row

"NDBC" wrote:

I am trying to get the row address of a target cell. The following code does
not work. Please tell me where I'm going wrong. Thanks

If Target.Column = 11 Then
trow = Sheets("a grade").Cells(Rows.Count, Target).Row