hi guys ive been using this code before to paste a data that i copy, but now im doing a new project it suddenly not work and give me error of
PasteSpecial method of Range class failed
im so confused right now. thanks
PasteSpecial method of Range class failed
im so confused right now. thanks
VBA Code:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False