Hw to write a macro to calculate values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Akash - 11 Dec 2006 06:40 GMT

I want the following workflow module:

A + B - C = D

A B C D
10 10 05 = 15
20 20 10 = 30
40 60 00 = 100

What would be the Code

Reply to this Message

Martin Fishlock - 11 Dec 2006 08:08 GMT

Akash,

What are you trying to do?

I don't see why you need code for the specified formula of a+b-c.

Signature

Hope this helps
Martin Fishlock
Please do not forget to rate this reply.

> I want the following workflow module:
>
[quoted text clipped - 6 lines]
>
> What would be the Code

Reply to this Message

paul.robinson@it-tallaght.ie - 11 Dec 2006 09:05 GMT

Hi
I can't believe any reader would have any idea what you want here. The
only thing I can think of is that in column D, row 1, you want the
formula

=A1+B1-C1

and copy down for the other rows.

regards
Paul

> I want the following workflow module:
>
[quoted text clipped - 6 lines]
>
> What would be the Code

Reply to this Message

Akash - 11 Dec 2006 10:05 GMT

Dear Paul,

I want the Macros... Not the simple way =A1+B1-C1

I dont know how to write a macros. So thts y i asked u a sime thing to
write a simple macro, so that i could make ammendments and try to use
the same macro for Division, Multiplication, Average, Countif and more
....

Awaiting for ur reply...

Regards

Akash

On Dec 11, 2:05 pm, paul.robin...@it-tallaght.ie wrote:

> Hi
> I can't believe any reader would have any idea what you want here. The
[quoted text clipped - 18 lines]
>
> > What would be the Code

Reply to this Message