+ Reply to Thread
Results 1 to 10 of 10

xxx should be replaced by a reference to the cell, in the D column in the same row of the

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    GENT
    MS-Off Ver
    O365
    Posts
    13

    xxx should be replaced by a reference to the cell, in the D column in the same row of the

    Hi Folks

    Someone can surely help me out here.
    As a no-techie I've been struggling with this last bit.
    In the following line, the xxx should be replaced by a reference to the cell, in the D column in the same row of the active Cell.
    Please Login or Register  to view this content.
    I guess quite simple, but I can't see it, nor find it at first hand.

    Thx in advance for any knowledge help

    aTRc
    Last edited by AliGW; 07-10-2019 at 02:00 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are still new here, I have done it for you this time.)


    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are still new here, I will do it for you this time.)
    Last edited by AliGW; 07-10-2019 at 02:01 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    When you pushing the reference in code then why you need INDIRECT(""RC[-2]"",0)?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    You can answer - the OP is new and I have made the changes for him.

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    Quote Originally Posted by AliGW View Post
    You can answer - the OP is new and I have made the changes for him.
    Thanks for the intimation

  6. #6
    Registered User
    Join Date
    07-08-2019
    Location
    GENT
    MS-Off Ver
    O365
    Posts
    13

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    Quote Originally Posted by AliGW View Post
    You can answer - the OP is new and I have made the changes for him.
    Confusing. Do I need to do anything else.
    Sorry for the trouble, was struggling to give a good discription in the Thread Name.
    Will be more specific in the future...

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    No, as you are new I have done it all for you, as I explained in my post (not confusing if you read everything I wrote).

  8. #8
    Registered User
    Join Date
    07-08-2019
    Location
    GENT
    MS-Off Ver
    O365
    Posts
    13

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    Quote Originally Posted by :) Sixthsense :) View Post
    When you pushing the reference in code then why you need INDIRECT(""RC[-2]"",0)?
    Hi
    I need to have the average value from a range starting in the D column of the active Row and stopping in the last(-2) column in the active row.
    I see now that I made an additional error by stating ActiveCell.Offset(0, 6).FormulaArray =
    Since columns may be inserted, the Offset 6 will not do it.
    So I have to figure out some more things.

    In short and to visualise it:
    Attachment 631600

    the value in cell V8 should be =IFERROR(AVERAGE(R8:INDIRECT("RC[-2]";0));"")
    when inserting columns adding colums

    Anyway thx.
    I have to rework first

  9. #9
    Registered User
    Join Date
    07-08-2019
    Location
    GENT
    MS-Off Ver
    O365
    Posts
    13

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    Quote Originally Posted by AliGW View Post
    No, as you are new I have done it all for you, as I explained in my post (not confusing if you read everything I wrote).
    OK, thx.
    Will pay attention in the future

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: xxx should be replaced by a reference to the cell, in the D column in the same row of

    Untested but try

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Replies: 1
    Last Post: 08-14-2015, 02:49 AM
  2. Indirect Sheet reference with cell reference left function and text
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:31 AM
  3. Replies: 1
    Last Post: 02-11-2015, 01:56 PM
  4. [SOLVED] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  5. Replies: 5
    Last Post: 02-25-2010, 03:51 PM
  6. Replies: 3
    Last Post: 05-13-2009, 11:51 PM
  7. Text Cell reference and increase the cell reference by step value
    By Supriya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2005, 08:18 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