I have created a funtion in Excel VB
Public Function endid(var1 As String)
varlen = Len(var1)
startpar = InStr(var1, "("
endpar = InStr(var1, "
"
idlen = endpar - startpar
endid = Mid(var1, startpar + 1, idlen - 1)
End Function
Workbook
cell a1 = Security Update for Microsoft Windows XP (KB328940)
cell b1 = +endid(a1)
I get an error in cell b1 #name?
I want to pass the contects of a cell and pull the data that is in between the parentheses. If I fill in var1 with data and step through it works and pull the info I want.
Thanks
DDNWOLFF
Public Function endid(var1 As String)
varlen = Len(var1)
startpar = InStr(var1, "("
endpar = InStr(var1, "
idlen = endpar - startpar
endid = Mid(var1, startpar + 1, idlen - 1)
End Function
Workbook
cell a1 = Security Update for Microsoft Windows XP (KB328940)
cell b1 = +endid(a1)
I get an error in cell b1 #name?
I want to pass the contects of a cell and pull the data that is in between the parentheses. If I fill in var1 with data and step through it works and pull the info I want.
Thanks
DDNWOLFF