I want to rename my 2nd worksheet in my VBA WorkSheets(2) using an input box. I want the user to be able to enter what the renamed sheet name freely. Issue is, I am new to VBA and this isn't as easy as the YouTube videos I watched made it appear.
My current code giving me an error of "Compile Error: Sub or function not defined"
My current code giving me an error of "Compile Error: Sub or function not defined"
Code:
Dim AssetSheet As String
AssetSheet = InputBox("Please designate whether your active asset sheet is GS or AE")
Workshets(2).Name = AssetSheet
