Losing hyperlinks in advancedfilter copy to location
 

When I do an advancedfilter on a range that includes cells with hyperlinks
to the internet I lose the embedded link when they are copied to the new
output range. Any idea why?

Thanks
Josh

Losing hyperlinks in advancedfilter copy to location
 

Try paste special
"Josh" wrote in message
. ..
When I do an advancedfilter on a range that includes cells with hyperlinks
to the internet I lose the embedded link when they are copied to the new
output range. Any idea why?

Thanks
Josh

Losing hyperlinks in advancedfilter copy to location
 

How do I do paste special as part of the Advancedfilter CopyToRange?

Thanks
Josh