Return named range with vba

[Sir Babydum GBE]

Hi

This isn't working:
[vba]wsR.Cells(iRow, 4).Value = mySite[/vba]
what i want to do is return the contents of the cell i've named "mySite" (as a named range in the workbook) to the destination cell.

This just returns a blank

How do I write it correctly please?

[mvidas]

SBD

[vba]wsR.Cells(iRow, 4).Value = Range("mySite").Value
'or
wsR.Cells(iRow, 4).Value = wsR.Range("mySite").Value[/vba]

[Sir Babydum GBE]

SBD

[vba]wsR.Cells(iRow, 4).Value = Range("mySite").Value
'or
wsR.Cells(iRow, 4).Value = wsR.Range("mySite").Value[/vba]

I feel very daft at the moment.

Thanks!