Here is the code i am using:
Code
Worksheets("Costpercust").Select
Range("S:Y").Select
Selection.Copy
Sheets("Report2").Select
Range("A19").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=True, Transpose:=False
Basically S:Y is where data is advanced filtered, so i cannot pick a specific row size e.g. S1:Y2000
I want to copy data in columns S:Y until blank and then paste it A19 on another worksheet. The problem is i cant copy S:Y and paste it at A19 only at A1 i can paste it. Help would be much appreciated