mmetzinger
Board Regular
- Joined
- Dec 30, 2010
- Messages
- 61
So I have the following code
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,
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,