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