Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
I have a fairly large spreadsheet with about fifty columns. Some of the columns have dropdown lists from named ranges on other sheets. The problem i am having is rather than filling in the sheet a row at a time the users are cutting and pasting the values in from other excel docs. Works okay but they paste over my dropdowns and validations making them useless. How can i use the Worksheet_change event to validate the columns that have validation lists whenever a change is made? Overkill- I know but I am using these sheets to load databases and if the value is not valid the load croaks. any help would be appreciated. First time poster I just found this site and I hope you can help.

Thanks in advance :cool:
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top