I have a column of cells that are not merged that are for user inputs. When the user makes inputs into this cell a number of other columns, with merged and unmerged cells, make different calculations using the data. However, I am having a problem occur when the user types their input into the cell where the "cannot change part of a merged cell alert" pops up. I just click okay and the input goes where it was supposed to just fine. I was wondering if there is a way to code so that i don't see this alert. Ideally I would like to only shut off this particular sheet's alerts.

Thanks.