Try:

Activecell.end(xldown).offset(1,0).select

--
Regards,
Fred


"EducatingMom" wrote in message
...
Hello, I have recorded a macro and I need to know what command to give it to
advance the active cell down the spreadsheet to the first empty cell. Also,
how do I tell the macro to look at the active worksheet or file to run, not a
specific one. I want to run this macro on a lot of files. Right now the
macro has one specific file name and I need to be able to run the macro on
any file.

Thanks.