This will tell you the first available row at the end of a
range.

NextRow = ActiveSheet.Range("A65536").End(xlup).Row

Or you could return the address.

NextRow = ActiveSheet.Range("A65536").End(xlup).Row

tod

-----Original Message-----
Here is the scenerio any help would be great!!!!


1. So I have two pages in the worksheet one named "form"
and the other
named "data".
2. The form page has a submitt button at the bottom that
runs a macro
that basically cuts and pastes all required data to "data
page".

Easy enough...My Problem...

How do I find the next open row (on the "data" page) so
when the second
line of data is entered it does not overwrite the first?
Is this
something that can "easily" be done in excel?

Any thoughts of Excel wisdom would be great!


---
Message posted from http://www.ExcelForum.com/

.