mid$ in VBA
Yes 'Set' is required for the Range assignments. Like I said, the code
wasn't tested - mainly I was trying to point out that creating an array
of search values then using the Find function may be as easier
approach. The Find function code is almost verbatim out of the help
file.
-- Nick
|