Select next blank cell in column, before running macro
 

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

Select next blank cell in column, before running macro
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BadRasta" wrote in message
...
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

Select next blank cell in column, before running macro
 

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.

"BadRasta" wrote in message
...
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