Disappearing paste>?

  • Re: Disappearing paste>?


    Sorry, here it is.


  • Re: Disappearing paste>?


    Works fine for me. Are there any other procedures run after this - in particular I would be looking for a sheet level procedure being run on the sheet change event for the target sheet?


    Regards
    Weasel

  • Re: Disappearing paste>?


    Ok, here is everything.


  • Re: Disappearing paste>?


    While not being overly sure what the end result should be, the paste section is still working fine, assuming that is that the delete procedure doesnt end up deleing the data in E3:Y4.


    Regards
    Weasel

  • Re: Disappearing paste>?


    Strange. I want it to do simply what its doin on your machine. Simply copy , and paste on the other sheet. But it damn well doesnt want to stay on the other sheet. It just flashes on then off again. Very annoying!

  • Re: Disappearing paste>?


    OK, I have tracked the problem down. It seems that it doesnt like the command "Paste:=xlAllExceptBorders". When this is removed it does the paste. However this is not ideal, as I do not want it to copy the borders from the other page.

Participate now!

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