Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Range names as copy or print designations (Excel 2003)

    When I used Lotus years ago, I could name a range RANGE and then go to the copy function and say copy RANGE and paste the data from that range into the location I wanted. When I wanted to print I could name a range XYZ and simply tell Lotus to print XYZ. I have tried from time to time to get this to work in Excel but without success. I need that ability again and I thought I might ask the Forum if it is possible to do that. I can't say edit Copy and insert XYZ into the instruction somehow. Can it be done? As always, TYIA.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Using Range names as copy or print designations (Excel 2003)

    Select the "copyfrom" name in (or type it into) the NAME BOX
    Edit - copy (or Ctrl-c)
    Select the "copyto" name in (or type it into) the NAME BOX
    Edit - Paste (or Ctrl-v)

    In VB you can use the names as ranges (change the range names as approipriate)
    Range("CopyFrom").Copy Range("CopyTo")


    Steve

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Using Range names as copy or print designations (Excel 2003)

    Steve,

    This looks interesting but I'm not sure what to do.

    I created 2 cells with names of "copyfrom" (cell A4) and "copyto" (cell D4). The cell copyfrom has a value of 14. I position the cursor in A4 and up pops copyfrom in the NameBox. I copy that to the clipboard so the clipboard contains the word "copyfrom". I now position the cursor in D4 and up pops copyto in the NameBox. I paste the contents of the clipboard into the NameBox and it now contains copyfrom. When I hit enter, the active cell becomes A4.

    Somehow, I don't think this is what was expected. Looking at the VBA, it definitely seems something different is happening - copying the contents of copyfrom to copyto.

    Fred

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Using Range names as copy or print designations (Excel 2003)

    Don't copy the NAME to the clipboard. You will select the cell(s) named CopyFrom.

    Select the "copyfrom" name in (or type it into) the NAME BOX [This will Select the "CopyFrom Cells"]
    Edit - copy (or Ctrl-c)
    Select the "copyto" name in (or type it into) the NAME BOX [This will Select the "CopyTo Cells"]
    Edit - Paste (or Ctrl-v)

    Steve

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Using Range names as copy or print designations (Excel 2003)

    Thanks Steve.

    Got it now. I thought this would be dynamic so that if copyfrom changes, the copyto cell changes. I see what's going.

    Fred

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Using Range names as copy or print designations (Excel 2003)

    If you want to do that, you can do with links

    Instead of pasting, You can paste - special and press <Paste Links> and then changes in the copy from will change the copyto

    OIr, in the Copyto cells, just enter an equal sign (=) and point to the cell you want to link. Then you can copy this formula to fill in the rest of the cells

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •