Range("SrcRg").Copy Range("DestRg")

should work. I don't usually do a Set of a range variable unless I'm going
to use it several times.

--
Jim
"Ian" wrote in message
...
| Tom, I'm having difficulty with this. If I do away with the Dim & Set
lines
| and leave the Copy line the same, I get a Run-time error '424': Object
| required. Am I missing something glaringly obvious?
|
| --
| Ian
| --
| "Ian" wrote in message
| ...
| So basically I'm doing away with my Dim & Set lines and leaving the Copy
| line the same. Easier to implement than I thought.
|
| Thanks, Tom.
|
| --
| Ian
| --
| "Tom Ogilvy" wrote in message
| ...
| Intra_mA.Copy Range("Destination")
|
| --
| Regards,
| Tom Ogilvy
|
| "Ian" wrote in message
| ...
| I am creating a series of sheets where basic data is entered on a
| userform
| then ranges are copied from a lookup sheet are copied to a sheet 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 sheet, 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
| --
|
|
|
|
|
|
|
|