>>Thanks Hugo. Your hint pointed me in the right direction and I found:
>>

>>.activecell.address
>>

>>which is what I was looking for.
>
>Would that give the address as a single text, like "C3"? In general, when doing Automation, I would much rather work with the row and column as numbers, since this seems much easier. (Which column comes after column "Z"? OK, I know it is "AA", but try to explain this to your program.!)

Try it.
It comes up as "$C$3". Numbers may be easier but how do you insert them into a .range statement?

.range(.activecell.address + ":D4").select 

works for me.