Hi all, is it true that copy, destination and paste special don't work together???
i'm trying to put them all together in my code but i get errors all the time..... i wanted the code to just paste only the value of copied range(B10:S10) into a single starting cell (A1) instead of using A1:A10.
My codes:
Thanks you.Set rng = wb.Worksheets(Sheet1).Range("B10:S10") rng.Copy Destination:=Range(A1).PasteSpecial(xlPasteValues