Passing data to array from another sheet

[Recyler]

I have a two sheet workbook with sheets("input") and sheets("output"). I'm trying to pass a particular range of data from sheets("output") to an array while I'm on sheets("input") but keep getting a Run-time error '1004': Method 'Range' of object'_worksheet failed.

Code works fine if sheets("output") is activated first.

Any guidance on how to pass this data without activating sheets("output") first?

Please Login or Register  to view this content.

Thanks.

[JBeaucaire]

When using parent sheet variables, you have to apply them consistently...like so:

Please Login or Register  to view this content.