software

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!

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.
quot;Dejanquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I would appreciate any input on this matter.
gt;
gt; Not sure if anyone has experienced anything like this before. The file
gt; starts out being around 1meg just a few sheets with lots of VBA code, when
gt; the macro is done it deletes all the VBA code. There are no formulas, I
gt; tried
gt; deleting all sheets in the workbook, just leaving one and even deleting
gt; all
gt; data. Still I get huge file sizes. around 850KB, not sure what is taking
gt; up
gt; the space.
gt;
gt; Thank You!
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

quot;Alanquot; wrote:

gt; One possibility, try Crl-End to see where the last used cell is, it occurred
gt; to me that if the whole sheet or a large part of it is non blank, like full
gt; of null strings, a huge file size would be the result,
gt; Regards,
gt; Alan.
gt; quot;Dejanquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I would appreciate any input on this matter.
gt; gt;
gt; gt; Not sure if anyone has experienced anything like this before. The file
gt; gt; starts out being around 1meg just a few sheets with lots of VBA code, when
gt; gt; the macro is done it deletes all the VBA code. There are no formulas, I
gt; gt; tried
gt; gt; deleting all sheets in the workbook, just leaving one and even deleting
gt; gt; all
gt; gt; data. Still I get huge file sizes. around 850KB, not sure what is taking
gt; gt; up
gt; gt; the space.
gt; gt;
gt; gt; Thank You!
gt;
gt;
gt;

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:
gt; Hello Alan,
gt;
gt; I did as you suggested, still no luck, the file only contains one sheet, no
gt; data of any kind, everything is blank even the formatting. Still around 800
gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB, something
gt; weird happening, just driving me crazy cause I email these sheets all the
gt; time, and I have to compress them each time I send to save space.
gt;
gt; If any other suggestions please let me know.
gt;
gt; Thanks
gt;
gt; Dejan
gt;
gt; quot;Alanquot; wrote:
gt;
gt;
gt;gt;One possibility, try Crl-End to see where the last used cell is, it occurred
gt;gt;to me that if the whole sheet or a large part of it is non blank, like full
gt;gt;of null strings, a huge file size would be the result,
gt;gt;Regards,
gt;gt;Alan.
gt;gt;quot;Dejanquot; gt; wrote in message
...
gt;gt;
gt;gt;gt;Hello,
gt;gt;gt;
gt;gt;gt;I would appreciate any input on this matter.
gt;gt;gt;
gt;gt;gt;Not sure if anyone has experienced anything like this before. The file
gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA code, when
gt;gt;gt;the macro is done it deletes all the VBA code. There are no formulas, I
gt;gt;gt;tried
gt;gt;gt;deleting all sheets in the workbook, just leaving one and even deleting
gt;gt;gt;all
gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what is taking
gt;gt;gt;up
gt;gt;gt;the space.
gt;gt;gt;
gt;gt;gt;Thank You!
gt;gt;
gt;gt;
gt;gt;

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

quot;Bill Martinquot; wrote:

