This really doesn't belong here, but I'm not sure who to ask. Does anyone know how to convert between the index format Cells(Row,Column) to R1C1 format?

I need to select a range of cells. I know the starting cell is going to be A5. I know the ending cell is in the "G" column, but I don't know what the row #. So I've got a function that looks down the rows of the entire column until it decides where to stop. So now I've got the row #. You'd think I'd be able to now select the range, but Range expects only R1C1 formats. Any ideas?

Thanks,