Is there a way to release all object variables in a subroutine from the memory. For example: Lets say I have 50 object variables and then at the end of the routine I want to release them all. Is there a way to do that without explicitly setting all the object variables to nothing. Below is an example of the method I currently use.
Name = Range("GroupName") Eff = Range("EffDate") Spec = Range("SpecDed") Spec2 = Range("g35") Spec3 = Range("g36") Set Name = Nothing Set Eff = Nothing Set Spec = Nothing Set Spec2 = Nothing Set Spec3 = Nothing
Thanks for your help!