Hi, In Excel 2003 the default option to copy from flitered data was that when you press CTRL + C over the filtered data the visible cells where copyied, in Excel 2007 I have to press F5 do all the procedure, is there any way to make the visible cells copy the default option, like in Excel 2003? I have a lot of Macros from Excel 2003 that use the Selection.Copy instruction to copy the visible cells and the results when running in Excel 2007 are not good. Thanks.
I have this question too.
tsmith1,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks