current row - VBA
 

Hi, i am wanting to find the row number of a active cell. can anyon
give me some code to be able to do this?
Many thanks Chris

--
Message posted from http://www.ExcelForum.com

current row - VBA
 

Hi Chris

Use

Dim ActiveRow as Long
ActiveRow = Activecell.Row
msgbox ActiveRow


This gives the numeric value of the Row that the cell is on

HTH

Davi

--
Message posted from http://www.ExcelForum.com

current row - VBA
 

ActiveCell.Row

Troy

"chrisdarl " wrote in message
...
Hi, i am wanting to find the row number of a active cell. can anyone
give me some code to be able to do this?
Many thanks Chris.


---
Message posted from http://www.ExcelForum.com/

current row - VBA
 

Chris,

Activecell.Row

Cheers, Pete

-----Original Message-----
Hi, i am wanting to find the row number of a active cell.
can anyone
give me some code to be able to do this?
Many thanks Chris.


---
Message posted from http://www.ExcelForum.com/

.

current row - VBA
 

micro = ActiveCell.Row

where micro is a variable



-----Original Message-----
Hi, i am wanting to find the row number of a active cell.
can anyone
give me some code to be able to do this?
Many thanks Chris.


---
Message posted from http://www.ExcelForum.com/

.

current row - VBA
 

What about this;

Sub RowNnumber()
Dim RowNumber As Long
RowNumber = ActiveCell.row
MsgBox ("Row number of the active cell is " & ActiveCell.row)
End Sub

Henk

chrisdarl wrote in message ...
Hi, i am wanting to find the row number of a active cell. can anyone
give me some code to be able to do this?
Many thanks Chris.


---
Message posted from http://www.ExcelForum.com/

current row - VBA
 

Hey, try this:
= ActiveCell.Row
-----Original Message-----
Hi, i am wanting to find the row number of a active cell.
can anyone
give me some code to be able to do this?
Many thanks Chris.


---
Message posted from http://www.ExcelForum.com/

.

current row - VBA
 

Thanks everyone for all your help its working fine now.
Chri

--
Message posted from http://www.ExcelForum.com