locked
vbacode for RRS feed

Answers

  • Hi rammi,

    I am not sure your details requirement. I suggest you manually operate the copy and paste operation, and record the steps, then add logic statement to modify the code for your own requirement.

    Based on your requirement, it seems you will need some function below:

    1. Get value from drop down cell, you could use ActiveSheet.Range("E15").Value
    2. Loop the cells, you could use “ActiveSheet.Cells(1, 1).Value”

    For excel object model, you could refer the link below:
    # Object model (Excel VBA reference)
    https://msdn.microsoft.com/en-us/library/office/ff194068.aspx

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Friday, October 9, 2015 5:40 AM