Help! Find reference of last used row
 

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.

Help! Find reference of last used row
 

=ADDRESS(MATCH(LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535),A:A,0)+1,1)

will give address for column A

Change the last "1" to your column as well as changing the "A" ranges

"Haxer" wrote:

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.

Help! Find reference of last used row
 

Thank you for your quick answer. I should have explained more... I am
actually using a macro. I need it to find the last cell in column A that has
data in it. Then add one to it (drop down to the next empty row) and give me
the reference of that cell (examle: A564) I need to place data in cells
pertaining to that reference and would like to know what it is. Thank you for
all your help!

"Toppers" wrote:

=ADDRESS(MATCH(LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535),A:A,0)+1,1)

will give address for column A

Change the last "1" to your column as well as changing the "A" ranges

"Haxer" wrote:

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.

Help! Find reference of last used row
 

nextrow=cells(rows.count,"A").end(xlup).row+1

will give next empty cell in column A

"Haxer" wrote:

Thank you for your quick answer. I should have explained more... I am
actually using a macro. I need it to find the last cell in column A that has
data in it. Then add one to it (drop down to the next empty row) and give me
the reference of that cell (examle: A564) I need to place data in cells
pertaining to that reference and would like to know what it is. Thank you for
all your help!

"Toppers" wrote:

=ADDRESS(MATCH(LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535),A:A,0)+1,1)

will give address for column A

Change the last "1" to your column as well as changing the "A" ranges

"Haxer" wrote:

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.

Help! Find reference of last used row
 

An over tired idiot thanks you! I knew that is what i was looking for as soon
as I saw it. Once again thank you!
"Toppers" wrote:

nextrow=cells(rows.count,"A").end(xlup).row+1

will give next empty cell in column A

"Haxer" wrote:

Thank you for your quick answer. I should have explained more... I am
actually using a macro. I need it to find the last cell in column A that has
data in it. Then add one to it (drop down to the next empty row) and give me
the reference of that cell (examle: A564) I need to place data in cells
pertaining to that reference and would like to know what it is. Thank you for
all your help!

"Toppers" wrote:

=ADDRESS(MATCH(LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535),A:A,0)+1,1)

will give address for column A

Change the last "1" to your column as well as changing the "A" ranges

"Haxer" wrote:

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.

Help! Find reference of last used row
 

Sub findbottom()
MsgBox ActiveSheet.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).Address
End Sub


Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 11:28:02 -0700, Haxer
wrote:

Thank you for your quick answer. I should have explained more... I am
actually using a macro. I need it to find the last cell in column A that has
data in it. Then add one to it (drop down to the next empty row) and give me
the reference of that cell (examle: A564) I need to place data in cells
pertaining to that reference and would like to know what it is. Thank you for
all your help!

"Toppers" wrote:

=ADDRESS(MATCH(LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535),A:A,0)+1,1)

will give address for column A

Change the last "1" to your column as well as changing the "A" ranges

"Haxer" wrote:

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.

Help! Find reference of last used row
 

I know the feeling well!!!

"Haxer" wrote:

An over tired idiot thanks you! I knew that is what i was looking for as soon
as I saw it. Once again thank you!
"Toppers" wrote:

nextrow=cells(rows.count,"A").end(xlup).row+1

will give next empty cell in column A

"Haxer" wrote:

Thank you for your quick answer. I should have explained more... I am
actually using a macro. I need it to find the last cell in column A that has
data in it. Then add one to it (drop down to the next empty row) and give me
the reference of that cell (examle: A564) I need to place data in cells
pertaining to that reference and would like to know what it is. Thank you for
all your help!

"Toppers" wrote:

=ADDRESS(MATCH(LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535),A:A,0)+1,1)

will give address for column A

Change the last "1" to your column as well as changing the "A" ranges

"Haxer" wrote:

I know this is a simple thing I'm sure.

I'm just trying to find the reference of the cell after the last cell with
data in it in a known column.

I'm sleep deprived and can no longer figure simple things out! I need to get
this done so I can sleep! Thanks for any help.