Greetings,
I want to do following;
A1----------B1------ C1------ D1--- E1
England-Turkey-Germany-France-Italy
I am running following code;
This is Macro1 result;![]()
Sub Macro1() myarray = Array("England", "Turkey", "Germany", "France", "Italy") For i = 1 To 5 Sheets("Sheet1").Cells(1, i) = (myarray) Next i End Sub
A1----------B1------ C1------ D1--- E1
England-England-England-England-England
P.S: Using array function is must.
Regards
Bookmarks