Range selection macro

[not very bright dave]

Hi all

I have a dynamic range of data which will be added to constantly. This means that when I want to select the data I will require non-specific selection criteria. At the moment I have, starting at the very bottom of the worksheet:


Selection.End(xlUp).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlUp)).Select

My only problem is that I need to select down one row after this so to remove the header row. Can anyone help me with the code for this?

Many thanks

Dave

 

[shades]

Something like this?

Sub FindFirstEmptyCell()
    Dim myRow As Long
    myRow = Range("A1:A" & Range("A65536").End(xlUp).Row).Count
    Cells(myRow + 1, 1).Select
End Sub