MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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