How do I get a cell's row number

M

Mattias

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
 
P

Patruck Molloy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
VBA Assigning cell value to variable giving runtime error 3
Need Help with a VBA subroutine 0
Footer On Last Page Only Not Working 1
Paragraph numbering in Word 1
find and scroll to cell string value in Excel 2

Top