VBA Graphics Range Selection

[Guerty]

Folks,
I'm having problems writing the following code.
I would like the Macro to select from a worksheet different ranges, and then plot them
into one plot. My data has a counter (w.Row), in order to determine the lenght of the
selection, and the data are not in contiguous cells.

Example
Sub Graphics()
Worksheets("Data_Table").Activate
Range("A1:B & (w.Row - 1), E1:E & (w.Row - 1)").Select (THIS IS WHERE I'M
HAVING PROBLEMS, AT A MULTISELECTION OF DATA, WITH DIFFERENT RANGES
ASSOCIATED)

Charts.Add

ActiveChart.ChartType = xlXYScatterSmooth</pre>

 

[ravishankar]

Hi
try
Range("A2:B" & w.row - 1 & ",E2:E" & w.row - 1).Select
Ravi