title: Is there any way to check if what i'm adding to the value of a cell is already in the cell?
body: <p>So I have multiple macro's that input value's into the cells in a workbook. This is the relevant part that I'm having trouble with:</p>
  
  <pre><code>If wsCsh.Cells(cshrow, cshcol) = "" Then
        Cells(cshrow, cshcol - 1).FormulaR1C1 = "='WREG'!R" + CStr(wregrow) + "C" + CStr(wregcol)
  Else
        Cells(cshrow, cshcol - 1).FormulaR1C1 = Cells(cshrow, cshcol).FormulaR1C1 + "+'WREG'!R" + CStr(wregrow) + "C" + CStr(wregcol)
  End If
  </code></pre>
  
  <p>If the cell(cshrow,cshcol) is empty, it enters in the R1C1 formula to link it to the cell(wregrow,wregcol), if it isn't then it adds cell(wregrow,wregcol) to whatever is in the cell. However, say I run this macro twice in a row. Then it will basically add cell(wregrow,wregcol) to the cell twice so cell(cshrow,cshcol) ends up looking like "=cell(wregrow,wregcol)+cell(wregrow,wregcol)". How can I check if a cell is already referenced in the R1C1 formula so I can avoid adding the value a second time?</p>