I have a worksheet with 100 rows. Each row has many formulas referring
to 100 (closed) Excel files. The filenames look like
'??-???????-???.XLS'. So in each row there are strings in the formulas
that look like this [??-???????-???.XLS], different for each row.

I now need to change the formulas to refer to 100 new Excel files. Same
naming scheme, different characters. Manually, I can select the first
row and search for the '[??-???????-???.XLS]' string and replace with
the correct, new string. Then go onto the second row, search for the
same generic '[??-???????-???.XLS]' string and replace with the 2nd new
filename.

But what if I put the 100 new filenames in column A. Is there a way to
do a Find & Replace for the generic string [??-???????-???.XLS] on each
row and replace with the appropriate values from column A. Kindof a
dynamic Search and Replace?

Thanks for any suggestions...
-Paul Cross