How 2 Programmatically copy active worksheet?

[dkathrens77]

I am working at an office that uses MS Office 97.

I'm trying to build an Excel application to track daily productivity in (loads scheduled) a trucking dispatch
office.

The helpful IT people neglected to install the VBA help files.

Can anyone post the code to copy the active worksheet?

Also, is there a way to build a chart including data ranges on different worksheets?

Thanks,

DennisK

 

[luceze]

This will copy the active sheet and place it at the end.

ActiveSheet.Copy After:=Sheets(Sheets.Count)

HTH,
Eric