define range name, use on VBA selected sheet
 

I want to sort tables of data results. Results for differant areas are stored
on differant worksheets in one workbook. Some of the worksheets do not
contain result data.
The required range is defined as several contiguous columns.
How can I define the range once, and yet apply it to the result sheets from
VBA.

Do I have to write a function to convert the named range column referances
to a string format suitable for defining a range? Or is there an existing
function/method I am missing.