|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Range(Cell1,Cell2) Error on another workbook controlling some other workbook?
Code:
Sub test() Dim book As Workbook Dim sheet As Worksheet Set book = Workbooks("test.xls") Set sheet = book.Worksheets("Sheet1") sheet.Activate ''' Application defined or Object defined error sheet.Range(Cells(23, 2), Cells(47, 2)).Select ''' the below one didn't return an error ''' sheet.Range("B23:B47").Select Set book = Nothing Set sheet = Nothing End Sub But when I run the command on a local worksheet to select a range of cells on another worksheet, it returns the error (see the comment above) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Shared Workbook | SJT | Excel | 6 | 01-12-2012 11:33 AM |
Loop through folder of workbooks and copy range to other workbook | Snvlsfoal | Excel Programming | 3 | 07-29-2011 05:55 AM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Select a range in one one workbook while working in other workbook | Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |
Share Workbook cannot merge | Ichigo | Excel | 3 | 01-19-2010 03:05 AM |