Determine minimum indent level of selected cells

[gnethery]

I need to determine if any of the cells selected by the user have an indent level equal to 1 and if so then have them confirm the action. the below works well if the user only selects one cell but if the select 2 or more and any of the selected cells has an indent level greater than 1 it doesn't show the confirmation.

Please Login or Register  to view this content.

[shg]

What am I missing? It looks like the code does the same thing whether the user chooses Yes or No.

[gnethery]

You are correct. Ultimatly the indent of the selected cells is decreased. What I want happen is this example

User select 3 cells in column:
Cell 1 - Indent level = 1
Cell 2 - Indent level = 2
Cell 3 - Indent level = 2

If the user only selected Cell 1, then all works as expected. E.g. - confirmation message is displayed and when user confirms the indent level is decreased. But when the user selects cells 1 & 2 is doesn't work as expected.

Here is what I want:
If any one of the selected cells indent level is = 1 then display the confirmation message and if user answers yes then decrease the indent. The decrease indent works but since some of the selected cells has an indent level <> 1 then the confirmation message does not appear.

[gnethery]

OK...I have it working using a For Each statement but not sure this is the best way

Please Login or Register  to view this content.

If a user select 5 cells 2 have an indent level of 1 and 3 have an indent level of 2 then the confirmation message is shown once and then the indent is decreased.