Restrict cell values in excel

[Vpremakumar]

I'd like to restrict excel values to X and Y only, I know Data validation will do this but , if I enter any other values that will indicate error and when I copy paste any value it won’t indicates error.I want to know hot to restrict copy/paste also for the validated cells.

 

[Luke M]

Check this out:

http://www.j-walk.com/ss/excel/tips/tip98.htm

 

[Vpremakumar]

Hello,

Its working fine only for small range of cells, i added same code for 4000 rows with 10 columns and if I pick any value from drop down list, excel will shutdown. Please suggest me on this. Thanks

 

[Luke M]

You just have the small block of code, correct?

You defined all your cells with data validation as a single range named ValidationRange?

 

[Vpremakumar]

Yes, even with that its not working,

 

[NARAYANK991]

Hi Premakumar ,


Can you copy & paste the code you are using ?


Narayan