How to automatically number rows after running macro

I have created a standard list of items that may or may not need to be included depending on the type of project being worked on. You will see a macro in the right hand column that will hide all rows to which the "NO" is applied. I do not want to delete the "NO" rows since this is intended to develop into a master list of items. After clicking the "HIDE button, only the "YES" items remain and the "NO" rows are hidden. Is there a way to then automatically number the visible (YES) rows in numerical sequence? Everything that I have tried numbers the hidden rows also and so there are gaps in the numbering.

Thanks

Or

Please Login or Register  to view this content.

and add this line to your "revealing" code

Please Login or Register  to view this content.