Selecting

Hopefully someone will clarify an issue for me that has me baffled. This is
not the first time that selection of a range in another work*** generates
errors. I want to select a range in another work***. Excel keeps giving
me a run time error '1004'.

These errors occur even if I fully qualify the name, such as
Worksheets("PI").Range("P").Select. I also recorded a macro to see what it
generated for code, then copied that and still received the error.

This is the code that I am using currently:

Worksheets("PositionImports").Select
Range("Positions").Select

This is the error with the Range select line highlighted in the IDE:

Run time error '1004'

Method 'Range' of object '_Work***' failed.


What gives here? Excel seems to not deal with this issue in a consistent
manner.

Thank you,
Mark

.

Loading