ExcelBanter - workbook size

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - workbook size (https://www.excelbanter.com/excel-programming/298817-workbook-size.html)

I have a workbook with VBA macros attached. It is now
huge in terms of rows and article 211888 suggests that
this is due to using the VBA editor and suggests deleting
unused sheets.

On the sheets I am using I have thousands of rows while I
am only using a few hundred. This means that a slight
nudge on the scroll bar putting me into outerspace. Is
this just something I have to live with? Maybe I will
have to develop a more delicate mouse action!

Judith,

if your empty rows all have some kind of formatting then
it's probably taking up quite a bit of memory. To get rid
of some of this dead space, go to the last row of actual
data on the sheet, select the entire row for all the rows
beneath this and delete them all. Repeat the same for
columns to the right of your data.

Now save the workbook. If you check the properties, you
should notice a reduction in the size of the file and, if
not, at least your scroll bars will be back to normal!

Cheers, Pete.

-----Original Message-----
I have a workbook with VBA macros attached. It is now
huge in terms of rows and article 211888 suggests that
this is due to using the VBA editor and suggests deleting
unused sheets.

On the sheets I am using I have thousands of rows while I
am only using a few hundred. This means that a slight
nudge on the scroll bar putting me into outerspace. Is
this just something I have to live with? Maybe I will
have to develop a more delicate mouse action!
.

Hi
see
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Frank Kabel
Frankfurt, Germany

judith wrote:
I have a workbook with VBA macros attached. It is now
huge in terms of rows and article 211888 suggests that
this is due to using the VBA editor and suggests deleting
unused sheets.

On the sheets I am using I have thousands of rows while I
am only using a few hundred. This means that a slight
nudge on the scroll bar putting me into outerspace. Is
this just something I have to live with? Maybe I will
have to develop a more delicate mouse action!