Hello,
I am writing a macro to filter a bunch of data. One of the data sets has hyperlinks. I want to do an advanced filter, but when I do a filter xlFilterCopy the hyperlinks on the new sheet don't work. Is there a way keep the hyperlinks intact while they area being copied to the new sheet.
Thanks,
BTW Here's my code (If it helps :P):
Please Login or Register to view this content.
Last edited by schlacter901; 11-02-2012 at 04:06 PM.
hi schlacter901, welcome to Excelforum, as an option: make a copy of the sheet with the data to be filtered and then delete all unnecessary data on it. This way you will get everything you'd like.
Um, i'm new to excelforum and i want to ask if how can i make my code function correctly as shown below:
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