Using an array as criteria in an AutoFilter

Howdy.....just a quick question....when you say it doesn't work....do you get an error? or unexpected results?....and if unexpected, what as it and what should it be?

The entire chart gets wiped out as if nothing matched.

I have narrowed it down to having something to do with data types.

The source array cells which are to be used as the criteria1 array are actually populated with a vlookup formula displaying the Student Identification Numbers, which gets the student numbers from a master table Worksheets("History_").Range("tblHistory"), which is all records,.

Though I have tried a number of attempts to convert these to string or text, I have discovered many ways that it won't work. (That was trying to put a positive spin on a negative).

The student numbers are the only definitive record identity I have, for names get muddled with middle initials, Jr.'s and Sr.'s, and other weirdisms.

Running what I have on an alternate test set of tables ran fine when I based it on text fields. What I finally condensed down to use (just to eliminate all the variables was:

Please Login or Register  to view this content.

and I verified column 4 as being the Student ID fields. Worksheets("George") is the sheet devoted to instructor Mr. George and SID is a column in his table of Student ID numbers that actually have the afore cited lookup function.

I get the feeling I am headed to copying the vlookup colum to a colum of text values in order to have a chance to make this work, but if there is another method that won't have me adding columns and basically duplicating data, I SURE would like to know of it...

Edit: Not even copying the list and formatting it to text worked. Now, even worse, I suspect I need to use an Advanced Filter, copy the visible cells to a new sheet, then sub-filter those with an auto filter. I feel really stupid, but at least it will work until someone educates me...

if you believe the problem to be that the SID is a number and not text, try cancatenating a "' ' " in front of the number. that's the character below the double quotes. If you are using a VLOOKUP then you can try something like

="'"&VLOOKUP(...........................)

I haven't tested this, just a shot in the dark....

Use Strings:

Please Login or Register  to view this content.

for example.