J
jesmin
Hi There: 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 rang
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
Jesmi
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 rang
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
Jesmi