Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am trying to find a way to be able to paste to multiple selections in a number of grouped sheets. In the example below it only refers to 2 cell locations whereas there are actually more. Thanks in antisipations. Mick Sheets(Array ("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "S ep", "Oct", "Nov", _ "Dec")).Select Sheets("Jan").Activate Worksheets("DataSheet").Range("G10,G11").Copy ActiveSheet.Paste Destination:=Worksheets("Jan").Range ("A4:A5") 'Selection.Paste Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple selections | Excel Discussion (Misc queries) | |||
copy and paste with multiple selections in Microsoft Excel | Excel Discussion (Misc queries) | |||
copy and paste with multiple selections in Microsoft Excel | Excel Discussion (Misc queries) | |||
Vlookup for multiple selections | Excel Worksheet Functions | |||
Copy and paste selections and formatting to new worksheet | Excel Programming |