
Originally Posted by
p45cal
direrctly after the line which begins:
newLink = ThisWorkbook.....
try adding the temporary line:
MsgBox IsArray(ThisWorkbook.LinkSources)
and run it.
What does the messagebox say?
Where is this code? (Standard code module? a sheet's code-module? the ThisWorkbook code-module) and in which workbook is it situated? (Let's hope it's not within the Personal workbook.)