| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting to sheet without actually going to the sheet
I want to be on a sheet, select a range, and paste it to another sheet within
the workbook without actually going to the other sheet. I have used this in the past for a single cell: TargetSheet.Range("A1").Value = Sheets("Maintenance").Range ("A50").Value I have TargetSheet defined and everything, but how do I do this for a range? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting to sheet without actually going to the sheet
Sheets("Sheet1").Range("A1:J10").Copy Destination:= _
Sheets("Sheet2").Range("AB45") -- Gary''s Student "Mike" wrote: I want to be on a sheet, select a range, and paste it to another sheet within the workbook without actually going to the other sheet. I have used this in the past for a single cell: TargetSheet.Range("A1").Value = Sheets("Maintenance").Range ("A50").Value I have TargetSheet defined and everything, but how do I do this for a range? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting to sheet without actually going to the sheet
You're not really "pasting" but "setting the value of one range to another".
To do that to multicell range is little different than what you posted: TargetSheet.Range("A1:A2").Value = Sheets("Maintenance").Range ("A50:A51").Value -- Jim "Mike" wrote in message ... I want to be on a sheet, select a range, and paste it to another sheet within the workbook without actually going to the other sheet. I have used this in the past for a single cell: TargetSheet.Range("A1").Value = Sheets("Maintenance").Range ("A50").Value I have TargetSheet defined and everything, but how do I do this for a range? Thanks in advance. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pasting to sheet without actually going to the sheet
Perfect! Thank you!
"Gary''s Student" wrote: Sheets("Sheet1").Range("A1:J10").Copy Destination:= _ Sheets("Sheet2").Range("AB45") -- Gary''s Student "Mike" wrote: I want to be on a sheet, select a range, and paste it to another sheet within the workbook without actually going to the other sheet. I have used this in the past for a single cell: TargetSheet.Range("A1").Value = Sheets("Maintenance").Range ("A50").Value I have TargetSheet defined and everything, but how do I do this for a range? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting into a filtered sheet | Excel Discussion (Misc queries) | |||
| Pasting Into new sheet | Excel Discussion (Misc queries) | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
| Problem pasting a row from a hidden sheet to the first free row on another visible sheet | Excel Programming | |||
| Pasting to Sheet | Excel Programming | |||
Linear Mode
