Dynamic Range

[sabascal]

Hi all,
I'd like to use dynamic range functionality in my VBA.
I know how to use that with formulas i.e :
if rg1 is my range, and r2 is the new range I want to use:
-Excel Formulas:
Insert >Name> r2 =OFFSET(rg1,r1,c1, myRowLength, myColumnLength)

-How do I perform the same operation in VB?

Many thanks

 

[SkipVought]

Hi,

You could us the OFFSET worksheet function just as you have it

Set rg2 = Application.OFFSET(rg1,r1,c1, myRowLength, myColumnLength)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com