sheet selection from an input box - Thank you
Hi Gary, that was awesome, so easy and works perfect. Thank you so much
"Gary''s Student" wrote:
Sub sheet_picker()
Dim s As String
s = Application.InputBox(prompt:="enter sheetname:", Type:=2)
Sheets(s).Activate
End Sub
--
Gary''s Student - gsnu200811
|