Hi All,

I have a problem or situation. I have excel sheets that have formula
that needs to be changed. I have changed one set and done a copy---
paste special ----- formula. Fine till here.

Now what I want to do is select the range that I have copied the
formula and check if it is in the same format that I require. For
example the formula is say "=If(isblank(A2),"N/A",(C2/E2-D2)).

So, what I need to do is enter the following in a text box :
(if(isblank(xx999),"N/A",(xx999/(xx999-xx999)), where xx represents any
column from A to IV and 999 be a row from 1 to 65536. Is this possible?

Any help will be highly appreciated. Or else i have to check the 27
sheets with 400 formulae in each sheet manually :-(.

Regds