Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cleaning up code
The below code will copy all cells from Sheet1 to Sheet2. Sheets("Sheet1").Cells.Copy Sheets("Sheet2").Range("A1") PS: To copy all cells you can also try sheet copy... If this post helps click Yes --------------- Jacob Skaria "kevin" wrote: Hi I recorded a copy/paste special as values macro but am sure there is a more elegant way of writing the code. what part of the code below is not necessary? Sheets("Market").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Range("A1").Select Thanks Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cleaning up code | Excel Programming | |||
Cleaning up some code? | Excel Programming | |||
Help Cleaning up Code | Excel Programming | |||
Help on cleaning / speeding up code | Excel Programming | |||
Need help Cleaning up Code | Excel Programming |