Problem copying array values to worksheet cells

Hi to all,

I have a program where i need to assing array values to worksheet cells.The code is in Excel VBA.
I don't why it is taking lot of time to update 1 row of data.
When i checked the Taskmanager it is taking 50% of Excel.exe.


The sample code is

Please Login or Register  to view this content.

Please let me know how can i handle this in excel vba.

As I said in my reply to your PM, please read the Forum Rules - you must use Code tags when posting code here.

Have you set ll your variables & how?