Hi there,

I am writing some code in Excel VBA, and I need to find the position of a colon in a string variable. I thought I would be able to use the 'find' function to return the position value as I would on a normal worksheet. However, VBA doesn't seem to recognise the function ("Sub or Function not Defined"). I have also checked the help files and there seems to be no mention of it. Could somebody please advise me on an alternative.

Many thanks,

Dave