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]

The fault must be in the underpinning of MyRange. It has the code =OFFSET(A3,0,0,1,6) to give me 6 col wide range