Thread: Searching for text within formula
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Searching for text within formula
did you put on one line ?


y = Application.Substitute(x, .Range("Current_Function"), .Range("Selected_Function"))


--
isabelle

Reply With QuoteReply With Quote