This is intriguing, can you send the file to me? (zipped of course, I don't
want an 8Meg file coming through!) I'd like to actually see it if that's ok
with you,
My address ) on here is a phoney to avoid spam, replace
111 with 8202,
Regards,
Alan.
"Dejan" wrote in message
...
Hello,

When I press Ctrl+End it brings me to G1, there is absolutely nothing in
the
file, no macros no data, that I can see, just one sheet, and it 873KB.

Thanks

"Bill Martin" wrote:

Just to be completely explicit, and have no communication failure, when
you
press Ctrl-end what cell does the cursor go to?

Bill
---------------------
Dejan wrote:
Hello Alan,

I did as you suggested, still no luck, the file only contains one
sheet, no
data of any kind, everything is blank even the formatting. Still
around 800
KB, it's crazy! But yet when I use winzip it compresses to 10KB,
something
weird happening, just driving me crazy cause I email these sheets all
the
time, and I have to compress them each time I send to save space.

If any other suggestions please let me know.

Thanks

Dejan

"Alan" wrote:


One possibility, try Crl-End to see where the last used cell is, it
occurred
to me that if the whole sheet or a large part of it is non blank, like
full
of null strings, a huge file size would be the result,
Regards,
Alan.
"Dejan" wrote in message
...

Hello,

I would appreciate any input on this matter.

Not sure if anyone has experienced anything like this before. The
file
starts out being around 1meg just a few sheets with lots of VBA code,
when
the macro is done it deletes all the VBA code. There are no formulas,
I
tried
deleting all sheets in the workbook, just leaving one and even
deleting
all
data. Still I get huge file sizes. around 850KB, not sure what is
taking
up
the space.

Thank You!