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