View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Like, with worksheet- UDF?

You cannot perform a worksheet operation on a cell from within a function,
with or without Like.

--

HTH

Bob

"Steve" wrote in message
...
Howdee all.
Has anyone ever made a UDF, for Like, to use in a worksheet function?

I.e., look at a string of text in a cell, and see if a given format
exists,
to then perform a worksheet operation on that cell's contents, based on
its
matching the like operator?

I swear I remember a discussion like this before, but I can't find it.

I am aware that it's not a standard worksheet function. Hence the UDF.