nilem, TABLE1 currently spans 1m+ rows so this is no different to using entire column cell references in the Array (i.e. you would want to resize Table first).