Ok lets look at the FIND syntax then. In financial analysis we can use this function to locate specific data. But in VBA we need to write a function to find the content we are looking for.
Based on the Excel spreadsheet above the following FIND examples would return.
Here is the structure of the FIND function. If you dont want to do a case sensitive search or use wildcard characters you can use SEARCH and SEARCHB. Find any text in Excel. The function will return the position of a specified character or sub-string within a supplied text string.