I have looked at examples of Select Case VBA on the web and tried to modify them to suit my purpose but so far no joy.
Could anyone point me in the right direction?
I am trying to call a macro if a range of pre - selected numbers appear in cell A1.
Lets say those numbers are 3,6,9,12. If any of those numbers appear in cell A1 then the required macro would be called.
Any help would be appreciated
Could anyone point me in the right direction?
I am trying to call a macro if a range of pre - selected numbers appear in cell A1.
Lets say those numbers are 3,6,9,12. If any of those numbers appear in cell A1 then the required macro would be called.
Any help would be appreciated