AutoSum already selected columns

[Chadcp1]

Hi,

I'm VERY new to this but have picked up a bit already.

I have the columns already selected by way of my macro, but I need to be able to perform a sum on each.

The spreadsheet changes in size weekly, so I don't want to the rows "hard coded" in the macro.

Can anyone help here?

Like I said I've already got the end of each column selected. So it's just a matter of running the sum formula in there.

Any assistance you can provide would be really appreciated.

Thanks!

[jolivanes]

It would be helpful to see the code you will be using.
Selecting is typically not required and really slows things down.
Are you willing to share your code with us?

[Chadcp1]

I have 8 columns of figures that are separated by blank rows.
The sheet can vary between 1400 - 6000 rows long, which is separated into around 40 sets of row.

So at each break there is a blank row.

At columns G,H,I,J,K,L,M,N in the blank row I need the macro to autosum the data above.

When I was doing the macro it would put in the actual row, but when the sheet changes from week to week, this won't work.

The code that i've used to select the blank rows is below;
Thanks

Please Login or Register  to view this content.

[Chadcp1]

This is the full code... Forgive my ignorance... I just started this yesterday.

The sheet size changes often.. So below everything works and once this runs all I have to click is autosum and its done... But I'd like the macro to do everything.

Please Login or Register  to view this content.

[jolivanes]

Before continuing, please read and react to rule #2 of the Forum Rules at the top.

Once done with that, attach a representative workbook without personal (names, addresses, phone numbers etc) data.

[Chadcp1]

I've corrected the issue above.

I'm having difficulty uploading the attachment to this replay.

I've uploaded the attachment to an upload service but I'm unable to attach the link...

What now?

[jolivanes]

Try this on a copy of your original.

Please Login or Register  to view this content.

[Chadcp1]

Thanks, but this didn't work.

It's changing the values in the row BELOW the blank rows.. giving all of them a "0" value.

So I think the calculation needs to come up by 1 row.

Thanks

[jolivanes]

What about attaching a representative workbook. The attachment in Post #6 has no empty rows as you say there are in your original. One of the columns to be summed have dates in it.
Anyway, on a sample file I made, the code works perfect.
See attached

[Chadcp1]

The file I sent is the raw data.

I then ran my macro, without your code and it would clear it up with the blank rows

[jolivanes]

Check out the attachment in Post 9.
It sounds like the empty rows are not empty. They might have something in it but without having the file to check, it's just a stab in the dark.

[Chadcp1]

Ok here is the file after I run my macro (SIX) showing the blank spaces

[jolivanes]

The so called blank rows are not blank rows. As you see, the cells in columns A and B have data in them.
Change code to

Please Login or Register  to view this content.

[Chadcp1]

SUCCESS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Man I can't thank you enough!!!

[jolivanes]

Glad it works for you.
Good luck.