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: 1096

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?



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.