Check the macro in which any columns get deleted. Try to clear the columns rather than delete, which causes the REF error.