Error Declaring Variable... Simple

[buzz71023]

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 search for.", "Search", "Enter Here")

Cells.Find(what:=myLoc, LookIn:=xlValues).Activate

Set myRng = ActiveCell.Offset(0, -1) 

Set NewLoc = myRng.Value

 

[Jonmo1]

NewLoc is Dimmed as String, so try removing the 'Set' from
Set NewLoc = myRng.Value

 

[buzz71023]

Perfect... Thank you for the quick response. One question. Do you not have to "Set" string variable types?

 

[Jonmo1]

That's correct.

Set is for Objects like Ranges / Sheets / Books

 

[James Snyder]

Non-objects like strings, numbers, etc are assigned directly.

newLoc = "your string here"

 

[buzz71023]

Thanks again.

 

[Jonmo1]

You're welcome.

 

[buzz71023]

Thanks James.. That helps clear some of this up.