Saving Variables with a Worksheet

**daviddoria** · 12-26-2008, 10:31 AM

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** · 12-26-2008, 11:06 AM

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** · 12-26-2008, 06:10 PM

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** · 12-26-2008, 06:14 PM

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** · 12-26-2008, 06:17 PM

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