create a chart with multiple plots using the cells command

  • Hello and Welcome to the Forum :)


    Have you tried to turn on your macro recorder ... and build your chart ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Yes, but the recording defines the ranges using letters, I need to use cells command


    Great ... at least you do have a starting point ...;)


    Could you post your current macro ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    If you only need the equivalence between the two instructions ...


    Range("E3") can be written Cells(3,5) ... since Cells instruction requires Cells(Row_Number, Column_Number)


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)