Sounds like usinput refers to a formula somewhere in it's string

[VBA]Sub test()
MsgBox Names("usinput").RefersTo
'If the return is too long
'NewSheet.Range("A1") = "'" & Names("usinput").RefersTo
End Sub
[/VBA]