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
I get the error on the "ActiveSheet.Paste"
Please Login or Register to view this content.
can someone please help me.
Thanks
You want only the filtered cells to be copied right?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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
Last edited by Shedacq; 08-14-2012 at 06:05 AM.
Try this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks