+ Reply to Thread
Results 1 to 4 of 4

Relative Reference Formula VBA

  1. #1
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    50

    Relative Reference Formula VBA

    Hi All, Could you please kindly advise as to why the below formula throws a run time error (1004) on the 'RC' part, when I try to run it inside of a previously working loop?

    Please Login or Register  to view this content.
    I'm trying to input a relative reference to Col C from Col J, for what it's worth.

    Many thanks!

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Relative Reference Formula VBA

    You should use
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Relative Reference Formula VBA

    You're mixing A1 and R1C1 reference styles. Use one or the other.

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Rory

  4. #4
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    50

    Re: Relative Reference Formula VBA

    Thank you!

+ 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. Named formula relative reference
    By radji in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-11-2016, 04:56 PM
  2. [SOLVED] Formula insertion with relative reference.
    By gsandy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2014, 04:22 PM
  3. [SOLVED] Formula with relative reference
    By MigLMunoz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2013, 12:50 PM
  4. Replies: 5
    Last Post: 09-21-2012, 02:08 PM
  5. [SOLVED] Count Formula with Relative Reference
    By amotto11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2012, 11:39 AM
  6. [SOLVED] Problem with a relative reference in a formula.
    By roontoon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2012, 10:34 AM
  7. Using Relative Reference in a Formula
    By tedd13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2006, 11:10 AM

Tags for this Thread

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