Thread: How can I use the worksheet function FIND in VBA or is there a FIN
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kurt Kurt is offline
external usenet poster
  
Posts: 47
Default How can I use the worksheet function FIND in VBA or is there a FIN
Hi everyone!

I'm trying to parse of a string from a cell in VBA.
I need to go thru one sheet "find" a sub-string within a cell and if it's
there copy that
row into a different sheet.

I tried using =IF(FIND("C2PC",G101),"yup","nope"), but I get an error.
I can't "find" a FIND in VBA.

Please help.
Regards, Kurt
Reply With QuoteReply With Quote