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

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