ExcelBanter - Evaluating (splitting out) a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Evaluating (splitting out) a formula (https://www.excelbanter.com/excel-programming/416343-evaluating-splitting-out-formula.html)

meldrum_scotland

Evaluating (splitting out) a formula

Hi,

If there was a formula in cell A1 of the following: =offset(C1,1,1) +
G1 * sheet2!A1

I would like to (using VBA) determine the number of elements in the
formula. So for the above formula the evaluating would be:

Parts: 3 (1=offset(C1,1,1), 2 = G1, 3=sheet2!A1)
Elements: 5 (C1, 1, 1, G1, sheet2!A1)
Ref Elements:

All times are GMT +1. The time now is 05:27 PM.