Select next blank cell in column, before running macro

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
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Macro to copy from active cell and down 8
Concat a three column range into one cell Then Next... 2
Ignoring a blank cell while running a macro. 1
Combine 2 columns in a dynamic range into one 7
For-Next by a row Counting consecutive Zero in the column 4
Skip copying empty column where remaining rows are filled 2
Focus on next blank cell 14

Top