Excel VBA Check if Postal code falls within Postal Code Range

Re: Excel VBA Check if Postal code falls within Postal Code Range

I've been looking for something like this for some time. This is awesome, but I need the returned value to be accessible so I can then add it to another number. How do I change the macro so that it just leaves that number in a cell that I can cross reference from another workbook?

Re: Excel VBA Check if Postal code falls within Postal Code Range

Hi Jindon,

I have the same question as the one above - but wanted to know it there was a possibility to put the zone (A,B,C) next to the postal code in the column next to it (rather than having a box give out the answer)?

This way, I can simply copy paste both columns with the postal code and the range it falls in.