Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the cell reference for a vlookup? | Excel Worksheet Functions | |||
Can't find the min of a lookup reference | Excel Worksheet Functions | |||
find reference to other workbook | Excel Discussion (Misc queries) | |||
Find Max and Min based on cell reference | Excel Discussion (Misc queries) | |||
How do I find a cross reference value | Excel Discussion (Misc queries) |