VBA with Array not copying all the columns.

[excellearner121]

Hi All,

thanks for your time to looking into it. I had this macro earlier which was working fine it copies data from 7 sheets and pastes into the summary sheet. but I had to delete some columns from source file, I updated the array details but not all the data is being copied only a few columns are being copied.

please help.

thanks,

[AB33]

You have 27 columns in the arSource array and all are copied. Your sheet loop stops at 7.