Hi I need some to help me to remove the 2 input boxes in below code.
Myval have to be :21:*
MyCol the range have to be from A2 to last used row(will be blanks between, but shall not change them.)
Please have a look. If its possible to make so Myval can be with 3 inputs like this, it will be optimal. If so they have to run one by one in below order.So the code first run with :21:* and then further on
Please have a look have been clumcy around in this some timem, so would like some help.
thanks in advance