okay so after running my code i get cells that say 'LUMPLUMP' or 'LUMPLUMPLUMP' and this repeats
i am adding cells together and the columns are mostly numbers but some say lump. so i get some cells that will say LUMPLUMP or more. I have used the following code to fix this problem
but i would like a better way to handle this because it could be possible that a cell contains more lumps added together then what i check for
what i would like is to find any cell that contains the word letters LUMP and then replace the whole cell with LUMP.
anyone know how I could do this? idn if i add wildcards if i could somehow do this.
it will be much more easier to do this then prevent the lumps from being added in the first place because im using a scripting.dictionary to do that.
thanks
JD
Bookmarks