PDA

View Full Version : Solved: just values insted formula



white_flag
12-09-2010, 01:56 PM
Hello,

I have an line really long, something like this (result from VBA):
ex:

=(PI()*(2*I$11+$B15)/1000*(0.276)+0+PI()*(2*I$11+$B15)/1000*I$11/1000*0+19.74*(1-50/100)*(1+20/100)+7.5/60*36.5+(PI()*(2*I$11+$B15)/1000+0.05)*INDEX(cladding,1,1)*(1+5/100)*(1+10/100)+INDEX(m_cla,MATCH($B15,Data!$C$50:$C$70,1),IF(ISNA(MATCH(I$11,Data!$C$ 50:I$50)),1,MIN(IF(ISNA(MATCH(I$11,Data!$C$50:I$50,0)),MATCH(I$11,Data!$C$5 0:I$50)+1,MATCH(I$11,Data!$C$50:I$50,0)))))/60*36.5*1+INDEX(prefab,IF(ISNA(MATCH((2*I$11+$B15),Data!$AC$5:$AC$13)),1,MI N(IF(ISNA(MATCH((2*I$11+$B15),Data!$AC$5:$AC$13,0)),MATCH((2*I$11+$B15),Dat a!$AC$5:$AC$13)+1,MATCH((2*I$11+$B15),Data!$AC$5:$AC$13,0)))),2)*1)*1


how can be done, that in excel, to have only the values?
Application.Evaluate - I guess it is not going here.

thank you

Bob Phillips
12-09-2010, 02:57 PM
Do a Copy>Paste Values

white_flag
12-10-2010, 01:02 AM
thx, Bob

I used in the end this


.Value = .Value

Bob Phillips
12-11-2010, 06:08 AM
Same effect mate :)