How to define, refer to and reference ranges on inactive sheets

Hi all,

I keep getting RunTime Error 1004: Method 'Range' class of object '_Worksheet' failed with the following code.

In the past I've used dynamic named ranges with the built in OFFSET function and Name Manager to reference ranges on inactive sheets. I'm trying to get away from that. I understand that the .Range property normally defaults to the Active sheet as it's object without an object qualifier. What I don't understand is how my code below does not provide that. Each Worksheet object is declared and defined. Can anyone point out why this is not working or provide guidance on another method.

The code is simply intended to populate various combo boxes of a user-form from worksheet ranges.

Please Login or Register  to view this content.

Thanks.

Thanks. That solved it.

So the "With" statement applies the wsLists qualifier to any argument that needs it? Is that correct?

The expanded Code would be something like:

Please Login or Register  to view this content.

For example?

Yep, just making sure I understand what the code is doing.