Find and Select the Next Empty Cell in Column A

You don't need to select cells to put data into them. When you use the macro recorder, it records FAR more events than are needed, and pretty much the "select" stuff can always be edited out.

For instance, your three lines above can actually be reduced to one like so:

Please Login or Register  to view this content.

Now, to answer your question, it could be done a few ways. Longer and harder to read, but still basically the same code as above:

Please Login or Register  to view this content.

If you post up your entire macro, we'll be able to suggest more ways to simplify the code, I'm sure.