Hi Expert,
need help for optimizing the mentioned loop code.
it is running very slow.
![]()
Please Login or Register to view this content.
Hi Expert,
need help for optimizing the mentioned loop code.
it is running very slow.
![]()
Please Login or Register to view this content.
Can you explain what you trying to do?
What is the code actually doing and what's the end result you need? Consider whether a loop is necessary at all since more often that not loops are not the most elegant way of achieving your goal
You should generally avoid stuff like .Select which just slows things down.
Upload the workbook with a before and manually created after situation so that we can offer a more considered response.
Last edited by Richard Buttrey; 12-16-2017 at 03:42 PM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are data validation drop down list with named range in multiple column
User also have feasibility to copy paste records in those columns
I want to check whether the entered values are same as given in the dropdown list
If not, I undo the process.
What I am doing in the code?
Once the user entered the record
I check 500 cells of each column VS each record of the named range.
What can be helpful?
If I can able to check only those cells for which the value is changed
Why aren't you using data validation in from wherever the users are copying data?
As I said upload the workbook with a before and after and explain what sorts if things users copy and paste.
Is this duplicated thread?
https://www.excelforum.com/excel-pro...alidation.html
yes, but as you can see i come up with code now and having issue with code
as i didn't got any help on the earlier post, i tried to write code by my own, but got stuck here with slow loop
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks