Hi guys, does everyone know how to copy and paste value while the filter is on. I read couple online answer and they seemed recommend to use Special and select visible cells only. I guess that only works for excel 2007, and won't work in excel 2010. Is there any recommendation?