View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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
--