Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub Macro1()
Dim wshO As Worksheet, rgO As Range '(O)rigin sheet and range Dim wshD As Worksheet, rgD As Range '(D)estination sheet and range Set wshO = ThisWorkbook.Worksheets("Murk 11A") 'origin sheet Set rgO = wshO.Range("A1:038") 'origin range Set wshD = ThisWorkbook.Worksheets("Murk 11A") 'dest sheet 'Find last cell on dest range using column A. '--- Copy Murk 11A!A1:O38 at end of data in "Murk 11A" --- Set wshO = ThisWorkbook.Worksheets("T+M") 'origin sheet Set rgO = wshO.Range("A1:w89") 'origin range Set wshD = ThisWorkbook.Worksheets("T+M") 'dest sheet 'Find last cell on dest range using column A. '--- Copy T+M!A1:W89 at end of data in "T+M" --- Set wshO = ThisWorkbook.Worksheets("Murk 12C") 'origin sheet Set rgO = wshO.Range("A1:Q41") 'origin range Set wshD = ThisWorkbook.Worksheets("Murk 12C") 'dest sheet 'Find last cell on dest range using column A. '--- Copy T+M!A1:Q41 at end of data in "Murk 12C" --- Set rgD = wshO.Columns(1).Cells(wshO.Columns(1).Cells.Count) 'last cell in col A: A65536. Set rgD = rgD.End(xlUp).Offset(1, 0) 'last cell of data in A then 1 row bellow. 'Now copy/paste rgO.Copy rgD 'Syntax: OriginRange.Copy DestinationRange '--- repeat above section --- End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming |