Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Range

Status
Not open for further replies.

sabascal

IS-IT--Management
Joined
Aug 20, 2002
Messages
85
Location
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top