gt; Just to be completely explicit, and have no communication failure, when you
gt; press Ctrl-end what cell does the cursor go to?
gt;
gt; Bill
gt; ---------------------
gt; Dejan wrote:
gt; gt; Hello Alan,
gt; gt;
gt; gt; I did as you suggested, still no luck, the file only contains one sheet, no
gt; gt; data of any kind, everything is blank even the formatting. Still around 800
gt; gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB, something
gt; gt; weird happening, just driving me crazy cause I email these sheets all the
gt; gt; time, and I have to compress them each time I send to save space.
gt; gt;
gt; gt; If any other suggestions please let me know.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Dejan
gt; gt;
gt; gt; quot;Alanquot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;One possibility, try Crl-End to see where the last used cell is, it occurred
gt; gt;gt;to me that if the whole sheet or a large part of it is non blank, like full
gt; gt;gt;of null strings, a huge file size would be the result,
gt; gt;gt;Regards,
gt; gt;gt;Alan.
gt; gt;gt;quot;Dejanquot; gt; wrote in message
gt; ...
gt; gt;gt;
gt; gt;gt;gt;Hello,
gt; gt;gt;gt;
gt; gt;gt;gt;I would appreciate any input on this matter.
gt; gt;gt;gt;
gt; gt;gt;gt;Not sure if anyone has experienced anything like this before. The file
gt; gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA code, when
gt; gt;gt;gt;the macro is done it deletes all the VBA code. There are no formulas, I
gt; gt;gt;gt;tried
gt; gt;gt;gt;deleting all sheets in the workbook, just leaving one and even deleting
gt; gt;gt;gt;all
gt; gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what is taking
gt; gt;gt;gt;up
gt; gt;gt;gt;the space.
gt; gt;gt;gt;
gt; gt;gt;gt;Thank You!
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;

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.
quot;Dejanquot; gt; wrote in message
...
gt; Hello,
gt;
gt; When I press Ctrl End it brings me to G1, there is absolutely nothing in
gt; the
gt; file, no macros no data, that I can see, just one sheet, and it 873KB.
gt;
gt; Thanks
gt;
gt; quot;Bill Martinquot; wrote:
gt;
gt;gt; Just to be completely explicit, and have no communication failure, when
gt;gt; you
gt;gt; press Ctrl-end what cell does the cursor go to?
gt;gt;
gt;gt; Bill
gt;gt; ---------------------
gt;gt; Dejan wrote:
gt;gt; gt; Hello Alan,
gt;gt; gt;
gt;gt; gt; I did as you suggested, still no luck, the file only contains one
gt;gt; gt; sheet, no
gt;gt; gt; data of any kind, everything is blank even the formatting. Still
gt;gt; gt; around 800
gt;gt; gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB,
gt;gt; gt; something
gt;gt; gt; weird happening, just driving me crazy cause I email these sheets all
gt;gt; gt; the
gt;gt; gt; time, and I have to compress them each time I send to save space.
gt;gt; gt;
gt;gt; gt; If any other suggestions please let me know.
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt; Dejan
gt;gt; gt;
gt;gt; gt; quot;Alanquot; wrote:
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;gt;One possibility, try Crl-End to see where the last used cell is, it
gt;gt; gt;gt;occurred
gt;gt; gt;gt;to me that if the whole sheet or a large part of it is non blank, like
gt;gt; gt;gt;full
gt;gt; gt;gt;of null strings, a huge file size would be the result,
gt;gt; gt;gt;Regards,
gt;gt; gt;gt;Alan.
gt;gt; gt;gt;quot;Dejanquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;gt;
gt;gt; gt;gt;gt;Hello,
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;I would appreciate any input on this matter.
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;Not sure if anyone has experienced anything like this before. The
gt;gt; gt;gt;gt;file
gt;gt; gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA code,
gt;gt; gt;gt;gt;when
gt;gt; gt;gt;gt;the macro is done it deletes all the VBA code. There are no formulas,
gt;gt; gt;gt;gt;I
gt;gt; gt;gt;gt;tried
gt;gt; gt;gt;gt;deleting all sheets in the workbook, just leaving one and even
gt;gt; gt;gt;gt;deleting
gt;gt; gt;gt;gt;all
gt;gt; gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what is
gt;gt; gt;gt;gt;taking
gt;gt; gt;gt;gt;up
gt;gt; gt;gt;gt;the space.
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;Thank You!
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
Any pictures in the worksheet?

