VBA Programming
 

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





( then print in C(clumnn.

VBA Programming
 

On 31/01/2014 07:49, Ratanlal Mahanta wrote:
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.


--
Regards,
Martin Brown