Invalid reference error in VBA

[ConneXionLost]

I'm beginning my foray into VBA and, not suprisingly, am now stuck.
The workbook is far too large to post, so here's some background:
- - - - - - - - - - - - -
I'm receiving an error in my VBA at the point where I'm attempting to sort. This is the error message:

Please Login or Register  to view this content.

My workbook consists of the following sheets:
Orders
SortSheet
Operations
Staging
BWInput
Analysis
Summary
I'm attempting to move/manipulate/sort data from the Orders & Operations sheets (via the SortSheet & Staging Sheets) to the BWInput sheet with this VBA:

Please Login or Register  to view this content.

Here are the Dynamic Range Names (DRN) I'm using:

Please Login or Register  to view this content.

- - - - - - - - - - - - -
I don't know if it is the DRN that's causing the error, but I think I need to use one since the size of data block will change from run to run.
Any suggestions?

[shg]

Assuming this is the line that's failing

Please Login or Register  to view this content.

Range("A2"), refers to the active sheet, not (necessarily) the sheet on which the sort range exists (SortSheet).

Using OFFSET in all those range definitions makes all your formulas that depend on them volatile. Consider modifying to use INDEX instead.

[ConneXionLost]

That worked!

Thx shg.