Hi The New bee.
I have data like:
A------B-----C----D-----E----F------G H I
1990--1-----------3-------6---------8
1991--1-----------9-------2---------7
1992--2-----------5-------7---------1

Col C will have data diff(G1990-B1991).That means for previous year.
I was trying:
range("c2:c3").formular1c1 = "=RC[4].offset(-1,0) - RC[-1]"
--Not working,Having application error

I will try the following way. But its too long. I need to use a range
and a formula(if possible).
cell(2,3).value = cell(2,3).offset(-1,3).value -
cell(2,3).offset(0,-1).value
cell(3,3).value = cell(3,3).offset(-1,3).value -
cell(3,3).offset(0,-1).value
Thanks in advance
Jesmin


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=492400