Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cut and Paste special (2000/XP)

    I need to cut and paste a formula to 200 rows.
    MID(G4,1,SearchReverse(G4,".")-1)&"("&D4&E4&"_"&C4&"_"&F4&"_"&A4&")"&MID(G4,Searc hReverse(G4,"."),4)
    Part of the formula references data in row 4 "("&D4&E4&"_"&C4&"_"&F4&"_"&A4&")"
    I want to keep that constant in each row.
    When I use Paste Special>Formula, it modifies the formula for the current row number.
    Is there a way to paste so I don't have to edit formulas in 200 rows. Or is there another way to do it.
    thanks,
    Scott

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cut and Paste special (2000/XP)

    Select the part of the formula you want to keep constant.
    Press F4, then Enter.
    Alternatively, you can insert $ signs before the row numbers you want to keep constant. The $ signifies an absolute (unchanging) reference, as opposed to the default relative (changing) reference.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cut and Paste special (2000/XP)

    Hans,
    The $ was what I was looking for.
    I was going to do a search but didn't know what to call what I was looking for.

    Thanks again, <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    Scott

Posting Permissions

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