How to set MyRange if i have dynamic range for dynamic chart

Need help to set “MyRange” if i have dynamic source for dynamic chart in vba
Start from columns H
columns filled H,I,J,K,L,M,N,O,P,Q …….
Lastcol = Q in this moment
Used columns for chart is H + 2
ex: H, J, L, N, … until Lastcol -1
For next time the lastcol will be S and used R

Please Login or Register  to view this content.

For beginning thanks for help
Selected cell is G3 or G4 or random rows from column G , until G & last row (Target.Column = 7 & Target.Row> 2)
code works perfectly for range needed (strX, stry)
I am novice with VBA programming language, for that I need your help with formula
For that I chose each time to create a new chart, when I have a new selection should be removed for regeneration Chart
In your formula how should I do??
...
currently my formula looks like this, but I met a problem
for more rows added, If i select a row below in the sheet i will not see the chart in the same area where is row

Please Login or Register  to view this content.