Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
First blank row in a column
A couple of weeks ago, someone in this group gave me a
very clean one-line macro to find the first blank row in a column. It had (xlDown) and Offset(0,1) in it but I can't remember the whole thing. Could someone please help me find it again? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
First blank row in a column
Richard
something like: Range("A1").End(xlDown).Offset(1,0).Select Regards Trevor "Richard" wrote in message ... A couple of weeks ago, someone in this group gave me a very clean one-line macro to find the first blank row in a column. It had (xlDown) and Offset(0,1) in it but I can't remember the whole thing. Could someone please help me find it again? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
First blank row in a column
Richard,
Assuming that there are at least two items at the top of the column, use Range("A1").End(xlDown).Offset(1, 0).Select Change A1 to the appropriate starting cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Richard" wrote in message ... A couple of weeks ago, someone in this group gave me a very clean one-line macro to find the first blank row in a column. It had (xlDown) and Offset(0,1) in it but I can't remember the whole thing. Could someone please help me find it again? Thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
First blank row in a column
Nothing's easy. What do you mean "find" it? Return it's value? Return
it's address? Select it? Something else? Alan Beban Richard wrote: A couple of weeks ago, someone in this group gave me a very clean one-line macro to find the first blank row in a column. It had (xlDown) and Offset(0,1) in it but I can't remember the whole thing. Could someone please help me find it again? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Sum a column if reference column is blank | Excel Worksheet Functions | |||
insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
SUM values in this column F only if cell is blank in column Q...HE | Excel Discussion (Misc queries) | |||
How do I count the items in one column if another column is blank | Excel Worksheet Functions | |||
Warning message if one column contains any text and another column is blank | Excel Worksheet Functions |