Delete all given values gives wrong select?

[Reinder]

Hi All,

I would like to delete only given values in a specific area. This works fine with numbers, but with letters, I keep getting error 91. Can anyone help?

Atttatchment contains the example (which does not fully ).

Book2.zip

[Leith Ross]

Hello Reinder,

You declare your variables MinimumValue and MaximumValue as Double. This is fine for numbers, but to test both text and numbers you need to declare your varaibles as Variant.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Reinder]

Leith,

Tnx a million, however.....it still does not seem to work as you can witness in the attatchment. It seems so simple....

Book2.zip

[royUK]

Is the last example what you are trying, because the actual code is outside the Procedure and will error. Also, are you actually setting the MinimumValue and MaximumValue?

Please Login or Register  to view this content.

You could change it to

Please Login or Register  to view this content.

[Reinder]

If I do that, then I get an error that there is a double declaration. Prtobably because I call the function like this?:

Please Login or Register  to view this content.