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


    Code
    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

    JimmyB

    Stay safe & have a great week

Participate now!

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