>>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.