How about a background (format|sheet|background)?
Dejan wrote:
gt;
gt; Hello,
gt;
gt; When I press Ctrl End it brings me to G1, there is absolutely nothing in the
gt; file, no macros no data, that I can see, just one sheet, and it 873KB.
gt;
gt; Thanks
gt;
gt; quot;Bill Martinquot; wrote:
gt;
gt; gt; Just to be completely explicit, and have no communication failure, when you
gt; gt; press Ctrl-end what cell does the cursor go to?
gt; gt;
gt; gt; Bill
gt; gt; ---------------------
gt; gt; Dejan wrote:
gt; gt; gt; Hello Alan,
gt; gt; gt;
gt; gt; gt; I did as you suggested, still no luck, the file only contains one sheet, no
gt; gt; gt; data of any kind, everything is blank even the formatting. Still around 800
gt; gt; gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB, something
gt; gt; gt; weird happening, just driving me crazy cause I email these sheets all the
gt; gt; gt; time, and I have to compress them each time I send to save space.
gt; gt; gt;
gt; gt; gt; If any other suggestions please let me know.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; Dejan
gt; gt; gt;
gt; gt; gt; quot;Alanquot; wrote:
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;gt;One possibility, try Crl-End to see where the last used cell is, it occurred
gt; gt; gt;gt;to me that if the whole sheet or a large part of it is non blank, like full
gt; gt; gt;gt;of null strings, a huge file size would be the result,
gt; gt; gt;gt;Regards,
gt; gt; gt;gt;Alan.
gt; gt; gt;gt;quot;Dejanquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;gt;
gt; gt; gt;gt;gt;Hello,
gt; gt; gt;gt;gt;
gt; gt; gt;gt;gt;I would appreciate any input on this matter.
gt; gt; gt;gt;gt;
gt; gt; gt;gt;gt;Not sure if anyone has experienced anything like this before. The file
gt; gt; gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA code, when
gt; gt; gt;gt;gt;the macro is done it deletes all the VBA code. There are no formulas, I
gt; gt; gt;gt;gt;tried
gt; gt; gt;gt;gt;deleting all sheets in the workbook, just leaving one and even deleting
gt; gt; gt;gt;gt;all
gt; gt; gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what is taking
gt; gt; gt;gt;gt;up
gt; gt; gt;gt;gt;the space.
gt; gt; gt;gt;gt;
gt; gt; gt;gt;gt;Thank You!
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;

--

Dave Peterson

There is no background or images. The file is not 8 meg, it's (873KB) approx
1 meg. There is nothing in it that I can see, I just don't understand why
it's taking up so much room.

Dejan

P.s. gt; Just sent a copy to Alan
quot;Dave Petersonquot; wrote:

gt; Any pictures in the worksheet?
gt;
gt; How about a background (format|sheet|background)?
gt;
gt;
gt;
gt; Dejan wrote:
gt; gt;
gt; gt; Hello,
gt; gt;
gt; gt; When I press Ctrl End it brings me to G1, there is absolutely nothing in the
gt; gt; file, no macros no data, that I can see, just one sheet, and it 873KB.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; quot;Bill Martinquot; wrote:
gt; gt;
gt; gt; gt; Just to be completely explicit, and have no communication failure, when you
gt; gt; gt; press Ctrl-end what cell does the cursor go to?
gt; gt; gt;
gt; gt; gt; Bill
gt; gt; gt; ---------------------
gt; gt; gt; Dejan wrote:
gt; gt; gt; gt; Hello Alan,
gt; gt; gt; gt;
gt; gt; gt; gt; I did as you suggested, still no luck, the file only contains one sheet, no
gt; gt; gt; gt; data of any kind, everything is blank even the formatting. Still around 800
gt; gt; gt; gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB, something
gt; gt; gt; gt; weird happening, just driving me crazy cause I email these sheets all the
gt; gt; gt; gt; time, and I have to compress them each time I send to save space.
gt; gt; gt; gt;
gt; gt; gt; gt; If any other suggestions please let me know.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt; Dejan
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Alanquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;gt;One possibility, try Crl-End to see where the last used cell is, it occurred
gt; gt; gt; gt;gt;to me that if the whole sheet or a large part of it is non blank, like full
gt; gt; gt; gt;gt;of null strings, a huge file size would be the result,
gt; gt; gt; gt;gt;Regards,
gt; gt; gt; gt;gt;Alan.
gt; gt; gt; gt;gt;quot;Dejanquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;gt;Hello,
gt; gt; gt; gt;gt;gt;
gt; gt; gt; gt;gt;gt;I would appreciate any input on this matter.
gt; gt; gt; gt;gt;gt;
gt; gt; gt; gt;gt;gt;Not sure if anyone has experienced anything like this before. The file
gt; gt; gt; gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA code, when
gt; gt; gt; gt;gt;gt;the macro is done it deletes all the VBA code. There are no formulas, I
gt; gt; gt; gt;gt;gt;tried
gt; gt; gt; gt;gt;gt;deleting all sheets in the workbook, just leaving one and even deleting
gt; gt; gt; gt;gt;gt;all
gt; gt; gt; gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what is taking
gt; gt; gt; gt;gt;gt;up
gt; gt; gt; gt;gt;gt;the space.
gt; gt; gt; gt;gt;gt;
gt; gt; gt; gt;gt;gt;Thank You!
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Maybe just a small test.

