I Have Following Code not working for Me Please Guide what is my mistake.
I have worrkbook which have sheet name like Annex (1) , Annex (2), Annex (3), ... i want to create macro where in input box i write sheet name and it activate that sheet for the purpose i have created that macro but not working Please guide.
Dim MyVal As String
MyVal = InputBox("WriteSheetName", , "Annex(1)")
'On Error Resume Next