That worked out great actually.I just have to either 1 manually change
the code when I need to change the value I'm looking for perhaps I
should look at having a user input box come up :)
Thank you Paul, a great help and huge time saver (and looks very
easy!)
On Jun 19, 9:29 am, Paul Schreiner
I'm not sure if I understand exactly what you're asking.
In a MACRO, it would be very easy to check the contents of "B",
and if it contains something specific (like 1:22), then clear "A".
Like this:
For I = 1 to 1000
if (instr(1,cells(I,2),"(1;22)") > 0) then cells(i,1) = ""
next I
is that th
