Hi,
i have very serious issue.
Code:
so generally idea is to check if validation is true or false in A1 in yellow field.
I am using code like above (test macro) to check this.
For this data validation i am using few named ranges combined with formulas in order to :
1. get mapped regex pattern.
2. get named range cell name.
3. combine both within formula and return boolean.
Generally i am importing all named ranges from CSV to main workbook and want to check if all fields are validated.
Issue occurs when validation (complex one like in my example) is not on activesheet So first what i have to do is select A1 cell and run code (result: "True"). If i am on another worksheet - result will be "False".
How can fix the issue without slowing general working of macro performance?
Can anybody help?
Best,
Jacek
Bookmarks