Hi I am trying to set a macro using VBA so when I close excel there is a certain range of cells that I need to make an array with but they all have differing formulas
ex c1 could have =sum(a1:a3) + 5
while b1 could have =sum(a1:a3)*2
Is there a way to use the formula array to pick up just the beginning of the formula so just =sum(a1:a3) then have it array the rest based on the length?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Range("B1:D1").FormulaArray = THIS IS THE PART WHERE I DONT KNOW WHAT TO PUT"
End Sub
Thank you
Bookmarks