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

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