Private Sub Worksheet_SelectionChange vs other options

  • Namastey dangelor,

    This is working just fine. Thanking you for all your help, will share a sample of the working file later with you, as I have added few more steps to it.

    There is one thing though that I am trying to overcome currently. I am getting a Circular Reference Error prompt, error of which I can't find:-

    "Microsoft Excel cannot calculate a formula there is a circular reference in an open workbook, but the references that cause it cannot be listed for you."

    Will update you on this as well!

    Also, the WiseOwl Tutorials are just perfect, thank you!

    Take care!