pasting to sheet without actually going to the sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sheets("Sheet1").Range("A1:J10").Copy Destination:= _
Sheets("Sheet2").Range("AB45")
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RunTime Error 91 (Leo Asked) 4
Run-time error '1004': Method 'Range' of object '_Worksheet'failed... again! 4
Value from one sheet paste under same value on other sheet. 7
clear all sheets code 4
Formatting and copy or copy and formatting ?? 2
Run macro from active workbook whose name keeps changing 20
Copy columns and paste with blank column between 5
Run two macros for two different sheets 11

Back
Top