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
When I run the Range(Cell1, Cell2).Select on a local worksheet, no problem.
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)