I can't figure out why my Excel file size is jumping from 550kb to 35mb. I
am running some formulas to copy data, and some special links from other
pages, as well as scripts which hides rows... I tried deleting extra
unhidden rows, and got nothing. Any ideas?

After deleting the extra rows and columns you must SAVE the workbook to
effect changes in used range.

As far as the size jump..............change the macro code to copy data etc.
to a defined rather.

Sounds like you are copying to a greater range than you need.


Gord Dibben MS Excel MVP

On Fri, 22 Jan 2010 09:06:01 -0800, New2Macros
wrote:

I can't figure out why my Excel file size is jumping from 550kb to 35mb. I
am running some formulas to copy data, and some special links from other
pages, as well as scripts which hides rows... I tried deleting extra
unhidden rows, and got nothing. Any ideas?

Should read defined range

On Fri, 22 Jan 2010 11:13:07 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

As far as the size jump..............change the macro code to copy data etc.
to a defined rather.

Still can't find it. I only have a string in Visual Basic - I tried to stay
away from macros. All that string is doing is cutting off rows based on a
certain cell's value.

Thanks


"Gord Dibben" wrote:

Should read defined range

On Fri, 22 Jan 2010 11:13:07 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

As far as the size jump..............change the macro code to copy data etc.
to a defined rather.

.

I have not yet seen confirmation that you saved the workbook after deleting
unused rows and columns on all worksheets.

I cannot see the "string in Visual Basic" so not easy to trouble-shoot that
aspect.


Gord

On Fri, 22 Jan 2010 12:12:07 -0800, New2Macros
wrote:

Still can't find it. I only have a string in Visual Basic - I tried to stay
away from macros. All that string is doing is cutting off rows based on a
certain cell's value.

Thanks


"Gord Dibben" wrote:

Should read defined range

On Fri, 22 Jan 2010 11:13:07 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

As far as the size jump..............change the macro code to copy data etc.
to a defined rather.

.

I have had to save it a lot and keep backups to fall back on if it suddenly
expands in size. I deleted rows and colums that were not being hidden by
Visual Basic. However, nothing has been changed in Visual Basic for a year,
and it has been working fine until now.

Here is the string I'm using to hide rows that are being unused:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$U$1" Then
Range("2:" & Rows.Count).EntireRow.Hidden = False
Range(CStr(3 + 2 * Range("U1").Value) & ":" & _
Rows.Count).EntireRow.Hidden = True
End If
End Sub


I just plug a number into cell U1, and it hides the correct cells.

Thanks



"Gord Dibben" wrote:

I have not yet seen confirmation that you saved the workbook after deleting
unused rows and columns on all worksheets.

I cannot see the "string in Visual Basic" so not easy to trouble-shoot that
aspect.


Gord

On Fri, 22 Jan 2010 12:12:07 -0800, New2Macros
wrote:

Still can't find it. I only have a string in Visual Basic - I tried to stay
away from macros. All that string is doing is cutting off rows based on a
certain cell's value.

Thanks


"Gord Dibben" wrote:

Should read defined range

On Fri, 22 Jan 2010 11:13:07 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

As far as the size jump..............change the macro code to copy data etc.
to a defined rather.

.


.