I'm very new with macros and have been looking for a solution for couple of days now but I have only found very complicated ways to find ALL the possible combinations to reach the target.

Instead I have a column of numbers, any two of which won't sum to same as another pair. I would need to write a macro that would find the pair of numbers that will sum to a target value?

Any help would be appreciated.