06-22-2009, 11:36 AM
Hi Ritesh,
First of all sorry for my answer, you are correct 'Nothing' can be used only for Objects.
The solution for issue is here,
You should be Using 'Empty' to free up the memory for a variable
example:
Hope this will solve your problem.
Thanks
Vinod
First of all sorry for my answer, you are correct 'Nothing' can be used only for Objects.
The solution for issue is here,
You should be Using 'Empty' to free up the memory for a variable
example:
Code:
Dim a
a= 120
Msgbox LenB(a)
' this will return 6. LenB means - "The LenB function returns the number of bytes used to represent that string."
' Now memory used by 'a' is 6 bytes.
a = Empty
Msgbox LenB(a) ' This will reture zero which means that the memory used by a is zero
Hope this will solve your problem.
Thanks
Vinod