| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name defined Range - Copy?
Hi!
One way: Assume the defined name is Rng. Select the the destination range H6:M10 (5R x 6C). With H6 as the active cell (H6 has no "blueish" color, all other cells in the selection do) enter this formula using the key combination of CTRL,SHIFT,ENTER: =Rng Biff "John Buckley" wrote in message ... On sheet one I have a 5 row 6 column, named range. All cells are text. This named range starts at cell A1. I want to display this named range on sheet three, starting at cell H6. Copy / Paste? Formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy the formatting and content of a range | Excel Discussion (Misc queries) | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| How to copy a filtered range ? | Excel Discussion (Misc queries) | |||
| How do you copy RANK w/o it changing the range? | Excel Worksheet Functions | |||
Threaded Mode
