Thread
:
Used Range Problem
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Used Range Problem
SAVE
if that doesn't work
exit
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"Donald Lloyd" wrote in message
...
Hi,
On a worksheet I am using the first 69 rows and the first 55 columns.
Everything was fine until I unlocked a range of 31 columns.
Following guidelines from the group a couple of days ago, I unlocked the
entire columns.
This resulted in the file size increasing from 240 kb to 1.57 mb, with the
used range covering the entire worksheet. (The sheet referred to is a
template and a further 11 copies are to be added - I hate to think about
the
resultant file size!)
I have cleared and deleted then unused columns which changed the used
range
to cover the used columns, although this has not reduced the file size.
I have also in desperation cleared and deleted the unused rows below my
usage, but this has not
made any difference - the used range still covers the entire column range.
Any ideas will be gratefully considered.
Regards,
Don
--
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]