Why doesn't Application.Index write array column to worksheet range?

I am trying to use Application.Index to write a specific column of a 2D array to a worksheet.

See extract of code below. Everything runs fine until it reaches the .Cells line and then it goes to the error handler. Why?

Please Login or Register  to view this content.

Arrgh. I commented out the On Error and now VBA calmly processes the .Cells line.... except it doesn't write any values to the worksheet??? (My array is 5 rows by 7 columns. No base 0 option).

Solved. (It's always the little things). (I should have had the worksheets as

Please Login or Register  to view this content.

)