But Copy method only copies visible cells and so SpecialCells are not
needed:

Yes, indeed. It also just pastes values resulting from formulas. In
that case, if no formatting, PasteSpecial won't be necessary either.
(Just specify destination!)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus