EXCEL USER-DEFINED FUNCTION USING EXCEL TEXT FUNCTION
Posted by John Walker on September 19, 2001 11:31 AM
I tried creating a user-defined function in Visual Basic using some of the text functions in Excel. I wanted to create the following:
Function Whatever(TextDelim, CellText)
Whatever = Right(CellText, Len(CellText)-Search(TextDelim, CellText))
I get an error concerning the non-existence of the worksheet function "Search." I can write a function using "Right" and "Len" but not with "Search," even though Search is a legitimate Excel text function. What gives?