difficulty getting variable to work in activesheet.range filter field

[codelphi]

I'm sure this is something simple but I can't figure it out for the life of me. I have the variable "bob" which contains custom ranges based on the file name. An example value of "bob" shows as follows:

"-10", "-9", "-8", "-7", "-6", "-5", "-4", "-3", "-2", "-1", "0", " "

If I hardcode the exact same information into the activesheet.range section it works exactly as it is supposed to. But if I put in the variable (when stepping through I have verified that the variable does hold the correct values) instead it simply does not work. What am I doing wrong?

Also here is a portion of the code being used. with the location in question in bold

Please Login or Register  to view this content.

[Norie]

If you are trying to filter -10 to 0, why not use between -10 and 0 instead of specifying every number inbetween?

By the way, Array(bob) will create an array with one item, the string '"-10", "-9", "-8", "-7", "-6", "-5", "-4", "-3", "-2", "-1", "0", " "'.

If you wanted an array from '"-10", "-9", "-8", "-7", "-6", "-5", "-4", "-3", "-2", "-1", "0", " "' you could use Split with comma as a delimiter.

[codelphi]

I was under the assumption that I could not use between because the column views all entries as text instead of numbers hence specifying each individually, was I incorrect in this assumption? As for the reasoning that makes sense now that you mention it. I will test that and see if that fixes it.

[Norie]

Aren't you converting any number as text columns to 'real' numbers when opening the file?

[codelphi]

Unfortunately the files in question have auto part numbers in them and some of the manufacturers like to use alphanumeric strings such as 300E523 which will convert to an exponent if viewed as a number. So no, not converting to real numbers. As for split I cannot seem to get it to work.

Please Login or Register  to view this content.

Try as I might google searches are not very helpful in this context and I am thinking I am using it incorrectly.

[Norie]

Split returns an array, so there's no need for Array.

[codelphi]

it keeps kicking back a error 13 type mismatch.

[Norie]

Have you checked the array?