I must set up an extra column that only contains values--values that
are equal to calculated values from another column. This has to be
done in VBA and not a regular formula (the column must contain
values--not formulas). I've tried...

Range("NameValues").Value = Range("NamesConcatenated").Value

The problem is that the NameValues must be updated after worksheet
change.

However, this is creating a never-ending 'filling cells' process. When
forced quit (Error 1004) the data values, however, are in the
NameValues column--so it's partially working--can this work?

Any help would be incredibly appreciated.

Eric