combination

Hi, I have a columns labelles A B C D E under which are numbers. Is
there a way, in combinations of 3, to work out all the possible
combinations that = a certain total using vba.
eg, ABC, ABD, ABE......ETC. At the momment Im using varaiables and
simply saying x = a + b + c....etc. Then taking the variables and
finding which ones = my target. Thought Id ask incase somebodys already
done this.
Regards Robert

See:


http://www.microsoft.com/communities...2-b6a19c6fc282
--
Gary's Student


"RobcPettit@yahoo.co.uk" wrote:

> Hi, I have a columns labelles A B C D E under which are numbers. Is
> there a way, in combinations of 3, to work out all the possible
> combinations that = a certain total using vba.
> eg, ABC, ABD, ABE......ETC. At the momment Im using varaiables and
> simply saying x = a + b + c....etc. Then taking the variables and
> finding which ones = my target. Thought Id ask incase somebodys already
> done this.
> Regards Robert
>
>

Thankyou fpr your reply, very usefull.
Regards Robert


Gary''s Student wrote:
> See:
>
>
> http://www.microsoft.com/communities...2-b6a19c6fc282
> --
> Gary's Student
>
>
> "RobcPettit@yahoo.co.uk" wrote:
>
> > Hi, I have a columns labelles A B C D E under which are numbers. Is
> > there a way, in combinations of 3, to work out all the possible
> > combinations that = a certain total using vba.
> > eg, ABC, ABD, ABE......ETC. At the momment Im using varaiables and
> > simply saying x = a + b + c....etc. Then taking the variables and
> > finding which ones = my target. Thought Id ask incase somebodys already
> > done this.
> > Regards Robert
> >
> >