Paste Screen Shot Into Set Range

  • Hi,
    I have code that very nearly does what I want...... When I paste the screen shot into a range it pastes into he correct first row, first col, last col..................... But ignores the last Row anyone got a clue?


  • Re: Paste Screen Shot Into Set Range


    Try your sequence something like this?


  • Re: Paste Screen Shot Into Set Range


    Thanks Fuzz-Head, however its screen shots I'm dealing with & when/If I get this working there will be a few screen shots I will be pasting (Via a button) so no pictures will be saved. The height seems dependant on the size of the screen shot....... I have it set to start at row 7 & stop at row 23 but although it starts at row 7 it wont stop at row 23?

Participate now!

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