loop through selection to find and replace while catching ex

[cavand]

I am trying to create a macro to replace specific text in excel cells. The macro I've created works fine except for certain cells where I get the message 'Formula is too long.' The message appears when I try to find and replace on cells that have a lot of text in them (>1000 characters). Do you have any suggestions for either a way to handle these cells (ideally) or a way to skip over the cells that have too much text? Thanks in advance.

 

[jimboy]

How about switching off alerts;

Application.DisplayAlerts = False

or something like;

If Len(ActiveCell) > 50 Then