eliW
Well-known Member
- Joined
- Mar 2, 2002
- Messages
- 1,940
Hi all,
In my macro's I often use:
set myRange = ActiveCell.CurrentRegion
which allows refering to changing ranges.
Now, I need to know the ADDRESS of some cells in that range and put into variable: say the first cell in the last column, or the third from top, second to the right. I need adress not content (e.g. "H1").
What is the VBA code for that?
Many thanks,
Eli
This message was edited by eliW on 2002-04-26 02:18
In my macro's I often use:
set myRange = ActiveCell.CurrentRegion
which allows refering to changing ranges.
Now, I need to know the ADDRESS of some cells in that range and put into variable: say the first cell in the last column, or the third from top, second to the right. I need adress not content (e.g. "H1").
What is the VBA code for that?
Many thanks,
Eli
This message was edited by eliW on 2002-04-26 02:18