Open your workbook.
Hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter
?activesheet.shapes.count

What do you see?

Dejan wrote:
gt;
gt; There is no background or images. The file is not 8 meg, it's (873KB) approx
gt; 1 meg. There is nothing in it that I can see, I just don't understand why
gt; it's taking up so much room.
gt;
gt; Dejan
gt;
gt; P.s. gt; Just sent a copy to Alan
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Any pictures in the worksheet?
gt; gt;
gt; gt; How about a background (format|sheet|background)?
gt; gt;
gt; gt;
gt; gt;
gt; gt; Dejan wrote:
gt; gt; gt;
gt; gt; gt; Hello,
gt; gt; gt;
gt; gt; gt; When I press Ctrl End it brings me to G1, there is absolutely nothing in the
gt; gt; gt; file, no macros no data, that I can see, just one sheet, and it 873KB.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; quot;Bill Martinquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Just to be completely explicit, and have no communication failure, when you
gt; gt; gt; gt; press Ctrl-end what cell does the cursor go to?
gt; gt; gt; gt;
gt; gt; gt; gt; Bill
gt; gt; gt; gt; ---------------------
gt; gt; gt; gt; Dejan wrote:
gt; gt; gt; gt; gt; Hello Alan,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I did as you suggested, still no luck, the file only contains one sheet, no
gt; gt; gt; gt; gt; data of any kind, everything is blank even the formatting. Still around 800
gt; gt; gt; gt; gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB, something
gt; gt; gt; gt; gt; weird happening, just driving me crazy cause I email these sheets all the
gt; gt; gt; gt; gt; time, and I have to compress them each time I send to save space.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; If any other suggestions please let me know.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Dejan
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Alanquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;gt;One possibility, try Crl-End to see where the last used cell is, it occurred
gt; gt; gt; gt; gt;gt;to me that if the whole sheet or a large part of it is non blank, like full
gt; gt; gt; gt; gt;gt;of null strings, a huge file size would be the result,
gt; gt; gt; gt; gt;gt;Regards,
gt; gt; gt; gt; gt;gt;Alan.
gt; gt; gt; gt; gt;gt;quot;Dejanquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;gt;Hello,
gt; gt; gt; gt; gt;gt;gt;
gt; gt; gt; gt; gt;gt;gt;I would appreciate any input on this matter.
gt; gt; gt; gt; gt;gt;gt;
gt; gt; gt; gt; gt;gt;gt;Not sure if anyone has experienced anything like this before. The file
gt; gt; gt; gt; gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA code, when
gt; gt; gt; gt; gt;gt;gt;the macro is done it deletes all the VBA code. There are no formulas, I
gt; gt; gt; gt; gt;gt;gt;tried
gt; gt; gt; gt; gt;gt;gt;deleting all sheets in the workbook, just leaving one and even deleting
gt; gt; gt; gt; gt;gt;gt;all
gt; gt; gt; gt; gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what is taking
gt; gt; gt; gt; gt;gt;gt;up
gt; gt; gt; gt; gt;gt;gt;the space.
gt; gt; gt; gt; gt;gt;gt;
gt; gt; gt; gt; gt;gt;gt;Thank You!
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

This is a copy of the one to one correspondence,

