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.

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.

Thanks, Fred. Any clue on how to replace a specific file name with a generic
one, like Active Worksheet? Here is the line from my macro that I need
changed, Windows("4 Way St.-Pretzel Park.xls").Activate

I want this macro to run on any file that I have open and active.




"Fred Smith" wrote:

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.

It's as you would expect:

Activesheet or
Activewindow

--
Regards,
Fred


"EducatingMom" wrote in message
...
Thanks, Fred. Any clue on how to replace a specific file name with a generic
one, like Active Worksheet? Here is the line from my macro that I need
changed, Windows("4 Way St.-Pretzel Park.xls").Activate

I want this macro to run on any file that I have open and active.




"Fred Smith" wrote:

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.