I am trying to copy and paste a the contents of a named range. The following code seemed a possibility but it doesn't work.
Sub trial()
Range("TapeBudgetA_Formulas2").Copy Destination:=Sheets("Utilities").Range("E32")

End Sub
If I use an ordinary range say ("A2:A30") it does work.
Where am I going wrong?
John