to clarify - the name MonthSales is a local name for the worksheet
'London'. It is defined above in my first post. I am referencing it
in another worksheet called 'Summary'.

could the problem be because the name effectively returns a value and
not a reference?