Thread: mid$ in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Hebb Nick Hebb is offline
external usenet poster
 
Posts: 162
Default 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