-
Hi Aflatoon
Apologies!
Its working now.
Then next problem,
When D9 value = new ofgen user request (or) ofgen user update request Then its showing the Role#1 rows visible then if all values are filled for Role#1 the flag in cell i38 turns 1 after that it should trigger Role#2 rows visible and so on.... but, this is not happening with current code.
Also, once this works there also possibility of users using Radio buttons in row1 which will update the validations of respective cells in Role#1 to Role#10.
These are the two solutions i'm looking for...as this intersect Range option used in the worksheet event is new to me i really have no idea of its funtionality.
If you help further i will be really thankful to you...
Best
Rem0
-
The Change event is not triggered by formulas recalculating. You would have to use the Worksheet_Calculate event for that.
-
Hi Aflatoon
Many Thanks!
This is something new...sure will give a shot and get back to you...
Best
Rem0
