| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range without changing sheet in view?
Greetings,
I need to use a macro to copy cell values from one sheet to anothe without changing the sheet that's in view. I have been using th following code but my selection method causes the sheet in view to fli back and forth between the sheet the cells are being copied from to th one they are being pasted on. I am using the follwing: Sheets("Sheet1Name").Select Range("D4").Select Selection.Copy Sheets("Sheet2Name").Select Range("C5").Select ActiveSheet.Paste How can I rewrite this to do all the work in the background? I guess need the syntax to copy a range from a sheet without making i "Active". Thanks in advance! -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to look up and copy a changing range of data ? | New Users to Excel | |||
| range of Formula copy but not changing the content | Excel Discussion (Misc queries) | |||
| How to copy range without changing formulas? | Excel Discussion (Misc queries) | |||
| Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
| How do you copy RANK w/o it changing the range? | Excel Worksheet Functions | |||
Threaded Mode
