with wkbk3.Sheets(x).Range("D1:D" & lrw)
.FormulaR1C1 ="=abs((RC[-2]-RC[-3])/RC[-2])"
.NumberFormat = "0.00%"
end with

--
steveB

Remove "AYN" from email to respond
"dailo" wrote in
message ...

So I'm tweaking around a little more and I want the delta to display as
a percentage how can I format this line so that it will display as a
percentage instead of a decimal?

wkbk3.Sheets(x).Range("D1:D" & lrw).FormulaR1C1 =
"=abs((RC[-2]-RC[-3])/RC[-2])"

Thanks.


--
dailo
------------------------------------------------------------------------
dailo's Profile:
http://www.excelforum.com/member.php...o&userid=25500
View this thread: http://www.excelforum.com/showthread...hreadid=389444