Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Summing a range of variable size

  Asked By: Nancy    Date: Mar 11    Category: MS Office    Views: 1133
  

This is a very, very basic question but I've struggled with it long enough and
still can't get it right.

I'm working on a program that inserts payment, interest, length of term
information about various assets into a worksheet using a userform. The
number of assets will vary each time the userform is used.

I want to sum the payment column in the cell directly below the last entry.

How do I do this?

I know cell b2, for example, will always be the starting point and the column
of data may extend through b25.

Do I have to activate cell b2 and then write the code from there?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Summing a range of variable size Or get search suggestion and latest updates.




Tagged: