You can't apply a comment to a range. If you highlight a range Excel only allows you to insert a comment in the active cell.