Excel VBA beginner problem

**Branko123** · 03-14-2015, 04:25 PM

Hello.
Can you please help me with this Excel VBA problem ? I have created a macro, that calculates a value in Solver for i times, where i is integer variable from 1 to 10. Then it copies answer from a designated cell and pastes it in cell A1 for example. I would like to see it write answers in cells Ai, that means A1 to A10.

.....
Range("B1").Select
Selection.Copy
Range("A1").Select (i would like to change this particular line to some thing meaning Ai... A1,A2,...,A10)
...
So for the first calculation it writes to cell A1, for second to A2 and so on.

A B
i Value
1 5
2 10
3 15
4 20
etc...
E
Thank you in advance.

**FDibbins** · 03-14-2015, 04:31 PM

Hi, Branco, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.