Re: Set range or named range?

Intra_mA.Copy Range("Destination")

--
Regards,
Tom Ogilvy

"Ian" <me@xxxxxx> wrote in message
news:xnClf.79$n95.24@xxxxxxxxxxxxxxxxxxxxxxx
> I am creating a series of sheets where basic data is entered on a userform
> then ranges are copied from a lookup *** are copied to a *** to create
a
> configured layout.
>
> To create the ranges I am currently using:
> Dim Intra_mA as Range
> Set Intra_mA = Worksheets("Lookup").Range("A13:F20")
>
> To copy the range I then use
>
> Intra_mA.Copy Worksheets("Dental").Range("A16")
>
> Would it be easier to create named ranges on the lookup ***, and how
would
> I then implement the copy routine?
>
> I am thinking this because I just came across an error in my original
setup
> for one of the sheets which meant I had to insert another line into a
range,
> thereby offsetting all the ranges below it.
>
> --
> Ian
> --
>
>


.