Solved: Specific cell selection

[justdream]

Dears,

Do you know how to force Macro to select the last row in Excel sheet
even if the sheet contains multiple blank rows..

I tried this code but I stucked in between balnk rows

[vba]Windows("Input.txt").Activate
Range("A1").Select
Selection.End(xlDown).Select[/vba]

[Bob Phillips]

[vba]

Windows("Input.txt").Activate
With Activesheet

.Cells(.Rows.Count, "A").End(xlUp).Select
End With
[/vba]

[justdream]

Dear Thanks a lot, I just would like to go down one more row
Sorry

[Bob Phillips]

[vba]

Windows("Input.txt").Activate
With Activesheet

.Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0).Select
End With
[/vba]

[Paul_Hossler]

[VBA]
Windows("Input.txt").Activate
With Activesheet

.Cells(.Rows.Count, "A").End(xlUp).Offset(1,0).Select
End With
[/VBA]

Paul