output array(1,4) without inner loop

The following code loops through 3 named worksheets used ranges and if columns c and d both = 5 then copy the entire row to sheet 21

I can list the arrays and find the array "rows" i require to output but I am struggling with how to output the array called arr3 to sheet without looping

any pointers appreciated

Please Login or Register  to view this content.

j was fixed to 4 columns but really should be variable per sheet

How does j vary with each sheet? Some examples please.

The first argument to Resize is the number of rows. Assuming you want to output it as a row, not transpose it, you should be using .Resize(, Ubound(arr3))