excel - Storing 1000 cells of formulas into a variable VBA

Question

Hi everyone is there a way of storing range 1000 cells of formulas into declared variable which is variant. Whilst I have been able store 1000 cells which are values into a variable. I am keen to know how you can do this with formulas and formating, large range of formulas using VBA.

标签： excelvba

Answer 1

例如，您可以像使用值一样执行此操作

Dim v As Variant
v = Range("B1:B3").Formula

这将为您提供数组中的字符串形式的公式。

至少我是这样理解你的问题的。