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 & ")"
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 & ")"