Hi All,

One part of a macro that I wam working on filters a column where the
contents of the cells is N/A.

How do I display the text from these filtered columns only in a label
on a form.

Filtered results as follows:
A, B, C
Garry, Smith, N/A
Fred, Blogs, N/A
How do I capture the contents of the cells containing "Garry" and
"Fred" and display them in a form label? The number of cells to be
captured will need to be dynamic depending on the number of N/A' that
are shown in the filter.

Thanks
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=532117