ronjon65
03-11-2012, 04:08 PM
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.
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.