MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Create Dynamic Ranges in VB

  Asked By: Gin    Date: Sep 13    Category: MS Office    Views: 2125

I want your help. i want to make dynamic ranges in VB.
I have a database wherein i keep adding data in rows. I want someone
to create a dynamic range which will expand as and when other cells
are filled. Example, I have data in columns A, B & C. In a2 & b2
there are amounts which are filled manually and C2 is a function, =sum
(a2*b2) as and when i fill a3 & b3 the formula in should get exteded
in C3 dynamically. Please Help me to do this with VB with offset



1 Answer Found

Answer #1    Answered By: Adalwen Fischer     Answered On: Sep 13
Didn't find what you were looking for? Find more on Create Dynamic Ranges in VB Or get search suggestion and latest updates.