Excel 2003 Unable to copy last work sheet

[Anna22]

Dear all

Please could someone help me ... i have several excel spreadsheets that are worked on by various people on a weekly basis. Each week a copy of the previous worksheet is taken and copied as a blank to the end. This works fine for a few weeks and then i am unable to copy the last worksheet, but i can copy the sheet previous to that. Also it sometimes lets me manually copy the entire worksheet, insert a new worksheet and then copy the clipboard. When i have been checking with a few other users they appear to get this problem as well. All users have Office 2003 Pro with SP1.

Can anybody help me

Regards Anna

 

[RonRepp]

Anna:

Try this:

Dim SheetToCopy as Integer
Dim LastSheet as Integer

SheetToCopy = 1
LastSheet=Worksheets.Count

Sheets(SheetToCopy).Copy After:=Sheets(LastSheet)

I hope this helps.

Ron

 

[jazminecat]

Anna, given that you have multiple users, is it possible someone is locking the worksheet?

 

[SkipVought]

Anna,

Spreadsheets are sooooo easy to use, and....

sooooo easy to make big mistakes!

It does not SEEM like a mistake to take similar data and segment it into separate sheets or workbooks. But it is, in fact, as useful as putting daily, weekly, monthly data on a piece of paper and filing it away.

Data is an important corporate asset, that is rarely ONLY useful in pieces (daily, weekly, monthly). The aggregation of daily data results in weekly; weekly agregates to monthly, quarterly, annual. This data can also be leveraged into forecasts for future trends.

Now your application may, indeed, be the sort of data that lends itself to sticking it into a sheet and forgetting about it in the context of some more inclusive view. But I'd wager, not even being a betting guy, that your organization could be better served by considering this valuable asset by way of a loftier vista.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}