Paste Special within If Statement

Hi, I have read through a few posts and online searches on how to get Paste Special to work with into an IF statement.

This is what I have constructed (which doesn't work). I have tried adding code to the end of the if statement as suggested to me but the IF statement doesn't like that.

Any help greatly appreciated

Jon

Please Login or Register  to view this content.

Hi Jon,

You can't use Copy and PasteSpecial on the same line. It needs to be two separate operations. However it looks as though you are pasting everything anyway so PasteSpecial is not required. If that is indeed the case then all you need is this:

Please Login or Register  to view this content.

Hi,

Please remember to add code tags to your code as per the forum rules. I've added them for you this time but not for the next time.

What sort of PasteSpecial action are you wanting? In general the .PasteSpecial instruction needs to be followed by a modifier. e.g.

Please Login or Register  to view this content.

assuming it values that you are wanting to paste. Or maybe (xlPasteAll)..

If you do require pastespecial, then it must be two separate operations:

Please Login or Register  to view this content.

Yes, sorry. Doing it that way it should have been on two lines

Worksheets("table").Range("B3:bn3").Copy
Worksheets("import_table").Range("A2:BM2").PasteSpecial(xlPasteValues)