copy text to specific cell
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? |
copy text to specific cell
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 --- This has no validation at all! If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Tattyfur wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 02:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com