Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is my Code:
Public Var1, MyRange as Range Sub A For c = 1to 10 do Call Sub B Next c end Sub A Sub B Set Var1 = MyRange.Find("Blah", lookat:=xlPart, _ Searchorder:=xlByRows) if Not (Var1 is Nothing) then Debug.print "Var1 exist" end if end Sub B Sub B gets looped 10 times. I run into this problem where if Var1 is found in one iteration, in the next iteration, even though it doesn't refer to any Range, it is not recognized as Nothing anymore. Why is that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variable name question | Excel Discussion (Misc queries) | |||
Question about a Variable being Nothing | Excel Programming | |||
Variable Question | Excel Programming | |||
variable question | Excel Programming | |||
variable question | Excel Programming |