| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find row number of next empty cell in range
I need to find the row number of next empty cell in a range E7:E66. How do I
do this. Thanks, Albert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find row number of next empty cell in range
Hi Albert
Assuming you have a heading in E6, you can use this line NextRow = Range("E67").End(xlUp).row Regards, Per "Albert Browne" skrev i meddelelsen ... I need to find the row number of next empty cell in a range E7:E66. How do I do this. Thanks, Albert |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find row number of next empty cell in range
Or, if you want to go from the top down
NextRow = Range("E7").End(xldown).row+1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Per Jessen" wrote in message ... Hi Albert Assuming you have a heading in E6, you can use this line NextRow = Range("E67").End(xlUp).row Regards, Per "Albert Browne" skrev i meddelelsen ... I need to find the row number of next empty cell in a range E7:E66. How do I do this. Thanks, Albert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i find last not empty cell in a range | Excel Worksheet Functions | |||
| Find first empty cell in range and paste formula?? | Excel Programming | |||
| find first empty cell in range and copy information from another workbook | Excel Programming | |||
| Macro to find empty cell and select range to print selected. | Excel Programming | |||
| find the cell above any number in any range | Excel Worksheet Functions | |||
Hybrid Mode
