Workbooks("q").Activate
Range("c16").Copy
Workbooks("w").Activate
Selection.PasteSpecial@ ActiveCell.Offset(0, 1).Activate

The above code works copying values from one sheet and pasting them in another, i however have a problem with formulas. I tried the xlpastevalue fxn but it does work, can someone help me or even write a better code for me? URGENT!!!