Ok weird thing guys. I have some named cells that contain comments, when i
run a certain macro, 4 or 5 of these cells have their comments height reduced
every time i run this macro. BUT NOT ALL OF MY CELLS. only certain ones
everytime. essenitally all this macro does is Add a row, or delete a row
based on certain conditions. It seems that this only affects the comments
when rows are added. The delete part of it does nothing to affect them. This
only affects comments below the area that was added. BUT NOT ALL OF THEM.