I have a spreadsheet with 2 buttons on it, and all the code behind the
sheet

I'd prefer it if one particular variable (an array) was "held" at the
end of running button1, before I press button2.

I can use a DoEvents loop so effectively the program stays running, but
I was wondering if there was a better way. It's not a major problem for
me, it just means I'm doing a load of processing I don't really need to
do had the variable still been in memory
--
Mike