I'm not if this is exactly what you are looking for, but it should at least get you in the right direction. There is a .Row property that you can call on a Range object which will return the index of the first row of the selected Range. If your Range is a single cell, it will thus return the row index of that cell.