Hi,

I applied data validation to the cells in the macro using the excel options available. Applied data validation to all cells in a row of each column. Even the blank cells.

Now when i run the macro, it is running very slow. Any reasons for this.

Please advise how i can avoid this.

Regards
Dhivya