How can one build an macro to search all over the workbook and substitute part of the validation formula ?
someting like
=book1!A1:A2 to =A1:A2
?????
thx in advanced
p.s. i know that probably have to use INSTR but do not know how
How can one build an macro to search all over the workbook and substitute part of the validation formula ?
someting like
=book1!A1:A2 to =A1:A2
?????
thx in advanced
p.s. i know that probably have to use INSTR but do not know how
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks