+ Reply to Thread
Results 1 to 4 of 4

ActiveCell.FormulaR1C1 Dynamic Row

  1. #1
    Registered User
    Join Date
    12-01-2009
    Location
    NorCal, CA
    MS-Off Ver
    Excel 2007
    Posts
    8

    ActiveCell.FormulaR1C1 Dynamic Row

    Hi,

    I am trying to use ActiveCell.FormulaR1C1 to select a particular cell.

    My code is the following:

    Please Login or Register  to view this content.
    However, I don't always want it to select 9 rows down.
    Earlier in the macro I have defined the following variables:
    assumptions_end
    assumptions_beg

    I tried to use the following syntax but it did not work:

    Please Login or Register  to view this content.
    What is the proper syntax for using a dynamic row? (The column does not need altering).

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: ActiveCell.FormulaR1C1 Dynamic Row

    If relative use:

    Please Login or Register  to view this content.
    If non-relative (ie absolute/fixed row) remove the [ ]

  3. #3
    Registered User
    Join Date
    12-01-2009
    Location
    NorCal, CA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: ActiveCell.FormulaR1C1 Dynamic Row

    Thanks. The non-relative is really the only way for me to do what I need, but is there any way to remove the "$" that comes along with the non-relative formula? The formula fixes the row and I would like to undo that, if possible.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: ActiveCell.FormulaR1C1 Dynamic Row

    Quote Originally Posted by goldenbear10 View Post
    Thanks. The non-relative is really the only way for me to do what I need, but is there any way to remove the "$" that comes along with the non-relative formula? The formula fixes the row and I would like to undo that, if possible.
    I'm afraid that doesn't make much sense to me - if you don't want the $ then that is not a "non-relative" approach.

    There are quite a few posts where people will outline the basics re: R1C1 notation - "here is one I made eariler" so to speak:

    http://www.excelforum.com/2171545-post2.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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