A Albert Browne Jun 14, 2008 #1 I need to find the row number of next empty cell in a range E7:E66. How do I do this. Thanks, Albert
P Per Jessen Jun 14, 2008 #2 Hi Albert Assuming you have a heading in E6, you can use this line NextRow = Range("E67").End(xlUp).row Regards, Per
Hi Albert Assuming you have a heading in E6, you can use this line NextRow = Range("E67").End(xlUp).row Regards, Per
D Don Guillett Jun 14, 2008 #3 Or, if you want to go from the top down NextRow = Range("E7").End(xldown).row+1