How do I get a cell's row number
 

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

How do I get a cell's row number
 

activecell.Row

On Mon, 18 Aug 2003 23:03:37 -0700, "Mattias"
wrote:

I have a rather simple question. I need to know a cell's
row number and put it in a variable.

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



.