Hi,
I have the following problem:
I am using a bigger VBA macro, as a part of this I want to search for a certain code(s) in a cell with multiple codes, and convert the entire cell with a new code/text. For example if a cell contains "NDM TRL WE5 YIC ZAH", I want to search for "TRL" and replace the entire cell with "Trend". And I have 6 other codes like "TRL" which will have to be replaced by other codes/texts..
I hope someone can help me.
This is what I have so far:
Range(Line).Select
ActiveCell.Formula = "=IF(ISNUMBER(SEARCH(""TRL"",$CF1,1)),""Trend"","
Range(Line).Select
Selection.Copy
Range(Range_Line).Select
ActiveSheet.Paste
I have the following problem:
I am using a bigger VBA macro, as a part of this I want to search for a certain code(s) in a cell with multiple codes, and convert the entire cell with a new code/text. For example if a cell contains "NDM TRL WE5 YIC ZAH", I want to search for "TRL" and replace the entire cell with "Trend". And I have 6 other codes like "TRL" which will have to be replaced by other codes/texts..
I hope someone can help me.
This is what I have so far:
Range(Line).Select
ActiveCell.Formula = "=IF(ISNUMBER(SEARCH(""TRL"",$CF1,1)),""Trend"","
Range(Line).Select
Selection.Copy
Range(Range_Line).Select
ActiveSheet.Paste