Excel 2003
I have three macros:
Code
Sub Concat()
ActiveCell.FormulaR1C1 = "=IF(RC[-1] > 1,CONCATENATE(""*"",RC[-1],""*""),"""")"
End Sub
Sub InsertLocation()
ActiveCell.FormulaR1C1 = "=IF(RC[-2] > 1, R[2]C[2],"""")"
End Sub
Sub Dupes()
'
ActiveCell.FormulaR1C1 = "=IF(RC[-3] > 1, COUNTIF(C[-3],RC[-3]),"""")"
End Sub
I need to have them excecute automatically once data is enter into a cell in column A:
I've attempted onEvent configurations starting with -
Sub FillScanSheet()
ActiveCell.EntireColumn.Select
If ActiveCell > 1 Then
Application.Run Concat
Application.Run InsertLocation
Application.Run Dupes
End IF
Display More
However I keep getting a circular reference error --
Any help would be greatly appreciated...
While using a scan tool once a scan code is recorded into a cell in column A I would like to have the three macros executed