vba loop help
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
Software/Hardware used:
excel 2003 macro
ASKED:
February 7, 2010 4:14 PM
UPDATED:
February 19, 2010 5:40 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
