Formula is too long

[pnjfksx]

I have some rather large cells where I am trying to replace some character strings using a macro. When I use something like

Selection.Replace "<.p>", " "

I get this error

Run-time error '1004': Formula is too long

I have already cut the characters down to 1500 in any cell, but I am still getting a runtime error on some cells. Is there anyway to anticipate this error and keep from manually intervening?

Thank you,

 

[Damon Ostrander]

Hi pnjfksx,

I seem to remember running into this problem some time ago. I believe that you have to break the cell contents into 1024-character blocks and process each block separately. This means that it is probably best not to try to do the replacement in the cell directly, but rather load the text into a string variable and do the replacement there. Then load the text from the string variable back into the cell. And I believe that you will have to do the operations that load the text to and from the string variable in 1024-character blocks.

Damon