Cant't get Code to sort named Range when looping through worksheets.

Try adding a dot to qualify this

Please Login or Register  to view this content.

ByteMarks,

Many thanks for prompt suggestion, but unfortunately adding the dot hasn't solved the problem.

TMS,

Apologies, hadn't noticed the Workbook had not attached (Hazard of working all hours!). It is now.

"Should be" worksheet shows what the output should be, enabling the PIVOT Table and SLICERS in Cols U - AB.

Objective is to loop through each Monthly worksheet, sort the data by the first revenue stream (Col K) and post the details of that bloc, putting the revenue in Col L of the MASTER worksheet, adding the Revenue stream Name in Col K, then repeat sorting by Col L (Copies to next free row of MASTER), then Col N. Result is all three Streams are listed sequentially in one column.

Problem is the Code generates an Error when I define the Range to copy across.

Please Login or Register  to view this content.

As before, all solutions, suggestion and alternatives welcome as ever.

Ochimus

Does this work for you?

Please Login or Register  to view this content.