View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jack jack is offline
external usenet poster
 
Posts: 186
Default Dr. Watson error

Hello all,

I hope that someone will be able to help me with this problem. I have a
heavily coded spreadsheet in xl 97. It's been working fine for over a year
now. Suddenly, it now produces a Dr. Watson error in windows when it reaches
a specific point in the code where it copies a worksheet in the workbook and
pastes it at the end of the tabs. I'm using plain, simple code that as I
say, has been working great for over a year, so I'm very confused at why this
error would suddenly begin after all this time. I hope someone can tell what
I need to do to handle this Dr. Watson error. My code that copies the sheet
is below in case it is helpful in some way.

Sheets(3).Copy After:=Sheets(7)

ps: neither the workbook nor worksheet are protected


Thanks for any help/advice,

-Jack