sum of a range in a variable in excel 1

[sunnytahir]

to anyone who knows best.
i want to sum a range in excel (in a variable) not in excel cell.
thanks.

 

[PHV]

Try something like this:
myVar = Application.WorksheetFunction.Sum(myRange)

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sunnytahir]

Dear phv,

This function does not work.

I have some values in Column A

I want to get the total of ( A1 to A5 ) in a variable.

Thanks in advance.
sunnytahir

 

[sunnytahir]

Dear phv,

This function does not work.

I have some values in Column A

I want to get the total of ( A1 to A5 ) in a variable.

Thanks in advance.
sunnytahir

 

[Loomah]

sunnytahir
What PHV is suggesting is replacing myRange with whatever your range is so in your case

myVar = Application.WorksheetFunction.Sum(Range("A1:A5"))

should do the trick

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[TonyJollans]

Hi sunnytahir,

This function does not work

Well, this function does work. If what you have done doesn't work, we would be better able to help if we knew what you had done.

The Worksheet Sum Function can take a Range as an argument; my guess is you gave it a string, so try this ..

[blue][i]VariableName[/i] = Application.WorksheetFunction.Sum(ActiveSheet.Range("A1:A5"))[/blue]

.. and if you have trouble making this work, please post exactly what you have coded, and where.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.