Hi

I have noticed in these posts the use of (xlCellTypeVisible) to select only
the filter data.
Can that be used to select only the filtered names in column A for copying
to a second sheet?

I have a list of 390 names in column A, a total of 12 room numbers in Column
L and a "Y" & "Z" code in column N.
I'm filtering the names by room number & a "Y" code.

The code I'm using at the moment is;

''' Tranfer Class No.4 names only
Sheets("Names").Select
[A1].Select
Selection.AutoFilter Field:=12, Criteria1:="04"
Selection.AutoFilter Field:=14, Criteria1:="Y"
Range("A1").Offset(1, 0).Resize(400, 1).Copy
Destination:=Worksheets _
("Results2004").Range("B2")

''' Tranfer Class No.5 names only
Selection.AutoFilter Field:=12, Criteria1:="05"
Selection.AutoFilter Field:=14, Criteria1:="Y"
Range("A1").Offset(1, 0).Resize(400, 1).Copy
Destination:=Worksheets _
("Results2004").Range("B38")

The Resize(400,1) is to ensure all names for a room are copied,
Question: What is the correct syntax to select only the visible names?

--
Thank you

Regards

Bob C
Using Windows XP Home + Office 2003 Pro