Macro Problem

Posted by Charlie on October 24, 2001 4:17 AM

I am trying to setup a macro that will automatically goto the end of my file each time I run it. The problem is that each day this file is of a different length.

Thanks

Posted by George Camsell on October 24, 2001 5:44 AM

It depends what you mean by the "end of the sheet".

For instance, if you want to select the last cell in the sheet's used range :-
With ActiveSheet
.UsedRange.Cells(.UsedRange.Cells.Count).Select
End With

But this might not be what you are looking for.
I think you'd better clarify what you want to do.