Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing formulae links
I am copying formulae from an old version of a template, into a newer
one, using a macro. Unfortunately, when the macro copies over the formulae, it references them to cells in the old worksheet, not the new one. I know I could use : ActiveCell.ChangeLink Name:= _ "old template", NewName:= _ "current/new template", Type:=xlExcelLinks But the problem with this is that it changes links for the whole workbook. While I do want to change the links in some cells, I also want to keep them for others. Is there any VBA code to change links individually for cells? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing formulae links
select the cells, then do Edit=Replace
old link string new link string -- Regards, Tom Ogilvy " wrote: I am copying formulae from an old version of a template, into a newer one, using a macro. Unfortunately, when the macro copies over the formulae, it references them to cells in the old worksheet, not the new one. I know I could use : ActiveCell.ChangeLink Name:= _ "old template", NewName:= _ "current/new template", Type:=xlExcelLinks But the problem with this is that it changes links for the whole workbook. While I do want to change the links in some cells, I also want to keep them for others. Is there any VBA code to change links individually for cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing formulae to their value | Excel Discussion (Misc queries) | |||
How do I save 2 linked spreadsheets and update links in formulae | Excel Discussion (Misc queries) | |||
How do I save 2 linked spreadsheets and update links in formulae | Excel Discussion (Misc queries) | |||
Changing the row and column in R1C1 formulae | Excel Programming | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) |