Auto selection of next row

[railpost]

Hi,

I am trying to simplify the entry of data onto a spreadsheet..

The calculations etc are all setup and working but I now need to allow the user to enter from data from a seperate form.. Question How do I get excel to select the next empty row for the entry of data without losing data already in the column using a form???...

Thanks..

Railpost

 

[HalfAce]

If your column of interest was column A... then
Range("A65536").End(xlUp)(2, 1).Select
will select the first blank row below the lowest data in column A.

(Several ways to get there, this is just one of them.)

Hope it helps,
Dan