advanced filter- no findings

Godday Group,

Have an existing excellist made by "manual" inputs. Have now
made an Userform where TextBox text is put in the excellist by:

Sheets("data").Range("A" & r) = Userform1.TextBox1
etc etc

When using the Advanced Filter only the "new" inputs made by the code is
found.
All previous "manually" logged data is not found.

Any hints how to solve this?

Brgds

CG Rosén

Does the Advanced Filter list range include all the rows?
What criteria do you use for the advanced filter?
Perhaps the new entries and criteria have space characters that manual
entries don't have.

CG Rosén wrote:
> Godday Group,
>
> Have an existing excellist made by "manual" inputs. Have now
> made an Userform where TextBox text is put in the excellist by:
>
> Sheets("data").Range("A" & r) = Userform1.TextBox1
> etc etc
>
> When using the Advanced Filter only the "new" inputs made by the code is
> found.
> All previous "manually" logged data is not found.
>
> Any hints how to solve this?
>
> Brgds
>
> CG Rosén
>
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html