• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Paste as link:=True | a quick question

Mr.Karr

Member
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.

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.
 
Hi !

Activate Macro recorder, operate manually for creating link :
you will have your own free code !
 
Back
Top