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
method.