If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

If so, for your first question I think you could use the ActiveCell property of a worksheet object. With ActiveCell property you can get the property Row and Col for the row and column selected, like ActiveCell.Row or ActiveCell.Col.

For your second question I'm not very sure how you want to handle it but you could use the ASCII code to do something like:

col = var + 65

where var would be the col in the form Cell(row,col), the you just can convert that number to character: