String Deleting

[McCoy]

Hi

Can someone tell me a way to delete strings in Visual Basic once the Sub
Function is complete

Thanks

 

[Brendan Reynolds]

If the variable is declared within the procedure, without using the Static
keyword, it is disposed of automatically when the procedure exits.

If you really want to, you could assign the empty string to the variable
before exiting the procedure (strMyStringVariable = vbNullString) but there
really isn't any point.

VB/VBA are not like C/C++, where you need to worry about allocating and
freeing variable memory. VB and VBA take care of most of those issues
automatically.