Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
de-select range in other workbook?
Greetings,
I am copying data from one workbook (book1) to another (book2) like this: Dim sht As Worksheet Set sht = Workbooks("Book2").Sheets("Sheet1") sht.Range("B10:H20").PasteSpecial So when I go to Book2 I see the data but it is all highlighted. I tried de-selecting it by saying sht.Range("A1").Select after the PastSpecial statement, but that gave me an error message that the selection failed. Is there a way to do this in code to de-select a range in a workbook from another workbook? Thanks, Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select and copy 100 random cells from a range in a source workbook | Excel Worksheet Functions | |||
Open Workbook - Select Range as table for vlookup | Excel Discussion (Misc queries) | |||
Select a range and copy to new workbook | Excel Programming | |||
Select and move range throughout workbook | Excel Programming | |||
RefEdit - cannot select range on another workbook | Excel Programming |