Activesheet.Pastespecial not working

  • Hi, the below code works fine when i say


    activesheet.paste


    but when i replace it with


    ActiveSheet.PasteSpecial xlPasteValues
    nothing pastes. I have stepped through and it works until I get to the paste line.


    Any help would be appreciated.


    Dave

  • SOLVED


    I replaced


    activesheet.pastespecial xlPasteValues


    with


    Range(temp_rng_strt).PasteSpecial xlPasteValues.


    Easy when you know how.


    Dave

Participate now!

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