Writing Macro to Sum different Ranges in WorkSheet

**tattoo** · 02-09-2009, 05:10 PM

Hello,

I am trying to write a Macro that will sum a range of numbers and then go down to the next range of numbers, hten go to the bottom of that range to where I wnat the Sum and then total the second range.

I have tried recording the Macro using keystrokes but it keeps putting the Row,Col range in the Macro.

Here is what I have so far.

Please Login or Register  to view this content.

Not all the ranges have the same number of rows in them.

any help is greatly appreciated.

Regards

tattoo

**Leith Ross** · 02-09-2009, 05:18 PM

Hello tattoo,

Welcome to the Forum!

Can you give an example of the ranges you will be using. The length of a range can be determined in code using VBA. The macro recorder only records what you type. It isn't designed to optimize the code.

**mr.alexander** · 02-09-2009, 05:19 PM

how are the ranges distinguished? i.e. are there row headers for them?

**tattoo** · 02-09-2009, 06:01 PM

Originally Posted by mr.alexander

how are the ranges distinguished? i.e. are there row headers for them?

Here is an example of my Worksheet

Please Login or Register  to view this content.

Sorry I couldn't get it to line up properly but I think it is undestandable.

The First row does contain a header of each cell. Also as you will notice,
the first group has 4 records to sum and the second has 13.

This data is generated from our Invoice System via a Crystal Report and then Exported to Excell Data Only format. the totals that come over now are only displaying the number, not the formula.

Once the user has Exported this data from our system as shown above,
she may then have other rows to manually enter on the sheet. If she does then those values are not incorporated into the total values because they are not a formula, only the Total value that is printed by the Crystal report.

Hope all this makes sense, please let me know if you need more info....

regards

tattoo