View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
loopoo[_15_] loopoo[_15_] is offline
external usenet poster
 
Posts: 1
Default Define Range in VBA


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