Hello,
I have a requirement to copy a particular range and paste as link in same sheet. But I'm trying to perform this action from another sheet active, which is a dashboard view.
The idea is to use macro buttons and shows various graphs on click (which updates in another sheets as we click macro buttons.
above code is not working. Please can someone help and fix this.
Thank you very much.
I have a requirement to copy a particular range and paste as link in same sheet. But I'm trying to perform this action from another sheet active, which is a dashboard view.
The idea is to use macro buttons and shows various graphs on click (which updates in another sheets as we click macro buttons.
Code:
Worksheets("View4").Range("A69:T86").Copy _
Destination:=Worksheets("View4").Range("A11"), Link:=True
'ActiveSheet.Pictures.Paste(Link:=True).Select
above code is not working. Please can someone help and fix this.
Thank you very much.