Thread: VB Question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] oitbso@yahoo.com is offline
external usenet poster
 
Posts: 18
Default VB Question

Hi Ajay...Sometimes worksheets go "bad". Cycle through your workbook
one worksheet at a time. Insert a new sheet, copy and paste from the
old sheet, delete the old sheet, then save and close your workbook and
see which old sheet(s), when deleted, significantly reduced your file
size. If this is the source of the problem, then you can add a few
lines to your macro and have your macro do this for you when you next
update your master...Ron