jules meredith
New Member
I have a spreadsheet that uses some vba to create a new name range whenever the contents of cells in column C are changed - (the new name range is named after the contents of the changed cell in column C . This works well until I try to insert a new row - the vba crashes because the cell it is looking at has no text and named ranges must begin with a letter or underscore. There is a lot of info on tables and automatically copying "formulas" when inserting new rows but not for a simple text string i.e "SET_UP"