Hi again!

This time I need some help on the following issue:

I have the limits of a range as 2 columns (the first one, it;s fixed,
"A3", and for the second one I know the relative position to this one -
for example, if this position is 20, i know it's about "A23" - 20 cells
below "A3").

Can anyone help me to define this range into a "as range" VBA variable
??

Also, this definition will be executed multiple time, and in the first
place I need a range delete. Is "Range("my_range")).delete" the correct
method call for that?

Thanks in advance,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=487185

Hi Chris,

Perhaps:

Range("A3").Resize(20).Delete shift:=xlUp

---
Regards,
Norman



"loopoo" wrote in
message ...

Hi again!

This time I need some help on the following issue:

I have the limits of a range as 2 columns (the first one, it;s fixed,
"A3", and for the second one I know the relative position to this one -
for example, if this position is 20, i know it's about "A23" - 20 cells
below "A3").

Can anyone help me to define this range into a "as range" VBA variable
??

Also, this definition will be executed multiple time, and in the first
place I need a range delete. Is "Range("my_range")).delete" the correct
method call for that?

Thanks in advance,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile:
http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=487185

Thanks a lot,

It works just fine for me


Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=487185