About Us

[email protected]

ahh, that works nicely
wrote:
Hi Robert,

The copy function would take over the whole range. You can use it like
so:

Worksheets("Template").Range("statrows").Copy Selection

Regards,
Steve

wrote:
I just needed to resize the selection to match the named range:

Range("a1").End(xlDown).Offset(2, 0).Select

Selection.Resize(10, 60).Select

Selection.Value = Worksheets("Template").Range("statrows").Value

Although it seems like there should be a way to make it just dump the
whole range in without requard to size.

wrote:
Steve,

I updated the code with your suggestion to:

Range("a1").End(xlDown).Offset(2, 0).Select

Selection.Value = Worksheets("Template").Range("statRow").Value

I still get an "Run Time Error 1004 Application Defined or Object
Defined Error."

Thanks for the help

wrote:
Hi Robert,

You don't need to use the names collection. Just say:

Worksheets("Template").Range("statRow").Value

Regards,
Steve

wrote:
I have a macro in a workbook that creates worksheets and copies data
from other sheets to the new sheets. I also have a template sheet
that has large range of cells with formulas that I want to copy to the
new sheet after the rest of the data is in place. I'm using a named
range for the location of the template cells "Template!statRow".
The following code is initiated in the new worksheet and activates the
correct cell to paste the cells from the names range but I cannot seem
to get the pasting in correct.

Public Sub InsStatRow()
'Insert Statistics rows

'move to insertion point
Range("a1").End(xlDown).Offset(2, 0).Select

Selection.Value = Worksheets("Template").Names("statRow")

End Sub

I get a runtime error 1004 at the line
Selection.Value = Worksheets("Template").Names("statRow")

I've tried many variations, to no avail. Any help will be
appreciated.
Robert

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste to next empty cell in named range of cells	Sully	Excel Discussion (Misc queries)	3	March 4th 10 05:23 PM
Copy and Paste 2 columns from a named range?	Simon Lloyd[_735_]	Excel Programming	2	May 28th 06 08:10 PM
paste values from named dynamic range to another worksheet	Nate H	Excel Programming	2	January 25th 06 06:50 PM
Paste a named range to another range in Excel	David Jean	Excel Discussion (Misc queries)	2	April 13th 05 02:02 PM
How to paste only certain columns from a listbox into a named range	GH[_2_]	Excel Programming	2	January 5th 05 12:40 PM

Menu

About Us