why is copy and paste so tricky with vba?

[ajm]

maybe its just me? anyhoo, i have a routine which opens another workbook, moves the data around and adds an autofilter. It should then copy the autofiltered range back to my source workbook.

With ESMwb.ActiveSheet.AutoFilter.Range
    .Offset(1, 0).Resize(.Rows.Count - 1).Copy
    Sourcewb.MainWS.Range("A" & LastRow + 1).PasteSpecial
    End With

I get "Run-time error 438: Object doesn't support this property or method" on the Sourcewb.MainWS... line

what is the correct syntax please?

 

[Michael M]

@ajm....so it works now ???

 

[ajm]

@ajm....so it works now ???

sorry Michael. Yes it does. I have to do some reading (in all my spare time!....) on the when to use what with copy and paste. Its my achilles heel for some reason. thanks all for your help.

 

[Michael M]

yeah, I agree copy / paste special.....always used to do my head in....