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.
|