Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
De selecting a range after a copy and paste is performed
Hi In the below code, I am copying a range from Sheet 1 and with the PasteValues method, I am pasting that range to a cell on Sheet 2. The problem I am having is that I can not "de select" the selected (copied) range on Sheet 1. I have tried doing an ESC using SendKeys but that doesn't seem to want to work. Any ideas? Is there a select = False or some code that I am missing? Thanks! ML 'Copy Bills Sheets(1).Activate Sh1bw.Offset(0, 2).Copy 'Copy Column C bills Sheets(2).Activate Sh2bw.Offset(0, 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone 'Paste bills one column over from Sh2bw |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste without selecting sheet or range | Excel Programming | |||
Selecting range of cells to copy using a variable | Excel Programming | |||
Selecting data to copy and paste | Excel Programming | |||
Auto copy/ paste on relevant work sheet when selecting list item | Excel Programming | |||
paste grays out after function performed | Excel Programming |