Your terminology seems erroneous to me. A 'named range' (Lotus 123
terminology) in Excel usually means a defined name i.e. a Name object.
You seem to be using 'named range' to mean a range's address e.g. 'UC
Scenario Status'!$M$6 is a range address. And the dollar signs in the
above example signify an absolute reference, not a relative reference.
Are your AssignedToRange etc variables Dim'd as type Excel.Range?

--

(Ken) wrote in message . com...

The named range I pass to the macro is defined in relative terms (ie.,
with dollar signs) and is prefaced with the worksheet name that
contains the range. Here's what the ranges look like:

AssignedToHeading ='UC Scenario Status'!$M$6
AssignedToStart =OFFSET(AssignedToHeading,1,0)
AssignedToEnd =OFFSET('UC Scenario Status'!$M$25,-1,0)
AssignedToRange =AssignedToStart:AssignedToEnd

"AssignedToRange" is what I'm passing to the macro.