+ Reply to Thread
Results 1 to 6 of 6

Reference row of Active Cell in Hyperlink formula

  1. #1
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Reference row of Active Cell in Hyperlink formula

    I need to modify my existing code to reference the Row of the Active Cell.
    Then, use that Row reference in part of my formula.

    Please Login or Register  to view this content.
    The highlighted reference is where I would like to change 11 of C11 to the Row of the Active Cell.

    Thank you for your help,
    Delain

  2. #2
    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,464

    Re: Reference row of Active Cell in Hyperlink formula

    Please Login or Register  to view this content.

    Regards, TMS
    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


  3. #3
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Reference row of Active Cell in Hyperlink formula

    Excellent & sweet, at the same time!

    Thanks for the quick response.

    Delain

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Reference row of Active Cell in Hyperlink formula

    Another option, using R1C1
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  5. #5
    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,464

    Re: Reference row of Active Cell in Hyperlink formula

    You're welcome. Thanks for the rep.

  6. #6
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Reference row of Active Cell in Hyperlink formula

    Norie, thanks for your input. Mr. Shuttleworth's solution is exactly what I was looking for.


    Delain

+ 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. External cell reference based on hyperlink in a cell in the active sheet
    By Sydstar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2014, 08:25 AM
  2. [SOLVED] Formula/Macro to give active cell reference in cell
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-23-2014, 03:36 AM
  3. Replies: 2
    Last Post: 07-14-2011, 03:16 PM
  4. Replies: 4
    Last Post: 02-22-2011, 10:56 AM
  5. How to change active cell after hyperlink clicked
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 12-28-2009, 02:29 PM
  6. Use Active Cell to create Hyperlink
    By cob943 in forum Excel General
    Replies: 2
    Last Post: 10-08-2008, 03:37 PM
  7. script to hyperlink and reference a cell value in the hyperlink
    By Natasha D. in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2006, 02:43 PM

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