+ Reply to Thread
Results 1 to 5 of 5

Formula insertion with relative reference.

  1. #1
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    280

    Formula insertion with relative reference.

    I have used the code below to add a formula into a cell but all the references are absolute and I want C4a to be relative. How do I modify the code to get C4a relative?

    Please Login or Register  to view this content.
    Thanks Sandy

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula insertion with relative reference.

    Try something like this:
    Please Login or Register  to view this content.
    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: Formula insertion with relative reference.

    Hi Ron, That got the row relative, thanks. How do I get the column relative as well?

  4. #4
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula insertion with relative reference.

    Not surprisingly:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: Formula insertion with relative reference.

    Thanks Ron that worked Sandy

+ 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. [SOLVED] Formula with relative reference
    By MigLMunoz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2013, 12:50 PM
  2. Needing a relative cell reference for a vba formula insertion
    By timsilver in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2013, 02:17 PM
  3. Replies: 5
    Last Post: 09-21-2012, 02:08 PM
  4. [SOLVED] Count Formula with Relative Reference
    By amotto11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2012, 11:39 AM
  5. [SOLVED] Using Relative Reference in a Formula
    By tedd13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2006, 11:10 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