PDA

View Full Version : Assistance with formula arrangement



Pete
06-26-2008, 12:07 AM
see code
Hi Expert

Need to re-arrange the following fromula (as shown below)

=(('Pricing Demand'!$F145 *
(1-'Shipping BOG'!$F145))
*
'Modelling (Vol)'!$F145)

to

=(('Pricing Demand'!$F145 * (1-'Shipping BOG'!$F145)) * 'Modelling (Vol)'!$F145)

on one line.....easier to read..........in the worksheet

Nothing else..........



.Cells(startrow + 1, curCol).Formula = _
"=((" & _
"'Pricing Demand'!$F" & startrow + 1 & " * " & Chr(10) & _
"(1-'Shipping BOG'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")"

mdmackillop
06-26-2008, 07:23 AM
.Cells(startrow + 1, curcol).Formula = _
"(('Pricing Demand'!$F" & startrow + 1 & " * " & _
"(1-'Shipping BOG'!$F" & startrow + 1 & "))" & _
"*'Modelling (Vol)'!$F" & startrow + 1 & ")"