Runtime error 1004 when copying and pasting a filtered collumn excel 2010

[Shedacq]

Hi i have a macro which worked in excel 2007 but since our company has changed to 2010 i doesnt seem to work anymore.
I keep getting runtime error 1004 "That command cannot be used on multiple selections"

This i get while running following macro part

Please Login or Register  to view this content.

I get the error on the "ActiveSheet.Paste"

can someone please help me.

Thanks

[arlu1201]

You want only the filtered cells to be copied right?

[Shedacq]

Yes i do but it seems that doesnt work

EDIT

IT seems i found the easy solution thanks to your response it was just as simple as that just only selecting the range from B4 and not from B3 as B3 is filter header.

thanks

[arlu1201]

Try this

Please Login or Register  to view this content.