+ Reply to Thread
Results 1 to 2 of 2

Reference the next available row/cell within a worksheet

  1. #1
    Registered User
    Join Date
    10-09-2006
    Posts
    22

    Reference the next available row/cell within a worksheet

    I am trying to find a way to hyperlink to a cell within a worksheet that is referenced from another worksheet but within the same workbook. Iím going to need a formula to do this for I must first check the first column of the sourced worksheet for it is the only column in which there will be data stored. This is a date column but all I want to find out is what the next available row is so I can use that reference when sourcing the appropriate cell within my hyperlink.

    For instance:


    A B C D
    1 01/25 4.856
    2 02/01 3.254
    3 03/25 3264
    4 06/15 3.265
    5 08/17 3.25
    6
    7
    8


    I need to hyperlink to column C but jump to row 6 for that is the next available row to be written to.

    Iím thinking that I can use row A for it will always be populated whereas the other rows only one of the columns may contain data. Is this possible? Can you help me come up with a way to identify the next available row to write data?

    Any help would be greatly appreciated..

    Mike

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by d888nc
    I am trying to find a way to hyperlink to a cell within a worksheet that is referenced from another worksheet but within the same workbook. I’m going to need a formula to do this for I must first check the first column of the sourced worksheet for it is the only column in which there will be data stored. This is a date column but all I want to find out is what the next available row is so I can use that reference when sourcing the appropriate cell within my hyperlink.

    For instance:


    A B C D
    1 01/25 4.856
    2 02/01 3.254
    3 03/25 3264
    4 06/15 3.265
    5 08/17 3.25
    6
    7
    8


    I need to hyperlink to column C but jump to row 6 for that is the next available row to be written to.

    I’m thinking that I can use row A for it will always be populated whereas the other rows only one of the columns may contain data. Is this possible? Can you help me come up with a way to identify the next available row to write data?

    Any help would be greatly appreciated..

    Mike
    Try

    LastRow = Sheets("Sheet1").Range("C65536").End(xlUp).Row

    (for column C - otherwise take the correct column)

    note, if either of two columns could have data, run that twice and select the greater row number.
    ---
    Last edited by Bryan Hessey; 10-16-2006 at 08:10 PM.
    Si fractum non sit, noli id reficere.

+ 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