FROGGER24
Well-known Member
- Joined
- May 22, 2004
- Messages
- 704
- Office Version
- 2013
- 2010
- Platform
- Windows
I have these two lines of code that I would like to combine so it does not overwrite a cell if it has a value in it
Range("A2:A" & Cells(Rows.Count, 3).End(xlUp).Row).FormulaR1C1 = "=IF(ISNUMBER(SEARCH(""PBO"",RC[3])),""S"")"
Range("A2:A" & Cells(Rows.Count, 3).End(xlUp).Row).FormulaR1C1 = "=IF(ISNUMBER(SEARCH(""VS"",RC[2])),""B"",""S"")"
Thanks in advance
Range("A2:A" & Cells(Rows.Count, 3).End(xlUp).Row).FormulaR1C1 = "=IF(ISNUMBER(SEARCH(""PBO"",RC[3])),""S"")"
Range("A2:A" & Cells(Rows.Count, 3).End(xlUp).Row).FormulaR1C1 = "=IF(ISNUMBER(SEARCH(""VS"",RC[2])),""B"",""S"")"
Thanks in advance