Rune, then how about something like this, will copy only the visible cells
in the filtered list

Sheet1.Range("A1:A200").SpecialCells(xlCellTypeVis ible).Copy _
Destination:=Sheet2.Range("B1")

"Rune_Daub" wrote in message
...

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/