When you delete columns, the columns to the right move left to take the place of what you deleted. When you delete rows, the rows below move up to take the place of what you deleted.
If you delete a column or row containing a range that a formula refers to, the formula results in ERR. Any other formulas that depend on this formula also result in ERR.
If you delete columns or rows containing cells that are part of a named range, the named range shrinks by the number of columns or rows you deleted.
If you delete an entire named range, the name is no longer associated with that range. To maintain that association, you must name the range again.