Hello all,

Have an unusual problem.

I've written a module (as Worksheet_SelectionChange) that builds out a hierarchical organization chart. So, the first level of executives are displayed in column A. The user selects a cell (it highlights) and all of the selected executive's subordinates at the next level populate column B (the data is from a large table on a different sheet). The user has the option of continually selecting deeper into the organization until the lowest level is reached.

The goal is to enable certain reports to be generated at any level.

My problem is that if someone inadvertently deletes a name from column A, there's no easy way to rebuild the first tier of names as every click relaunches the build out macro. I've tried repopulating column A every time the macro is launched, but I get into a recursive loop.

Is there any way to suspend the build out macro if I have to repopulate the starting data?

Art