VBA to copy from one work book to another when checkbox ticked, was working not isnt!

  • Hi All,


    I am probably running low on sugar and caffeine, the code below was working this morning and now I get the run-time error 50290 Method 'ScreenUpdating' of object '_Application' failed. I am more of a have a go hero than an expert so could use any help.


    The code copies specific cells from one workbook to another when a checkbox is ticked.


  • Re: VBA to copy from one work book to another when checkbox ticked, was working not i


    If I remove the screen updating, i get application-defined or object-defined error, I swear this was working earlier today!!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!