Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I created an Excel workbook that has a macro opens others spreadsheet

files. It has vba code that reads data on sheet 1 and writes data onto

sheet 3 of the workbook that I opened.

The number of rows varies from one spreadsheet to another.

So for example I processed 9 rows of data, headings are in the first

rows. For column C I want sum C2:C10 and place the formula in C11.

I have a variable that tells me how may rows I have processed.

Does anyone have any suggestions?

well if you have a variable that tells you how many rows... use that

variable something like this

range("c" & var + 1).formula = sum("c1":"c" & var)

just air code.. but i think something like this should do it

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

Related Topics:

- Summing a range of variable size
- highlight a range using a named range
- Using Macro to automatically sum a variable range of rows?
- custom Sum function?
- SUM content of rows
- count the sum of a column
- Calculate Total Sum
- sum of amount deliverd group
- Sum colunm total in repeater
- 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
- Conditional Summing
- sum formula
- how to sum the even numbers only
- Sum values entered into text boxes
- Data Sum rows not hidded
- sum cells with conditional formatting color
- sum of series of natural numbers
- 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