Range("A1").End(xlDown).Select

But review the message in the programming newsgroup for caveats about not
selecting and activating things when you don't have to.

On Fri, 11 Mar 2005 23:41:33 -0600, "Greegan" wrote:

Now I know i could select ctrl down arrow to select the last cell and then
arrow down again to select the next cell.
If I record this it suggests I am selecting specific cells.
My issue with that is that column A will have a different number of rows
occupied by text and whatnot.
Is there a command or something that would select the first blank cell in
column A?

Thank you in advance. You guys are always willing to give an answer.

G