How do I get a cell's row number
Dim CellRow as Long
CellRow = Selection.Row
'OR'
CellRow= ActiveCell.Row
To see more, in the IDE step into the proc, open a
watchwindow (View/Watch Window) and drag ActiveCell into
it. In the watch window, click on the '+' and you'll see
more of the available properies
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hello all!
I have a rather simple question. I need to know a cell's
row number and put it in a variable.
Best Regards
Mattias
.
|