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