The official MySQL documentation the the MEMORY storage engine covers maximum table size (in MB) but the maximum number of columns that can be defined on a table is not specified.
This question is specifically about the MEMORY storage engine - not InnoDB or MySQL in general.