+ Reply to Thread
Results 1 to 4 of 4

Coping with $?

  1. #1
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Coping with $?

    For a cell i use this formule
    Please Login or Register  to view this content.
    But i like the same formule for row 6 till 44 and have some columns to copy as well.
    Is there a way to copied this and adding a row.
    Please Login or Register  to view this content.
    etc

    I need the $ because a script is copying cells and the conditional formatting depending on it.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Coping with $?

    The whole reason for using $ is to make the cell reference absolute - in other words, to lock it. If you want the row to increment as you go down the rows, you should use this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If for some reason you MUST use the absolute references for E5 and F5, then you could use this to increment the row as you drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Helpt dat?



    For non-Dutch speakers who might view this thread, the formulae are:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: Coping with $?

    Thanks for the help sometimes you try things for a our ans think let ask. And then you get a eureka moment!
    I solved the problem with not copying bur value = value in VBA. Then is leaves the conditional formatting as is.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Coping with $?

    Goed dat u een oplossing gevonden hebt en bedankt voor de reputatie.

    (translation for non-Dutch speakers: It's good that you found a solution and thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Coping Data Help
    By REAPERSROVERS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-19-2014, 01:24 PM
  2. Coping from one sheet to another using VBA
    By harcor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2013, 08:43 PM
  3. Coping a picture
    By CovePark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2008, 12:57 PM
  4. Coping down error
    By bud77 in forum Excel General
    Replies: 2
    Last Post: 07-12-2008, 07:58 PM
  5. coping data without coping formulars
    By stevekirk in forum Excel General
    Replies: 6
    Last Post: 09-07-2006, 11:47 AM
  6. Coping formula down
    By Jennifer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2005, 08:05 AM
  7. [SOLVED] coping
    By ben kiser in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-11-2005, 09:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1