Hello,
I have an excel file which is composed of several very different tabs with a lot of formating.
With the following instruction the file is 950 kB in size.
For T = 1 To ThisWorkbook.Worksheets.Count
ThisWorkbook.Worksheets(T).Cells.ClearFormats
Next T
If I save this same file with formating its size is > 17 000kB.
I would like to save the file without formating and with VBA code that would format each tab on the fly as users activate these tabs.
The size of the file would be minimal (code doesn't take space) and the user would never read a sheet with no formating.
However, the formating was long and very specific to each sheet, cell, colomn, etc...
Is there an easy way I can get code that would generate this formating without having to go through "record a macro" etc...
I have an excel file which is composed of several very different tabs with a lot of formating.
With the following instruction the file is 950 kB in size.
For T = 1 To ThisWorkbook.Worksheets.Count
ThisWorkbook.Worksheets(T).Cells.ClearFormats
Next T
If I save this same file with formating its size is > 17 000kB.
I would like to save the file without formating and with VBA code that would format each tab on the fly as users activate these tabs.
The size of the file would be minimal (code doesn't take space) and the user would never read a sheet with no formating.
However, the formating was long and very specific to each sheet, cell, colomn, etc...
Is there an easy way I can get code that would generate this formating without having to go through "record a macro" etc...
