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
- what is instance variable and class variable.
- What variables are in heap and what variables are in stack
- multiplying two integer variables and assigning to a long variable
- 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
- Calculate Total Sum
- Sum colunm total in repeater
- sum of amount deliverd group
- count the sum of a column
- SUM content of rows
- custom Sum function?
- Loop, sum values and paste
- VBA code to sum
- sum in columns
- Summing on varying number of rows in Excel using VBA
- getting the sum of the last 20 cells