Paste Values using Selection feature

 Workbooks(“q”).Activate

    Range(“c16”).Copy

    Workbooks(“w”).Activate

    Selection.PasteSpecial@ ActiveCell.Offset(0, 1).Activate

code works but doest apply to cells with formulas, selection doesnt allow xlpastevalues

By: Kwame duah

Leave a Reply

Your email address will not be published. Required fields are marked *