Скачать или смотреть Check if cell has validation list and Ctrl+Up (xlUp) including validation list | Excel VBA Discovery

The xlUp function in VBA is very popularly used. However, it only goes to a cell with a value/text in it and if you want your code to go up to the first cell with even data validation in it, then check out this method.

Hope this was helpful! Note that you can also add the code line "Application.ScreenUpdating = False" at the beginning of the macro then "Application.ScreenUpdating = True" at the end of the macro, so that you don't visually see all the cells being checked.

Let me know if you have any questions or comments in the comment section!

Get my quality, user-friendly, and feature-full Excel Products here!
https://spreadsheetnut.com/ (TBA)
Follow my brand new Excel communities here!
https://techcommunity.microsoft.com/t...
https://stackoverflow.com/users/19176...
Subscribe to my newly revamped Excel & VBA YouTube channel where I share progress and discoveries with my projects!
   / @kendethar  

Hire my skills!
www.linkedin.com/in/kenneth-j-nelson