Select next blank cell in column, before running macro

[BadRasta]

Keeping in mind, Im a rookie...

Hello All,
I have a spreadsheet that tracks how many estimates our department does with
other pertinent data
The macro I recorded opens a text file formats it with text to column and
then copies specific cells and pastes them to one row (11 consecutive cells)
Is there a way to have the macro select the next blank cell in column "A"
before starting executing the rest of the macro?

Thnx,
BadRasta

 

[Don Guillett]

The best time to learn procedure is now. ALWAYS post your code for comments.

 

[Patrick Molloy]

add

range("A1").end(xldown).offset(1).select

to just before the paste section.

it would be easier to say where if you showed your code.