I have a very short macro snippet here that I need to iterate several
times:
Sub Macro1()
'
Sheets("Detail").Select
Range("ES3").Select
Selection.Copy
Sheets("Price List").Select
Range("W12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.Copy
Range("W13:W22").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
Each time through, the values for the following objects will need to
increment accordingly:
Range("ES3").Select + 1 (until the column is blank)
Range("W12").Select + 11
Range("W13":W22").Select + 11 + 11 accordingly.
I'm sure this is very easy, but I don't know where to begin.
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
