Empty cells with criteria

[Reinder]

Hi All,

I'd like to delete all the cells (content) in a sheet with some given criteria. Example is that all the exact letters between C and Z have to be deleted. I have a macro which deletes all the numbers between 10 and 10000. and a macro which deletes all cells with some values starting with the criteria. However I would like them to delete only the cell if the value is exactly "A" and not if it is "AA" of "=A32" etc

Example code for all text:

Please Login or Register  to view this content.

Plz help! It seems so simple, but I can't get it to work....

[antoka05]

Try to modify you macro so:

Please Login or Register  to view this content.

Regards,
Antonio

[Reinder]

tnx! However it now seems to get stuck on the next piece of code?

Please Login or Register  to view this content.

[Reinder]

mmm, my bad....it now seems to work!! tnx!!

Please Login or Register  to view this content.

Problem was occuring because there where no values to select. Is there some line that does not make the function crash? (end if??)