Count The Number Of Rows Of Selection

First - What I need is an idea of how to just get the number of rows on a selection. For instance -

select worksheet
select paticular area (easy like a1)
get the number of rows that comes from that selection (there could be upto 5 rows that are merged by the front end, what i need is the number of rows that have been merged)

and Second -

once i have that number of rows - the next portion that I need selected could be a different colum - how do you add to columuns without knowing where you are at -

for instance - knowing that you are at a1 (a) but then having togoto columum number 4 row 1 (d1) - so i guess the question is is how I convert a number to the correct character then add the number at the end then use that compilation to select. something like

delare temp
get updated colum letter from corresponding column number
combine column letter and the row number you already know
select that in the worksheet