Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resetting the activesheet used range
Hi Mark,
Go to Debra Dalgleish's web site and look for her DeleteUnused routine: http://www.contextures.com/xlfaqApp.html - Unused --- Regards, Norman "Mark" wrote in message ... Hi, I am using EXCEL 97 at work, I have a large worksbook with about 200 worksheets in it. The file size is quite large and having an impact on it's use because as the file is on a server some distance away, it's on a 1meg link but still takes some time to open. I have tried reducing the fiule size with the CodeCleaner programme from Rob Bovey but that hasn't reduced it hardly any. I wonder whether part of the problem is whether each spreadsheets used range is more than it needs to be. Is there some code that someones got that can run and look at each worksheet throught the workbook and reset the usedrange? Any assistance would be greatly appreciated. Thanks -- Mark A Whitehead |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resetting the activesheet used range
Hi Mark,
Slight pasting error, the link should be: http://www.contextures.com/xlfaqApp.html - Unused --- Regards, Norman "Norman Jones" wrote in message ... Hi Mark, Go to Debra Dalgleish's web site and look for her DeleteUnused routine: http://www.contextures.com/xlfaqApp.html - Unused --- Regards, Norman "Mark" wrote in message ... Hi, I am using EXCEL 97 at work, I have a large worksbook with about 200 worksheets in it. The file size is quite large and having an impact on it's use because as the file is on a server some distance away, it's on a 1meg link but still takes some time to open. I have tried reducing the fiule size with the CodeCleaner programme from Rob Bovey but that hasn't reduced it hardly any. I wonder whether part of the problem is whether each spreadsheets used range is more than it needs to be. Is there some code that someones got that can run and look at each worksheet throught the workbook and reset the usedrange? Any assistance would be greatly appreciated. Thanks -- Mark A Whitehead |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Help Spreadsheet1.ActiveSheet.Range("B1").LoadText debugging | Charts and Charting in Excel | |||
Resetting the end of a worksheet | New Users to Excel | |||
Used Range is not resetting | Excel Programming | |||
Resetting cells | Excel Programming |