Select the next row after xldown range

[ExcelMonkey]

I want to highlight column A all the way down to the end of its curren
data range and then select the first row after the end of the dat
range. Assuming column A has 14 rows of data I want to then select th
15th row (i.e. A15).

What do I have to add to the end of this code to do that?


Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select

Thank

 

[Frank Kabel]

Hi
try
Range(Selection, Selection.End(xlDown).offset(1,0)).Select

 

[ExcelMonkey]

Thanks Frank