wks.Transform(1, wks.UsedRange.RowCount, "C=C*0.1") wks.Transform(1, wks.UsedRange.RowCount, "D=A+B")