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.
 

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

Ignoring a blank cell while running a macro. 1
Need Macro... 8
Concat a three column range into one cell Then Next... 2
Advice on multiple macros, same code just a different column 9
Updatig the Next Consecutive Empty Cell in a Range 3
Focus on next blank cell 14
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Macro command to move cell selection 3

Back
Top