Macro to insert link or formula in another sheet
Posted by Jim on April 20, 2001 10:49 AM
What is the best way to insert a link or formula into a specific cell of another worksheet without changing the currently selected sheet and cell?
Thanks for all the help!
Posted by Dave Hawley on April 20, 2001 11:02 AM
Hi Jim
if the link cell reference is absolute you can simply copy it:
=Sheet4!$A$8
No matter where you copy this within the Workbook it will read the same.
Dave
OzGrid Business Applications
Posted by Jim on April 20, 2001 11:11 AM
I should have described this better
From within a macro, I want to take dynamically changing variables (numbers and strings) and plug them into specific cells on another worksheet without changing the selected cell. Is that possible?
Posted by Dave Hawley on April 20, 2001 11:13 AM
In That Case...
Sheets("Sheet1").Range("A1") = Sheets("Sheet2").Range("A1").Formula
Dave
OzGrid Business Applications
