copy text to specific cell

T

Tattyfur

In one cell I have a String And in another cell I have a reference to a cell.
How do I put the String into the referenced cell?
 
D

Dave Peterson

A Formula will return a value to the cell that holds the formula.

You'd need some VBA to do what you want.

dim myStrCell as range
dim myAddrCell as range

with activesheet
set mystrcell = .range("a1")
set myaddrcell = .range("b9")
.range(myaddrcell.value).value = mystrcell.value
end with
 
Top