Displaying filtered results in a form


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?action=getinfo&userid=31075
View this thread: http://www.excelforum.com/showthread.php?threadid=532117

.

Relevant Pages

  • Re: Excel VBA autofilter problem
    ... Working with dates in filters in VBA can be a challenge. ... > Dim mydate1 As Date ... > three cells above, these cells are validated cells which allow the user ... > correct records are displayed!!! ...
    (microsoft.public.excel.misc)
  • Re: Max power from solar cells
    ... > to reflect light of wavelengths which are not well converted by the cells. ... > are heatproof (compared to the usual gels and glass filters). ... I was only thinking of a mirror directing sunlight to the cells ...
    (sci.space.policy)
  • Re: Using the "Count" function with filters?
    ... So you want to do the equivalent of =countifbut with filtered data? ... result changing when applying filters to other columns in the spreadsheet. ... I was able to get the total number of cells that contains, ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Preventing a Filter from affecting cell shading
    ... Select all the cells on the worksheet ... Choose Format>Conditional Formatting ... but I'm also using filters. ... When I filter results, the cell shading is also filtered out, so instead of white line/gray line over and over I get blocks of colour which defeat the purpose of the shading. ...
    (microsoft.public.excel.misc)
  • Re: Max power from solar cells
    ... Such filters exist, and could be placed on cells. ... beginning to be used as coloured gels in theatrical spotlights because they ... near-monochromatic light at high intensity, ...
    (sci.space.policy)