Simple Question - Resetting a range variable.

[mmetzinger]

So I have the following code

dim FoundCell as range
    Set FoundCell = Columns("Q").Find(What:="F", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False)

some code later the range value is populated

What i need is that after I utilize this variable I need to reset the variable to null but i can't figure out the context. I do not want to clear the contents of the range only reset the variable to null.

Thanks,

 

[vaskov17]

set foundcell=nothing

 

[VoG]

Try

Set FoundCell = Nothing

 

[mmetzinger]

Thanks! That worked great.

 

[shg]

Not sure why you'd need to do that -- the Find statement will assign Nothing to the range variable if it fails, irrespective of its prior value.