Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy & Paste code more efficient
Hi all, In an effort to make this code shorter and more efficient i am attempting to rewrite it. It copies a range from one workbook and pastes into another workbook. I have several blocks of code like this. Any suggestions appreciated. Original: 'Copy and paste site data Windows("UCPSITE-06.xls").Activate Sheets("UCP SITE - Totals").Select Range("BJ5:BJ617").Select Selection.Copy Windows("3140UCP2006WithShell.xls").Activate Sheets("UCP All Site Rankings").Select Range("I2").Select ActiveSheet.Paste 'Clears Clipboard Application.CutCopyMode = False New: 'Copy and paste site data Windows("UCPSITE-06.xls").Activate Sheets("UCP SITE - Totals").Range("BJ5:BJ617").Copy Windows("3140UCP2006WithShell.xls").Activate Sheets("UCP All Site Rankings").Range("I2").Paste 'Clears Clipboard Application.CutCopyMode = False -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=571946 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More efficient copy/paste?? | Excel Programming | |||
Efficient Copy/Paste | Excel Programming | |||
Efficient Code | Excel Programming | |||
More Efficient code than this | Excel Programming | |||
More efficient method to copy-paste values in place? | Excel Programming |