Hi Dejan,
The problem is that you have (probably) hundreds, if not thousands of named
ranges, typically named PURO0036 which refer to one of your files I would
think:
'C:\Documents and Settings\user\My Documents\EXCEL FILES\UAP\Edmonton\[A -
1 - TEMPLATE.xls]0194'!$A$9:$M$67
I suspect that the macro code you are using is creating them somehow.
I deleted loads of them then saved and the file size reduced, albeit by not
very much! It will take a bit of work to delete all of them. Go 'Insert' gt;
'Names' gt; 'Define' and you'll see them.
I'll copy this to the newsgroup, maybe someone knows a way to delete lots of
named ranges in one go,
Regards,
Alan.
quot;Dejanquot; gt; wrote in message
...
gt; There is no background or images. The file is not 8 meg, it's (873KB)
gt; approx
gt; 1 meg. There is nothing in it that I can see, I just don't understand why
gt; it's taking up so much room.
gt;
gt; Dejan
gt;
gt; P.s. gt; Just sent a copy to Alan
gt; quot;Dave Petersonquot; wrote:
gt;
gt;gt; Any pictures in the worksheet?
gt;gt;
gt;gt; How about a background (format|sheet|background)?
gt;gt;
gt;gt;
gt;gt;
gt;gt; Dejan wrote:
gt;gt; gt;
gt;gt; gt; Hello,
gt;gt; gt;
gt;gt; gt; When I press Ctrl End it brings me to G1, there is absolutely nothing
gt;gt; gt; in the
gt;gt; gt; file, no macros no data, that I can see, just one sheet, and it 873KB.
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt; quot;Bill Martinquot; wrote:
gt;gt; gt;
gt;gt; gt; gt; Just to be completely explicit, and have no communication failure,
gt;gt; gt; gt; when you
gt;gt; gt; gt; press Ctrl-end what cell does the cursor go to?
gt;gt; gt; gt;
gt;gt; gt; gt; Bill
gt;gt; gt; gt; ---------------------
gt;gt; gt; gt; Dejan wrote:
gt;gt; gt; gt; gt; Hello Alan,
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; I did as you suggested, still no luck, the file only contains one
gt;gt; gt; gt; gt; sheet, no
gt;gt; gt; gt; gt; data of any kind, everything is blank even the formatting. Still
gt;gt; gt; gt; gt; around 800
gt;gt; gt; gt; gt; KB, it's crazy! But yet when I use winzip it compresses to 10KB,
gt;gt; gt; gt; gt; something
gt;gt; gt; gt; gt; weird happening, just driving me crazy cause I email these sheets
gt;gt; gt; gt; gt; all the
gt;gt; gt; gt; gt; time, and I have to compress them each time I send to save space.
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; If any other suggestions please let me know.
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; Thanks
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; Dejan
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; quot;Alanquot; wrote:
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;gt;One possibility, try Crl-End to see where the last used cell is, it
gt;gt; gt; gt; gt;gt;occurred
gt;gt; gt; gt; gt;gt;to me that if the whole sheet or a large part of it is non blank,
gt;gt; gt; gt; gt;gt;like full
gt;gt; gt; gt; gt;gt;of null strings, a huge file size would be the result,
gt;gt; gt; gt; gt;gt;Regards,
gt;gt; gt; gt; gt;gt;Alan.
gt;gt; gt; gt; gt;gt;quot;Dejanquot; gt; wrote in message
gt;gt; gt; gt; ...
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt;gt;Hello,
gt;gt; gt; gt; gt;gt;gt;
gt;gt; gt; gt; gt;gt;gt;I would appreciate any input on this matter.
gt;gt; gt; gt; gt;gt;gt;
gt;gt; gt; gt; gt;gt;gt;Not sure if anyone has experienced anything like this before. The
gt;gt; gt; gt; gt;gt;gt;file
gt;gt; gt; gt; gt;gt;gt;starts out being around 1meg just a few sheets with lots of VBA
gt;gt; gt; gt; gt;gt;gt;code, when
gt;gt; gt; gt; gt;gt;gt;the macro is done it deletes all the VBA code. There are no
gt;gt; gt; gt; gt;gt;gt;formulas, I
gt;gt; gt; gt; gt;gt;gt;tried
gt;gt; gt; gt; gt;gt;gt;deleting all sheets in the workbook, just leaving one and even
gt;gt; gt; gt; gt;gt;gt;deleting
gt;gt; gt; gt; gt;gt;gt;all
gt;gt; gt; gt; gt;gt;gt;data. Still I get huge file sizes. around 850KB, not sure what
gt;gt; gt; gt; gt;gt;gt;is taking
gt;gt; gt; gt; gt;gt;gt;up
gt;gt; gt; gt; gt;gt;gt;the space.
gt;gt; gt; gt; gt;gt;gt;
gt;gt; gt; gt; gt;gt;gt;Thank You!
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt; gt;gt;
gt;gt; gt; gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Dave Peterson
gt;gt;