set ARange = RangeName.offset(0,-1)

--
Regards,
Tom Ogilvy


"Bill Case" wrote in message
...
My explanation in my first post wasn't very clear. Let me try again.

I have RangeName as $B$5:$B$?

I want to :

Dim ARange as Range
Set ARange = RangeName only as $A$5:$A$?

I can do this with Cells( i, 0) and a For loop but there should be a
better
way.

Regards Bill


"Bill Case" wrote:

Hi;

I have a range name $B$5:$B$?. ? means the length of the range can
change.
I want to create a new temporary range that depends on the length of the
original range name i.e. $A$5:$A$?. I should know how to do this, but
tonight, Gawd if I can make it work.

Any suggestions?

Regards Bill