I dont totally grasp the whole declaring variable part yet but I am getting an object required error on "NewLoc" in my code. I realize this is probably pretty basic but I can figure it out.
Dim myLoc As String, myRng As Range, NewLoc As String
myLoc = InputBox("Enter what you would like to...