advanced filter- no findings

  • Thread starter Thread starter CG Rosén
  • Start date Start date
C

CG Rosén

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.
 
Back
Top