Set other worksheet range --- runtime error 1004

D

dlee888

Joined
Jul 20, 2007
Messages
8
Reaction score
0
Got a strange problem here when trying to set a range in a different work sheet (same workbook)

Here are the codes:

Range(Cells(40, 1), Cells(68, 40)).Select
----Works fine ----
Sheets("OtherSheet").Activate
Sheets("OtherSheet").Select
Sheets("OtherSheet").Range("A40:BQ68").Select
Sheets("OtherSheet").Range("A40", "BQ68").Select
----OK ---
Sheets("OtherSheet").Range(Cells(40, 1), Cells(68, 40)).Select
--- runtime error 1004

Any suggestions?
Thanks in advance for the help.
dlee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set worksheet range ---runtime error 1004 0
AdvanceFilter Problem 2
Conflict 8
Error Message - Macro to Unlink MS Queries from Workbook 0
Copy Data from Closed File to Existing File 0
How to activate Sheet2? 5
Runtime 1004 Error Help Request 1
Run-time Error '1004': Selection is too large. 0

Top