Name
Posted by Dee on November 04, 2001 7:30 AM
I have defined & named a range in both a source workbook & a destination workbook. I do not find that name when I click on Name box in the upper left hand corner of the destination workbook. If in the destination workbook I click Insert name & Define, it shows up there. What am I doing wrong? I'm trying to create a macro & it would help to have that name show up in the Name box. Thank you in advance.
Posted by Dee on November 04, 2001 12:39 PM
I figured out how to name a single cell in a source workbook & then copy it to a single cell in another workbook, but now I'm having trouble naming 3 cells in a row in a source workbook & copying that name (& the data) to 3 cells in a row in a destination workbook. When I copy the named range from the source workbook to a destination workbook only the first cell is copied. Any help would be appreciated. Again, thank you
