J
jamie.cutting
The workbook I am working on has expanded to 7.5M after removing all
unused ranges using the last used cell approach as discussed on
several posts here, so I am now trying to reduce the file size using
Rob Bovey's code cleaner. I have installed it and read through the
help but I seem to be missing something. I have added the com addins
button but when I hit ok with Code cleaner ticked nothing happens. I
also have tried running the Public Sub CleanAllProjects() macro from
the example file whilst having the files open I am attempting to clean
but I get an error message "Method 'VBE' of object'_Application'
failed."
I realise I am doing something wrong bit cant figure out what. Could
someone provide an idiots guide to running the code cleaner.
Many thanks for any advice.
Regards
JAmie
unused ranges using the last used cell approach as discussed on
several posts here, so I am now trying to reduce the file size using
Rob Bovey's code cleaner. I have installed it and read through the
help but I seem to be missing something. I have added the com addins
button but when I hit ok with Code cleaner ticked nothing happens. I
also have tried running the Public Sub CleanAllProjects() macro from
the example file whilst having the files open I am attempting to clean
but I get an error message "Method 'VBE' of object'_Application'
failed."
I realise I am doing something wrong bit cant figure out what. Could
someone provide an idiots guide to running the code cleaner.
Many thanks for any advice.
Regards
JAmie