Solved how to copy a named range of cells to another range

October 27, 2014 at 01:12:47
Specs: Windows 7
For example, I have named a box of cells (3 across and 3 down) with the name Tile1.

I now want to be able to enter =Tile1 at another location and for the data that makes up Tile 1 to appear. How do I do it?

See More: how to copy a named range of cells to another range

Report •

October 27, 2014 at 06:17:24
Try this:

In the Name box (to the left of the formula bar)
Select Tile1
Select Copy

Navigate to the cells where you wish to copy to:
Select Paste

See how that works.


message edited by mmcconaghy

Report •

October 27, 2014 at 07:53:11
✔ Best Answer
I don't know that it can be done as simply as just entering =Tile1.

I know it can to be done via VBA or by using the INDEX function, but the INDEX method would require an INDEX function in each cell.

In other words,

=INDEX(Tile1,1,1) would return the upper left cell of the named range
=INDEX(Tile1,2,1) would return the cell just below the upper left cell

There are creative ways to avoid entering each individual INDEX function by using the ROW() and COLUMN() functions, but we would need more detail related to the location of the Named range and the destination range for the "copy". Using ROW() and COLUMN() as the arguments for the INDEX Function might allow for simply dragging a single INDEX function across and down.

VBA would be easy:

Select the first cell of the destination range and run this code:

Sub CopyNamedRange()
   Range("Tile1").Copy Range(Selection.Address)
End Sub

There may be a way to make the VBA solution automatic but I need to know if you are even interested in a VBA solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question