macro- move down to empty cell & active worksheet

E

EducatingMom

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.
 
E

EducatingMom

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.
 
Top