Great that it takes care of your requirement.
You do not need to mention anything about A column or range. For every cell in E column the procedure checks if it is a blank, if so the .offset(0,-4) code checks if there is any value in col A in the same row. If there is a value, then it will not allow the saving of the workbook till the corresponding E cell is filled up. If there is no value in A then, next E cell is checked.
It would work for all the rows without mentioning of the Col A or the row number explicitly. Pl choose the correct worksheet and run it.
Pl let me know if there is a problem.