replacing defined names for ranges

If I go to Insert | Name --> Define and define a name as a range, can I just
replace an absolute range in VBA with the named range?

For example my named range is called ValuesX1.
ValuesX1 = offset($C$1,0,0,countif($A:A$,1),1)

When I record a macro and autofill a range in column C, my VBA code looks
like this: Selection.AutoFill Destination:=Range("Y1:Y61")

However my range changes for different worksheets so can I just replace
"Y1:Y61" with ValuesX1?

Yes, just use

Selection.AutoFill Destination:=Range("ValuesX1")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chris" <[email protected]> wrote in message
news:[email protected]...
> If I go to Insert | Name --> Define and define a name as a range, can I
just
> replace an absolute range in VBA with the named range?
>
> For example my named range is called ValuesX1.
> ValuesX1 = offset($C$1,0,0,countif($A:A$,1),1)
>
> When I record a macro and autofill a range in column C, my VBA code looks
> like this: Selection.AutoFill Destination:=Range("Y1:Y61")
>
> However my range changes for different worksheets so can I just replace
> "Y1:Y61" with ValuesX1?