The site formatting didn't help with the display of my code....
what the above should have said was....
'The row number of the active cell
Dim RNum As String
RNum = ActiveCell.Row
In fact making RNum an Integer has solved that bit, but I need to find the column letter as well, which obviously isn't an integer. (I hadn't posted this part originally as I thought the solution would be the same for both row and column!)
Any more help is welcome.
Thanks in anticipation,