I know that solution.. I used it before, but the problem is that I have
an interactive range in Sheet 1 that changes due to some restrictions.
If I just set the value range to for example
Sheet2.Range("B1:B200").Value it will copy the entire rows, but If I do
the copy function I can make it copy only exactly what the interactive
range says.

In sheet 1 I have to copy a filtered list. The only way I can do this,
is by a copy function. As far as I know anyways.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/