Summation where range vary using Macro

**halogen_bulb** · 11-15-2011, 03:56 AM

Hi,

I was able to create a macro to sum up a range of every page but that was fixed only on specific numberof rows. The problem arises when size of the rows on every page vary and the result of the sum will not be the actual value of every page rather the sum up is overlapped or shortened. Sumif is better but during submission to our client, every page should come with a simple summation.

Here is the code I use.

Please Login or Register  to view this content.

I am attaching the sample of my worksheet. Im pretty sure there is a way to do it but I dont know how

Please help

Thanks,

**arthurbr** · 11-15-2011, 06:53 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

http://www.msofficeforums.com/excel/...ing-macro.html

**halogen_bulb** · 11-15-2011, 08:22 AM

I apologize for cross posting. but let me close this thread since I was able to come up the solution I need using Excel Forum and other forums. Here is the code I gathered by combining there codes

Please Login or Register  to view this content.

I will use this site to update my thread from those forums.

**romperstomper** · 11-15-2011, 09:30 AM

Either mark this thread solved or comply with the request to add links to your cross-posts, please.

**halogen_bulb** · 11-15-2011, 10:32 AM

cross post:

http://www.ozgrid.com/forum/showthre...d=1#post584512

http://www.msofficeforums.com/excel/...html#post24800

http://www.ozgrid.com/forum/showthre...480#post584480

http://www.access-programmers.co.uk/...61#post1112261

I apologize again, will review the rules.

Summation where range vary using Macro

LinkBack

Thread Tools

Rate This Thread

Display

Summation where range vary using Macro

Re: Summation where range vary using Macro

Re: Summation where range vary using Macro

Re: Summation where range vary using Macro

[SOLVED}: Summation where range vary using Macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions