Hallo! I have a workbook with multiple worksheets.

Is there a vba so i can extract the formula with values from a cell.

eg. lets say there are 2 worksheets: 1 and 2.

A1 in worksheet 1 has a formula that gives as a result 1 and

A1 in worksheet 2 has a formula that gives as a result 2


a formula in a cell in worksheet 2 is: = 1!A1 + A1, so i want it to display: 1+2

Is there a vba that works like that?