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 "Smiley" icon, below, in the bottom right corner :)

    Quote from kato01

    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 "Smiley" 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 "Smiley" icon, below, in the bottom right corner :)

Participate now!

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

Register Yourself Login