Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from ActiveRow, Paste to A2 in Another Sheet
I am trying to copy a row (could be any row) from a sheet named €˜Master and
paste to another sheet, named €˜Summary, in the same workbook, and PasteSpecial in Cell A2. Below is the code that I'm trying to implement: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim Currrow As Range Currrow = Range("A2" & .Row & ":V" & .Row) Worksheets("Master").Range("A" & Currrow & ":V" & Currrow).Copy Worksheets("Summary").Range("A2").PasteSpecial End Sub It would be the entire row; doesn't matter. The data goes from A:V. Thanks, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Paste from Class Sheet to Filtered List on Combined Sheet | Excel Programming | |||
Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming | |||
Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
Select Shape in activerow | Excel Programming | |||
automatic copy and paste from sheet to sheet in a workbook | Excel Programming |