New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

VBA Macro to sum a variable range

Macros, VBA, Excel Automation, etc.

VBA Macro to sum a variable range

Postby Wither125 » Tue May 17, 2016 4:14 pm

Hello,

I am creating a macro that would calculate the sum from the column(TOTAL_DLR_AM) of the table(calculation) and paste the calculated sum in the next table(Approvals Summary) in the column(Sum).
i am able to calculate the sum but not able to put the calculated sum in the column(Sum).
i would like to know how do i put the calculated sum in the column named sum.


Image
  • 0

Wither125
Rookie
 
Posts: 3
Joined: May 16, 2016
Reputation: 0
Excel Version: 2010

Re: VBA Macro to sum a variable range

Postby NoSparks » Tue May 17, 2016 11:28 pm

What you are referring to as table(calculation), isn't a real table, it's a standard range.
Maybe having a look at this site or this one can assist you with tables.

I've read your post on numerous different forums and don't know what it is you're asking for.

http://stackoverflow.com/questions/3726 ... ied-column
http://www.mrexcel.com/forum/excel-ques ... olumn.html
http://answers.microsoft.com/en-us/offi ... 50/?auth=1
http://software.moftalk.com/vba-macro-t ... SqWwj.html
http://www.excelguru.ca/forums/showthre ... ied-column
http://www.excelguru.ca/forums/showthre ... able-range
and twice at this forum.

i am able to calculate the sum but not able to put the calculated sum in the column(Sum).

You don't have a column(Sum).
You have a cell that contains the word "Sum".
In your original post, your macro put the word "Sum" into that active cell which kind of indicates it doesn't already exist, so my question would be.... what are you asking for?
  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: VBA Macro to sum a variable range

Postby pecoflyer » Wed May 18, 2016 3:10 am

  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: VBA Macro to sum a variable range

Postby Wither125 » Wed May 18, 2016 4:35 pm

Hello NoSparks ,

yes i have a cell named sum. and what i am asking is that i want to put the calculated sum from the column(TOTAL_DLR_AM) into the cell named sum.

Image

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/vba-macro-to-sum-a-variable-range-and-put-the/129d7f81-c59c-4947-957d-7512f155fb50?msgId=9826e261-f457-41e2-9988-b5c7e2bc50fb&rtAction=1463606109619
  • 0

Wither125
Rookie
 
Posts: 3
Joined: May 16, 2016
Reputation: 0
Excel Version: 2010

Re: VBA Macro to sum a variable range

Postby pecoflyer » Thu May 19, 2016 2:14 am

OP has sufficient answers elsewhere. Topic closed
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 32 guests