kylefoley76
Well-known Member
- Joined
- Mar 1, 2010
- Messages
- 1,553
I'm trying to loop through what I call sentences. Below the find_sentences2 function will identify the sentences that compose an active cell. So
(xHy) & (xHz) & (bHc)
The find_sentences2 will store the above 3 sentences between parentheses into an array. I can't figure out how to loop through it. Till now, I've just been putting a number between the parentheses after atomicsent which will identify which sentence I'm analyzing.
(xHy) & (xHz) & (bHc)
The find_sentences2 will store the above 3 sentences between parentheses into an array. I can't figure out how to loop through it. Till now, I've just been putting a number between the parentheses after atomicsent which will identify which sentence I'm analyzing.
Code:
Dim input3 As Variant
dim input1 as string
input1 = activecell.Value
atomicsent = find_sentences2(input1)
input3 = atomicsent()
For Each input3 In atomicsent
(code)
Next