Clear / Empty Variable for next loop
You can't "clear" a non-object variable, you can only set it to a defined value. For a string variable, that's usually the empty string ""
.
lastword = ""
or (identical)
lastword = vbNullString
For object variables, there is Set myObj = Nothing
.
If your variable is not an object you can also do:
lastword = Empty