Select next blank cell in column, before running macro

  • Thread starter Thread starter BadRasta
  • Start date Start date
B

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
 
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.
 
Back
Top