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

Are you saying you want this in C something?

=G1990-B1991

"jesmin" wrote in
message ...

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

Hi: I want to deduct the data in col. B from data in col. G and then put
the deducted result in col C. But col B data of 1991 will be deducted
from col G data of 1990. For example:

cell(2,3).value
= cell(2,3).offset(-1,4).value - cell(2,3).offset(0,-1).value
A------B-----C----D-----E----F------G H I
1990--1----------3----------6-------8
1991--1----------9----------2-------7
1992--2----------5----------7-------1

I want to do it with a range and formula. Something like:
range("c2:c3").formular1c1 = "=RC[4].offset(-1,0) - RC[-1]"
Thanks


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