I have this macro that worked last week now it does not? I am not sure what has changed
Run-time error '1004';
Method'ChangeLink' of object'_Workbook' failed
code:
Any ideas???![]()
Sub ChangeLink() 'Changes Link to Trial Balances Dim OldLink As String Dim NewLink As String Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Woodbury") OldLink = ws.Range("K1").Value NewLink = ws.Range("K2").Value ThisWorkbook.ChangeLink Name:=OldLink, NewName:=NewLink, Type:=xlExcelLinks
Bookmarks