macro- move down to empty cell & active worksheet

[Guest]

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.

 

[Fred Smith]

Try:

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

 

[Guest]

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]

It's as you would expect:

Activesheet or
Activewindow