Resetting Variable value's

[vin1]

I got some issue with my code.

Somehow when i run it multiple times the script wil function wrong and diffrent from the 1 time before.

Is there something that will reset all variable values to empty?

i know yo ucan do this manualy in VBA but i want it in code.

Else i have to loop trough all varaible's and put them Empty.
or reopen the workbook but that is not an option for every little change.

[TMS]

It would probably help if we could see the code, ideally in the context of a workbook.

If you "scope" your variables effectively, they should be easy enough to locate and reset.

You should define (Dim) your variables at the "right" level. For example, if a variable is only used within a subroutine or function, define it within that subroutine/function. If it's used across the module, you can declare it outside the subroutines so you can pass information between the subroutines. Public variables have even wider scope.

That said, it is better to avoid widening the scope unnecessarily and you can pass variables between the routines in the subroutine call.

Hope this helps.

Regards