Hi All,

One Small Issue:

I am drawing a chart and this is the source data for that.

ActiveChart.SetSourceData
Source:=Sheets("Analysis").Range("E1:E11,Y1:AJ11") _
, PlotBy:=xlRows

Is there any way I can put a variable in place of 11 in the range.
This variable will count the data in column E.

Also, Column AJ is the extreme, I may not go upto that. Is there
anyway I can make that as a variable also. This variable counts the
data in Y1:AJ1 and goes only that many columns to the right of Y1

Let me know if you people can help with this

Thanks,
Anshuman