Sum using named range

[ManUBlueJay]

I would like to be able to sum a named range in VBA. I tried the following but it comes back with a 0 value

Application.WorksheetFunction.Sum(Range("MYRange"))

 

[ManUBlueJay]

I would like to be able to sum a named range in VBA. I tried the following but it comes back with a 0 value

Range("Al") = Application.WorksheetFunction.Sum(Range("MYRange"))

 

[DanteAmor]

What do you have in MyRange?

Range("Al")

There you have a letter 'l' and you should put the number 1.

If in myRange you have numbers then this should work:

Sub test()
Range("A1") = WorksheetFunction.Sum(Range("MYRange"))
End Sub

 

[ManUBlueJay]

5 cells of numbers.
In excel proper =sum(myrange) returns the correct sum

 

[DanteAmor]

Did you copy and test the code from post #3?

 

[ManUBlueJay]

That was a typo when I posted the formula.
Your suggestion doesnt work. for me. It returns a 0. When I do an immediate check it also returns zero

 

[MARK858]

Is the sheet that the named range is on the activesheet when the code is ran?

 

[ManUBlueJay]

Yes

 

[ManUBlueJay]

There must be something wrong with my file.
I tried your suggestion in a brand new workbook and it works fine

 

[MARK858]

Try it in the file that isn't working specifying the sheet name in the code.