Define Range in VBA

[loopoo]

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

 

[Norman Jones]

Hi Chris,

Perhaps:

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

 

[loopoo]

Thanks a lot,

It works just fine for me


Chris