100 Columns is not going to be very functional anyway! Leith's suggestion will not work in this case because the data you are trying to add is a filtered range. The only thing you could do to implement his suggestion is to copy the filtered range to another location then set the new range as the rowsource.