How do I set a number to nothing?

[QuantBurner]

Hi,
I have a loop that goes through a series of files assigning numerical values to variables and pastes the values in another spreadsheet. At the end of each iteration, I want to set the variables to nothing. How do I do that for integers, singles, etc? intMyVariable=nothing doesn't work. I don't want to assign 0, I want a blank in my resulting table.
Thanks!

 

[Juan Pablo González]

You can't. Only objects are assigned Nothing, and Variants can be set to empty. But that's about it. You can test for the last item in the table, and if so, then don't write anything!

 

[QuantBurner]

Thanks for the answer.

The answer is DARN annoying though!!!

I would thunk that there would be a way to set an integer variable back to its unassigned value state.

Thanks for the workaround too.

Cheers

 

[Juan Pablo González]

There's no unassigned state for a number. VBA initializes it to 0.