Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Macro; Loop is Misbehaving
Im trying to come up with a macro that takes names in a list, Range is
AA1:AA11, copy paste each name into both Range A3:A6 and Range A11:A14. Several links, all using GetPivotTable functions, will update with the name in those ranges. Then I want to copy/paste the Range A1:O17 to a new Sheet and loop to the next name. Im sure it is possible. I am not sure of how to do it. Can someone please assist? I think it is going to look something like this: Sub Macro1() For Each c In Sheets("Report").Range("A1:A11") lstRw = Cells(Rows.Count, 27).End(xlUp).Row ActiveCell.Select Selection.Copy Range("A3:A6,A11:A14").Select Range("A11").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("A1:O17").Select Application.CutCopyMode = False Selection.Copy Sheets.Add ActiveSheet.Paste Selection.Columns.AutoFit Range("A1").Select Next c End Sub It keeps copying/pasting the value in A1, in Sheet "Report" to Range("A3:A6,A11:A14").Select. Regards, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy-paste started misbehaving (cell reference wrong) | Excel Discussion (Misc queries) | |||
copy paste loop---new to vba | Excel Programming | |||
Copy and Paste Loop | Excel Programming | |||
Copy/Paste Loop | Excel Programming | |||
copy and paste loop | Excel Programming |