sorry for late responce
This example works fine but is it possible that when a Leader is selected it also places his members in the range with the DV list of his members also for that Leader....currently when a Leader is selected it places his members in the DV list but does not change the names in the range from the previous leader
Thanks
Jeff
Bookmarks