Looping through Data Validation list & copy/paste a range of cells

  • Hi,


    I have the following activity that I need to perform using a macro, however I am unable to loop through a drop down list to perform the repetitive action


    Cell E9 contains the data validation option which has data linked to another sheet ('CE Mapping'!$A:$A). I want to copy a range of cells & paste it as a picture in another sheet, every time I change a value in Cell E9 (Drop Down) the corresponding values in the range changes. Below is the code I use which only copy pastes the values from the first option in the drop down on cell E9


    Range("D7:N43").Select
    Selection.Copy
    Sheets.Add After:=ActiveSheet
    ActiveSheet.Pictures.Paste.Select
    ActiveSheet.Shapes.Range(Array("Picture 1")).Select
    Sheets("P4P PPM").Select

  • Re: Looping through Data Validation list & copy/paste a range of cells


    It would be helpful to see the workbook.


    When you click reply there will be a new button labeled go advanced, click on that button then there will be a paperclip icon in the toolbar, click on that icon and follow the instructions.

    Bruce :cool:

Participate now!

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