| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Values code
Yes. Thanks!!
"Mike H" wrote: Hi, Maybee this Sub CopySheets() Sheets("Sheet2").UsedRange.Copy Sheets("Sheet1").Range("A1").PasteSpecial Paste:=xlPasteValues End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jules" wrote: Is there a faster way to copy and paste one entire worksheets data into another existing worksheet? I do NOT want to rename the sheets. Code below is what I'm using now but it seems that there should be a simpler way. Thanks! Sub CopySheets() Sheets("Sheet2").Select Cells.Select Selection.Copy Sheets("Sheet1").Select Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find matching values, copy/paste values as well as values in ColA | Excel Programming | |||
| What code for repeatedly copy, paste values ?? | Excel Programming | |||
| VBA code to copy and paste by values from one Excel workbook to another | Excel Programming | |||
| code to FIND value, copy, paste values onto other sheet | Excel Programming | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
Hybrid Mode
