Macro code for 3 case

[turist]

I have the below code.(in my worksheet VBA page)

Please Login or Register  to view this content.

in D6:D75 numbers to be input.
From G6:G75 this numbers to be calculated.

With this code only D6:D75 range is working at G6:G75 area. E6:E75 and F6:F75 Targets does not run with D6:D75 together.

I want to run for three case at G6:G75 range.

What is missing or wrong in this case?

Anyone can correct the logic of the code, or new one?

Thanks in advance for any reply and help.
Regards,
turist

[Olly]

Try:

Please Login or Register  to view this content.

[turist]

Try:

Please Login or Register  to view this content.

Thanks for reply.
But 3rd condition was:
[CODE]If Intersect(Target, [f6:f75]) Is Nothing Then Exit Sub
Target.Offset(0, 1) = -Target + Target.Offset(0, 1)

How can you fix the code if this condition exist? ( İn F column numbers will not be added, will be excluded at G column as (-) )

[slx]

Use "Else If" for the concurrent if statements.

[slx]

Use "Else If" for the concurrent if statements.

Please Login or Register  to view this content.

[turist]

Use "Else If" for the concurrent if statements.

Please Login or Register  to view this content.

Thanks for reply , but NOT WORKING.

[Olly]

How can you fix the code if this condition exist? ( İn F column numbers will not be added, will be excluded at G column as (-) )

Try:

Please Login or Register  to view this content.

[turist]

Try:

Please Login or Register  to view this content.

Dear Olly,

Thanks a lot for your solution.
Regards and rep.
turist.