Problem with Paste method

  • Good Morning...well it's still morning here anyway...LOL

    Here's the code I used. The line is imbedded at the end of the 'for' statement .

    Heading out for the day. Will check back later.

    Thanks JimmyB

    It normally works on all of the other 43 sheets

  • This line should allow macros to work on the sheets in the If statement

    ws.Protect "Pamela491", UserInterfaceOnly:=True, DrawingObjects:=True, Contents:=True, Scenarios:=True
  • Yeah it's weird. It works on all of the 43 sheets just fine...just not that one...No real matter though, I went around it by Unprotecting at the start of the sub and protecting at the end. Works fine

    Anyway thanks for your help


    Stay safe & have a great week

Participate now!

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