VBA Programming

[Ratanlal Mahanta]

HI All,
I have problem how to add two cell using VBA code.
Problem details
Suppose in Excel file
A B C D E
1 -1 1
2 -2
3 -3
4 -4
-3 3
-2 2
-1 1

Find the value of when Sum is greater than 1 if A(1,)+B(1,)=1,or A(1,)+B(2)=1,or A(1)+B(3).... or A(1)+B(7)=1,
A(2)+B(2)=1.....A(2)+B(7)=1..........or A(7)+B(7)=1.I want to print the value in C when the sum of two value is greater than 1.Please send the suggestion and solution of the problem If you have any query , Please revert me back .

Thanks Advance.

Thanks Regards
Ratanlal Mahanta
email:[email protected]




( then print in C(clumnn.

 

[Martin Brown]

HI All,
I have problem how to add two cell using VBA code.
Problem details
Suppose in Excel file
A B C D E
1 -1 1
2 -2
3 -3
4 -4
-3 3
-2 2
-1 1

Find the value of when Sum is greater than 1 if A(1,)+B(1,)=1,or A(1,)+B(2)=1,or A(1)+B(3).... or A(1)+B(7)=1,
A(2)+B(2)=1.....A(2)+B(7)=1..........or A(7)+B(7)=1.I want to print the value in C when the sum of two value is greater than 1.Please send the suggestion and solution of the problem If you have any query , Please revert me back

Sounds like basic homework. Show us your attempt to solve it first.