Frankinstyyn
New Member
- Joined
- Feb 21, 2019
- Messages
- 14
Hi all,
I'm after some code which will check a range and run a Sub if any where in the cell it show 2 DAY(S) or above, if not run a different sub.
The overall idea is to have code that checks between 2 parameters, if '2 DAY(S)' or above appears, show the rest of the information in that cell.
For example, cell A14 says "2233 FORUM5 INBOUND SALES NOT RETRIEVED FOR 2 DAY(S)" I would like the code to check the whole cell and identify that it says '2 DAY(S)' which will then run a sub.
If it checks the cells and there is no '2 DAY(S)', then move onto the next cell within the range. If it cannot find any '2 DAY(S)' or above then run a specific sub.
I hope that makes sense!
Thanks in advance.
I'm after some code which will check a range and run a Sub if any where in the cell it show 2 DAY(S) or above, if not run a different sub.
The overall idea is to have code that checks between 2 parameters, if '2 DAY(S)' or above appears, show the rest of the information in that cell.
For example, cell A14 says "2233 FORUM5 INBOUND SALES NOT RETRIEVED FOR 2 DAY(S)" I would like the code to check the whole cell and identify that it says '2 DAY(S)' which will then run a sub.
If it checks the cells and there is no '2 DAY(S)', then move onto the next cell within the range. If it cannot find any '2 DAY(S)' or above then run a specific sub.
I hope that makes sense!
Thanks in advance.