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
Will not be able to comment unless you provide more information as to what the macro is, and what the data is etc. Posting a trimmed down version of the file with an exact representation of the scenario might help.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks