I have names going down column B starting in Row 3. The list of names will grow and shrink. Is there a macro that can number these names down col A. So, B3 will always be 1, b4 2 ect., until B runs out. I will want to run this by button so that when I change my list I can click the button to re-number my list.

Thank you for your time and help.