ExcelBanter - find row address of target cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - find row address of target cell (https://www.excelbanter.com/excel-programming/431488-find-row-address-target-cell.html)

NDBC

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

NDBC

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

All times are GMT +1. The time now is 02:05 PM.