I would like to output the array with the name of the country and to to have the country name in each row
if I start from A4 to have germany in A4, France in A5, United Kingdom in A6
The code I have bellow is working horizontally.
MyArray = Array("Germany", "France", "United Kingdom")
Range("A1:A3") = MyArray
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Many thanks, I'm very new into Excel and VBA
It resolved 80% of my problem
now my question is the following
I try to copy the entire row on the A5 and duplicate a number of time (3 times depending of the number of item in the array) the I try to paste.
My concern I would like each time I run the vba he will start to copy and past from A5, because if I run the vba the first time it will be fine but the second time the vba will past at A8 and not A5 , somehow I would like to override the existing row on A5
My code:
Please Login or Register to view this content.
Last edited by michelgirault; 06-19-2013 at 05:11 AM.
Michel,
Please use code tags with your code. You need to edit the last code and wrap it with code tags.
vba will past at A8 and not A5.
Yes, the NR has gone up to A8.
When you re-run the code, NR will go back to 5, so what do you want to do?
Sorry I was not clear.
I want each time the VBA is run to paste at A5
I guess there is a problem with
Please Login or Register to view this content.
maybe so
Please Login or Register to view this content.
Resize(1) would not do anything as it is a default valuePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks