How do I overcome limitations in Find-Replace?
 

Hi,

I have something like a document in an Excel Workbook. I have placeholders
in the contents of cells. I need to find each of these and replace them
using VBA. I am facing
problems with limitations in Excel

1) Find - Replace will not work in cells with large amount of text.

2) If some characters of a cell are formatting in a different way (say
bolded or italicised), then Find -Replace changes the formatting.

3) The cells are merged and text is warpped. After the replace is done, I
want the cells to accomodate the new length so that all characters are
visible. Autofit does not seem to help in this case.

I have tried using textboxes instead. Here text wrapping is not a problem.
And I got the Find-Replace to work. But couldn't get the text formatting to
stay as is.

I can send the workbooks if required.

Please help me find solutions or work arounds to these problems.

Thanks,
Priya