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]
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]
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