Unset UDA in a variable.

Hi all,

I have created a small macro, where I am extracting 10 nos

of pipe UDA in 10 variable.

To extract this for bulk of pipe I have used DO loop.

My issue is, let's assume any 1 UDA in undefined in pipe 3  then in report I am not getting unset , it's giving me previous pipe 2's data in Excel.

So i want to reset all the variable after each pipe in do loop , so that it will not take previous pipe data.

Please suggest how do this.

Parents Reply Children
No Data