I have a macro that takes data from one sheet and adds it into a table
on another form, at the moment it all works fine as long as all fields
are filled in everytime a new entry is added. What I want is to be
able to have some fields blank, to do this I need to be able to find
the last row with data in any column on the first sheet, and the first
row with no data in any columns on the next sheet. Is there a simple
way this can be done.
At the moment I use this:

Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

but this will find the first empty fields and so doesn't necesarily
find all the data.

Thanks for any assistance.

J


--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile: http://www.excelforum.com/member.php...o&userid=34382
View this thread: http://www.excelforum.com/showthread...hreadid=541627