I have some code that finds the value based upon a counter, such as:

Cells(10, 10) = Cells(CounterA, ColumnA)

...Lets say CounterA=1

I want Cells(10,10) to actually be "=A1", rather than whatever value was contained when it was run. Any ideas? For some reason, I thought I did this before, but can not find the code to do it.