In excel i have different number from lets say 10 to 200 in random basis from cell a1 to a100. I have a number in b1 which is say 20. Now i want to know if i start from cell a1 to a100 which number comes early (b1- 2, or b1+2) i.e. 18 or 20. Now whichever number comes early i want it at cell c1.
Please provide a customized vba so that it can be used for other cell ranges. i.e instead of a1 to a100 can be used for g5 to g200 etc.
Please provide a customized vba so that it can be used for other cell ranges. i.e instead of a1 to a100 can be used for g5 to g200 etc.