I have been searching all morning for the method to output the row and column reference of a selected cell.
I'm sure i have done it before with a simple expression along the lines of row(Selection)= MyRow
But this does not seem to work.
The cell is selected using a range command from a user input i.e. "A1"
I wish to be able to get the row part of this separately so I can manipulate an offset function I am using.
(I only wish to offset the cell when the row number is greater than 200)
Thanks in advance