View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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