(Solved) – Loop copy paste and paste special in different sheets

(solved)-–-loop-copy-paste-and-paste-special-in-different-sheets

I’m new to vba, and I’m trying not to use ‘Select’, but I can’t figure out, how to do the code without it. I have three sheets (data sheet, generator sheet and picture sheet). I need to loop through the data sheet and copy a cell/value to a cell in the generator sheet. From here, copy a range and paste special as picture into the picture sheet (with Name, Width and OnAction) – then the next loop.
I’ve tried to do as in this link (VBA Copy paste columns in different sheet) with the named worksheets. The problem is the paste special – here I can’t make it work without selecting the picture sheet and the cell 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *