Reference the next available row/cell within a worksheet

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.
---