Macro throwing out 'memory' error

@thatandyward

That would only work if all the cells have the same number format. Otherwise, the Numberformat will return Null, not an array of formats.