Offset named range

HI Emma,

I'm not that familiar with named ranges - so, see if the syntax is appropriate:

Sheets("2014").Range("Target").Offset(1, 0).Resize(1964, 1).Value = _
    Sheets("2013").Range("Start").Offset(1, 0).Resize(1964, 1).Value

Are you looking for the syntax

Range("MyNamedRange").Copy Destination:= Range("MyOtherNamedRange")

or (across workbooks) perhaps this syntax

Dim SourceRange as Range
Dim DestinationRange as Range

Set SourceRange = Workbooks("Workbook1.xlsm").Names("ANamedRange").RefersToRange
Set DestinationRange = Workbooks("Workbook2.xlsx").Names("BNamedRange").RefersToRange

SourceRange.Copy Destination:=DestinationRange

Hi Mike,

Is my syntax proper? She wants to use offset with her named ranges

Once you have Range("myNamedRange"), its a range object and .Resize or .Offset will work.

At this point, I think we are both waiting for the OP to explain what "based on named ranges" means to them.

@ Mike - It seems that offset and resize always operate on ranges

Yeah, my interpretation of the need was "I have a named range, how do I refer to it in VBA?".

So, what about my syntax Her named ranges are both just single cells