Store formulas in range into array

Hi All,

I am try to store the formulas in a certain range into an array, in order to paste them again at some point later.

This is what I am trying to do and I get a run-time error '13' Type mismatch. (it is only part of the code, I didnt want to include everything)

Please Login or Register  to view this content.

So, not all the cells in the range have a formula. Some have numbers or blanks. I read in the excel help that Range.Formula object should deal with nonformulas.

Any ideas?

Thanks.

I think I solved the problem by looping over the rowns and columns of the array and inserting the formulas one by one. I cannot pass the Range all at once.