Hey Leith,

Thanks for taking some time to look at the code and offering a solution.

My code does 4 things:
1/ highlight cells that have comments
2/ change all lowcase values in uppercase
3/ Sort ranges C:I depending on input in collumn C
4/ Unhide a new row if value is added in collumn C, or hide a row when a value is deleted

After replacing the original code with yours, unfortunately all macro's have stopped working (no error, just not doing anything)
On the bright side, the sheet works very very fast now hahahaha

To explain number 3 and 4, let me try to give an example:

C D E F G H I
9 Jurgen Jurgen Jurgen Jurgen Jurgen Jurgen
10 Stefano Stefano Stefano Stefano Stefano Stefano
11 Ron Ron Ron Ron Ron Ron

Row 12 is an empty line, where user can make new input in collumn C.
The moment the input is done, C9:C12 is sorted (A to Z) en and a new line is unhiden (row 13).
(btw collumn D is just empty)

Hope this helps a bit