Hi,
I have a VBA Array that holds various sentences. I need to know how many words are in the entire array. If this were on a normal spreadsheet I'd use the formula:
{=(SUM(LEN(Test))-SUM(LEN(SUBSTITUTE(Test," ",""))))+COUNTA(Test)}
How would I do this on a VBA array?
Many thanks
I have a VBA Array that holds various sentences. I need to know how many words are in the entire array. If this were on a normal spreadsheet I'd use the formula:
{=(SUM(LEN(Test))-SUM(LEN(SUBSTITUTE(Test," ",""))))+COUNTA(Test)}
How would I do this on a VBA array?
Many thanks