vba loop help

5 pts.
Tags:
Excel VBA
Microsoft Excel
Microsoft Excel 2003
VBA
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1       x 2 3 4 5 6 7 8 9 0 once i can do that then all of the other math is done automatically for me. i thank you for any help you can give.


Software/Hardware used:
excel 2003 macro
Asked: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi, try this:

Dim Counter as Integer

For Counter = 1 To 10 Step 1
Range(“A” & Counter).Select
Selection.Copy
Range(“B1”).Select
ActiveSheet.Paste
Next Counter

Cheers

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: