Hi,
I have the same data validation formula set for the range B:B on a couple of hundred worksheets. I need it replaced throughout the workbook by another formula. Is there a way to do it quickly with a macro or something? Changing the thing by hand will take half a day at least...
Thanks in advance.
Last edited by Saighead; 08-22-2017 at 02:40 AM. Reason: Redacted to remove bad language.
This certainly can't be done using find and replace - the CF set-up needs a major overhaul by Microsoft - but may be possible with VBA (not sure). I'll move your thread to that section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Be a little more specific and I'm sure someone can help. What is the formula and what do you want to replace it with?
Unfortunately, my question has been misunderstood by the moderator who edited it.
It is not about conditional formatting. What I have is a data validation formula (ribbon: Data > Data Validation > Settings) set for the range B:B on multiple worksheets to prevent identical entries. Now, it happens to be case-insensitive and I need to do a global search throughout the workbook and replace it with a case-sensitive alternative. Can this be done automatically?
A good way to start is using your recorder do one sheet. Then present it too the Forum. Preparing a code to change/reset each sheet should not be a problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks