Saving Variables with a Worksheet

[daviddoria]

Is there any way to make a variable that is available again when the sheet is reopened? For example, I do alot of calculations to construct a big vector. I don't want to have to redo those calculations every time the sheet is opened, I'd rather just save the resulting vector and load it each time.

Is this possible?

Thanks,

Dave

[davesexcel]

Check out the formula in Column B in this example, it may get you an idea.
EnterStartDate.xls
Enter a Start date in C1 and all the days remaining in that month will show in column B

[daviddoria]

thanks davesexcel - but I was actually more interested in saving the vector than this particular date application. I'll keep that in mind though that you can simply "add" +1 to a date to get the next date.

Dave

[shg]

You can copy results when the calculation is complete, and paste it as values someplace. Without knowing what you're trying to do, it's hard to be specific.

[daviddoria]

the thing is I don't want these values to be visible. I just want a vector to be accessible via from vba functions but not show up in the actual cells. Is that clearer?

Dave

[shg]

Save it to a hidden sheet.