finding last row

[TCHME]

I have a program that enters data in to certain column, but I need to find the next open row
Can anyone help with this?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks
TCHME

 

[Trevor G]

If you record with the mouse you can use the Ctrl + Down Arrow key on the keyboard and that will give you code you could use. Sample below:

Range("D3").Select
Selection.End(xlDown).Select

Then you could add and Offset so you end up with this

Range("D3").Select
Selection.End(xlDown).Select
Activecell.Offset(1,0).select

 

[Desu Nota from Columbus]

I have a program that enters data in to certain column, but I need to find the next open row
Can anyone help with this?
<!--?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /--><o></o>
Thanks
TCHME

Columns("A:A").Select
Range("A" & Rows.Count).End(xlUp).Offset(1,0).Select

 

[Comfy]

http://www.mrexcel.com/td0058.html