Fellow comedians are paying tribute to Norm Macdonald who died Tuesday after a private battle with cancer