0d1
11-04-2015, 01:43 PM
Hi!
First of all, unfortunately, I have no experience with visual basic. My first question is rather stupid but for some reason I can't find any explanations or examples for that.
1: How do I use the functions already existing in excel using VBA? For example I would expect
Function bla()
Call IsNumber(3)
End Function
to give me the value "true". Instead it says "#NAME?".
2: I will elaborate on my general goal. Basically I have a set of text segments in column A (each cell contains a text segment). Now let's say I have text segments in row B. For every a_i in A I want to find the set of b's in B that are contained in a_i and put out a string in c_i (in coloum C) consisting of those b's. In pseudo code (for a specific segment in A):
Find Subsegments(Segment)
For i=1 to 10000
If b_i in Segment
Define X_i = C_i
End if
End for
Print "X_1, X_2, X_3, X_4"
Seems like an easy task but the obstacle in 1 is somewhat in the way. If someone has any tips to do this stuff it would be greatly appreciated.
Warm regards.
First of all, unfortunately, I have no experience with visual basic. My first question is rather stupid but for some reason I can't find any explanations or examples for that.
1: How do I use the functions already existing in excel using VBA? For example I would expect
Function bla()
Call IsNumber(3)
End Function
to give me the value "true". Instead it says "#NAME?".
2: I will elaborate on my general goal. Basically I have a set of text segments in column A (each cell contains a text segment). Now let's say I have text segments in row B. For every a_i in A I want to find the set of b's in B that are contained in a_i and put out a string in c_i (in coloum C) consisting of those b's. In pseudo code (for a specific segment in A):
Find Subsegments(Segment)
For i=1 to 10000
If b_i in Segment
Define X_i = C_i
End if
End for
Print "X_1, X_2, X_3, X_4"
Seems like an easy task but the obstacle in 1 is somewhat in the way. If someone has any tips to do this stuff it would be greatly appreciated.
Warm regards.