Rationalizing code

**mark-ainsworth** · 04-20-2011, 07:33 AM

Hi,

I'm trying to reduce the following code down to a smaller ammount of code:

Please Login or Register  to view this content.

My guess was something like:

Please Login or Register  to view this content.

Note: c & d have been defined as objects at the start of the code.
N15 = 7, O15 = 14 & P15 = 28

Any idea's?
Thanks,
Mark

**romperstomper** · 04-20-2011, 07:47 AM

Something like:

Please Login or Register  to view this content.

**mark-ainsworth** · 04-20-2011, 07:58 AM

Thanks - could you tell me why my code doesn't work?

**romperstomper** · 04-20-2011, 08:39 AM

In what way does it not work?

Mine should actually be this to replicate your original code:

Please Login or Register  to view this content.

and avoid double counting.

**mark-ainsworth** · 04-21-2011, 03:46 AM

Not quite, if you look at my code - the 2nd two arguments are referring to O17 & P17 respectively, not just N17.

So I have:

Please Login or Register  to view this content.

Can this be reduced further?

Thanks,
Mark

**romperstomper** · 04-21-2011, 03:57 AM

Actually my last should have been:

Please Login or Register  to view this content.

the original version I posted will count some things in two or three groups.

Re: Rationalizing code