Thread: Replace vs Application.Substitute
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ski Ski is offline
external usenet poster
  
Posts: 5
Default Replace vs Application.Substitute
When replacing text in cells with lots of text, using Replace() will
return a "Formula too Long" error. If I use Application.Substitute, it
replaces text just fine. Anyone know why? Thanks.

Reply With QuoteReply With Quote