Is there a way to free up the memory used by the variables during run time?

[ursvinod]

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:

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