ExcelBanter - How to enter data in maximum of one cell in range?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to enter data in maximum of one cell in range? (https://www.excelbanter.com/excel-worksheet-functions/78882-how-enter-data-maximum-one-cell-range.html)

bobedcar

How to enter data in maximum of one cell in range?

If cell A1 has data I need to block cells A2-A4 from accepting data.
If cell B2 has data I need to block cells B1,B3,B4 from accepting data.
Office 2003

All times are GMT +1. The time now is 02:32 PM.