cache storage in Excel Custom Function

Viewed 41

I want to store my searched values in key and pair in excel custom function. and when I search again with the same value it should return from the cache storage. How can I do that?

When I use office runtime storage it shows me error that is "wrong data type". Except officeruntime storage is there any other way to storage the value in cache storage?

0 Answers
Related