Hi,

I have data validation that does not permit text to be written in the cell (Basically Text Length = 0). The range of cells with this validation was renamed "ValidationRange". A macro was created so you cannot paste over the data validation and erase it (http://www.j-walk.com/ss/excel/tips/tip98.htm).

However, it does not work if someone Pastes Special Values. Can someone help me with a VBA code to make this work?