Thanks for your help. I can now copy array b data in excel sheetcolumn 1.How do I copy this excel 10000 cells data back to array c in asingle command.