| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get cell's number format category in VBA? | Excel Discussion (Misc queries) | |||
| row= cell's row | Excel Worksheet Functions | |||
| How to change an other cell's value? | Excel Discussion (Misc queries) | |||
| returning a cell's value and a corresponding value | Excel Worksheet Functions | |||
| cell's address of the largest number | Excel Discussion (Misc queries) | |||
![Mattias[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
