Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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?

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

Related Topics:

- Summing a range
- How to declare a range using a variable
- Error when using variable to name a range
- Variable Ranges, Loop?
- Using a Defined Variable Range in a VBA SumIf
- VBA variable range in a formula
- Using Macro to automatically sum a variable range of rows?
- How to get MIN, MAX and AVG of a variable sized table
- highlight a range using a named range
- multiplying two integer variables and assigning to a long variable
- what is instance variable and class variable.
- What variables are in heap and what variables are in stack
- Write a shell program to find the sum of the series sum=1 + 3 + 5 + 7 + …+ n
- Code for Write a shell program to find the sum of the series sum=1 + 5 + 9 + ...+ n in Unix
- sum and difference of 2 bcd numbers
- Compute the sum of both positive and negative elements of an array
- Getting the sum and percentage in Excel coulmn
- sum and Multiply number and print in decimal
- Create a constructor class Sum
- sum of series of natural numbers
- Sum values entered into text boxes
- Data Sum rows not hidded
- sum cells with conditional formatting color
- sum of amount deliverd group
- Calculate Total Sum